DSXchange

No, we are not using any Hash Files.

The table defintions are good.

Hi, I am trying to insert date values into db2 table which is defined as date(10). I tried using both ODBC & DB2UDB stage. When i use ODBC stage, iam getting the following error: Illegal date/time value DATE1 = '01/01/2004' When i use DB2UDB stage, iam getting the following error: " Value t...

Hi, We installed DataStage 7.1 on 2 different servers. The same job works fine on 1 server and does not work on different server. When it comes to a LinkCollector stage in the job, it aborts, stating the following message: ds_ipcopen() - call to OpenFileMapping() failed - The system cannot find the ...

Hii All, I have requirement like this: Date,BusinessDayInd,WeekDayInd,NextBusinessDay 10/28/2004,Y,Y,--------- 10/29/2004,Y,Y,--------- 10/30/2004,N,N,---------- 10/31/2004,N,N,--------- 11/01/2004,Y,Y,---------- Here i have to set the "NextBusinessDay" based on the "BusinessDayInd&q...

Kenneth, To be more clear about my question: I have 7 jobs to be executed through Sequncer. Each job takes more than 15 parameters. Right now i am creating a seperate JobControl job, which will set the parameters and run my jobs from there. DSAttach.. DSRunJob.. DSWait.... I thought there might be s...

Is there any way i can make my Sequencer job to read the JobParameters from a Parameter File? I have 7 jobs to be put in JobSequencer. All these jobs read the parameters from a Parameter File. Instead of manually setting the Parameter values in JobSequencer, can i make the Sequncer job to read from ...

Hi Poorna, Can you please elaborate on what is your input and processing for the above error message? Ketfos I am trying to load data to SQL Server database from a Mainframe data. The Data is in a flatfile, used ComplexFlatfile stage. ComplexFlatfile ->Transform->ODBC I am just loading the data int...

SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=IM974, DBMS.CODE=0
[DataStage][SQL Client]Parameter marker text size exceeds allocated space

Can you any one tell what this error is?

Thanks in Advance