Please look at this link which explains how to parse big data in JSON or XML.
Type: Posts; User: barrymavin
Please look at this link which explains how to parse big data in JSON or XML.
SET XMLFORMAT TO ADO is the default in Lianja.
So the COPY command produces XML in Microsoft ADO format. If you execute the following commands in the console workspace you can see the xml output....
Yes, just to explain.
When DEBUG is ON it lets us (and you) see how lianja is introspecting the ActiveX.
Lianja looks into the ActiveX and determines the method and property signatures and...
have a look in debug_client.txt
I'd also like to point out that we do in fact support loading tables from XML in our SQL but the format of that XML has to be in Microsoft ADO format. There are also built-in functions that will map...
Ok then submit an enhancement request on lianja.com. We use an XML parser internally maybe we can expose it as a standard system class.