|
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 -----
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
+---
|
midrange.com
