Cannot create view using jdbc

[Mike Schuler]

Hello,
I thought I knew sql, but when I send this as an argument of a
Statement.execu te():

create view mike.unnamed1(W ORKDEPT) as select f1.WORKDEPT as
\"WORKDEPT\"\r\ nfrom MIKE.EMPLOYEE f1\r\nfor read only\r\n

I get:

[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token \"create view
mike.unnamed1(W ORKDEPT) as sel\" was found following
\"BEGIN-OF-STATEMENT\". Expected tokens may include: \"<values>\" .
SQLSTATE=42601\ r\n

Since this code works for Sybase, Oracle, Cache, SQLServer, Postgress,
etc. I have to assume this is a JDBC driver fault.
(COM.ibm.db2.jd bc.net.DB2Drive r)

Has anybody seen/dealt with this?
Any hints would be much appreciated.

[Rhino]

"Mike Schuler" <ma*****@imag.n et> wrote in message
news:27******** *************** ***@posting.goo gle.com...

Hello,
I thought I knew sql, but when I send this as an argument of a
Statement.execu te():

create view mike.unnamed1(W ORKDEPT) as select f1.WORKDEPT as
\"WORKDEPT\"\r\ nfrom MIKE.EMPLOYEE f1\r\nfor read only\r\n

I get:

[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token \"create view
mike.unnamed1(W ORKDEPT) as sel\" was found following
\"BEGIN-OF-STATEMENT\". Expected tokens may include: \"<values>\" .
SQLSTATE=42601\ r\n

Since this code works for Sybase, Oracle, Cache, SQLServer, Postgress,
etc. I have to assume this is a JDBC driver fault.
(COM.ibm.db2.jd bc.net.DB2Drive r)

Has anybody seen/dealt with this?
Any hints would be much appreciated.

Try using executeUpdate() instead of execute().

This is some code I have that works fine on DB2 for Windows/Linux/Unix with
COM.ibm.db2.jdb c.app.DB2Driver ; I assume it will also work for the 'net'
driver.

String createStmt = "create view ..."; //your 'Create View' statement
try {

Statement stmt02 = conn01.createSt atement();

stmt02.executeU pdate(createStm t);

}

catch (SQLException excp) {

//your error handling logic

}

Rhino

[Serge Rielau]

"FOR READ ONLY"? DB2 does not support this syntax outside of the
select-statement.
I'm curious whether your driver strips it for other DBMS or whether
other DBMS indeed support this syntax natively to define READONLY views (?).
... easy enough to support if it's a common problem.

Cheers
Serge

[Rhino]

"Serge Rielau" <sr*****@ca.e ye-bee-em.com> wrote in message
news:41******** @news3.prserv.n et...

"FOR READ ONLY"? DB2 does not support this syntax outside of the
select-statement.
I'm curious whether your driver strips it for other DBMS or whether
other DBMS indeed support this syntax natively to define READONLY views (?). .. easy enough to support if it's a common problem.

Good point, Serge! I had forgotten that FOR READ ONLY isn't allowed in a
CREATE VIEW. Perhaps that is part of the problem.

Rhino