Re: File transfer

["Jim Ackerman" <jackerman@xxxxxxxxxxxxxxxx>]

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!

----- Original Message -----

From: Steve_Roncskevitz@GriffinLLC.com

To: RPG400-L@midrange.com

Sent: Tuesday, December 28, 1999 12:50 PM

Subject: Re: File transfer

Have you thought of writing a quick and dirty conversion program that would
convert the data that you are receiving into the format of the information that
you want it to go into.

Steve






"Jim Ackerman" <jackerman@dllr.state.md.us> on 12/28/99 11:21:49 AM

Please respond to RPG400-L@midrange.com

To:   RPG400-L@midrange.com
cc:    (bcc: Steve Roncskevitz/Griffin_Corp)

Subject:  File transfer




I am having difficulty uploading a text file into a DB2/400 file because of
the date and time fields in the DB2/400 file.

DSPFFD shows the date fields as 10 Alpha, even though the DDS has them
defined as type 'L'.  When I downloaded the file through Client Access to
create the .fdf file, the .fdf file shows them as 8 Alpha, and the resulting
downloaded file shows them as MM/DD/YY even though they are stored in the
DB2/400 file as YYYY-MM-DD.

I have tried using both FTP and Client Access, to no avail.  I have tried
tweaking the data, using different formats (the MM/DD/YY and YYYY-MM-DD, as
well as just numbers).

Any ideas?

Jim


+---
| 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
+---






+---
| 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
+---