Version 5
My version of CUSTINQ accepting Environment Variable set from a .env file
From the user’s perspective, the result is the same.
It is only the structure of the program that is different. The .env file
DB1 Connection parameters
db2name=name
username=userid
password=passwd
The compile script
#!/bin/bash
# Set Up variables
# Program to run
PGM=CUSTINQ
# DB2 Load Libraries
export LOADLIB="$DB2_HOME/lib64"
# COBOL and SQL Copy Libraries
export COBCOPY="../cpy"
export SQLCOPY="$DB2_HOME/include/cobol_mf"
# Delete previous versions
rm ../cbl/$PGM.bnd
rm ../tcbl/$PGM.cbl
rm ../bin/$PGM
# DB2 Prep and Bind
db2 -tvf ../sql/$PGM.sql
read -p "Press any key to resume"
# Compile
cobc -std=default -x -o ../bin/$PGM ../tcbl/$PGM.cbl \
-static \
-I $SQLCOPY \
-I $COBCOPY \
-L $LOADLIB \
-l db2 \
-Wall \
-O
# Check return code
if [ "$?" -eq 0 ]; then
echo "SUCCESS: Compile Return code is ZERO."
else
echo "FAIL: Compile Return code is NOT ZERO."
fi
The run script
#!/bin/bash
# Set Up variables
# Program to run
PGM=CUSTINQ
# Export the environment variables in the .env file
export $(grep -v '^#' ../.env | xargs)
# run program
../bin/$PGM
# Leaving this here as an example but not required.
# Remove the variables in the .env file from the environment
# unset $(grep -v '^#' ../.env | sed -E 's/(.*)=.*/\1/' | xargs)
The program.
**********************************************************
* Program name: CUSTINQ
* Original author: David Stagowski
*
* Description: Query the Customer table.
*
* Maintenance Log
* Date Author Maintenance Requirement
* ---------- ------------ --------------------------------
* 2023-03-08 dscobol Created to learn.
* 20XX-XX-XX If you change me, change this.
*
**********************************************************
IDENTIFICATION DIVISION.
PROGRAM-ID. CUSTINQ.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
* SOURCE-COMPUTER. IBM WITH DEBUGGING MODE.
DATA DIVISION.
WORKING-STORAGE SECTION.
EXEC SQL
INCLUDE SQLCA
END-EXEC.
EXEC SQL
DECLARE CUSTOMERS TABLE
(
CUSTNO CHAR(6) not null,
FNAME CHAR(20) not null,
LNAME CHAR(30) not null,
ADDR CHAR(30) not null,
CITY CHAR(20) not null,
STATE CHAR(2) not null,
ZIPCODE CHAR(10) not null)
END-EXEC.
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
01 HV-Customer-Row.
12 HV-Cust-Number PIC X(06).
12 HV-Cust-First-Name PIC X(20).
12 HV-Cust-Last-Name PIC X(30).
12 HV-Cust-Address PIC X(30).
12 HV-Cust-City PIC X(20).
12 HV-Cust-State PIC X(02).
12 HV-Cust-ZipCode PIC X(10).
* DB1 connection parameters.
01 DB1-DBName PIC X(8).
01 DB1-User-ID PIC X(10).
01 DB1-Password.
49 DB1-Passwd-Length PIC S9(4) COMP-5 VALUE 0.
49 DB1-Passwd-Name PIC X(18).
EXEC SQL END DECLARE SECTION END-EXEC.
*******************
01 WS-SQL-STATUS PIC S9(9) COMP-5.
88 SQL-STATUS-OK VALUE 0.
88 SQL-STATUS-NOT-FOUND VALUE 100.
88 SQL-STATUS-DUP VALUE -803.
01 WS-Application-Flags.
12 WS-Inquiry-Flag PIC X.
88 WS-Keep-Looking VALUE 'Y'.
88 WS-Stop-Looking VALUE 'N'.
12 WS-Find-Customer-Flag PIC X.
88 WS-Customer-Found VALUE 'Y'.
88 WS-Customer-Not-Found VALUE 'N'.
01 EOJ-Display-Messages.
12 EOJ-End-Message PIC X(042) VALUE
"*** Program CUSTINQ - End of Run Messages".
PROCEDURE DIVISION.
0000-Mainline.
PERFORM 1000-Begin-Job.
PERFORM 2000-Process.
PERFORM 3000-End-Job.
GOBACK.
1000-Begin-Job.
PERFORM 9800-Connect-to-DB1.
IF SQL-STATUS-OK
SET WS-Keep-Looking TO TRUE
END-IF.
2000-Process.
PERFORM 2100-Display-Customer
UNTIL WS-Stop-Looking.
2100-Display-Customer.
PERFORM 2110-Accept-Customer-Number.
IF WS-Keep-Looking
PERFORM 2120-Get-Customer-Row
IF WS-Customer-Found
PERFORM 2130-Display-Customer-Lines
ELSE
PERFORM 2140-Display-Error-Lines
END-IF
END-IF.
2110-Accept-Customer-Number.
DISPLAY '-------------Customer Inquiry--------------------'.
DISPLAY '-------------------------------------------------'.
DISPLAY 'Key in the next Customer Number and press Enter,'.
DISPLAY 'or key in 999999 and press Enter to quit.'.
ACCEPT HV-Cust-Number.
IF HV-Cust-Number = '999999'
SET WS-Stop-Looking TO TRUE
END-IF.
2120-Get-Customer-Row.
PERFORM 5000-Read-DB1.
2130-Display-Customer-Lines.
DISPLAY '-------------Customer Inquiry--------------------'.
DISPLAY '-------------------------------------------------'.
DISPLAY ' Customer: '
HV-Cust-Number.
DISPLAY ' Name: '
FUNCTION TRIM(HV-Cust-First-Name), SPACE,
FUNCTION TRIM(HV-Cust-Last-Name).
DISPLAY ' Address: '
FUNCTION TRIM(HV-Cust-Address).
DISPLAY ' '
FUNCTION TRIM(HV-Cust-City), SPACE,
HV-Cust-State, SPACE, HV-Cust-ZipCode.
DISPLAY '-------------------------------------------------'.
2140-Display-Error-Lines.
DISPLAY '-------------Customer Inquiry--------------------'.
DISPLAY '-------------------------------------------------'.
DISPLAY ' Customer: ' HV-Cust-Number ' was not found.'.
3000-End-Job.
EXEC SQL CONNECT RESET END-EXEC.
MOVE SQLCODE TO WS-SQL-STATUS.
5000-Read-DB1.
EXEC SQL
SELECT CUSTNO, FNAME, LNAME,
ADDR, CITY, STATE,
ZIPCODE
INTO
:HV-Cust-Number,
:HV-Cust-First-Name,
:HV-Cust-Last-Name,
:HV-Cust-Address,
:HV-Cust-City,
:HV-Cust-State,
:HV-Cust-ZipCode
FROM CUSTOMERS
WHERE CUSTNO = :HV-Cust-Number
END-EXEC.
MOVE SQLCODE TO WS-SQL-STATUS.
IF SQL-STATUS-OK
SET WS-Customer-Found TO TRUE
ELSE
IF SQL-STATUS-NOT-FOUND
SET WS-Customer-Not-Found TO TRUE
ELSE
DISPLAY "*** WARNING ***"
DISPLAY "There was a problem Fetching the cursor."
DISPLAY "SQLCODE = " SQLCODE
PERFORM 3000-End-Job
MOVE 8 TO RETURN-CODE
GOBACK
END-IF
END-IF.
9800-Connect-to-DB1.
PERFORM 9810-Setup-DB1-Connection.
IF SQL-STATUS-OK
CONTINUE
ELSE
DISPLAY "*** The DB connection is not valid!***"
DISPLAY "Exiting the program.!"
GOBACK
END-IF.
9810-Setup-DB1-Connection.
PERFORM 9811-Get-Credentials.
PERFORM 9812-Create-Connection-To-DB1.
9811-Get-Credentials.
ACCEPT DB1-DBName FROM ENVIRONMENT 'db2name'.
ACCEPT DB1-User-ID FROM ENVIRONMENT 'username'.
ACCEPT DB1-Passwd-Name FROM ENVIRONMENT 'password'.
* Passwords in a CONNECT statement should be entered
* in a VARCHAR format with the length of the input string.
INSPECT DB1-Passwd-Name
TALLYING DB1-Passwd-Length
FOR CHARACTERS BEFORE INITIAL " ".
D DISPLAY "DB1-DBName " DB1-DBName.
D DISPLAY "DB1-User-ID " DB1-User-ID.
D DISPLAY "DB1-Passwd-Name " DB1-Passwd-Name.
9812-Create-Connection-To-DB1.
PERFORM 9814-Connect-To-DB1
IF SQL-STATUS-OK
PERFORM 9816-Create-Cursor-DB1
IF SQL-STATUS-OK
PERFORM 9818-Open-Cursor-DB1
END-IF
END-IF.
9814-Connect-To-DB1.
EXEC SQL
CONNECT TO :DB1-DBName
USER :DB1-User-ID
USING :DB1-Password
END-EXEC.
MOVE SQLCODE TO WS-SQL-STATUS.
9816-Create-Cursor-DB1.
* Parms for DB1-C1
*D DISPLAY "Nothing to do here.".
* As an example:
* MOVE "DESIGNER" TO HV-Job-Title.
9818-Open-Cursor-DB1.
* This would be where you open a cursor.
* Not needed for this program.