home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Club Amiga de Montreal - CAM
/
CAM_CD_1.iso
/
files
/
579a.lha
/
sqldb_v1.0alpha2
/
rexx
/
sqltest.rexx
next >
Wrap
OS/2 REXX Batch file
|
1991-11-25
|
887b
|
31 lines
/* sqltest.rexx */
options results
address 'SQLserver'
say 'Got Server'
'ExecSQL' "open table test;"
'ExecSQL' "declare testcur cursor for select from test;"
'ExecSQL' "open testcur;"
say 'About to fetch 1'
'ExecSQL' "fetch next of testcur;"
say 'fetch_buf = ' result
say 'sqlca.sqlcode = ' sqlca.sqlcode
say 'About to fetch 2'
'ExecSQL' "fetch next of testcur;"
say 'fetch_buf = ' result
say 'sqlca.sqlcode = ' sqlca.sqlcode
say 'About to fetch 3'
'ExecSQL' "fetch next of testcur;"
say 'fetch_buf = ' result
say 'sqlca.sqlcode = ' sqlca.sqlcode
say 'About to fetch 4'
'ExecSQL' "fetch next of testcur;"
say 'fetch_buf = ' result
say 'sqlca.sqlcode = ' sqlca.sqlcode
say 'About to fetch 5'
'ExecSQL' "fetch next of testcur;"
say 'fetch_buf = ' result
say 'sqlca.sqlcode = ' sqlca.sqlcode
say 'sqlca.sqlerrmsg = ' sqlca.sqlerrmsg
'ExecSQL' "close testcur;"
'ExecSQL' "close table test;"