Issue 96327 - DB2 return SQL0151N on “advanced†queries
Summary: DB2 return SQL0151N on “advanced†queries
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO300m9
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2008-11-18 22:31 UTC by rds08
Modified: 2017-05-20 09:36 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rds08 2008-11-18 22:31:22 UTC 
I'm able to make “simple†queries against a central DB2 server, from my RedHat
52 PC running DB2 Client v9.5, unixODBC-2.2.11-7.1, and OOo 3.0. However, when I
try to execute queries generating dynamic contents, DB2 returns SQL0151N.

The problem can be reproduced by creating a view (e.g. "create view test.view1
as select current date as today from sysibm.sysdummy1") and submitting a query
(select * from TEST.VIEW1) from OOo.

SQL Status: 42808
Error code: -151
[IBM][CLI Driver][DB2/LINUX] SQL0151N  The column "TODAY" cannot be updated. 
SQLSTATE=42808

This is similar to issue 77863, which seems to have been closed due to lack of
interest.
Comment 1 Rainer Bielefeld 2014-05-05 15:48:31 UTC 
@rds08 
Please contribute a test kit and an instruction how to reproduce the problem.
Comment 2 Rainer Bielefeld 2014-05-15 15:11:57 UTC 
Closing issue due to reporter's inactivity.

@reporter:
Please feel free to reopen this Bug if you find out that the problem still exists in the latest public release of AOO and if you can provide requested additional information. We need a test kit (Attachment here in the Bug report) and a detailed step by step instruction how to reproduce your problem, for details please see <http://wiki.openoffice.org/wiki/QA/HowToFileIssue>!