go to post Robert Cemper · Jun 27 @Alexey Nechaev In my trial file SSLDefs.ini was placed into C:\Program Files (x86)\Common Files\InterSystems\IRIS\ whích required admin access rightsI also gave Full Access to Everyone for the file (to avoid conflicts with 👿 MS security) in addition also my ip address was NUMERIC to match DSNso your's should look like this [My CloudSQL Server] Address=44.221.219.249Port=443SSLConfig=SampleSSLConfig
go to post Robert Cemper · Jun 23 not really since as you know there is always ObjectScript under most SQL Functions.BUT as mentioned: I found TO_VECTOR() the most comfortable one.without SQL it might look like this: or worse ;; assume a $LB structure of %Integer as input set intlist=$LB(...........) ;; fill vector set maxvecsize=22 ; just an assumption for i=1:1:maxvecsize { set val=$li(intlist,i) if '(val\1=val) continue set $vector(vec,i,"int")=val } write $isvector(vec) write vec zwrite vec I think the difference is obvious.Servus
go to post Robert Cemper · Jun 23 Hallo @Ditmar Tybussek lange nix mehr gehört von dir ! See my article Using VECTORs in ObjectScript.related to your code: Simple Set vector=.... doesn't workit is Set $VECTOR(vectorname, pos,type) very clear exampleand type can never be changed position is less sensitive. In your case using SQL functíon TO_VECTOR() might be quite comfortableas it does all the checks for you under cover.i also used all-MiniLM-L6-v2 (as PY method) starting from label sc3 in the examplein my OEX package Vector-inside-IRISLG. aus Wien
go to post Robert Cemper · Jun 21 THe 3rd AI proposal looked better - Just looked! it refers to an Java based installation for DBeaver. (ok for this) the fact that Apache Superset is straight and only Py based was totally ignored so the advice was useless!
go to post Robert Cemper · Jun 21 a personal hint: be as precise in your question as possible. example (with shortened replies)- how to run IRIS ODBC client install in a fresh container ? >> use IRIS container as base 😕- how to run IRIS ODBC client install in a NOT IRIS based container ? >> No idea, ask developer community 🤒- how to connect to Cloud SQL from Apache Superset osing ODBC and TLS/SSL ?>>> what I really has in mind. (found it by accident) Reply is quite detailed It's the example from the announcement above I'll try
go to post Robert Cemper · Jun 20 minor simplification:inserting my 77 char server address into the15 char Server-IP of Windows DSN caused me repeating problems.k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com A real pain to verifySo I translated it to a real IP address using nslookup SAMPLES>$nslookup k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com ; . . . . Name: k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com Address: 3.215.248.100 3.215.248.100was working excellent and easy to check and to work with
go to post Robert Cemper · Jun 20 see: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RGOT_complete browser search "Extent Index"
go to post Robert Cemper · Jun 18 in XML the construct with ![CDATA[ gets used if the string contains anycharacter that may cause conflicts in XML parsing:In your case it is the & (Ampersand) that triggers the different use. THIS causes the ![CDATA[ in a string field!.
go to post Robert Cemper · Jun 16 $ZTRAP is pretty much the same idea as ONERROR that you find inBASIC, VB, VBA, JavaScript and some other old languages. a left over from M
go to post Robert Cemper · Jun 14 in docker-compose.yml change command: --key /dur/key/iris.key to command: --key /dur/key/iris.key -b "sleep 2000" so the container starts but IRIS is not started2000 is just some hang for your investigation (2000 sec) in a 2nd session run docker-compose exec iris bash and start IRIS manually to see all details of what might be wrong
go to post Robert Cemper · Jun 12 I share your suspicion on reserved Verbs. You may try m.Name as "myName" Or even m.Name as "Name" Just a guess from the hip
go to post Robert Cemper · Jun 9 Start reading the documentation:Running the Terminal Application from the Command Line
go to post Robert Cemper · Jun 7 once you know what namespace you are looking at you may list available schemata bySELECT * FROM INFORMATION_SCHEMA.SCHEMATA which returns 750 rows for namespace HSCUSTOM
go to post Robert Cemper · Jun 7 first you need to install a valid DSN: Defining an ODBC Data Source on Windowsfor PS you may take the same approach as described here
go to post Robert Cemper · Jun 6 And here is the full documentationProcessing Errors at the Terminal Prompt
go to post Robert Cemper · Jun 6 2d indicates that you are 2 stack levels down from Command prompt last entered by doenter QUIT to return to top do ^%STACK may display your way down to your actual point
go to post Robert Cemper · Jun 5 Wrap your SELECT in an Outer SELECT LIST(...inner select ...)try: SELECT LIST(DIAGNOSE) FROM ( SELECT MRDIA_.....->MRCID.... FROM ...... WHERE ..... ORDER BY ...... )
go to post Robert Cemper · Jun 4 What you describe is indeed named Global:and the syntax could be ^ehr.IP to follow your question.It is visible over the whole namespace.If you use ^%ehr.IP the % makes it available over all namespaces of your installation. Set ^%ehr.IP="whatever you need" is creating it
go to post Robert Cemper · Jun 4 @Enrico Parisi : I fully support your point!Global mapping - in any form - is the path for CONTROLLED managed growth.So I wonder about the intention of the "continuation".