DSXchange

Hi I have a requirement that to check for the string in a column and return that entire row to the output . Suppose I have 'true' in the column then return that else return the row which has 'false' . I am trying to do this in stage variable not sure the approach is correct . I have total 6 columns ...

Hi All,

I could able to parse the data but have some other columns in the table I need to extract them to output. I have tried not giving the xpath description but could not get those columns and throwing some weird errors.

Please help me on this one.

Regards
raj

Hi All,

How do I get the other key columns from the database table apart from the column with XML data in it. There are 3 more columns to be copied over to the output file. Is it possible thru XML stage or how should I proceed it.

I really appreciate your help

Regards,
Raj

Hi Eostic,

That means I need to import that single XML chunk into table definition , what If I had different XML formats written to the same sequential file but different rows. Can that be combined and parsed.

Please let me know

Raj

Hi Chulett, Here is the XML that I need to parse out , I first loaded this into the sequential file and need to parse out using XML input stage or transformer not sure what to use. <my:myFields xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-01-25T12:37:20"> <my:CALL...

Hi Eostic, I have tried using Oracle Connector stage in Datastage 9.1 and I can write the rows to a sequential file as you mentioned . But when I tried to import that sequential as XML table definition I am getting this error. "There are multiple root elements at line 10 position 2" . What...

Hi Eostic, I tried doing that but Oracle Enterprise stage is not supporting CLOB datatype and used DRS stage instead but still getting this error "Oracle_Enterprise_0: Error when checking operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: generic:" I app...

I tried to pull one row which has the XML information from the table to the sequential file but receiving fatal error that operated terminated abnormally SIGSEV . Is there any other way to pull this info .

Hi, I have a requirement where I need to parse XML data from a column in a table from Database. I have used XML input stage but getting errors that the link has no derivation values. My design is as below Oracle Stage -----> XML input stage -----> transformer------> seq file stage. I really apprecia...

Hi , I wanted to pass the output from the Exec command output in datastage to user variable actity which holds the list of the files separated by comma delimiter and pass one file to job where i have the loop in place . This is the output from exec command output abc.txt xyz.txt 123.txt These are th...

Hi All, I would like to sort the input column on descending order but facing problem with it. My input data looks Col1, Col2 A, 5 B, 10 C, 15 D,20 E,25 F,30 G,35 H,40 I,45 J,50 I used sort stage in descending order and in sequential mode. and the output I have J,50 A,5 I,45 H,40 G,35 F,30 How to sor...

Thanks Chris It worked . I appreciate your quick response.

Regards,
raj

Hi All, I need to add the date parameter in the column derviation in the transformer stage which the field should be hardcoded with the date paramter . For example List_Id -- " 01_yyyymmdd" I defined the date paramter as todays date in the job paramter I am passing that value in the transf...

Hi All, I am trying to compile my job but it says "An unidentified error has occured" when I clicked on show error button its pointing to Lookup stage in which I am looking up on two fields and making a reject link if lookup failure and writing the rejects to a sequential file. I tried to ...

Hi All, I am facing a problem with the partitioning/collecting method in datastage. I have a job which has two columns Priority_Cd and Priority Order . I have to aggregate count of rows for priority coming from three different files and I have manually derived the priority order column 1 coming from...