Determining the value of any SQL processing options that affect the design of your program
When you process SQL statements in an application program, you can specify options that describe the basic characteristics of the program. You can also indicate how you want the output listings to look. Although most of these options do not affect how you design or code the program, a few options do.
About this task
SQL processing options specify program characteristics
such as the following items:
- The host language in which the program is written
- The maximum precision of decimal numbers in the program
- How many lines are on a page of the precompiler listing
Procedure
To determine the value of any SQL processing options that affect the design of your program:
Review the list of SQL processing options and decide the
values for any options that affect the way that you write your program. For example, you need to know if you are using NOFOR or STDSQL(YES)
before you begin coding.