Creating a Fixed Length File

johnshot · Post by **johnshot** » Mon Jun 09, 2008 6:52 am

I'm trying to create a fixed length record, but can't seem to get it to work. I have selected the "Record Length=Fixed" property within the Format tab, all the columns are set to char data types. Any clues???

ArndW · Post by **ArndW** » Mon Jun 09, 2008 6:53 am

How about giving us a hint, just a little hint, on what isn't working?

johnshot · Post by **johnshot** » Mon Jun 09, 2008 9:36 am

The job isn't creating a fixed length record. All the data looks correct, but its not padding out the columns to fit the column's definition. I'm looking at the files in UNIX and they look as if I created them as VarChar Columns.

ArndW · Post by **ArndW** » Mon Jun 09, 2008 9:40 am

Have you looked with a binary editor? Or try setting $APT_STRING_PADCHAR to a space.

johnshot · Post by **johnshot** » Mon Jun 09, 2008 10:56 am

I haven't messed with the environment variables yet... I hoping to avoid that. Its a big pain in our environment. I'll check the binary editor route first.