All
Accepted answers
Robert Cemper 路 Aug 9, 2023 go to post

According to class  Class Contatos.Amiguinho you presented
Class Contatos.Empresa should look similar to this to work:

Class Contatos.Empresa Extends %Persistent
{
Relationship Nomedaempresa As 
    Contatos.Amiguinho [ Cardinality = many, Inverse = Trabalho ];

Property Nome As %String;

Storage Default
}
Robert Cemper 路 Aug 9, 2023 go to post

you may run an export ^%G like on the remote server and then copy somehow the result

Robert Cemper 路 Aug 9, 2023 go to post

It's an orgy of IsDefined ($DATA) and GetNext( $ORDER) as equivalent of $QUERY is not implemented 

Robert Cemper 路 Aug 9, 2023 go to post

You just can insert existing IDs.
So you have to check first:

set emp=##class(Contatos.Empresa).%OpenId(IDt)
if $isObject(emp) Do objcontato.Trabalho.Insert(emp)

Robert Cemper 路 Aug 9, 2023 go to post

Relationship is an Object concept that has no direct equivalent in SQL to handle it
The "MANY" end is basically just a piece of code ( RelationshipObject) to handle it.
By SQL you just can set it indirectly from the "ONE" end as you found yourself.
This is a real Property / Column that has a distinct value that you can touch and set
 

Robert Cemper 路 Aug 9, 2023 go to post

Instead of Set  
Set objcontato.Trabalho=##class(Contatos.Empresa).%OpenId(IDt)  
you need to use method Insert()
Do objcontato.Trabalho.Insert(##class(Contatos.Empresa).%OpenId(IDt))  

See Docs

Robert Cemper 路 Aug 8, 2023 go to post

My 3rd Choice:

  • get a network file connection to the source DB
  • mount the DB over the network as remote drive 

mixing file systems Win / *UX  might be tricky

Robert Cemper 路 Aug 4, 2023 go to post

BTW:
whatever your method does it always terminate with Quit $$$OK
so whatever happens it is equivalent to
set SphereJauh=1
I assume you look for a different return value ? Is it ?

Robert Cemper 路 Aug 4, 2023 go to post

your ClassMethod GetSphereJauh(Id..... is located in some Class

so just call it as any other class method
set SphereJauh=##class(classname).GetSphereJauh(ATTRDesc)  

the fact that this is used as part of a custom class query is totally irrelevant in this context.
it is straightforward ObjectScript. nothing else

Robert Cemper 路 Jul 31, 2023 go to post

Now it is obvious that ^realglobal has 11.3 times the size of ^testglobal
while your ^testglobal seems to have all blocks in buffers in memory
this is rather unlikely for ^realglobal.
So repeated reloading of blocks from disk seems to cause the delay
If you have the chance to double or triple your global buffers
you most likely may see improved processing of your $O()

Robert Cemper 路 Jul 22, 2023 go to post

Follow up to @Dmitry Maslennikov:
Error on IRIS side:  ACCESS DENIED  ODBC can't connect ===> timeout
Why  ACCESS DENIED ? The most likely cause

  • you run multiple ODBC connections in parallel
  • you use the same fixed USER for access to IRIS
  • maximum license slots by user is ~25
  • once you pass the limit your 25 slots get converted to 25 single licenses
  • any further connection consumes a full license 
  • until you run out of available licenses ==> ACCESS DENIED
  • you can get out of that trap only if ALL connections of that user are closed 

You can avoid this by

  • limiting your ODBC connections below 24
  • or run your ODBC access in  serial mode
  • or use multiple users for access with limit <24
Robert Cemper 路 Jul 11, 2023 go to post

Muchas gracias ! 
Thank you all! 
400+ years back when my earliest documented ancestor was born
Spain+Austria was a World Wide Empire ("Casa Austria", Emperor Carlos V.) that ruled the globe.
I feel quite familiar with you.
Robert 

Robert Cemper 路 Jul 10, 2023 go to post

if you want to take a look behind the scene try this example
Character-Slice Index
Quick Summary:

  • [ looks for any character(s)
  • %CONTAINS looks for words (separated by blanks or punctuations)
Robert Cemper 路 Jul 8, 2023 go to post

Hi @Vivian Lee !
I think you had no chance to see the problem in docs
You mentioned a custom class that extends %Text.English
this might be the cause of your problem.
The class is not visible in normal class reference (don't ask me why) 
Default %Text.English has a Parameter  NOISEWORDS100 =
"the of and a to in is you that it he for was on are as with his they at be this from I have or by one had not but what all were when we there can an your which their said if do will each about how up out them then she many some so these would other into has more her two like him see time could no make than first been its who now my made over did down only way find use may long little very after called just where most know get through back";

So you might be affected by these NOISEWORDS.
I failed to find any useful public documentation on this parameter and also %Text.Text is not too useful

Robert Cemper 路 Jul 7, 2023 go to post

Agree with @Julius Kavay 
Just read the documentation  on %CONTAINS
It's a function specific to data type %TEXT and is language dependant (more details in docs)
-------------------
If you look for a functionality as SQL LIKE you better use LIKE
or [ the contains operator of COS

Robert Cemper 路 Jul 6, 2023 go to post

You still didn't understand the difference:

  • - DATDEDIFF() works on local times  eg.  "1970-01-01" is your locale time  (eg. UTC+5.5 hrs)
  • - $ZDT(...,-2)  uses by definition 1970-01-01 UTC

you should know from what time zone you  get your input from

Robert Cemper 路 Jul 5, 2023 go to post

#1 is correct
Your calculation #2 is seriously wrong.
reason
reading documentation you see
dformat -2 

$ZDATETIME returns an integer specifying the count of seconds from a platform-specific origin date/time. This is the value returned by the time() library function, as defined in the ISO C Programming Language Standard. For example, on POSIX-compliant systems this value is the count of seconds from January 1, 1970 00:00:00 UTC

And that's the mistake:
Your BirthDate is obviously considered as  LOCAL time
And therefore the difference you see reflects the time offset of your machine to UTC
-19800 sec => -5.5 hrs
system variable $ZTZ will show your offset to UTC in minutes  => -330
my guess: your machine is running at local time in India