Army wrote:
On the other hand, if the statement is changed to:// Default schema APP. PreparedStatement ps = conn.prepareStatement( "select tablename, tabletype from sys.systables where " + "CAST (tablename as varchar(128)) = ?");then it might be better to take "current schema" to mean the time of *execution.* That way the the above statement will run correctly regardless of the current schema. If "current schema" was determined at compile time, the above statement would only work if "current schema" was a non-system schema.
I'm a little lost by this. What do these two terms mean to you? "run correctly" "would only work if" Thanks, Dan.
