Re: FTP Processing

What about any completion messages?

DB2 file
put rob/deleteme rob/deleteme
226 File transfer completed successfully.
20 bytes transferred in 0.002 seconds. Transfer rate 10.240 KB/sec.
This 20 bytes refers only to the data space size. Determined by the
CRTPF FILE(ROB/DELETEME) RCDLEN(10)
and the two rows I put into it. Two ten byte rows equals 20 bytes.
Therefore it doesn't include the information displayed with DSPFFD or
DSPFD.
And I got 20 bytes if the file existed beforehand or not. If it wasn't
created correctly beforehand I got a single row table (think pivot
table!).

Stream file
put /rob/a.txt /rob/a.tst
...
File transfer completed successfully.
6 bytes transferred in 0.001 seconds. Transfer rate 6.144 KB/sec.

Object . . . . . . : /rob/a.txt
Size of object data in bytes . . . . . : 6

Now script this:

CRTPF QTEMP/FTPIN RCDLEN(100)
UPDDTA QTEMP/FTPIN

DSPPFM QTEMP/FTPIN
ROB mypassword
BIN
PUT ROB/DELETEME ROB/DELETEME
QUIT

CRTPF QTEMP/FTPOUT RCDLEN(100)
OVRDBF FILE(INPUT) TOFILE(QTEMP/FTPIN)
OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPOUT)
FTP RMTSYS(mylpar)
DSPPFM QTEMP/FTPOUT
...
226 File transfer completed successfully.
20 bytes transferred in 0.002 seconds. Transfer rate 10.240 KB/sec.
...

You may prefer FTPAPI over this but a lot of people use this technique.

Rob Berendt