FTP Format

We currently get some of our orders through a very convoluted process that
we are trying to streamline. This requires some changes to the software
that sits on our Point-of-Sales PCs.



The software vendor has suggested FTP of the orders to our system (FWIW,
Model 250 running V5R1) directly into a file. The latter part (direct to a
file) is okay by me and even preferred. My question to the group is: Isn't
FTP just a character-by-character transmission? That is, the item number
may be 1-5 numbers (1-99999). If only '1' is transmitted, would not that
mean that everything gets PUT into the wrong locations of an SQL DDL file on
our system in that case?



My preference is for them to just use an ODBC connection and use SQL to
INSERT the records into the file.



Jerry C. Adams

IBM i Programmer/Analyst

The scientific unit of beauty is the millihelen, defined as the amount of
beauty to launch one ship. -EUI

--

A&K Wholesale

Murfreesboro, TN

615-867-5070