Shell Programming and Scripting

db2 "select *from TAB1  where PK IN (select PK  from  TAB2) order by BEDG_NR".

getCompareQuery ()
{
        firTab="${1}"
        secTab="${2}"
        pKey="${3}"
        orderBy="${4}"
        echo "select * from ${firTab} where ${pKey} IN (select ${pKey} from ${secTab}) order by ${orderBy}"
}

## Execute it as follow:
# getCompareQuery "TAB1" "TAB2" "PK" "BEDG_NR"
select *from TAB1 where PK IN (select PK from TAB2) order by BEDG_NR

# compQuery=`getCompareQuery "TAB1" "TAB2" "PK" "BEDG_NR"`
# db2 "${compQuery}"

$ ./cmpre.sh s1 tab1  tab2 PK ordkerkey 

ksh: ./cmpre.sh:  not found.
$
$ more cmpre.sh



$ more cmpre.sh
#!/usr/bash
#===========================
#Arguements Reading
#============================

schemaName="${1}"
firstTab= "${2}"
secondTab="${3}"
pKey="${4}"
orderBy="${5}"
db2 "set schema $schemaName"

#============================
#Execute Query as below
#CompareQuery "TAB1" "TAB2" "PK"
#============================

echo "db2 select count(*) from ${firTab} where ${pKey} NOT IN (select ${pKey} from ${secTab}) order by ${orderBy})"

# which bash
/bin/bash
# whereis bash
bash: /bin/bash /usr/share/man/man1/bash.1.gz