Hi Tim,
I'm highly interested to see this result.
I tried to do something similar recently to to be able to feed back to the sender what was wrong if something was wrong.
I failed to get the combinations of params for XERCES parser right. XMLIGNORE* worked OK but was not so useful.
You might have a shorter link to contact Marvin Tenner then me. 
As we see your ID is combined by 3 properties
for the sake of this example I name them id01, id02, id03
so your ID is this combination ID = id01_"||"_id02,_"||"_id03
so you may reformulate your query to make it readable
I'd suggest you apply as Support Engineer @ InterSystems
and over the years you might learn all the secrets of Caché.
I doubt what you ask for is subject for a public forum.
check side conditions of the related column.
from docs:
See details here:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
especially:
Sample Global Names and Their Uses
If your connection is not stable enough I'd suggest to take a closer look to good old Shadowing.
It's really jungle proof.
I used it in past to transfer data from an oil drill platform somewhere out on the ocean over a satellite link with just 64k bd bandwidth without any data loss. And this link was far from whatever you would expect from a wired connection on ground.
Shadowing did id with incredible stability and no loss.
Cascading of shadowing is also almost unlimited with no issue.
That really sounds like Shadowing or Asynchronous Mirror.
All you have to do is map your Globals,.. to a DB to be "exported"
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
teak a look to it.
It's a rare case in combination with %Persistent,
but it makes sense also to exclude any class with Property Abstract=1 in your Query
Firefox Quantum 57.0 (64-bit) worked immediately
Chrome Version 62.0.3202.94 (Offizieller Build) (64-Bit) had troubles.
Thanks Stephen,
Its the same link but works from course page + in different browser
??? and how do you include this in ENSEMBLE ???
Example WebService:
Example Schema1
<?xml version="1.0" encoding="UTF-8"?>
<s:schema xmlns:s="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<s:complexType name="Schema1">
<s:sequence>
<s:element name="Max_Results">
<s:simpleType>
<s:restriction base="s:long">
<s:minInclusive value="1"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element name="Home-State">
<s:simpleType>
<s:restriction base="s:string">
<s:maxLength value="2"/>
<s:minLength value="2"/>
</s:restriction>
</s:simpleType>
</s:element>
<s:element minOccurs="0" name="Office-State" type="s:string"/>
<s:element minOccurs="0" name="Name-Startswith" type="s:string"/>
</s:sequence>
</s:complexType>
</s:schema>
Example Schema2
<?xml version="1.0" encoding="UTF-8"?>
<s:schema xmlns:s="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<s:complexType name="Schema2">
<s:sequence>
<s:element minOccurs="0" name="Results" type="ArrayOfSchema2Result"/>
</s:sequence>
</s:complexType>
<s:complexType name="ArrayOfSchema2Result">
<s:sequence>
<s:element maxOccurs="unbounded" minOccurs="0" name="Schema2Result" nillable="true" type="Schema2Result"/>
</s:sequence>
</s:complexType>
<s:complexType name="Schema2Result">
<s:sequence>
<s:element minOccurs="0" name="Home-Address" type="Address"/>
<s:element minOccurs="0" name="Office-Address" type="Address"/>
<s:element minOccurs="0" name="Person-Name" type="s:string"/>
<s:element minOccurs="0" name="Person-ID" 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:schema>
You may take this approach:
create an object based on Schema1: My.Schema1
create an object based on Schema2: My.Schema2
HowTo: => XML Schema Wizzard
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
Then you may use this method.
My.Schema1 is checked as input parameter according tothe generated class
inside your Method you transform it to My.Schema2
and return it.
The most tricky thing might be how to reply to a request that doesn't match Schema1.
Rebuild takes time - ONCE
and gives you the unique chance to fill the created index in contiguous global content blocks.
That pays back at ever access by less global pointer blocks whatever storage technology you use.
Nope
https://learning.intersystems.com/pluginfile.php/15097/mod_resource/con…
Next:
Download PDF
downloads a html page but with .PDF termination.
I'm not an expert on callout but deep back in history I believe to remember that what ever you
transfer is in wider sense a single item. If string structured by $p() or $lb().
You my take a closer look to %XML.SAX.* classes.
The highest structure is $LB(). Which is a string under cover.
And take care of the 32k limit
so $lb($$$FIXSTR,text) since $L(text) is included there anyhow
and $$$FIXSTR tells you that it's < 32
why not $lb(166,"Fringe") ?
I'd suggest to use $LB() if you are not hit by the LongString limit.
why: all packaging, selection,.... is already done and "hard wired" in C++
with $C() you may re-invent $LB() or $Piece() or similar. And you have to do it in COS.
Same applies to local array where you may iterate over the structure in COS again.
Nothing against COS but C++ (in COS Functions) IS faster
Thank you, Dan!
I was pretty sure to miss some cases.
SOID is probably the one nobody else would be aware of that it exists.
similar in practice if you run bookkeeping as a service.
master has full access and has the responsibility for the content. Using Work class
clients have just read access to most fields. Using Client class.
I didn't say tax control doesn't see everything. Using Government class
A few recommendations:
#2) save you original Global as you do otherwise. [Just to be Save]
#1) In Studio Copy class has a checkbox to copy Storage Definition (=Globals) . Set it.
In the new class add ClassParameter MANAGEDEXTENT=0 ;
So the old and the new class use the same Globals.
Now go on with #3 to #6
If you miss something in refactoring the damage should be limited as you just change names not the Storage in Globals.
Assuming the change of ClassName is all you do.
I see. It's hard generated
IndexNext distracted me
But you may call it individually. With your sequence then.
For %BuildIndices you may provide a list or use default. it doesn't affect sequence
example from Sample.Person.1.Int
%Save does it straight by ASSCII sorting of index names (lower after Upper case)
See %SaveData(id) in the generated .int
ok.
You followed the direction: that you mark the "unavailable" value by a UNIQUE value.
So for SQL it's NOT NULL.
I agree with you that NullString (COS) => String of length 0 and NULL(SQL) is confusing
[since invention of SQL in the late 60ties]
Take a closer look to %Library.Date, %Library.TimeStamp, %Library.Integer
and you will see the various methods for LogicalTo.....
The switch you select applies to the final presentation only. Not to internal calculations.
I think there is a basic misunderstanding of what NULL means in SQL.
NULL in SQL means unknown / undefined value / any value
Which is to my understanding a clear contradiction to uniqueness.
If you assign yourself something indicating NO VALUE ( e.g '') then it works but it isn't NULL anymore in the sense of SQL.
as documented in
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
DATEPART delivers a %Integer value.
Differently to %Date which has different display, logical and ODBC presentation %Integer does not follow any specific presentation but is just Integer and nothing else.
And your input to DATEPART function is in any example the same: the logical value of TimeCreated.
To cover your expectations you would need to adapt your input yourself. eg by %ODBCOUT() function.
or the related LogicalToDisplay function.
Your expectation that a data type %Integer does a revers research how it was calculated is just un-realistic.