DSXchange

Hi, We are having a requirement to create a Adapter for performing folwoing task: 1. Read the receipts XML records from MQ. 2. Translate the XML fields into Cobol Copy Book format (EDI multi level format). 3. Write the output into the EDI MQ, I xml per (EDI multi level record) . The challenges we ar...

Thanks chulett

I will try the two options folder and external stage..

Yes you are correct! parsing directly while reading from the database won't give this issue From the database the xmls are landed in the sequential file I found one more option where if you validate your xml with schema then it will strip off the CRLF from the sequential file. I can't change change ...

hi All, I am getting xmls from my souce with CRLF characters after each tag, while parsing with xml input it fails. As a wor around i added Erepacle for search and strip off CRLF in the datastage transformer after my ORAOC19 stage in the server job , the message are stored as clob. Another way i tri...

hi, My source and target is xml, i need to do some translation and transformation to this input xml. earlier i had only translation so i was not parsing my xml achiveing it with xslt. Now i need to look up database to fech some value. Problem is i have repeating elements at same level. Please sugges...

In that case your master job would have a polling mechanism for triggering and it might be looping through list of jobs in csv files, after reading your .ini file. update your .ini file with startdate parameter and csv with your job 1st creating startdate file then your select job. Here you just nee...

Sorry... :oops: completely missed your note Note : we are not using Sequencer Jobs Could you pls share some more info about your master job is this a parallel job/server basic job which reads your param file and csv file of job names to call the jobs in sequence. Please elaborate on your master cont...

is ur control job a sequencer job which controls the flow of the jobs

if yes while configuring job activity the sequencer will over right the value of the job called.

the way i understood your design is : 1st job creating a sequencial file with subquery to get the date field (which you are reading through unix command) 2nd job actual extract query Now, if these two jobs are in different sequencer job is easy just map your jobparameter while calling your dsjob -pa...

pls use the information provided in the designer while configuring column generater under colum to generate Name of column to be added to row by the generator. To control the way random data is generated, open up the column editor for the output column and select Parallel Generator properties. go to...

I have 15 columns all defined with datatype & length.

You can produce this error by selecting null as column, although datatype(length) is defined.

Thanks,
Aruna

i had never specified varchar(0), it was always varchar(10), i said i was sorry i missed to share this info in this forum. In datastage it was always there Ray

i will go with the suggestion provided CAST(null AS VarChar2(10)) cr_code and with below theory not sure though that it's fully correct! oracle nulls can be identified where as for datastage null should be converted to a form or metadata datastage is aware off hence it worked once null is explicitly...

sorry to miss the length it's 10.

hi, I want to select some of my columns as null from the database oracle like select t1.fd_id, t2.px_number, null cr_code, null pt_code from table1 t1, table2 t2 this query works fine in sqlplus and sqldeveloper where as in datastage it giving following error db_Tx_data: Error when checking operator...