Language commands are the simplest way to issue a request, but here are some 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 the DB2 access service supports long character strings in language events for non-select statements: Mainframe Connect for DB2 UDB scans SQL statements for long character strings and replaces them with parameter markers. Then, the long character string is passed to DB2 UDB with a SQL descriptor area (SQLDA).
Long character-string substitution is not done for select statements.