Re: Got an XLS spreadsheet. Need a DB2/400 file. What's the easiest way to get from one to the other?

Late Friday afternoon, eager to "make like a tree and get out of here," 
I wasn't exactly in the mood for an empirical solution to figuring out 
how to edit the .fdfx file. This morning, I was, and it turned out that 
the most obvious solution was the correct one.

From:

   [Data Transfer File Description]
   FieldCount=10
   FileType=12
   ClientFileEncoding=UTF-8
   DataTransferVersion=1.0
   [Options]
   DateFormat=1
   DateSep=1
   DcmlSep=1
   TimeFormat=1
   TimeSep=1
   [F0001]
   Length=9
   Name=CDATE
   Type=2
   [F0002]
   Length=7
   Name=CTIME
   Type=2
   [F0003]
   Length=10
   Name=CUSER
   Type=1
   [F0004]
   Length=9
   Name=LDATE
   Type=2
   [F0005]
   Length=7
   Name=LTIME
   Type=2
   [F0006]
   Length=10
   Name=LUSER
   Type=1
   [F0007]
   Length=10
   Name=LJOB
   Type=1
   [F0008]
   Length=10
   Name=LPGM
   Type=1
   [F0009]
   Length=14
   Name=EMID
   Type=2
   [F0010]
   Length=100
   Name=EMADDR
   Type=1

to

   [Data Transfer File Description]
   FieldCount=2
   FileType=12
   ClientFileEncoding=UTF-8
   DataTransferVersion=1.0
   [Options]
   DateFormat=1
   DateSep=1
   DcmlSep=1
   TimeFormat=1
   TimeSep=1
   [F0001]
   Length=14
   Name=EMID
   Type=2
   [F0002]
   Length=100
   Name=EMADDR
   Type=1

Stuffing some constant value into the other 8 fields will be easy enough.
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.