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?
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.
Thanks that bit of advise did help
|Powered by Social Strata|