TechTip: Compiling an SQL Program

SQL
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times
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 email address is being protected from spambots. You need JavaScript enabled to view it..

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$0.00 Raised:
$