connect to db2 using shell script

Shell Programming and Scripting
1

Guys,
I am trying to write a shell script that connect to wcsprod database and read the query

#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd > 
select * from catentry fetch first 1 row only with ur;

databse: wcsprod
user: wcsadm
pwd: pwd

thanks

2

try like this,

#!/bin/sh
sqlplus -s wcsadm/pwd@wcsprod <<ENDOFSQL
     set feed off
     set head off
     set pages 0
     set verify off
     select query;
     exit
ENDOFSQL