Jan Olav Pedersen
New User
Joined: 23 Jan 2018
Posts: 1
Location: Norway
|
|
|
|
Why isn't this SQL running is Easytreieve. The sql is working fine i SPFI, COBOl and REXX
SELECT ROUND(MONTHS_BETWEEN (CHAR(CURRENT DATE, ISO),:WS-DATE )) +
FROM SYSIBM.SYSDUMMY1
The hostvariable is translated like this
(CHAR (CURRENT DATE , ISO) , ?)) |
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
SQL Statement - CA Easytrieve lists
| Quote: |
| SELECT INTO *(for static-only processing) |
as the only valid SELECT for DB2 access. You do not have an INTO in your code.
And since the syntax can vary from language to language, the mere fact that your SQL statements works in SPFI (sic) or COBOL or REXX does NOT mean that your SQL statement will work in Easytrieve. It is a mistake to assume that what works for one language works for all languages. |
|
