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
Record delimiter string vs final delimiter string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Dec 09, 2010 4:37 am
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
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
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