From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Mark Villa
Sent: Friday, March 07, 2008 8:12 AM
Subject: Updating by row count in Interactive SQL
Any suggestions on how you would do this in interactive SQL?
counter = counter + 1
set RECCNT = counter
where date1 > 20080000
An example would be most appreciated. The above, obviously does not work.
The only two options I have in this case are SQL and UPDDTA record by
BTW, every now and then I see answers posted asking a good question -
why would you want to do that? - the hard way? I suspect it is usually
because we are working on a box with restrictions, no developer
When we are in our native environment these questions (with simple
answers in another tool) don't pop up.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives