MVSFORUMS.com

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

I have the following codes:

kolusu · Posted: Thu Dec 09, 2004 6:31 am Post subject:

Danm,

When you use an ORDER BY clause on a cursor, then it becomes a Read-only cursor which CANNOT BE used to update or delete the underlying rows of the result table. However you can have a ORDER BY clause when you have declared the cursor as SENSITIVE STATIC scrollable which can be used to update.

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

Kolusu,

Thanks for the quick response.

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

Kolusu,

I got a sqlcode of -104 from "DECLARE C1 SENSITIVE STATIC SCROLL...." in DSNREXX:

Sqlcode : -104,
Sqlstate: 42601,
Sqlerrp: DSNTZDCL,
Sqlerrmc: SENSITIVE:CURSOR

I checked the SQL Reference, looks like the syntax is correct. Any suggestion?

kolusu · Posted: Fri Jan 28, 2005 1:58 pm Post subject:

Danm,
You need to prepare the statement and use it in the declaration.
ex:

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

Kolusu,

I am still getting the -104 sqlcode. Any one of the keywords (SENSITIVE, STATIC or SCROLL) will cause the -104. I am running DB2 V7.2. Any suggestion?

kolusu · Posted: Tue Feb 08, 2005 8:48 am Post subject:

Danm,

Make sure that you don't have any junk characters in columns 73 thru 80 in your sql.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

Kolusu,

No, I don't have any character in columns 73 thru 80. I placed several "say" statements in the REXX EXEC to check for the correct SQL statements. If I removed the "ORDER BY" clause from SelData and "SENSITIVE STATIC SCROLL" from the DECLARE, then it works fine.