Shell Programming and Scripting

function getParms {
for parm
do 
   `$parm`=`db2 +w -x "SELECT PARM_VALUE_TXT FROM ${FRMWRK_DB_SCHEMA}.JOB_PARM WHERE PARM_NM='$parm' WITH UR"`
done 
getParms parm1 parm2 parm3

function getParams {
for param in $@
do
   printf -v "$param" "%s" "$(./db2 +w -x "SELECT PARM_VALUE_TXT FROM ${FRMWRK_DB_SCHEMA}.JOB_PARM WHERE PARM_NM='$param' WITH UR")"
done
}

getParams parm1 parm2 parm3

$ cat nameref
#! /bin/ksh

typeset -n z=a

a="alpha"
b="beta"
echo $z

z=b   # z is no longer a name reference
echo now $z

typeset -n z=b
echo finally $z
exit 0
$
$
$ ./nameref
alpha
now b
finally beta
$

#!/bin/ksh
function getParams {
for param in $@
do
    export $param="$(db2 +w -x "SELECT PARM_VALUE_TXT FROM ${FRMWRK_DB_SCHEMA}.JOB_PARM WHERE PARM_NM='$param' WITH UR")"
done
}

getParams parm1 parm2 parm3

1. The  words  that  the  parser has marked as variable assignments
   (those preceding the command name) and  redirections  are  saved 
   for later processing.

4. The text after the = in each variable assignment undergoes tilde
   expansion, parameter expansion, command substitution, arithmetic
   expansion, and quote removal before being assigned to the  vari-
   able.