Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Newbie: Help with dumping to flat file
Go
New
Search
Notify
Tools
Reply
  
Newbie: Help with dumping to flat file
 Login/Join
 
<Shed>
posted
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
 
Reply With QuoteReport This Post
<monte2000>
posted
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.
 
Reply With QuoteReport This Post
<Shed>
posted
Thanks that bit of advise did help
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Newbie: Help with dumping to flat file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.