Search found 27 matches
- Wed Apr 13, 2016 4:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in XML Hierarchical stage
- Replies: 3
- Views: 17520
Issue in XML Hierarchical stage
Hi, For Validation of Output XML files we have used XML Parser followed by multiple Switch Step in Assembly editor of XML hierarchical data stage. The parser stage will do the validation and reject the invalid records. Since we have 4 different hierarchies we used 4 switch stage to filter each hiera...
- Wed Apr 13, 2016 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parent Child segment relationship error in IDOC
- Replies: 4
- Views: 6768
Parent child relationship is established based on the Hierarchy level populated in IDoc. HLEVEL column value is generated by the connector stage itself(Lat column in my example), this is not taking the value generated and passed from input link. below is the order expected and created properly by ot...
- Thu Apr 07, 2016 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parent Child segment relationship error in IDOC
- Replies: 4
- Views: 6768
Thanks for the reply Atul, All the Data segments are Optional in my IDOC Type. I had an last segment (LastOPTINALSEG), that I didn't process/ send any data. I tried sending data for all defined segments in IDOC including header and control and LastOPTINALSEG. But still getting same syntax error"...
- Tue Apr 05, 2016 3:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parent Child segment relationship error in IDOC
- Replies: 4
- Views: 6768
Parent Child segment relationship error in IDOC
I'm transmitting an IDOC with below segments in IDOC Type using IDOC Load Connector stage CONTROLREC -- Control Record HDRSEG -- Header DATASEG1 -- Parent Data Segment EXTDATASEG1 -- Child Segment DATASEG2 -- Data Segment ADM_SEGNUM is generated in Connector stage (It is not populated with data move...
- Wed Sep 17, 2014 1:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing XML file via XML Stage
- Replies: 1
- Views: 1492
Parsing XML file via XML Stage
Hi All, We are facing an issue while reading an XML in datastage v8.5 via XML Stage. We have XSD that shows the tree view of how the XML document should look. Say there are 5 hierarchy level defined in XSD and each hierarchy level has its own number of columns. The XML we tried to read is not having...
- Sat Dec 03, 2011 10:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Open command in ODBC stage
- Replies: 4
- Views: 3338
in parallel mode. Actually we need to truncate the table before loading. Since we are using lower version of DB2, We are using delete from table tabe_name in open command of ODBC stage which runs in parallel mode. if the delte command tries to delete the same record in each node the table will get l...
- Fri Dec 02, 2011 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Open command in ODBC stage
- Replies: 4
- Views: 3338
Open command in ODBC stage
Hi,
Will the Query in open command of ODBC stage run once in a parallel job with 4 nodes?
or
Will it run once for each node?
Will the Query in open command of ODBC stage run once in a parallel job with 4 nodes?
or
Will it run once for each node?
- Tue Feb 16, 2010 6:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Lookup stage with too many number of references
- Replies: 2
- Views: 2812
Error in Lookup stage with too many number of references
I'm having a job as below Reference Datasets (16 numbers) | | Dataset ---> Lookup -----> Transformer--->dataset I'm getting follwoing error... 692 INFO Tue Feb 16 06:31:14 2010 main_program: APT configuration file: /dsadm/Ascential/DataStage/Configurations/default.apt (...) 693 FATAL Tue Feb 16 06:3...
- Tue Dec 23, 2008 12:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cannot view full Log Detail for SQL *Loader
- Replies: 7
- Views: 3624
- Mon Dec 22, 2008 7:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cannot view full Log Detail for SQL *Loader
- Replies: 7
- Views: 3624
Cannot view full Log Detail for SQL *Loader
Hi, I'm having a unix script ICF_LAB_SERV_LINE_DETL.sh. This script has been called in Sequencer job. This script is used to load a table with SQL Loader. While running, I got an SQL Loader error. Checking in Datastage Director I can view LabStandardProcessingSeq.61.JobControl (ExecSH): Error when e...
- Sat Nov 29, 2008 5:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command to clear the log file
- Replies: 4
- Views: 2991
- Thu Nov 27, 2008 5:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command to clear the log file
- Replies: 4
- Views: 2991
Command to clear the log file
Hi,
I want to clear the logs (if exists) before running the job.
I want to do it with unix command. Is there any command for that?
I want to clear the logs (if exists) before running the job.
I want to do it with unix command. Is there any command for that?
- Wed Jul 23, 2008 12:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Round robin partition
- Replies: 1
- Views: 1802
Round robin partition
Hi, I want to split the number of records equally in each partiton. So I have used Roun Robin partition in Transformer stage. Job looks like Dataset Datasets(3) | | | | | | | | Dataset---join------Lookup-------Transformer-----Seq. File I'm having 50 records in input. In 2 node processing each node s...
- Fri Mar 07, 2008 4:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substring using modify stage
- Replies: 15
- Views: 8163
- Fri Mar 07, 2008 3:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substring using modify stage
- Replies: 15
- Views: 8163