I'm trying to perform a simple DB2 query from rexx, that will return the results to me on screen. I'm running rexx from an ispf edit session. This is as far as i've managed to piece together
/* REXX */
SUBSYS = DB2D
SQLSTMT1 ="my sql here"
ADDRESS TSO "SUBCOM DSNREXX"
IF RC THEN S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
subsys is correct, and the sql is correct as well (i lifted it straight from a spufi request). I know i need to connect, and do some other things. BTW, this code produces no errors or any other output, so the address tso subcom command must be working. Thanks!
/* REXX */
SUBSYS = DB2D
SQLSTMT1 ="my sql here"
ADDRESS TSO "SUBCOM DSNREXX"
IF RC THEN S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
subsys is correct, and the sql is correct as well (i lifted it straight from a spufi request). I know i need to connect, and do some other things. BTW, this code produces no errors or any other output, so the address tso subcom command must be working. Thanks!