I have a little problem:
I try to open a sequential file (fixed length).
For the character, that's Ok, I put blanck for the default but I cannot found the format for the decimal (length 12; scale 2) with sign (-).
I have already try 000000000.00 or 0000000000.00 but It gives me an error:
"##E TOIX 000139 10:35:55(018) <ExVuInv001CrTstData> Import validation failed:
>##E TFIG 000000 10:35:55(019) <ExVuInv001CrTstData> At field "PREV_BAL_AMT": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=12, scale=2, round=trunc_zero, ascii}
>##E TFIG 000119 10:35:55(020) <ExVuInv001CrTstData> At field "PREV_BAL_AMT": Error validating import/export function
>##E TOPK 000000 10:35:55(023) <_PEEK_IDENT_> Input dataset does not have field: "PREV_BAL_AMT"
>##E TFSR 000019 10:35:55(025) <main_program> Could not check all operators because of previous error(s)
>##E TCOS 000029 10:35:55(026) <main_program> Creation of step finished with status = FAILED
>"
Thanks for your help
Pey
Format for Opening file with Decimal in PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 25
- Joined: Thu Oct 02, 2003 8:57 am
-
- Participant
- Posts: 25
- Joined: Thu Oct 02, 2003 8:57 am
I am trying to copy your set-up so that i can see the error - i have created a sequential using your data, but then i need to enter the column definitions as you have. For example;
col_1 char 16
dat_1 date 10
col_2 char 18
dat_2 date 10
col_3 char 7
dec_1 decimal 12 2
This seems to work for me, so i think i have something different to you. How are your columns defined, and have you set any field properties?
col_1 char 16
dat_1 date 10
col_2 char 18
dat_2 date 10
col_3 char 7
dec_1 decimal 12 2
This seems to work for me, so i think i have something different to you. How are your columns defined, and have you set any field properties?