Re: communicating with a Windows based system

To add, use the FTP subcommand APPEND versus PUT.

The transport is data only. The "definition" of the table is not replaced with PUT; as implied by the DSPFFD in the included script. For a target of database file, a member is created or cleared, and only the data transported. A better name for FTP would be DTP [Data] or RTP [Record; where EOL\EOR delimiters signify a record versus a concept of fixed-length], but its origin is from systems where "everything is a file" so it got the less descriptive name.

Interestingly, the given scenario of duplicate key used to have the defect side-effect of deleting the existing file [or member; I do not recall... obviously for a SQL TABLE the RMVM would also fail]. In that defect, the FTP server did not properly track that it had not created the file.member as target, and mistakenly deleted [the member or the file] in response to the duplicate key error.

Regards, Chuck

rob@xxxxxxxxx wrote:

That was interesting. I would have thought that ftp would not have replaced the rows in a table but would have replaced the table - definition and all. Assume...

CREATE TABLE ROB/MS (MYCHAR CHAR ( 5) NOT NULL WITH DEFAULT,
MYINT INT NOT NULL WITH DEFAULT, PRIMARY KEY (MYCHAR))
INSERT INTO ROB/MS VALUES('a', 2)

C:\qtemp>copy con rob.txt
test^Z
1 file(s) copied.

C:\qtemp>ftp gdisys
Connected to GDISYS.dekko-1.
220-QTCP at GDISYS.dekko-1.
220 Connection will close if idle more than 5 minutes.
User (GDISYS.dekko-1:(none)): rob
331 Enter password.
Password:
230 ROB logged on.
ftp> put rob.txt rob/ms
200 PORT subcommand request successful.
150 Sending file to member MS in file MS in library ROB.
226 File transfer completed successfully.
ftp: 4 bytes sent in 0.00Seconds 4000.00Kbytes/sec.

dspffd rob/ms
Still had the two fields. And the row that I INSERTed with sql was gone and replaced with 'text' from the ftp'd file. Granted, the value of myint was 'interesting'.
select * from rob/ms
....+....1....+....2..
MYCHAR MYINT test 1,077,952,576 ******** End of data
Oh, and the duplicate key
ftp> put rob.txt rob/ms
200 PORT subcommand request successful.
150 Sending file to member MS in file MS in library ROB.
426-Unable to close file. Error code CPE3101.
426 Data transfer ended.
ftp: 16 bytes sent in 0.00Seconds 16000.00Kbytes/sec.
ftp>

WRKACTJOB JOB(QTFTP*)
Duplicate record key in member MS. Duplicate key not allowed for member MS. ? C Cancel reply received for message CPF5026.
2 records lost when member MS closed.

Rob Berendt