Page 1 of 1

Creating a Fixed Length File

Posted: Mon Jun 09, 2008 6:52 am
by johnshot
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???

Posted: Mon Jun 09, 2008 6:53 am
by ArndW
How about giving us a hint, just a little hint, on what isn't working?

Posted: Mon Jun 09, 2008 9:36 am
by johnshot
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.

Posted: Mon Jun 09, 2008 9:40 am
by ArndW
Have you looked with a binary editor? Or try setting $APT_STRING_PADCHAR to a space.

Posted: Mon Jun 09, 2008 10:56 am
by johnshot
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.