Using setLong( ) with large parameter values  Executing stored procedures

Chapter 2: Programming Information

Using COMPUTE statements

jConnect does not support computed rows. Results are automatically cancelled when a query contains a computed row. For example, the following statement is rejected: 

SELECT name FROM sysobjects 
WHERE type="S" COMPUTE COUNT(name)

To avoid this problem, substitute the following code: 

SELECT name from sysobjects WHERE type="S"
SELECT COUNT(name) from sysobjects WHERE type="S"



Copyright © 2003. Sybase Inc. All rights reserved. Executing stored procedures

View this book as PDF