Command types  Dynamic commands

Chapter 6: Issuing SQL Statements

Language commands

Language commands are the simplest way to issue a request, but there are drawbacks to using them:

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).

NoteLong character-string substitution is not done for select statements.





Copyright © 2005. Sybase Inc. All rights reserved. Dynamic commands

View this book as PDF