IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Easytrieve with SQL


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Jan Olav Pedersen

New User


Joined: 23 Jan 2018
Posts: 1
Location: Norway

PostPosted: Tue Jan 23, 2018 7:29 pm
Reply with quote

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) , ?))
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8568
Location: Dubuque, Iowa, USA

PostPosted: Tue Jan 23, 2018 7:44 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Easytrieve EZABX007 with error code 0... CA Products 7
No new posts Converting SAS code to Cobol or Easyt... All Other Mainframe Topics 6
No new posts UNIT=AFF for Easytrieve code JCL & VSAM 7
No new posts READ A PACKED "NEGATIVE" FI... CA Products 3
No new posts Easytrieve report CA Products 4

Back to Top