Sameer writes:
>psSequence = connection.prepareStatement("values identity_val_local()");
>I am getting the following error
>SQl code -142 : The sql statement is not supported.

Try "select identity_val_local() from sysibm.sysdummy1" and see if JDBC
likes the statement any better now that it is a SELECT.

Hope that helps,

Fred Sobotka
CollegeNET, Inc.

-
:::  When replying to the list, please use 'Reply-All' and make sure
:::  a copy goes to the list ([EMAIL PROTECTED]).
***  To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
***  For more information, check http://www.db2eug.uni.cc

Reply via email to