SQL Options

Greetings.


I have an SQL COBOL program to modify. Notes in the heading specify:

*Compile with COMMIT(*NONE) OPTION(*PERIOD)
* DATFMT(*ISO) TIMFMT(*ISO).


I added the SQL Options code into the program:

1958.00 ** Set SQL Options
SQL Exec SQL Set Option
SQL Commit = *None,
SQL Naming = *Sys,
SQL DatFmt = *ISO,
SQL TimFmt = *ISO,
SQL UsrPrf = *Owner,
SQL DynUsrPrf = *Owner
SQL End-Exec.

Is there a value I can enter for the Option(*PERIOD) to prevent having to remember to do it on the compile? The keyword OPTION will not work here, obviously. The system defines *PERIOD as:

The value used as the decimal point for numeric constants used in SQL statements is a period. This value is also used as the decimal point character when casting a numeric value to character.

It is only an option for compiling an SQL embedded program (SQLRPGLE or SQLCBLLE). It does not appear for an RPGLE program compile. The default is *XREF.

Is there a statement for *PERIOD which I could put in the Set SQL Options? It would be preferable to trying to remember keying *PERIOD in the options part of the compile.

Thanks,



Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Columbia, SC