Building language commands

Your application initiates a language command by calling ct_command with type as CS_LANG_CMD and *buffer as the language text. For example, the call below initiates a language command to select rows from the authors table in the pubs2 database:

ret = ct_command(cmd, CS_LANG_CMD,
 "select au_lname, city from pubs2..authors \
 where state = 'CA'",
 CS_NULLTERM, CS_UNUSED); 

Language commands can take parameters. For Adaptive Server Enterprise client applications, parameter placement is indicated by undeclared variables in the command text. For example, a language command such as the one below takes a parameter whose value is substituted for “@state_name”:

select au_lname, city from pubs2..authors \
       where state = @state_name

Parameters are useful when your code executes the same language command more than once.