View previous topic :: View next topic
|
Author |
Message |
vivbalboa
New User
Joined: 27 Feb 2009 Posts: 2 Location: Bangalore
|
|
|
|
Hi,
I am trying to display a panel retrieving information from a table.i used the select statement with cursor but its not working.Does anyone know the syntax how to use s select ,how to prepare it. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
What an informative statement that was. Obviously it isn't working otherwise you wouldn't be posting here ...... would you ?
How about something that we can work with, like your code and the error messages it produces. |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Before using DB2 in your rexx program, you must load the DSNREXX environment.
Have you done that ?
Code: |
Address TSO "SUBCOM DSNREXX"
If RC <> 0 Then Do
Signal On Syntax Name RXSubCom_Failed
RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
Signal Off Syntax
End
Address DSNREXX "CONNECT DB2T" /* for example */
.
.
.
RXSubCom_Failed:
Say 'Problem loading DSNREXX'
Exit |
|
|
Back to top |
|
|
|