DSXchange

I stopped the Job from the designer. We even tried restarting the DS server, it still didn't help.

The job was executing without any issues. In the second run I killed the job as it was slow. From there on, I get this below error message. I have no clue what is going on. Please find the error message below Thanks Format..AddressidtbloutHash.Addresstbl: DSD.BCIOpenW call to function SQLExecDirect ...

Date format is 'YYYY-MM-DD' in flat file .. I chnaged the query as you said and now it fails with this message CopyOfAffilInsUpdFlCreate..AFProcess: Exception thrown from CC_DB2DBStatement::executeSelect, file CC_DB2DBStatement.cpp, line 1958: SQLExecute reported: SQLSTATE = 42818: Native Error Code...

Hi craig, I have removed all the fields, now only it has 2 fields. It fails with the following error message CopyOfAffilInsUpdFlCreate..AFProcess: Exception thrown from CC_DB2DBStatement::executeSelect, file CC_DB2DBStatement.cpp, line 1958: SQLExecute reported: SQLSTATE = 22007: Native Error Code =...

SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007 I am using a transformer stage -- which has 2 inputs ( 1 seq file and ref look up) This is a migration project from 7.5 to 8.7 . It worked fine in 7.5 I have lot of date fields. Is there a way to track this field

Hi craig,

We were using ? instead of ORCHESTRATE. We opened a PMR to IBM and they suggested to use ORCHESTRATE instead of ? and it worked fine....

Actually i corrected the above issue, one coulmn definition was wrong.. thanks for your reply

Hi I get the following error in the Server job DSP.Open GCI $DSP.Open error -100.| I am using the below SQL in the DB2 connector stage SELECT a.PERSON_ID,a.CLIENT_NAME,a.AFFL_START_DATE,a.AFFILIATION_TYPE, a.CLIENT_REF_NUMBER,a.UNIT_ID,a.SUB_UNIT_ID,a.VIP_INDICATOR, a.AFFL_END_DATE,a.TERM_REASON_COD...

Hi, We would like to migrate from Ascential to IBM infosphere 8.5. Could you help me getting the below information 1) What are the improvements, changes (algorithm) etc between Ascential Datastage and IBM Infoshpere ? any material will be greatly appreciated 2) Step by Step guide of migration proces...

Hi, We would like to migrate from Ascential to IBM infosphere 8.5. Could you help me getting the below information 1) What are the improvements, changes (algorithm) etc between Ascential and IBM Infoshpere ? any material will be greatly appreciated 2) Step by Step guide of migration process.. New En...