DSXchange

I have a list of filenames in a file and i want to pass these file names in parameter and want to run my job for each file by keep in loop using job sequencer. in each files header is record count and and following are data. example: file1timestamp.txt ----------------------- 3 1 rec1 2 rec2 3 rec3 ...

No, I did not moved .o file to any where.but my make file copying file to prior directory.

Here are my enteries in general tab.

Routine name =pxEreplace
Type = External Function
Object Type = Object
External subroutine name = pxEreplace
Return Type =char*
Library Path =/code/ETL/dsroutine/ pxEreplace.o

I just deleted and recreated the routine.Right now it is not giving error in compile time but giving in runtime. Transformer_8: Failed to load the library "V1S1_CFF_TST1_Transformer_8.so"; either the directory containing the library file is not on the library search path, or the library wa...

The code is working fine when executed.But not working in datastage.

yes betterthanever ,
i have kept every thing in correct options.

Guru's i have used above programme but i am facing the below error while compile time. ##I IIS-DSEE-TFCN-00001 15:02:40(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.5075 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TUTL-00031 15:02:40(001) <...

I am not getting any warnings/errors.But it stop reading from <color><blue></color>.
<blue> is not an element it is data for color element.

Hi, i am unable to read the following data through xml input stage. <?xml version="1.0" encoding="UTF-8"?> <XML> <product> <number>123</number> <color><blue></color> <location>A</location> </product> </XML> Here i have issue with <color><blue></color> . Thanks Kris

Here the sequential file doing the same what the External source stage.i mean we are using Seq file stage to read the input name of the xml document.

At the outset it's not able to read the record.

From the XML itself Dropping the Rows.

Seq------>XML---------->Tx----------->Seq.
0Rows 0 Rows

I believe this makes sense.

yes iam using xml input stage.I hve tried with highlighting "Log reject errors" on the General tab but i didnot see any change.
even i tried with convert function using ASCII value 179 but no luck.

It's not issuing any errors/warnings.The job has been successfully compleated but it processed one record instead of two.And NLS is disabled in project level.

Actually file is coming with .txt but contents are in XML format.

I did not see any XSD option in import tab. I renamed File1.txt to File1.xsd and tried to import using XML Table definitions... it is throwing following error: Line 2,Position2:Expected Schema root.Make sure that the root element is <schema> and the namespace is 'htt//www.w3.org/2001/XMLSchema' for ...