Focal Point
[SOLVED] Create a master file separating one string to 10 occurrrence

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

April 18, 2013, 09:08 AM
kitten
[SOLVED] Create a master file separating one string to 10 occurrrence
I'm trying to separate one string to 10 occurrences in a master file. The field is DATA/A60. The first 8 characters are a filler, then every 3 character is an item upto 10. So that's 30 characters used of the 52. I've created the two masters but the occurs will not work. Something is wrong. Can someone offer any suggestions.

INVENTORY.mas:
FILENAME=INVENTORY, SUFFIX=FIX , IOTYPE=STREAM, $
SEGMENT=INVENTORY, SEGTYPE=S0, $
FIELDNAME=INVOICE_NUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=DATE, ALIAS=E02, USAGE=HMDYY, ACTUAL=A17, $
FIELDNAME=DATA, ALIAS=E10, USAGE=A60, ACTUAL=A60, MISSING=ON, $

INVENTORY_OCC.mas:
FILENAME=INVENTORY_OCC, SUFFIX=FIX , IOTYPE=STREAM, $
SEGMENT=INVENTORY, SEGTYPE=S1, $
FIELDNAME=INVOICE_NUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=DATE, ALIAS=E02, USAGE=HMDYY, ACTUAL=A17, $
FIELDNAME=FILLER8, ALIAS=FILLER8, USAGE=A8, ACTUAL=A8, MISSING=ON, $
FIELDNAME=DATA, ALIAS=E10, USAGE=A52, ACTUAL=A52, MISSING=ON, $
SEGNAME=ITM PARENT=INVENTORY, POSITION=DATA,OCCURS=VARIABLE, $
FIELDNAME=ITM, ALIAS=ITM, USAGE=A03, ACTUAL=A03, $


When I run a table file on them, I get data for INVENTORY but I get the following error for INVENTORY_OCC:
(FOC1822) WARNING. INVALID SYMBOL: >=<
BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: kitten,


WebFOCUS 7.6.2, MS Windows Server/______, Excel, PDF, HTML
April 18, 2013, 09:42 AM
Alan B
There is a comma missing after ITM:
SEGNAME=ITM PARENT=INVENTORY, POSITION=DATA,OCCURS=VARIABLE, $

This can be done a little more simply as:
FILENAME=INVENTORY_OCC, SUFFIX=FIX , IOTYPE=STREAM, $
SEGMENT=INVENTORY, SEGTYPE=S1, $
FIELDNAME=INVOICE_NUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=DATE, ALIAS=E02, USAGE=HMDYY, ACTUAL=A17, $
FIELDNAME=FILLER8, ALIAS=FILLER8, USAGE=A8, ACTUAL=A8, MISSING=ON, $
SEGNAME=ITM, PARENT=INVENTORY, OCCURS=VARIABLE, $
FIELDNAME=ITM, ALIAS=ITM, USAGE=A03, ACTUAL=A03, $



Alan.
WF 7.705/8.007
April 18, 2013, 02:00 PM
FrankDutch
I would suggest to not use field alias with E01 or E02 etc...
These names are internal used and I found out the system sometimes get confused.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

April 19, 2013, 09:39 AM
kitten
Thanks to everyone for comments and help. Issue solved see below:

INVENTORY.mas:
FILENAME=INVENTORY, SUFFIX=FIX , IOTYPE=STREAM, $
SEGMENT=INVENTORY, SEGTYPE=S0, $
FIELDNAME=INVOICE_NUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=DATE, ALIAS=E02, USAGE=HMDYY, ACTUAL=A17, $
FIELDNAME=DATA, ALIAS=E10, USAGE=A60, ACTUAL=A60, MISSING=ON, $

INVENTORY_OCC.mas:
FILENAME=INVENTORY_OCC, SUFFIX=FIX , IOTYPE=STREAM, $
SEGMENT=INVENTORY, SEGTYPE=S1, $
FIELDNAME=INVOICE_NUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=DATE, ALIAS=E02, USAGE=HMDYY, ACTUAL=A17, $
FIELDNAME=FILLER8, ALIAS=FILLER8, USAGE=A8, ACTUAL=A8, MISSING=ON, $
SEGNAME=ITM, PARENT=INVENTORY_OCC, OCCURS=VARIABLE, $
FIELDNAME=ITM, ALIAS=ITM, USAGE=A03, ACTUAL=A03, $


WebFOCUS 7.6.2, MS Windows Server/______, Excel, PDF, HTML