Editing Cobol and PostgreSQL (section)

== Simple Workflow script ==
The python script [[gixc.py]] implements the GixSQL Cobol compilation workflow. It is invoked with a single parameter, being the program_name suffixed by either 'cbl or 'cob'. People that like to get their hands dirty follow the two steps below.
=== gixsql precompilation ===
The command invoking the precompile process is as follows:<br/>
<pre>
/usr/bin/gixsql pgcobol.cbl pgcobol.cbsql -S -I . -e ".,*.cpy,*.CPY"
</pre>
The input file is pgcobol.cbl, the preprocessing output file is [[pgcobol.cbsql]]. It is very important to leave the cbsql file as is, because meddling with the file easily leads to errors in the next step of the workflow.<br /><br />
The result of the precompile step of the SQL stement above looks like this:
<pre>
GIXSQL*    EXEC SQL
GIXSQL*       CONNECT TO :DATASRC AS cobol_sql USER :DBUSR USING :DBPWD
GIXSQL*    END-EXEC.
GIXSQL     CALL STATIC "GIXSQLConnect" USING
GIXSQL         BY REFERENCE SQLCA
GIXSQL         BY REFERENCE DATASRC
GIXSQL         BY VALUE 64
GIXSQL         BY REFERENCE "cobol_sql" & x"00"
GIXSQL         BY VALUE 0
GIXSQL         BY REFERENCE x"00"
GIXSQL         BY VALUE 0
GIXSQL         BY REFERENCE DBUSR
GIXSQL         BY VALUE 64
GIXSQL         BY REFERENCE DBPWD
GIXSQL         BY VALUE 64
GIXSQL     END-CALL.
</pre>
The precompile program translated the SQL statement in to a standardised Cobol call.

=== The cobc GNUCobol compilation ===
The command invoking the precompile process is as follows:
<pre>
/usr/bin/cobc -x pgcobol.cbsql -l:libgixsql.so -T pgcobol.out
</pre>
This results in the executable program file '''pgcobol''' and the compilation listing [[pgcobol.out]].