Raggy,
On the Sequential File stage where you are writing the data out, do you have the "Update Action" set to "Overwrite existing file" or "Append to existing file"?
Also, you may want to land the data in another sequential file, then delete the original and rename the file you wrote to the original name. Just a suggestion.
Let us know what fixes it[:)]
Good Luck,
Tony
?? Loop Through File & Modify Fields ??
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Just to tidy this one up, you CAN update sequential files with DataStage BASIC, but the filepointer must be manipulated exactly (using SEEK, and the FILEINFO function to determine position to which to return) and the line length cannot be changed.
The two file approach is definitely better.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
The two file approach is definitely better.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518