IBM I : CRTSQLRPGI with option (*SQL)

Question

I have lots of SQLRPGLE programs that I have to compile with OPTION(*SQL). 99% of the time I forget to set that value at compilation time, so I tried to add this parameter value inside H SPECS. Unfortunately it doesn't seem to be any option to set that value in order to properly compile the source code without setting it manually every time. Any help is really appreciated , Giovanni

RockBoro · Accepted Answer · 2020-12-27 19:44:32Z

3

run the statement exec sql set option naming = *sql at the start of the program. That will set the naming convention of the program.

 /free                                   
      exec sql SET OPTION naming = *sql ;

      exec sql                           
      declare c1 cursor for              
      select      srcseq, srcdta         
      from        qgpl.qrpglesrc ;

a good article on using SQL options

answered Dec 27, 2020 at 19:44

RockBoro

2,5332 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charles Over a year ago

Should be noted that SET OPTION is actually a compile time statement and must be physically the first SQL statement in the source file.

Collectives™ on Stack Overflow

IBM I : CRTSQLRPGI with option (*SQL)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related