home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 18 REXX
/
18-REXX.zip
/
rxsql.zip
/
TEST.CMD
< prev
Wrap
OS/2 REXX Batch file
|
1993-08-17
|
1KB
|
66 lines
/****************************************************************************
RXSQL TESTING
****************************************************************************/
if rxfuncquery("QUERY") \= 0 then
do
call rxfuncadd "QUERY", "RXSQL", "RXSQLQUERY";
end
/*** set the following variables according to your setup ***/
server = "SERVER";
database = "DATABASE";
user = "USER";
password = "PASSWORD";
/*** main loop ***/
say "SQL access testing";
say;
do forever
com = charout("STDOUT:", "query or quit:");
com = linein("STDIN:");
parse upper var com com;
if com = "QUIT" then
do
leave;
end
if query(server, database, user, password, com, sql, 20, 20) = "OK" then
do
/*** show results ***/
do r = 0 to sql.1.0 - 1
do c = 1 to sql.2.0
rc = charout("STDOUT:", sql.r.c);
rc = charout("STDOUT:", "09"x);
end
say;
end
/*** drop variables ***/
do r = 0 to sql.1.0 - 1
do c = 1 to sql.2.0
name = "sql."||r||"."||c;
drop (name);
end
end
end
else
do
/*** show error ***/
say sql.0.0;
end
end
call rxfuncdrop("QUERY");