Dear Sirs or Madams,
I am making a program need to use SQL command in RPGIII or ASSET.
I write:
C/EXEC SQL
C+ INSERT INTO ABO025 (BO2502,BO2503,BO2510)
C+ SELECT ICPROD,ICFAC,ICDRAW FROM CICL89 WHERE
C+ LEN(CICL89.ICDRAW)=4
C/END-EXEC
I compile, it is OK, But when I call program and view report, it has a message report that:LEN IN [B]*LIBL TYPE *N NOT FOUND.
I need to get the length of ICDRAW field in CICL89 file, but i do not know the command to get length of field in RPGIII or ASSET.
Pls if anyone know how to get length of field, pls tell me.
Thanks in advance.
Best regards.
I am making a program need to use SQL command in RPGIII or ASSET.
I write:
C/EXEC SQL
C+ INSERT INTO ABO025 (BO2502,BO2503,BO2510)
C+ SELECT ICPROD,ICFAC,ICDRAW FROM CICL89 WHERE
C+ LEN(CICL89.ICDRAW)=4
C/END-EXEC
I compile, it is OK, But when I call program and view report, it has a message report that:LEN IN [B]*LIBL TYPE *N NOT FOUND.
I need to get the length of ICDRAW field in CICL89 file, but i do not know the command to get length of field in RPGIII or ASSET.
Pls if anyone know how to get length of field, pls tell me.
Thanks in advance.
Best regards.
Comment