DSXchange

I am not sure how to use DS_CONNECT or where to find it. I am relatively new to using DataStage and we have not had training on it.

We have a server job that extracts data from our system (MAPPER). It connects fine however instead of reading the data in each column, the ODBC connection is getting nothing but the column names repeated as data. So basically, all 172k records read the same - a duplicate of the column name. We have ...

Yes, I was able to recompile the 2nd job and it shows up now in Director, however when I try to run the job, I'm still getting the same error message. Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DB2_DW (Subroutine failed to complete successfully (...

We have a sequence job that was designed in DS Designer named D320_Court_Load_Seq. It consists of 3 jobs -- 1 to extract, one to load to a staging table (in DB2), then the 3rd loads to our production DB2. The problem is that the 2nd job is not showing up at all in DS Director. It is there in the des...

Hi guys, New to the forum and only been working with datastage for a couple of months, and unfortunately, our IBM contract time is up. Trying to make a few changes to jobs and have run into the below error message. Message: Xfm,1: Data string '20101015' does not match format '%yyyy-%mm-%dd': an inte...