Re: File transfer

["Scott P. Johnson" <sjohnson@xxxxxxxxxxxxx>]

How about using ODBC and SQL???  I am not sure if this would
work, but thought it was a good idea.  I don't think any
conversion pgm or file download would be required.  Just
an undate or insert SQL statement on the NT box and refer
to the AS/400 DB thru the ODBC.  Or which ever way you 
are going.?.?
-- 
------------------------------------------------------
Scott P. Johnson
Programmer/Analyst
IBM Certified Specialist - AS/400 RPG Programmer
Highsmith Inc.
W5527 Hwy 106, PO BOX 800
Fort Atkinson, WI 53538-0800
TEL:  920-563-9571                FAX:  920-563-7395
sjohnson@highsmith.com
www.highsmith.com
------------------------------------------------------
This is for an interface from a DB2 database on an NT server to a DB2/400
database.  I have asked the NT
guys to give me the information based on the AS/400 file description, which they
did.  Unfortunately the
AS/400 file description doesn't accurately reflect what the data needs to look
like.  So, I have created the
new intermediate files, and will call the conversion/interface program from a CL
that first copies from the
intermediate file into the interface file *map.
 
At least I think it will work.
 
Thanks!
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---