TechTip: Compiling an SQL Program PDF Print E-mail
Sunday, 26 October 2003

Here are four techniques to get the job done. There are a few ways to compile an SQL program in the ILE environment with special compiler parameters, such as ACTGRP:

1. If the program is ILE RPG, you may be able to specify the parameter in the H specification of the program.

H DFTACTGRP(*NO) ACTGRP('MYACTGRP')


2. If the program is ILE COBOL, you may be able to specify the parameter as a process option. But the ACTGRP parameter is not available as a process option.

3. Create a module using

      ===> CRTSQLxxxI OBJTYPE(*MODULE)

followed by

      ===> CRTPGM ACTGRP(MYACTGRP)


4. Create precompiled source using

      ===> CRTSQLxxxI OBJTYPE(*PGM) OPTION(*NOGEN)
                      TOSRCFILE(MYLIB/MYFILE)
      ===> CRTBNDxxx SRCFILE(MYLIB/MYFILE) ACTGRP(MYACTGRP)


Barbara Morris can be reached by email at This e-mail address is being protected from spam bots, you need JavaScript enabled to view it .

Last Updated ( Sunday, 26 October 2003 )
  No Comments Have Been Posted.

Discuss...
User Rating: / 0
PoorBest 
Related Articles
< Prev   Next >
[ Back ]

The following White Papers can be found at the MC White Paper Center


The following trial software can be found at the MC Press Software Center.   



   MC-STORE.COM