DSXchange

Is your datastage configuration running with 4 nodes, with the partitioning (dataset properties, input tab, partitioning subtab) set to ENTIRE ?

a) It isn't up to me. Client is upgrading to 8.1 or 8.5 anyway.

b) usually, I just need the lowest/leaf of every branch

c) Yes, it looks like I'll have to

In the metadata for the lookup, try setting the columns to be nullable, both on inut to the lookup stage and on output from the lookup stage.

Thanks Ernie. This is very helpful. re : a) does the importer for 8.5 (schema manager?) understand all of the current constructs? I think the "mixed=true" is in the 2004 spec, AFTER the 7.5 importer was released. b & c) The message is in a 2Mb - 2Gb CLOB/xml transaction. The structure ...

As per the example at http://www.w3.org/TR/2004/REC-xmlschema-0-20041028/#mixedContent Xml importer cannot find the text value of the complex element. I coded the example in an xsd and imported via the xml schema importer in 7.5. Autochecking the nodes did not check the value for "letterbody&qu...

I've looked at a few posts, especially http://www.dsxchange.com/viewtopic.php?t=129785&highlight=Consumed+more+than+100000+bytes+looking+for+record+delimiter I'm using 7.5x2 (windows server). The input file contains several columns (keys and other data) and then has 2 columns containing very lon...

Re : excellent post by Vincent McBurney, Nov 2007 :
http://it.toolbox.com/blogs/infosphere/ ... ster-20368

Is ist still true that the modify stage doesn't create any extra processes? I still see logging for this stage in director.

Not yet. But it sounds interesting. Will have a look at it tonight.

I got a SIMILAR error message "Array execute failed for insert" when accessing an Oracle CLOB via the Oracle Enterprise Stage. IBM support stated that ORACLE CLOB is not supported in the Oracle Enterprise Stage. Thye suggested I use the ODBC Stage or the Dynamic RDBMS Stage instead. http:/...

According to the IBM support rep, accessing a CLOB via the Oracle EE Stage is NOT supported. :cry: They suggested I try the ODBC or DRS Stage. I tried the DRS Stage with the DBMS set to "Oracle" and this worked very well. :D Apparently this is posted in an APAR, but I don't even know whete...

Is there an option, perhaps in "advanced connection options" or in the DS server or project that needs to be set/updated for the DS-to-Oracle connection to handle CLOBs correctly ?

rcanaran wrote:Opps. Sorry.

copied post to Enterprise Edition forum.

http://www.dsxchange.com/viewtopic.php?t=130465 http://www.dsxchange.com/viewtopic.php?t=112286 I've already looked at the 2 above. Error message is : oreLoadTable,0: Array execute failed for insert: insert is: INSERT INTO BAL_RECON (BAL_RECON_ID, SRC_TYP_CD, SRC_TXT, SUBJ_TYP_CD, SUBJ_SUB_TYP_CD, O...

Opps. Sorry.

http://www.dsxchange.com/viewtopic.php?t=130465 http://www.dsxchange.com/viewtopic.php?t=112286 I've already looked at the 2 above. Error message is : oreLoadTable,0: Array execute failed for insert: insert is: INSERT INTO BAL_RECON (BAL_RECON_ID, SRC_TYP_CD, SRC_TXT, SUBJ_TYP_CD, SUBJ_SUB_TYP_CD, O...