Re: SQL Options

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

decmpt


Robert Munday wrote:
> 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
>
>
>