Basically every SQL statement whether internal or external is cached for eventual reuse in future
You can find Cached Queries from SMP > System Explorer > SQL > Cached Query.png)
clicking on one in the list you get the details.png)
Tab SQL Statements shows much more details.png)
Click on SQL Statement Text offers a further drill down into details.png)
Typical mistakes with ODBC access over Windows DSN
How can I run this from my Win 11 + Desktop Docker ?
it actually fails, issue is reported https://github.com/grongierisc/iris-flask-template/issues/1
How can I run this from my Win 11 + Desktop Docker ?
it actually fails, issue is reported https://github.com/grongierisc/iris-django-template/issues/1
How can I run this from my Windows 11 Docker Desktop ?
install fails. https://github.com/grongierisc/iris-fastapi-template/issues/1
http://<server>:<port>/csp/......
refers to the private webserver installed and used in past releases
check if your external webserver listening to 8080 is started at all
You probably should ask this in an Oracle forum.
This is definitely not the best place to discuss such idea
_SYSTEM is just another user name with role %ALL
any other account with the same role can do it as well.
Tying some code to a Username ignoring the power of roles is an elementary design error.
Hi @Otto Medin !
HTTP is basically US ASCII 7bit with some "handcrafted" extensions
- somehow "UTF 7.6" 🤪 focussing on octets
it works for äöü but NOT for € (x20AC) >>> in URL %u20AC
for details: https://softwareengineering.stackexchange.com/questions/304419/what-encoding-are-the-http-status-and-header-lines
my hint: Try to avoid it in HTTP headers and stick with 7bit ASCII to be on the save side
browsers are less risk for problems but old applications are
any MIRORING is technically GLOBAL Mirroring
read in docs https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=PAGE_high_availability
4 options:
Manipulating time values is a risky ground. See this simple example.
USER>write ?1%, $ZTZ," : ",$zdt($ZTS)," : ",$zdt($now())," : ",$zdt($h)
-60 : 07/04/2024 16:03:42 : 07/04/2024 17:03:42 : 07/04/2024 18:03:42So for international applications using anything else than UTC is an open trap you might be caught in.
This was the original motivation to use UTC in ENSEMBLE and it's descendants and followers
traditional style:
Set From = "2024-07-04 13:21:16.477"
Set To = $tr(From," -:")\1Pls be more precise:
- where do your data come from and how?
- where do you expect to store them ?
- what do you mean by "linked servers" ?
NO ODBC: in general in IRIS almost every table can be accessed also as object..
My driver loaded using IRIS CLIENT installation
C:\Program Files\Common Files\InterSystems\IRIS\IRISODBC3564.dll
my driver version =2023.1.4.580.0
As displayed by OEBDC
If I understand it correctly :
- DBeaver uses your ODBC and works OK (or is this a different driver ?)
- Power BI tries ODBC but fails
Did "Test Connection" also fail ?.png)
YES, concurrency applies to persistent objects once the are sved the first time
this means: it doesn't apply when the object is NEW and has no ID yet.
the basic mechanic in ObjectScript is the LOCK command (https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=ITECHREF_lock)
for persistent objects this mechanic is named Concurrency
check this context with lots of various cases and examples
https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=GOBJ_concurrency
. https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls?KEY=GCOS_lockbasics
I just had a similar picture when my trial account was terminated.
see:
https://community.intersystems.com/post/intersystems-iris-cloud-sql-and-intersystems-iris-cloud-integratedml-are-now-generally
To encourage experimentation and developer creativity, new subscribers automatically receive a $300 credit for running deployments of any size. Beyond this free credit, customers will be billed through their AWS account.
After an updated + repair of my local Ensemble 2018 installation
I had to re-install my IRIS 2023.1.4 client!
@Alexey Nechaev
In my trial file SSLDefs.ini was placed into
C:\Program Files (x86)\Common Files\InterSystems\IRIS\
whích required admin access rights
I 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 DSN
so your's should look like this
[My CloudSQL Server]
Address=44.221.219.249
Port=443
SSLConfig=SampleSSLConfig
because of output formatting with !, # , ?n
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 vecI think the difference is obvious.
Servus
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 work
it is Set $VECTOR(vectorname, pos,type) very clear example
and type can never be changed
position is less sensitive.
In your case using SQL functíon TO_VECTOR() might be quite comfortable
as 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 example
in my OEX package Vector-inside-IRIS
LG. aus Wien
THe 3rd AI proposal looked better - Just looked!
so the advice was useless!
a personal hint:
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
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 verify
So 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.100
was working excellent and easy to check and to work with
see: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RGOT_complete
browser search "Extent Index"