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. |
|