I have a folder with 2 different Application Groups associated with the folder. Both Application Groups have the same fields except one has Amount_Charged as decimal and the other has Amount_Charged as string. As an Administrator when I use the folder I receive in the system log:
Application Group Query: Name(EOB3) Agid(251885) Count() SegStart(2017-07-02 00:00:00) SegStop(2019-01-02 23:59:59) Sql(2;ODDAT_OD_LOAD_DATE,ODDAT_OD_LOAD_DATE;'2017-07-02 00:00:00','2019-01-02 23:59:59';WHERE ODDAT_OD_LOAD_DATE BETWEEN ? AND ? ) SqlR(ODTBL.OD_APPLICATION IN ('ZF120D01 ')) FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()
The folder pulls up the documents that are desired.
When a user uses the folder they receive in the system log:
Application Group Query: Name(EOB3) Agid(251885) Count(751) SegStart(2014-01-03 10:12:39) SegStop(2019-01-03 10:12:39) Sql(3;ODDAT_OD_LOAD_DATE,ODDAT_OD_LOAD_DATE,CLAIM_NUMBER;'2014-01-03 10:12:39','2019-01-03 10:12:39';WHERE ODDAT_OD_LOAD_DATE BETWEEN ? AND ? ) ) SqlR(AMOUNT_CHARGED>-.01) FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()
and DB2 error in system log:
DB Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015} DSNT408I SQLCODE = -420, ERROR: THE VALUE OF A STRING ARGUMENT WAS NOT ACCEPTABLE TO THE DECFLOAT FUNCTION DSNT418I SQLSTATE = 22018 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRNUM SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF1A' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=5:10:2 -- SQLSTATE=22018, SQLCODE=-420, File=arsdoc.c, Line=3170
Notice the SQLR in both statements.
Any suggestions for a solution?