Length mismatch
Posted: Mon Jun 10, 2013 6:15 am
Hi,
My file has records of length 100 bytes and it is fixed width.
I need to reject record if it does not have actul length.
In transformer constraint, Im checking the length of the record.
If it equals to 100, then sending to target, else sending to reject file.
I have 2 records which is having length less than actual in source file.ie., 98 bytes.However, when I run the job, only one record got rejected.
in unix when I checked length of 2 records, its giving 98 bytes.
In job, rejected record giving length of 99 bytes and the other record(which is expected to be rejected) showing length of 100 bytes.
Can anyone help me, why both the records are not rejected and why mismatch in length of unix and datastage?
My file has records of length 100 bytes and it is fixed width.
I need to reject record if it does not have actul length.
In transformer constraint, Im checking the length of the record.
If it equals to 100, then sending to target, else sending to reject file.
I have 2 records which is having length less than actual in source file.ie., 98 bytes.However, when I run the job, only one record got rejected.
in unix when I checked length of 2 records, its giving 98 bytes.
In job, rejected record giving length of 99 bytes and the other record(which is expected to be rejected) showing length of 100 bytes.
Can anyone help me, why both the records are not rejected and why mismatch in length of unix and datastage?