Home > IT Answers > AS/400 > CRTSQLRPGI
GHENDER
165 pts.
 CRTSQLRPGI
AS/400 v6.1, AS400 RPGLE, SQL statements
I have two questions about an RPGLE program with embedded SQL statements:

When compiling an RPGLE program with embedded SQL statements, how do you set the activation group?

I am trying to run a program which ran when we were on version 5V4. Now that I am on version 6.1, the exact same program will not run. Is there something different I have to do when compiling? My commitment control is set to *NONE.



Software/Hardware used:
AS400 V6.1
ASKED: May 15, 2012  4:27 PM
UPDATED: May 25, 2012  7:16 AM
RELATED QUESTIONS
Answer Wiki:
Since the CRTSQLRPGI command does not have this parameter, your best bet is to imbed the instructions in your RPGLE source code as a header directive. Certain compile parameters cann be added to an H-spec line to force these parameters to be used everytime you compile the program. Try putting the following H-spec in your program. <pre> H DftActGrp(*No) ActGrp('activation group') </pre> where the ActGrp is the name of the activation group you want to start this program in. There are many other compile options you can select from. When you prompt on the Keywords entry field with an F1, this will take you to all of the H-spec directives you can use. The nice thing about these is you never have to wory that the next progammer will compile with the wrong parameters as what is in the source overrides any other in the create command.
Last Wiki Answer Submitted:  May 16, 2012  4:17 pm  by  WaltZ400   645 pts.
All Answer Wiki Contributors:  WaltZ400   645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What errors show in the job log (or program dump) when you try to run the program?

Splat
 5,740 pts.
 

When compiling an RPGLE program with embedded SQL statements, how do you set the activation group?

WaltZ400′s answer is the best choice, but it’s not always possible. If you can’t place the directives in the source, you can use the CRTSQLRPGI COMPILEOPT() parameter: 

COMPILEOPT('DftActGrp(*No) ActGrp(myactgrp)')

That parameter is used by the SQL precompiler to pass parms into the RPG compile.

Now that I am on version 6.1, the exact same program will not run. Is there something different I have to do when compiling?

Probably.

But unless you tell us something about what happens, we have no way of guessing what should be done differently.

Tom

TomLiotta
 110,185 pts.
 

Since we migrated to OS 7.1, if you compile program CRTSQLRPGI that has a OVRDBF using QCMDEXC on the SQL declare cursor file, it does not recognize the file over ride.  It does not error, just will not take the over ride.  Is this happening for others and how do we resolve this?  

Peg
 10 pts.
 
Is this happening for others and how do we resolve this?
.
It should only happen if the OVRDBF isn’t appropriate for the compile options of the program. If we can’t see the OVRDBF and the compile options, we can’t know what’s being done wrong.
.
Also, we might need to know the migration path. What was the previous version? Was it a migration or an OS upgrade? Was the OVRDBF command defaults changed in the previous system image?
.
Tom
TomLiotta
 110,185 pts.