Blog2011 ≫ A day of geekery today

A friend got barred from the google plus1 or something, for wanting to use "Kosso ." as his name and Google wants you to use a real first name and a real last name. I expect it'll get sorted out.

I have spent all afternoon struggling with a mad DB2 issue, trying to do a query on a federated table from within php using odbc_query. I'm paraphrasing a bit but where I had a query like "select name from blah.customer" I was getting an error that translated to

A federated insert, update, or delete operation, or a call to federated procedure with an SQL data access indication of MODIFIES SQL DATA is invalid in a function, a data-change-table-reference, a dynamic compound statement, a trigger, and an application execution environment where a

* SAVEPOINT is in effect
* scrollable cursor is used
* target view contains multiple tables or nicknames

saying "whoah, you can't update that table"... I'm not trying to update it, really I just want to query it. Found another query that was running against another federated table and all was good, the main difference being it was a more complex query joining two tables... so I made my query more complex, joining in a table that I don't need, and it let my query through. Messed up. I think php's odbc_query was adding "for update" to the end of my query for some reason and I couldn't stop it (or even see it, to be sure) but by complexifying my query it stopped doing that.

The boy has had his hair cut today, he looks WELL CUTE

⬅️ :: ➡️

Paul Clarke's blog - I live in A small town, Kent. Married to Clare + father to two, I am a full-stack web engineer, and I do javascript / nodejs, some ruby, other languages ect ect. I like pubs, parkrun, eating, home-automation and other diy jiggery-pokery, history, genealogy, TV, squirrels, pirates, lego, and TIME TRAVEL.