April 06, 2004, 02:00 PM<Shed>
Newbie: Help with dumping to flat file
I am working with Focus 68.5 and trying to create a flat file I can dump into a RDBM. Here is what I got so far.
TRFCODE BARCODE STATUS
EQUID NOMEN MODEL SERIAL MFG
BLDG ROOM ACQ_DATE CUSTODY COST
DOCUMENT_NO MINVDTE MINVCOD MEXPTCOD DEPT
SHOP EQUIDSTAT NOTE1 NOTE2 PMEUSER
AVBLDG AVROOM AVDEPT AVSHOP AVINVDTE
AVINVCOD AVEXPTCOD AVNOTE1 AVNOTE2 AVUSER
table file trfpyf02
> EQUID NOMEN MODEL SERIAL MFG
> BLDG ROOM ACQ_DATE CUSTODY COST
> DOCUMENT_NO MINVDTE MINVCOD MEXPTCOD DEPT
> SHOP EQUIDSTAT NOTE1 NOTE2 PMEUSER
> by TRFCODE
> on table hold as pme2a FORMAT ALPHA
One of mine problems is that in the output PMEUSER and PMEDATE are not seperated.
Also, is the TRFCODE, BARCODE, and STATUS primary keys. How do I get a grasp on this data structure from the focus tools?
April 13, 2004, 02:53 PM<monte2000>
Just spoke to the Product Manager and here was his reply:
The reason PMEUSER and PMEDATE are not separated is probably because the data in those fields takes the entire field length, for example if it is A8 and the value is 12345678, there will be no spaces between it and the next value. This should only be an issue if you read the flat data file. Any reports you issue against the flat data file will display the fields as 2
Hope that helps.
April 13, 2004, 05:37 PM<Shed>
Thanks that bit of advise did help