RE: FTP Format

Well, I finally make contact with the POS vendor's developer. The original
message regarding FTP came from his boss. He thought that was a bad idea,
too. (Bosses: What're gonna do?) He said that he uses OLEDB and thought
that simply adding the records using SQL would be easier and better for both
of us.

Since the back-end programs are written and tested (using test data
generated from our history), he and I will test it once he gets the
front-end done.

Jerry C. Adams
IBM i Programmer/Analyst
"Derrick" - (originally a scaffold) named after London hangman Goodman
Derrick. -EUI
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, November 15, 2011 1:09 PM
To: Midrange Systems Technical Discussion
Subject: Re: FTP Format

I guess you could go straight to the /qsys.lib file system. Bypasses
having to read stream files. Which may simplify it for you.

C:\qtemp\PMR\logs>copy con testme.txt
This is a file,01.12,the walrus is dead^Z
1 file(s) copied.

C:\qtemp\PMR\logs>ftp gdisys
Connected to gdisys.dekko-1.
220-QTCP at GDISYS.
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> bin
200 Representation type is binary IMAGE.
ftp> put testme.txt /qsys.lib/rob.lib/testmez.file/testme.mbr
200 PORT subcommand request successful.
150-NAMEFMT set to 1.
150 Sending file to member TESTME in file TESTMEZ in library ROB.
226 File transfer completed successfully.
ftp: 39 bytes sent in 0.00Seconds 39000.00Kbytes/sec.

DSPPFM FILE(ROB/TESTMEZ) MBR(TESTME)
all garbage!
dltf rob/testmez

ftp> asc
200 Representation type is ASCII nonprint.
ftp> put testme.txt /qsys.lib/rob.lib/testmez.file/testme.mbr
200 PORT subcommand request successful.
150 Sending file to member TESTME in file TESTMEZ in library ROB.
226 File transfer completed successfully.
ftp: 39 bytes sent in 0.00Seconds 39000.00Kbytes/sec.

DSPPFM FILE(ROB/TESTMEZ) MBR(TESTME)
*...+....1....+....2....+....3....+....
This is a file,01.12,the walrus is dead

DSPFD ROB/TESTMEZ
(keep in mind that ftp command created the file)
File Description Header
File . . . . . . . . . . . . . . . . . . . : FILE TESTMEZ
Library . . . . . . . . . . . . . . . . . . : ROB
Type of file . . . . . . . . . . . . . . . : Physical
File type . . . . . . . . . . . . . . . . . : FILETYPE *DATA
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
Record Format List
Record Format Level
Format Fields Length Identifier
TESTMEZ 1 39 391E07832AC44
Text . . . . . . . . . . . . . . . . . . . :
Total number of formats . . . . . . . . . . : 1
Total number of fields . . . . . . . . . . . : 1


DSPFFD ROB/TESTMEZ
Record Format Information
Record format . . . . . . . . . . . . . . . : TESTMEZ
Format level identifier . . . . . . . . . . : 391E07832AC44
Number of fields . . . . . . . . . . . . . : 1
Record length . . . . . . . . . . . . . . . : 39
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
TESTMEZ CHAR 39 39 1 Both TESTMEZ
Coded Character Set Identifier . . . . . : 500


Rob Berendt