Focal Point
Newbie: Help with dumping to flat file

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2161077331

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.

?f trfpyf02

FILENAME= TRFPYF02

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
PMEDATE

AVBLDG AVROOM AVDEPT AVSHOP AVINVDTE
AVINVCOD AVEXPTCOD AVNOTE1 AVNOTE2 AVUSER
AVDATE

UNIX/FOCUS
>> use
� /focd/pme/foc/trfpyf02.foc

table file trfpyf02
> print
> EQUID NOMEN MODEL SERIAL MFG
> BLDG ROOM ACQ_DATE CUSTODY COST
> DOCUMENT_NO MINVDTE MINVCOD MEXPTCOD DEPT
> SHOP EQUIDSTAT NOTE1 NOTE2 PMEUSER
> PMEDATE
> by TRFCODE
> on table hold as pme2a FORMAT ALPHA
> end

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?

Thanks
Shed
April 13, 2004, 02:53 PM
<monte2000>
Hi Shed.

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
separate entities.

Hope that helps.
April 13, 2004, 05:37 PM
<Shed>
Thanks that bit of advise did help