August 20, 2013, 05:53 PM
Josh Kdatatype transformations in mastefiles
Is there any documentation that explains the different datatypes like what P15.2NS is, etc?
In my master files on the as400 I have a redefinition in MASTER.F554852 and MASTER_53.F554852
DEFINE TLTRQT/P16.2NS=TLTRQT/100;,$
which is refedining this field to divide by 100 since its a JDE database:
FIELD=TLTRQT,
ALIAS=TLTRQT, USAGE=P15 , ACTUAL=P15,
DESCRIPTION='Transaction Quantity',
TITLE='Transaction Quantity',$
In EDAMAS7.F554852 I have:
FIELD=TLTRQT, TLTRQT, P16, P16,$
Finally in F554852.MAS on the Windows side, I have:
FIELD=TLTRQT,
ALIAS=TLTRQT, USAGE=P15.2NS , ACTUAL=P15,
DESCRIPTION='Transaction Quantity',
TITLE='Transaction Quantity',$
This transaction qty is supposed to be like pieces, but in the report its printed a $ in front likes its currency.
Is it because P15.2NS is for currency, or what? I just took the set of masterfiles from an old table and kind of pieced together how to create a new one, so I don't really understand why they're making a P8 into P15, then P15 into P16.2NS, and finally P15.2NS
Is there any documentation on these datatype trasformations?
August 20, 2013, 06:03 PM
Josh KI figured out I can just take the N out on the Windows side:
P15.2NS => P15.2S
And its no longer printing as currency.
August 20, 2013, 06:14 PM
Francis MarianiLook for "Describing Data With WebFOCUS Language" in the
Technical Documentation Library for WF 7.6 Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 21, 2013, 01:50 AM
VivianYou could also check out the WebFOCUS Keysheet Release 8 Chapter 8 - Master File. Gives you the all the different fieldtypes, segments, database types, etc.
All the essentials of master file definitions.
Vivian