MVSFORUMS.com

If you don't care about the sign how about this:

WORKING-STORAGE SECTION.
01 WS-AMOUNT PIC S9(3)V99 VALUE +123.45.
01 WS-AMT PIC 9(5) ...

This is how we use FTP:

//******************************************************
//FTPSTEP EXEC PGM=FTP
//SYSPRINT DD SYSOUT=* ...

It's also possible that the input data is different between production and development. Just a thought.

Could you put a check in to see if the file exist? If not then bypass the FTP step. I am with expat though, create the file in the ftp step with the lrecl you need.

Ok here is another silly idea... Very Happy

Define the output file as a sequential file with a disp of old. When the job is done kick off another job to offload the data to somewhere - anywhere(FTP?). W ...

What if you determined the maximum number of records that the file can hold then keep a record count of the records written and when the get close to the maximum close the file and reopen a new one.

Sounds like you are allocating more space that you need. It looks like a Computer Associates message. How much of the space allocated is actually being used?

The problem with saving it as a PRN file is that unless each column in the spread sheet is set to left or right justify you will have problems when you have a mixture of numbers in one cell in the col ...

I use Active States Perl on my Windows PC to extract the cells from an Excel spread sheet and place them in a text file formatted to what I need. Here is a link:
http://aspn.activestate.com/ASPN/doc ...

You can use Active States Perl version to extract cells from a MS Spread Sheet and create a text file. Here is a link:
http://aspn.activestate.com/ASPN/docs/ActivePerl/5.8/faq/Windows/ActivePerl-Win ...

The parm - &WORK is for the value SYSDA.

You would do it through your JCL. Here is a example:

//SORTWK01 DD UNIT=&WORK, <--- SORT WORK SPACE
// SPACE=(CYL,(10),,CONTIG) ...

What is the compile error that you are receiving?

Hi Slade,
Don't be afraid when you are correct. Thank you for correcting my mistake. Must have had a brain fart. I don't know what I was thinking.

I count them both as 5 bytes long due to the sign. The "Sign leading separate" phrase should not make a difference when determining what number of bytes are used to store the value.