DSXchange

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...

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...

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"...

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...

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...

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...

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?

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...

Hi,
Thanks for the reply.

I can able to view the log details with more than 30 lines also using -logdetail command. Why not SQL Loader alone?

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...

How can I set set the autopurge settings ?

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?

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...

Thank you. I got the output.

ok. I'm new to modify satge. can you please tell me how to get my desired format.