Focal Point
[CLOSED] Needing help with the conversion of the following fields from IBM

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

April 16, 2014, 02:57 PM
Don Robison
[CLOSED] Needing help with the conversion of the following fields from IBM
I am trying to convert the following from a IBM cobal layout.

03 VI001-FIXD-INT-RATE-PCT PIC SV9(5) COMP-3.
03 VI001-VAR-INT-RATE-PCT PIC SV9(5) COMP-3.
03 VI001-PR-INTEREST-PCT PIC SV9(5) COMP-3.

I am unsure of what is should convert to.
FIELD=FIXD_INT_RATE_PCT,FIXD_INT_RATE_PCT,P??? ,????,MISSING=OFF,$

This message has been edited. Last edited by: <Kathryn Henning>,


Version 7.17
April 16, 2014, 03:05 PM
Doug
Maybe this would help. If not, please post the acutal values in the desired format of what you want...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
April 16, 2014, 03:35 PM
Don Robison
03 VI001-FIXD-INT-RATE-PCT PIC SV9(5) COMP-3. ---- .00050
03 VI001-VAR-INT-RATE-PCT PIC SV9(5) COMP-3. ---- .00025
03 VI001-PR-INTEREST-PCT PIC SV9(5) COMP-3. ---- .00035


I am just unsure of what is should convert to.
????? ??
FIELD=FIXD_INT_RATE_PCT,FIXD_INT_RATE_PCT,USAGE=P0.5S ,ACTUAL=P2,MISSING=OFF,$


Version 7.17
April 16, 2014, 05:51 PM
Alan B
I think that it should be:
FIELD=FIXD_INT_RATE_PCT,FIXD_INT_RATE_PCT,USAGE=P8.5S,ACTUAL=P4,MISSING=OFF,$
but would have to try it.


Alan.
WF 7.705/8.007
April 17, 2014, 06:29 AM
Tom Flynn
See the link from Alan B from 2008 here.


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 17, 2014, 09:41 AM
Don Robison
Alan,

I have nothing to the left of the decimal.

the Field in need to format is

SV9(5) or .00000

I have tried
FIELD=FIXD_INT_RATE_PCT,FIXD_INT_RATE_PCT,USAGE=P0.5S ,ACTUAL=P2,MISSING=OFF,$

It errors off.
Don R


Version 7.17
April 18, 2014, 07:45 AM
Danny-SRL
Use:
USAGE=P7.5S ,ACTUAL=P3



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF