DSXchange

Hi Chandra, Please try this. ACCT -> svNewAcc TYPE -> svNewType RECNO -> svNewRec If svNewAcc = svOldAcc and svNewType = 36 Then 1 else 0 -> sv1 If svNewAcc = svOldAcc and svNewType = 36 Then svoldRec else 0 -> sv2 svNewAcc -> svOldAcc svNewType -> svOldType svNewRec -> svoldRec Put a constraint sv1...

Fixed width file doesn't have a record delimiter. Instead set "Final delimiter = none" at the Record level property.

Hi Ray, Actually I am using the schema file to read the sequential file and hence there is no column defined in the job. The record contents I have sent are of schema file. So I have the only option to reject the record during import. but It is not working for string type column. I also tried puttin...

Hi all, my job is reading the data from sequential file and then loading it into a database. I need to reject the record if the incoming column is null at the source sequential file stage itself. The stage is rejecting the records if null is found in Integer type column but not for string type colum...

Hi Frankline, Thanks for your quick reply. I have already done exatclty in the same way and it was a successful attempt. I was able to separate similar format records into single cff file and then read that file again using cff stage file proper record definition with no record_id since the file con...

Hi All, I have a cobol file containing 6 different format of records. Using copy codes for each type of records I am able to read the first 5 records through CFF stage but not the 6th and subsequent records. The column definition for that record is also correctly defined. Also I have defined one of ...