I haven't installed REXX/DB2 interface on my system But i am able to connect to DB2 through REXX. But where to see the output for a select query. below is the REXX code.
Address TSO "SUBCOM DSNREXX"
If RC <> 0 Then Do
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
If S_RC <> 0 Then
Say 'Problem Loading DB2 environment'
if rc = 0 then do
sam = execsql 'select * from frspsup.vcl03',
'where s_clntlocn_numb = '11111''
After executing the above code i got the following output
EXECSQL select * from frspsup.vcl03 where s_clntlocn_numb = 11111,
I am not able to see the output for my select query.