Re: communicating with a Windows based system

Michael,

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