Error SQL -514 / 26501

[gio.cot]

Hi all
when i execute the following statament inside an SQLRPGLE i receive error 26501 (after open) and 42601 after prepare , but if i try to run the same statement from ACS script SQL function, it works fine ; can some help me to understand which could be or hot to find the the problem ?

Thanks in advancve

[FONT=Calibri]SELECT A1DAT,[/FONT]
[FONT=Calibri]'A' AS ID,[/FONT]
[FONT=Calibri]A1COD,[/FONT]
[FONT=Calibri]A1ORA,[/FONT]
[FONT=Calibri]IFNULL(CAST(NULL AS DEC(9, 0)), 0) AS AETNR[/FONT]
[FONT=Calibri]FROM [COLOR=#1f497d]Mylib.FILE1[/COLOR][/FONT]
[FONT=Calibri]WHERE (A1DAT BETWEEN 20220525 AND 20220525[/FONT]
[FONT=Calibri]OR A1DAT = 00000000)[/FONT]
[FONT=Calibri]AND A1NOM <> ''[/FONT]
[FONT=Calibri]AND A1NOT <> 'XXXXXXXXXX'[/FONT]
[FONT=Calibri]AND A1NOT <> '**********'[/FONT]
[FONT=Calibri]AND A1NOT <> 'XXXXXXXXX'[/FONT]
[FONT=Calibri]AND A1COD IN ([/FONT]
[FONT=Calibri]'[COLOR=#1f497d]ZZZ[/COLOR]',[/FONT]
[FONT=Calibri]'[COLOR=#1f497d]AAA[/COLOR]',[/FONT]
[FONT=Calibri]'[COLOR=#1f497d]CCC[/COLOR]',[/FONT]
[FONT=Calibri]'[COLOR=#1f497d]ABC[/COLOR]'[/FONT]
[FONT=Calibri])[/FONT]
[FONT=Calibri]UNION ALL[/FONT]
[FONT=Calibri]SELECT AETDDS AS A1DAT,[/FONT]
[FONT=Calibri]'B' AS ID,[/FONT]
[FONT=Calibri]IFNULL(CAST(NULL AS VARCHAR(3)), ' ') AS A1COD,[/FONT]
[FONT=Calibri]IFNULL(CAST(NULL AS DEC(6, 0)), 0) AS A1ORA,[/FONT]
[FONT=Calibri]AETNR[/FONT]
[FONT=Calibri]FROM [COLOR=#1f497d]mylib.[/COLOR]file2[/FONT]
[FONT=Calibri]WHERE AETCBL = 'S'[/FONT]
[FONT=Calibri]AND (AETDDS BETWEEN 20220525 AND 20220525)[/FONT]
[FONT=Calibri]ORDER BY 1,[/FONT]
[FONT=Calibri]4[/FONT]
[FONT=Calibri]FOR READ ONLY [/FONT]

[TedHolt]

I don't know what your problem is, Gio. I vaguely remember running into this, but it's been many years.

I'd start by commenting out portions of the SQL statement to try to pinpoint the problem. You have a union. You could try one part at a time --- maybe only one of the two selects has the invalid syntax. You could also comment out the where clause, pieces of the where clause, etc.

[gio.cot]

Hi all
Solved .. the DS used for the Fetch into, was wrong
Sorry and thanks