¡ Hola Salva ! ( @Jose Tomas Salvador)
You motivated me to give it a try.
And with a little bit of tweaking the scripts my contribution for the contest
WebSocket Client JS with IRIS Native API as Docker Micro Server
is also running with no issues on Docker Desktop for Windows !
A very positive experience that I didn't expect at first sight.
¡ Gracias !
if you install Excel you have automatically also a DSN for ODBC access to EXCEL
check your DSN data sources in your Windows installation.
Use ODBC-Gateway in Cache / IRIS to access it.
Typically all strings are UTF encoded.
The average text often consist of single-byte characters (a subset of UTF-8)
As soon as a multibyte character joins the string the whole string just uses WIDE characters
example:
The conversion happens totally internal.
depending on your needs you can select the national language table.
different languages sort differently. e.g German äöü vs. aou
with set gStatus=$DATA(pGlobalName) you check the existence of your call parameter
but set gStatus=$DATA(@pGlobalName) check the existence of your Global
to go for the Global you require indirection therefore set gmin=$ORDER(@pGlobalName@(""))
will meet your expectations
using "œ" makes you internal string wide character.
you might fix it with DO $ZF(-1,$ZCVT("echo œ","O","UTF8")) if the encoding of your AIX is UTF-8.
The first example just shows that AIX understands its own console/terminal.
Bonne chance !
Sorry my fault: my quality was set back to 240 (!) as I was watching High Noot wich Garry Cooper last time
with 1080 HD it is excellent
I was unable to attend so I took the recording. The content was important and good to understand.
But the shared desktops are all unreadable in the video.
Molte grazie @Stefano Cairoli !
È sempre lo stesso problema : è scritto da qualche parte.
Ma dove ?
Migliori saluti da Vienna! E state tutti sani!
Robert
¡Hola Salva! ( @Jose-Tomas Salvador)
A great contribution. Having this experienced myself I know how much work it was.
A few remarks:
Thanks to your description I know that my expectations were just higher than reality.
I finally dropped Docker desktop and returned to my VMware that I used already
before it was supported platform for Caché, 
.
Especially networking was much easier (to me).
Maybe a future version might be more convincing.
But as I developed a predecessor of VMware already in 1972.. I'm quite demanding on that subject.
¡ Saludos desde Viena !
Robert
Your organization seems to run the traditional centralized approach where a few developers worked
in a rather close contact with each other being informed of any change immediately.
Experiencing all cross-over dependencies on code and data directly.
In a distributed / larger organization this information is poor or missing.
So with more people stirring the same pot of code from remote is a risky exercise.
You are well-advised to have local and separated installations for your developers.
The extra effort is to maintain a common code base and data set for them.
The advantage is that their changes don't interfere with each other.
The next challenge is to keep test data for them consistent.
This may even be harder to achieve than code consistency and requires precise maintenance and management.
I like it as it is based on Eclipse.
And as I used Eclipse since I wrote my first line of Java some decades back
I know where to find my buttons and switches, what fits my needs, ....
I'm not married to it. Just many years of positive experience. Why drop it for some younger tool ...
A minor addition:
For some time ( since last year ?) Studio is also available for stand-alone installation without any related Caché / IRIS Kit.
The support & documentation situation is important for the field.
So my vote: Studio for Win, Atelier for the rest
As there is no default RANDOM() in Caché/IRIS SQL you have to write it yourself.
Create this class:
Assuming your table has defautl ID (%Integer, MINVAL=1)
>= ensures that you just get an existing ID and don't drop on a deleted one
Of course, if you know in advance the highest existing ID (e.g. maxid) then RANDOM(maxid) will do it.
Extending the reply of @Vitaliy Serdtsev
Basically whatever your variable holds could be a %String (also including binary values)
COS has a few check functions to interpret the content
Further on the Pattern Match operator ? let you sort out pure text and binary, .....
All you have is just content. It is left up to you to decide what type it is.
You can find out by those functions what is NOT.
Only the data type classes decide to some limit what type it should be.
NO it is not possible:
In IRIS for Windows (x86-64) 2020.1 (Build 215U) it is compiled.
But at run time you get an SQLCODE=1 and an error message for a bad SQL statement.
Better compose an SQL string "SELECT name FROM "_table and process it with some ResultSet class,
The embedded code in the class we know from Cache is gone.
It all generates into a %scqlc.* class
If you don't have a standard ID (%Integer,MINVAL=1)
but something like ^<dataglobal>(BRANCH,ID) or similar than you might get your fast count by applying
The adopted Bitmap
Adopted Bitmaps example now on Open Exchange
ant iterate over the "BRANCHES"
If you run Tune Table on a regular base it updated EXTENTSIZE.
But this is then not exact but a close estimation depending on the frequency of run
In principle I'd share te suggestion of @Stephen Canzano;
with 2 minor additions: SELECT Count(ID) from <youtable> will you always lead to the
explicit or implicit Extent Index. (bitmap or standard)
This is important as there are a bunch of classes that have explicit defined table names.
In addition, it works also for table linked over SQL gateway
*.1.int shows us that this is generated from a class
%Stream.Object.... is a class from SYSLIB.
System Classes are typically only available in compiled format (.obj) You can't debug them.
Either skip them by <F10> or leave them by <SHIFT F11>
You might have a UNIQUE key on some of the other columns
I think your data is crap. (in the screenshot)
The ID you insert is totally different by structure than what you display from, table !!!
This one looks like a 3 level subscript (Server | CustID | ActivityCode)
I'd suggest not to try to insert ID at all. it is obviously generated
I'd suggest to UNSWIZZLE ( ~~ remove from memory) all children once you a done with an object.
it's described here:
https://docs.intersystems.com/iris20192/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_relationships
[SQLCODE: <-131>:<After Insert trigger failed>]
[%msg: <21003,Cannot INSERT "NIActivityCode" because number is already used.>]
this simply means that you try to insert something that is unique and already present.
so check against your table definition for uniqueness and next the data you want to insert.
Start with ID first.
It is definitely a data issue and not related to syntax
INSERT INTO ccms.NIActivityCode (ID, CustID, ActivityCode, Name, ShortName, CreateDate, Type, Server)
SELECT '1||1||102', '1', '102', 'Test1', 'test1', '2020-01-01 10:37:00', '4', '1'
UNION ALL
SELECT '1||1||103', '1', '103', 'Test2', 'test2', '2020-01-01 10:37:00', '4', '1'
UNION ALL
SELECT '1||1||104', '1', '104', 'Test3', 'test3', '2020-01-01 10:37:00', '4', '1'UNION ALL
UNION ALL adds to the previous Select.
ALL means all columns
This is just a wrong format.
the example you pointed to simulates an INSERT..... SELECT... construct
with no VALUES keyword !!
see docs: Insert Query Results: INSERT with SELECT
the SELECT combines single values with a UNION ALL clause.
All standard SQL.
An example as you see in namespace SAMPLES SOAP.Demo.cls .
First, of anything else, it is an XML document.
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:s0="http://tempuri.org" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" targetNamespace="http://tempuri.org">
<types>
<s:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org">
<s:import namespace="http://tempuri.org/ByNameDataSet" schemaLocation="http://localhost:57772/csp/samples/SOAP.ByNameDataSet.cls?XSD"/>
<s:import namespace="http://tempuri.org/QueryByName_DataSet" schemaLocation="http://localhost:57772/csp/samples/SOAP.Demo.QueryByName.DS.cls?XSD"/>
<s:element name="AddInteger">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="Arg1" type="s:long"/>
<s:element minOccurs="0" name="Arg2" type="s:long"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="AddIntegerResponse">
<s:complexType>
<s:sequence>
<s:element name="AddIntegerResult" type="s:long"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="DivideInteger">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="Arg1" type="s:long"/>
<s:element minOccurs="0" name="Arg2" type="s:long"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="DivideIntegerResponse">
<s:complexType>
<s:sequence>
<s:element name="DivideIntegerResult" type="s:long"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="FindPerson">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="id" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="FindPersonResponse">
<s:complexType>
<s:sequence>
<s:element name="FindPersonResult" type="s0:Person"/>
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="Employee">
<s:complexContent>
<s:extension base="s0:Person">
<s:sequence>
<s:element minOccurs="0" name="Title">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="50"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="Salary">
<s:simpleType>
<s:restriction base="s:long">
<s:maxInclusive value="100000"/>
<s:minInclusive value="0"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="Notes" type="s:string"/>
<s:element minOccurs="0" name="Picture" type="s:base64Binary"/>
</s:sequence>
</s:extension>
</s:complexContent>
</s:complexType>
<s:complexType name="Person">
<s:sequence>
<s:element name="Name" type="s:string"/>
<s:element name="SSN" type="s:string"/>
<s:element minOccurs="0" name="DOB" type="s:date"/>
<s:element minOccurs="0" name="Home" type="s0:Address"/>
<s:element minOccurs="0" name="Office" type="s0:Address"/>
<s:element minOccurs="0" name="Spouse" type="s0:Person"/>
<s:element minOccurs="0" name="FavoriteColors" type="s0:ArrayOfFavoriteColorsItemString"/>
<s:element minOccurs="0" name="Age" type="s:long"/>
</s:sequence>
</s:complexType>
<s:complexType name="Address">
<s:sequence>
<s:element minOccurs="0" name="Street">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="80"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="City">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="80"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="State">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="2"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="Zip">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="5"/>
</s:restriction>
</s:simpleType>
</s:element>
</s:sequence>
</s:complexType>
<s:complexType name="ArrayOfFavoriteColorsItemString">
<s:sequence>
<s:element maxOccurs="unbounded" minOccurs="0" name="FavoriteColorsItem" nillable="true" type="s:string"/>
</s:sequence>
</s:complexType>
<s:element name="GetByName">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="name" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="GetByNameResponse">
<s:complexType>
<s:sequence>
<s:element name="GetByNameResult" type="s0:DataSet"/>
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="DataSet">
<s:sequence>
<s:element ref="s:schema"/>
<s:any/>
</s:sequence>
</s:complexType>
<s:element name="GetDataSetByName">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="name" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="GetDataSetByNameResponse">
<s:complexType>
<s:sequence>
<s:element name="GetDataSetByNameResult" type="s0:ByNameDataSet"/>
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="ByNameDataSet">
<s:sequence>
<s:any namespace="http://tempuri.org/ByNameDataSet"/>
</s:sequence>
</s:complexType>
<s:element name="GetListByName">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="name" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="GetListByNameResponse">
<s:complexType>
<s:sequence>
<s:element name="GetListByNameResult" type="s0:ArrayOfPersonIdentification"/>
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="ArrayOfPersonIdentification">
<s:sequence>
<s:element maxOccurs="unbounded" minOccurs="0" name="PersonIdentification" nillable="true" type="s0:PersonIdentification"/>
</s:sequence>
</s:complexType>
<s:complexType name="PersonIdentification">
<s:sequence>
<s:element minOccurs="0" name="ID" type="s:string"/>
<s:element name="Name" type="s:string"/>
<s:element name="SSN" type="s:string"/>
<s:element minOccurs="0" name="DOB" type="s:date"/>
</s:sequence>
</s:complexType>
<s:element name="LookupCity">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="zip" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="LookupCityResponse">
<s:complexType>
<s:sequence>
<s:element name="LookupCityResult" type="s0:Address"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="Mission">
<s:complexType>
<s:sequence/>
</s:complexType>
</s:element>
<s:element name="MissionResponse">
<s:complexType>
<s:sequence>
<s:element name="MissionResult" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="QueryByName">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" name="name" type="s:string"/>
</s:sequence>
</s:complexType>
</s:element>
<s:element name="QueryByNameResponse">
<s:complexType>
<s:sequence>
<s:element name="QueryByNameResult" type="s0:QueryByName_DataSet"/>
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="QueryByName_DataSet">
<s:sequence>
<s:any namespace="http://tempuri.org/QueryByName_DataSet"/>
</s:sequence>
</s:complexType>
</s:schema>
</types>
<message name="AddIntegerSoapIn">
<part name="parameters" element="s0:AddInteger"/>
</message>
<message name="AddIntegerSoapOut">
<part name="parameters" element="s0:AddIntegerResponse"/>
</message>
<message name="DivideIntegerSoapIn">
<part name="parameters" element="s0:DivideInteger"/>
</message>
<message name="DivideIntegerSoapOut">
<part name="parameters" element="s0:DivideIntegerResponse"/>
</message>
<message name="FindPersonSoapIn">
<part name="parameters" element="s0:FindPerson"/>
</message>
<message name="FindPersonSoapOut">
<part name="parameters" element="s0:FindPersonResponse"/>
</message>
<message name="GetByNameSoapIn">
<part name="parameters" element="s0:GetByName"/>
</message>
<message name="GetByNameSoapOut">
<part name="parameters" element="s0:GetByNameResponse"/>
</message>
<message name="GetDataSetByNameSoapIn">
<part name="parameters" element="s0:GetDataSetByName"/>
</message>
<message name="GetDataSetByNameSoapOut">
<part name="parameters" element="s0:GetDataSetByNameResponse"/>
</message>
<message name="GetListByNameSoapIn">
<part name="parameters" element="s0:GetListByName"/>
</message>
<message name="GetListByNameSoapOut">
<part name="parameters" element="s0:GetListByNameResponse"/>
</message>
<message name="LookupCitySoapIn">
<part name="parameters" element="s0:LookupCity"/>
</message>
<message name="LookupCitySoapOut">
<part name="parameters" element="s0:LookupCityResponse"/>
</message>
<message name="MissionSoapIn">
<part name="parameters" element="s0:Mission"/>
</message>
<message name="MissionSoapOut">
<part name="parameters" element="s0:MissionResponse"/>
</message>
<message name="QueryByNameSoapIn">
<part name="parameters" element="s0:QueryByName"/>
</message>
<message name="QueryByNameSoapOut">
<part name="parameters" element="s0:QueryByNameResponse"/>
</message>
<portType name="SOAPDemoSoap">
<operation name="AddInteger">
<input message="s0:AddIntegerSoapIn"/>
<output message="s0:AddIntegerSoapOut"/>
</operation>
<operation name="DivideInteger">
<input message="s0:DivideIntegerSoapIn"/>
<output message="s0:DivideIntegerSoapOut"/>
</operation>
<operation name="FindPerson">
<input message="s0:FindPersonSoapIn"/>
<output message="s0:FindPersonSoapOut"/>
</operation>
<operation name="GetByName">
<input message="s0:GetByNameSoapIn"/>
<output message="s0:GetByNameSoapOut"/>
</operation>
<operation name="GetDataSetByName">
<input message="s0:GetDataSetByNameSoapIn"/>
<output message="s0:GetDataSetByNameSoapOut"/>
</operation>
<operation name="GetListByName">
<input message="s0:GetListByNameSoapIn"/>
<output message="s0:GetListByNameSoapOut"/>
</operation>
<operation name="LookupCity">
<input message="s0:LookupCitySoapIn"/>
<output message="s0:LookupCitySoapOut"/>
</operation>
<operation name="Mission">
<input message="s0:MissionSoapIn"/>
<output message="s0:MissionSoapOut"/>
</operation>
<operation name="QueryByName">
<input message="s0:QueryByNameSoapIn"/>
<output message="s0:QueryByNameSoapOut"/>
</operation>
</portType>
<binding name="SOAPDemoSoap" type="s0:SOAPDemoSoap">
<soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document"/>
<operation name="AddInteger">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.AddInteger" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="DivideInteger">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.DivideInteger" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="FindPerson">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.FindPerson" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="GetByName">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.GetByName" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="GetDataSetByName">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.GetDataSetByName" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="GetListByName">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.GetListByName" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="LookupCity">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.LookupCity" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="Mission">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.Mission" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
<operation name="QueryByName">
<soap:operation soapAction="http://tempuri.org/SOAP.Demo.QueryByName" style="document"/>
<input>
<soap:body use="literal"/>
</input>
<output>
<soap:body use="literal"/>
</output>
</operation>
</binding>
<service name="SOAPDemo">
<port name="SOAPDemoSoap" binding="s0:SOAPDemoSoap">
<soap:address location="http://localhost:57772/csp/samples/SOAP.Demo.cls"/>
</port>
</service>
</definitions>This is not a WSDL. it isn't even clean XML
It looks like a broken WSDL you get.
Download it from your SOAP source into a local file and validate it against an XML checker.
it could be your own or any public available service.
Google is your friend to find it.
you didn't tell us the Namespace. Assuming USER.
you have to take care that the Database for USER is part of your durable environment.
after restart of your container any thing not in the durable environment (e.g IRISTEMP) is gone
First, check if the Caché SERVICE (in win sense) gets started as account With enough privileges
Next, check that the installation directory and all sub dir are accessible with all right from this account
Eventually, consider a reinstall / Update with enough ADMINISTRATOR rights
Sorry I saw your FOR loop only when the reply was out already
So you are not hurt by First-Touch effect anyhow.
As it is always the same object even buffer size should have no influence.
is there any other load on the server that could have influence ?