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