512 byte Fixed length EBCIDIC

zaino22 · Post by **zaino22** » Tue Dec 04, 2007 1:50 pm

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.

landaghaar · Post by **landaghaar** » Wed Dec 05, 2007 8:20 am

when you create the copy book for the EBCIDIC file, you use COMP-3 and (19,2) or (17,2) look at it, it will tell you the size in bytes. it is perhaps 6 or 7 bytes. fix your filler accordingly.