DSXchange

The mentioned ODBC/SQL performance issue can be fixed by adding the following environment variable CC_ODBC_SET_COMMIT_MODE and set the value to 1. IBM confirmed that there apprears to be an issue whereby the auto commit property in the connector stage is not being honoured properly. Adding the menti...

To answer your questions: a) The xsd does specify anything regarding nillibility b) As far as I know, the target application/upload program will not accept attributes with xsi:nil="true" and the validation program also flag those elements that are problematic. c) It is worth a try, I will ...

I've removed the 'Created' constant in the Output step and the AMOCoverageBreakdownAssistance element line does not get created - which is great thanks Ernie; but one of the xml file requirements are that I need to print "Created" in the element tag line if there are values being created f...

I need to create xml files from multiple SQL source tables. I've configured the XML stage accordingly with most elements coming into the stage via the HJoin step. PolicyNo is the main 'driver' for the xml files to be generated but not all policies will have all elements generated by the XML. The pro...

Is this 8.7 ? Nope, it's 8.5. But it looks like the XML Validating Parser (target system xml validation tool)is going to be enhanced to sort the generated XMLs (according to XSD order) before validating. I'll mark this post as 'Workaround' for now. Will reopen anther post if the above cannot be ach...

I've failed to include the "xs:sequence" in my initials code snippet, but yes, it does include it: <xs:complexType name="AMOAutoPolicy"> <xs:sequence> <xs:element name="AMICriminalOffence" type="AMICriminalOffence" minOccurs="0" maxOccurs="99&qu...

That is my understanding as well, that the metadata provided by the xsd will 'drive' the output order. I am curious, however, if the order of your output columns in the stage match the xsd? The fields under each element are coming though in the correct order as per the xsd. Just some additional info...

Once you've had a look through the documentation you might want to have a look at the following blog by Ernie Ostic (Dsxchange Member) http://dsrealtime.wordpress.com/, some excellent posts on metadata management, esp. data and business lineage.

Thanks Ernie, I think I've figured it out. The XML stage is going to have multiple inputs and I'll use various HJoin steps to join all the unrelated groups. Multiple Regroup steps will take care of the different parent-child structure. I've managed to build the first few groups, hopefully I'll be ab...

I'm using the new XML assembly and we got the 8.5 Fixpack 1 installed. I agree, there are some good functionality included in the new XML assembly stage, but I'm just not sure how to create multiple parent-child relationships inside of the XML file. I've tried adding in the Regroup step more than on...

We got 8.5 installed as well as the XML Pack. The current solution we need to implement is reading from numerous component tables (38 of them), Driver, Vehicle, Policy, Criminal Offence etc. (all insurance related). Relational data from each of these tables need to be combined and a xml file need to...

Thanks for your help and the post you pointed me to. At the end I was using the following command line to compile the cpp file to an object file: cxx -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- G:/ISProjects/Project_Plus/dev/dev_ExigenMigration/bin/src/DWTimet.cpp -o DWTimet.o There was ...

Thanks James. Would you know if I can use the same compiler to compile to .dll instead of .o? I've actually tested the compiler below, compiling to file DWTime4.dll instead of DWTime4.o. cxx -O -I D:/IBM/InformationServer/Server/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c G:/ISProjects...

I came across quite a few topics with the same error, but none of them with a solution. I'm trying to compile a job with a C++ routine which has been successfully compiled by Visual Studio 2008 command prompt to create a .o file. I've changed my environmental variables to: APT_COMPILEOPT=-W/TP -W/EH...

I recently experienced the above issue when trying to recycle the DataStage Engine services on AIX. The command I was using bin/uv -admin -start from the $DSHOME after source dsenv. However the prompt would return no status. an echo $? however was returning a 2 indicating that there was an error. I ...