DB error in select query

[Bastien]

Hi All,

I am running a SELECT query (vbscript in asp/db2) to show the db structure. I am getting an error

[IBM][CLI Driver][DB2/NT] SQL0151N The column "PAGEVARIANCERATIO" cannot be updated. SQLSTATE=42808

and can't seem to work what is being updated?

Any ideas/hints/clues?

TIA


Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[Bastien]

Update:

More looking with google and the docs lead to this:

PAGEVARIANCERATIO DOUBLE Yes For future use.

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[MarcLodge]

Hi Bastien,

I have a feeling that if you are looking up SYSCAT tables, you need to add 'FOR READ ONLY' to the select, or DB2/IBM/ODBC (it's one of those 3, but I don't know which, sorry) defaults to update, somewhere along the access path.

Hope this helps.

Marc

 

[Bastien]

Adding a CursorLocation to the asp code solved it, thanks

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...