I am asked to modify an existing job that extracts from SQL server, and produces EBCIDIC, FIXED LENGTH file. I have to add 2 new decimal fields to it. In Sql server extraction stage (starting stage), these two fields are DECIMAL (19,2) each, and in the EBCIDIC stage (output stage) these fields are DECIMAL (17,2) each. Since output File must conform to 512 bytes, i need to modify filler in order to hve fixed length. Currently Filler is CHAR (LENGTH 249). I am not sure how much Filler i have to reduce to conform to 512 bytes, any idea?
I'll appreciate it.
512 byte Fixed length EBCIDIC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada