Honored Contributor Honored Contributor
Re: how to pass shell variable value into awk scripts
In x.sh do...

awk -v uid=$userid -f my.awk TRANSACT.DAT > "TMPTRANSACT.TXT"