delete the last row

[ray.wurlod]

The following is how you might do it in DataStage BASIC. Error handling has been omitted for clarity. File1 is the original file, file2 contains one fewer line (the final line) than file1. File1 has been opened for sequential access on variable F1, file2 has been opened for sequential access on variable F2.

Code: Select all

PrevLine = ""
LineCount = 0
Loop
While ReadSeq Line From F1
   If LineCount Then WriteSeq PrevLine To F2 Else NULL
   LineCount += 1
   PrevLine = Line
Repeat

The two CloseSeq statements have also been omitted for clarity.