I've 'been away' from REXX and SQL for a while and am VERY rusty. I wonder if anyone can help me with a problem I'm having?
I'm trying to select information from a SQL 7.0 DB on NT using REXX. The table in question is being used as a holding space for issues on servers, so when a problem arises it is written straight to the SQL DB using an isql INSERT cmd. In the event of a message storm or some very busy period, there may be a large number of identical issues at any one time.
I'm using a periodically run REXX to interrogate the SQL DB and instead of issuing a large number of similar errors to the Incident reporting system, I'm trying to get a count of the number of times any one problem has arisen.
BUT, when I use:
"select * INTO :variable from tablename" - isql doesn't recognise :variable as a valid entry
I can get:
"select * as variable from tablename" to create another temporary table but cannot extract that info into a variable?
Does this make sense? If so, can you help?
Many Thanks
I'm trying to select information from a SQL 7.0 DB on NT using REXX. The table in question is being used as a holding space for issues on servers, so when a problem arises it is written straight to the SQL DB using an isql INSERT cmd. In the event of a message storm or some very busy period, there may be a large number of identical issues at any one time.
I'm using a periodically run REXX to interrogate the SQL DB and instead of issuing a large number of similar errors to the Incident reporting system, I'm trying to get a count of the number of times any one problem has arisen.
BUT, when I use:
"select * INTO :variable from tablename" - isql doesn't recognise :variable as a valid entry
I can get:
"select * as variable from tablename" to create another temporary table but cannot extract that info into a variable?
Does this make sense? If so, can you help?
Many Thanks