Search found 210 matches
- Wed Feb 12, 2014 2:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating multiple XML files from XML output stage
- Replies: 9
- Views: 5666
Yes Ernie, that works when written by XML output as you said which is if I give filename.xml in the file path of XML output it is generating filename.xml,filename1.xml,filename2.xml....but if I give sequential file and give the same path all the 3 rows are combining into filename.xml.... What change...
- Wed Feb 12, 2014 1:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating multiple XML files from XML output stage
- Replies: 9
- Views: 5666
Thank you Ernie! In the XML_Output stage under stage-->Options--->Write to file where I gave path and the number of files are generated based on the trigger column. But if I follow the same by giving an output link from the XML output to a sequential file then only 1 file is created with all the XML...
- Tue Feb 11, 2014 4:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating multiple XML files from XML output stage
- Replies: 9
- Views: 5666
I used a sort stage before a transformer and then the XML output stage. I sorted using ACC_NO and processed the flow in sequential rather than parallel for the sort stage, transformer and XML output stage. Used the same trigger_column option and three files have been generated. Now I need to load th...
- Sun Feb 09, 2014 12:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating multiple XML files from XML output stage
- Replies: 9
- Views: 5666
- Sat Feb 08, 2014 11:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating multiple XML files from XML output stage
- Replies: 9
- Views: 5666
Generating multiple XML files from XML output stage
I am getting the input as XML and parsing it, which is giving the below records.. Name key Acct ABC 123 111 DEF 456 111 GHI 789 333 JKL 712 222 MNO 765 222 I am sending all these records into XML output stage to form 3 XML files based on the acct number i.e. 111 acct value records will go into one X...
- Wed Jan 29, 2014 5:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting records in form of groups
- Replies: 7
- Views: 3697
- Fri Jan 24, 2014 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting records in form of groups
- Replies: 7
- Views: 3697
When taken the same records given below as example our requirement is the account number 111 which has 2 records should go first as they will combine and form an XML column which will be inserted into the table as one record and later the 333 which has 1 record will go into one XML and get inserted ...
- Thu Jan 23, 2014 9:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting records in form of groups
- Replies: 7
- Views: 3697
Thank you Ray Actually I did start and followed a process but it did not work, what I did is used looping in transformer like below In the input transformer I sorted the with the Account number and used 3 stage variables StageVar1: Name is NumSavedRows Derivation is SaveInputRecord() StageVar2: Name...
- Thu Jan 23, 2014 6:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting records in form of groups
- Replies: 7
- Views: 3697
Inserting records in form of groups
I have a requirement where I need to send records in groups to the table. Below is the example Name Phone Acct ABC 123 111 DEF 456 111 GHI 789 333 JKL 712 222 MNO 765 222 the input from the source is this and I need to send only records which have same account number at a time like 111 has 2 records...
- Wed Dec 18, 2013 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907
The way which Ernie suggested worked for me, loaded the XML CLOB into a file and then parsed it with XML input stage but I have around 15 more transformations to do which should include CLOB column and other columns of the table. So it needs to be a single job, that is the reason I was asking for pa...
- Wed Dec 18, 2013 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907
- Tue Dec 17, 2013 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907
Actually when waiting for the solution for the issue, I tried some options and was updating the output each time I made changes. Now I get the output from the job in first post as wanted but only when I use External source.My requirement is to get the same output when I read the CLOB field informati...
- Tue Dec 17, 2013 8:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907
I removed the text() after / which made the derivation ending with / but still I get the warning and the records are not passing after XML input stage. Below are the warnings XML input document parsing failed. Xalan fatal error (publicId: , systemId: , line: 2, column: 2): Invalid character (Unicode...
- Tue Dec 17, 2013 7:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907
- Tue Dec 17, 2013 6:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input stage
- Replies: 16
- Views: 6907