Record delimiter string vs final delimiter string

[dsscholar]

Hi all,

In sequential file, in format tab, two options are there as record delimiter string and final delimiter string. whats the difference between them.

In my job,

I load 4 records to a sequential file and the format specified is "final delimiter = ~ ".. And in another job when i extract data from that sequential file with option as "record delimiter string = ~" the record count is 5. why is it so. If its final delimiter string,its extracting only 4 records.

Please explain the difference.

Thanks in advance

[vishal_rastogi]

i think it is like

for example i have record
asdfg|asdghyt|bhgft65|njnjh;

here '|' is the record delimiter and ';' is the final delimiter

experts please correct me if i am wrong

[jwiles]

Partially correct.

Have you read what the product documentation contains about these two items? Read <a href="http://publib.boulder.ibm.com/infocente ... 2%20">this page</a> about the Sequential File operator.

Regards,

[dsscholar]

Theoritically it makes some sense.

Final delimiter string : at the end of the last column
Record delimiter string : at the end of the record.

Practically both are same only right. At the end of the record and at the end of the last column in each record. Please explain with one sample.

Thanks in advance

[suse_dk]

example:

Field delimiter ','
Final delimiter '|'
record delimiter '\'

...having 3 fields would then give:

test1,test2|test3\