Hi all,
I wasn't sure where to post this so here goes. If it belongs somewhere else please let me know.
I'm going crazy over a problem I cannot resolve, I've wrestled this for days and all my research hasn't turned up anything.
I am getting a "decimal data error" when I access a database built by
DSPFD FILE(&LIB/&FILE) TYPE(*ACCPTH) +
OUTPUT(*OUTFILE) +
OUTFILE(QTEMP/IDBRACCPTH) OUTMBR(*FIRST *ADD)
The SQL statement returns SQLCOD -802 (-000000802) and field APNKYF (numeric) has blanks in it.
Running STRSQL command select * from IDBRACCPTH returns CPF5035 data mapping error
A data mapping error occurred on field IDBRACCPTH_1.APNSC2
There are access paths in this file for PF & LF but the records do not seem to vary.
Running V7R3M0.
Any ideas?
Many thanks!
Gary
I wasn't sure where to post this so here goes. If it belongs somewhere else please let me know.
I'm going crazy over a problem I cannot resolve, I've wrestled this for days and all my research hasn't turned up anything.
I am getting a "decimal data error" when I access a database built by
DSPFD FILE(&LIB/&FILE) TYPE(*ACCPTH) +
OUTPUT(*OUTFILE) +
OUTFILE(QTEMP/IDBRACCPTH) OUTMBR(*FIRST *ADD)
The SQL statement returns SQLCOD -802 (-000000802) and field APNKYF (numeric) has blanks in it.
Running STRSQL command select * from IDBRACCPTH returns CPF5035 data mapping error
A data mapping error occurred on field IDBRACCPTH_1.APNSC2
There are access paths in this file for PF & LF but the records do not seem to vary.
Running V7R3M0.
Any ideas?
Many thanks!
Gary
Comment