Create a response file

You can specify the command-line arguments for the Informix® ESQL/C command processor in a response file and specify the file name for the Informix® ESQL/C processor.

The Informix® ESQL/C response file is a text file with Informix® ESQL/C command-line options and file names, separated by a space, a new line, a carriage return, a line feed, or a combination of these characters.

The following example shows the syntax that specifies a response file called resp.esq: 
esql @resp.esq
The response file, resp.esq, might contain the following lines:
-we
first.ec
second.ec
third.ec
-r foo.rc
Use of this response file is the equivalent of the following esql command: 
esql -we -f project.txt -r foo.rc

In this example, project.txt is a project file that contains the file names first.ec, second.ec, and third.ec on separate lines, as the previous shows.

You might use a response file for the following reasons:
  • The command line is limited to 1,024 characters. If your esql options exceed this length, you must use a response file.
  • If you use one or more sets of esql options regularly, you can avoid a lot of typing by putting each set in a different response file. Instead of typing the options, you can list the appropriate response file in the esql command.