Language commands are the simplest way to issue a request, but there are drawbacks to using them:
You cannot control incoming datatype conversion.
You must issue a request and finish processing it before you can issue another request.
With certain commands, performance is slower than with dynamic and cursor commands.
Note that DirectConnect supports long character strings in language events for non-select statements: MainframeConnect for DB2 scans SQL statements for long character strings and replaces them with parameter markers. The long character string is then passed to DB2 with a SQL descriptor area (SQLDA).
Long character-string substitution is not done for select statements.
Copyright © 2005. Sybase Inc. All rights reserved. |