|
View previous topic :: View next topic
|
| Author |
Message |
gayathrinag
New User
Joined: 16 Oct 2008
Posts: 37
Location: chennai
|
|
|
|
Hi,
Can you please let me know whether it is possible to select a row in db2 tables without using cursors in Eazytrieve. If yes can you please tell me sample program... or the syntax and how it works ?
Thanks |
|
| Back to top |
|
 |
gayathrinag
New User
Joined: 16 Oct 2008
Posts: 37
Location: chennai
|
|
|
|
"SELECT INTO" IS VALID ONLY FOR SQLSYNTAX OF NONE AND STATIC-ONLY BIND
I am getting above error when i use PARM SSID(DSN)... when i use
SELECT INTO |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| At the risk of repeating myself (I've always wondered, what risk?). Look at the CA Products forum here, where your post is. Just click on it. Follow advice on the question from last week. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Can you please let me know whether it is possible to select a row in db2 tables without using cursors in Eazytrieve. |
As far as i know it is. . .
The same restriction applies - if the found set returns more than one row, an sql error code is raised. Pretty much just line in cobol. |
|
| Back to top |
|
|
|
|
