DSXchange

Could any one provide me with some code on how to actually do it as it would be very helpful. I am trying to make a after job routine for the same but am unable to achieve the desired functionality.

Hi All, In this job I am working at I have to write custom messages in the exception report file. Messages like "Output file failed to open" No of records parsed in each link No of records parsed with a particular field being NULL On completion of output file write it shoul mention that th...

Thanks a ton Ray..!!!

I guess that is where the problem lies.

Thanks

Ramesh

Hi Friends, I was trying to read through a Cobol File which has a occur clause in it. I tried to read data using the complex flat file stage. I am able to read the file however datastage is not able to filter the group according to the occur clause. Ex. 05 FIELD-A PIC X(4) 05 FIELD-E PIC 9(02) 05 FI...

My DS job uses ODBC to connect to DB2. Some of my Jobs fails in between throwing the following error message "INSERT OR UPDATE VALUE OF FOREIGN KEY TGT.ETW_RMS_REG_CUST_NOTES_DTL.ETWREG_ACC_NOTES_R INVALID" In other jobs, the job runs successfully with the similar kind of warnings . How am...

Here You Go... =================================== Code definition. ============== char BLOCKA=' '; char BLOCKB=' '; ============== code - Per records ======================= doTransfer(0); BLOCKA = ' '; BLOCKB = ' '; if (CHD_EXTERNAL_STATUS == 'B') { BLOCKA = 'B'; BLOCKB = 'H'; } else if (CHD_STATU...

Here is the data:
State City
a 1
a 2
a 3
b 4
b 5
c 6

I want remove duplcates (whic i can do using remove duplicate stage). And also want to capture removed duplicates.
i,e,

Output 1:
a 1
b 4
c 6

Output2;
a 2
a 3
a 4
a 5
b 5

Any suggestions.

I have == it was not working too. I made mistake while writing post.

generation of build op fails for incorrect operator ==' If condition with == works fine for all string constants but fails for decimal constants. Here is the code Code definition. ============== char BLOCKA=' '; char BLOCKB=' '; ============== code - Per records ======================= doTransfer(0)...

Gurus, I am just trying to cleanse data and i would like to capture all the rows that is not getting inserted in the target database. One example i am trying is to insert a varchar type into the integer column. I capture the reject records/Filtered records in the transformer using the following Filt...

Yes,

I am trying to insert String into an integer column.

I am getting the following error when i use DB2/UDB stage. "Attempt to convert String value "BADDER" to Long type unsuccessful" The row is getting inserted into the target table with a NULL value in the target column. Is there any way i can stop this and make DB2/UDB stage reject...

Thanks Mate,

The soultion what you have gave dosen't satify my needs. The reject file/table will contain all the records(filtered records+rejected records) and how will i able to differenciate these?

Mate Try using RowProcCompareWithPreviousValue Routine which is written by Datastage which will solve ur problem. The routine will give you the output as below Example: Input Returns 1 0 1 1 1 1 2 0 3 0 4 0 4 1 4 1 5 0

Mate Try using RowProcCompareWithPreviousValue Routine which is written by Datastage which will solve ur problem. The routine will give you the output as below Example: Input Returns 1 0 1 1 1 1 2 0 3 0 4 0 4 1 4 1 5 0