Reject Mode in Sequential File

vinodn · Post by **vinodn** » Mon Sep 17, 2007 1:40 am

Hi,

I am having a file of length 800, if the record size is above 800 i need to abort the job and go the next file to process.

I would like to know is there any restrictions that a Sequential File will hold only less than 400, as because if the length is 400 it is working fine.

JoshGeorge · Post by **JoshGeorge** » Mon Sep 17, 2007 3:35 am

Byte

Kilobyte

Megabyte

Raghavendra · Post by **Raghavendra** » Mon Sep 17, 2007 3:47 am

I believe the sequential file limit is at Operating system level. The limit will be set by your Unix admin.

JoshGeorge · Post by **JoshGeorge** » Mon Sep 17, 2007 4:02 am

By default there is a record size limit in datastage. Pls. refer HERE

Check the file size in the sequence job just before calling your main job and if your expectation doesn't match don't call the processing job, loop back .

vinodn wrote: I am having a file of length 800, if the record size is above 800 i need to abort the job and go the next file to process.
.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 3:38 pm

Use an Execute Command activity to test the size of head -1 filename

DSXchange

Reject Mode in Sequential File

Reject Mode in Sequential File

Re: Reject Mode in Sequential File