Help! I've not touched SQL and REXX for years but find myself having to do so again, and guess what ... I've forgotten almost everything!
I'm using isql from a REXX to interrogate a SQL table on Win NT and, although I've not actually used iSQL before I'm slowly getting the hang of it. But, I just cannot find a way of retrieving information from a select statement so I can then manipulate the results within REXX.
As a brief example:
If I've a table (TestTable) which has two columns:
1. Servername.
2. Problem description.
As and when a problem arises on a Server, I insert an entry into the table. That could mean, if I've a message storm, that I insert 36 lines exactly the same, as well as, say, 5 other problems. I want to select all identical issues from the sql table and put the count into a variable that can be used by REXX. I've tried the 'INTO :var1' statement, that is not accepted by SQL 7.0 using iSQL for some reason.
Can anybody help me?
ThanksI've no idea about REXX, thought this link (http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frm3toc.htm) may help you to find out the result.
HTH
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment