When to use dynamic SQL commands

Dynamic SQL prepared statement commands are the only command type that allows the application to query the server for the inputs required to execute the command and for the format of the command’s results: