July 17, 2007, 04:22 PM
GlendaMFD for an indexed file in IDX8 format
I need to create a MFD for a QicLink indexed file that is in IDX8 format. Any one know where I can find documentation on this? Classes? Anything?
The file layout is below:
01 zanm03-rec.
03 zanm03-key.
05 zanm03-tax-number pic 9(09).
05 zanm03-key-2.
10 zanm03-create-date pic 9(09) COMP-3.
**** Julian date format "yyjul"
10 zanm03-create-time.
15 zanm03-time1 pic 9(02).
15 zanm03-time2 pic 9(02).
15 zanm03-time3 pic 9(02).
10 zanm03-create-time-num
redefines zanm03-create-time
pic 9(06).
10 zanm03-conversion-date pic 9(08).
03 zanm03-fields.
05 zanm03-pmfdid pic x(09).
05 zanm03-pmfdsf pic x(02).
Thanks,
Glenda
July 17, 2007, 05:13 PM
Darin LeeI don't know what a QicLink indexed file is (or IDX8 for that matter) but they do not show up on the supported list of databases, so there would not be and adapter for this, even if you had a Master File. Are you accessing this via ODBC? If so, just let WF use your ODBC adapter for this file type to autogenerate it and see what you get.
July 20, 2007, 08:14 AM
hammo1jExport to flat file and there are loads of docs on how to convert COBOL type scheme to MFD.
July 20, 2007, 09:15 AM
GlendaThanks all. For the record, the file was used in its native form. The MFD suffix used was:
SUFFIX=MFCISAM