DSXchange

I am using a CFF stage to to read a file generated from COBOL, I generated the table defintion from COBOL copy book and using it in CFF stage. I loaded the table defination with "As-is" option. 1. When I try viewing the data with "Enable all group column selection" in Output->Sel...

Hi All,

Is it possible to select Oracle as the database type for picking up the DB sequence in the SCD Stage. We have both DB2 and Oracle in the drop down, but even if we select Oracle and save the job , it changes to DB2.

Thanks in advance.

Re_replace is user defined PX routine which is called in the transformer, and it has been tested in a separate job in the same way it is invoked in this particluar job and it works fine there. Even after removing the routines this error persists.

Yes , I have tried that it now refers to the new link name.

No, everything has been double checked,all the links are mapped and there is no unmapped output link.

Yes its valid, because we are using the transformer stage is other jobs which are running fine and even user defined routines are also used, even the same routine used in this particular job has been tested in other test jobs on the sample data.

Thanks for the reply, I have tried that also, removing the routine and then compiling the job, but still it throws the error.

Thanks Senthil for the reply, i have not enabled the reject port in any of the stage used in the job.

Hi All, I am getting the following error while compiling the job :- Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 19:49:44(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4447 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-...

The file is a simple sequential file, with only one field.

The link name is DSLink8.

Hi All, We are facing a error like :- Filter_9: The specified field: DSLink8.data does not exist in the view adapated schema. The design is like File ------- > Filter -----------> Peek In the filter the condition is something like DSLinkx.data='100' where data is the column from the file. The input ...

Any suggestions.

Hi All, We are facing one problem in job. There is a sequential file stage used in the job and when we try to import the data, the job aborts with the following message:- Consumed more than 100000 bytes looking for record delimiter; aborting Basically the records are xml records and everything is re...

Thanks for the reply, for the above data there is no problem, but for the data that I have posted we are facing the issue. Actually the data looks like :- <Document> ASSET_ALLOC <asset_agmt_set><chronicle_id>5066993935</chronicle_id> <Acct>64401886</Acct> <Inst>7654321</Inst> <Agreed>1</Agreed> </as...