You did say libraries, not directories.
By IFS did you mean ftping from
/QSYS.LIB/AMFLIB.LIB/*
I really don't think that will maintain the attributes. For example
CREATE TABLE ROB/NICKY
(MYCHAR CHAR (15 ),
MYDEC DEC (7 , 2),
MYZONE NUMERIC (7 , 2))
Table NICKY created in ROB.
INSERT INTO ROB/NICKY VALUES('A', 1.2, 2.3)
1 rows inserted in NICKY in ROB.
INSERT INTO ROB/NICKY VALUES('B', 3.4, 4.5)
1 rows inserted in NICKY in ROB.

From my PC:
C:\Documents and Settings\ROB>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> cd /qsys.lib/rob.lib
250-NAMEFMT set to 1.
250 "/QSYS.LIB/ROB.LIB" is current library.
ftp> bin
200 Representation type is binary IMAGE.
ftp> get nicky.file
200 PORT subcommand request successful.
150 Retrieving member NICKY in file NICKY in library ROB.
226 File transfer completed successfully.
ftp: 52 bytes received in 0.08Seconds 0.67Kbytes/sec.

Back on the i5
drop table rob/nicky

Back in the same ftp session on my pc
ftp> put nicky.file
200 PORT subcommand request successful.
150 Sending file to member NICKY in file NICKY in library ROB.
226 File transfer completed successfully.
ftp: 52 bytes sent in 0.00Seconds 52000.00Kbytes/sec.

Back on the i5
select * from rob/nicky
....+....1....+....2....+....3....+....4....+....5..
NICKY
A * 0000230B * 0000450
******** End of data ********
Cannot show this data at the display station.

Notice, one big field?
Also notice, two records are now in one record? "A" and "B"?

Summary: Do not bypass saving it to save file or virtual tape.

Rob Berendt

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].