cron jobs

Have included as much info as possible. We are unable to run this job "ship" successfully.. It runs otherwise. Any help is appreciated.. joshua # spinner rack 1 #05 17 * * 1,2,3,4,5 /usr4040/mis/mis_edc/progs/spin1.sh # spinner rack 2 #07 17 * * 1,2,3,4,5 /usr4040/mis/mis_edc/progs/spin2.sh # ups unload 45 * * * * /usr4040/mis/mis_edc/progs/ship.sh ********************************************************* TMPDIR=/dbtemp ;export TMPDIR LANG=C ;export LANG SRC=/usr4040/mis/mis_csrc ;export SRC MATHLIB=/lib ;export MATHLIB NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/prime/%N ;export NLSPATH MISDOC=/usr4040/mis/mis_doc ;export MISDOC DBTEMP=/dbtemp ;export MISDOC DEPTH=1 ;export DEPTH USRLIB=/usr/lib ;export USRLIB MENU=/usr4040/mis/utils ;export MENU PATH=/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/cmw/bin:/usr/bin/X11:/sbin:/misc/bin:/misc/etc:/udms:/udms/etc:/usr4047/wp/wpbin:/usr4047/wp/shbin:/i nformix5/bin:/u/orchid:/informix5/bin:/usr/mis/bin:/usr4040/mis/changes:/usr4040 /mis/utils:/usr4040/faxfx/bin ;export PATH DBASE_NAME=mis_db.dbs ;export DBASE_NAME UTILS=/usr4040/mis/utils ;export UTILS DBPATH=/usr4040/edc ;export DBPATH CDPATH=:..:/usr4040/mis/mis_all:/usr4040/mis/mis_po:/usr4040/mis/mis_oe:/usr4040 /mis/mis_csrc:/usr4040/mis/mis_ar:/usr4040/mis/mis_ic:/usr4040/mis/mis_sa:/usr40 40/mis/mis_doc:/usr4040/edc ;export CDPATH CSRC=/usr4040/mis ;export CSRC SUPPORTPROGS=/usr4040/mis/mis_214 ;export SUPPORTPROGS MISTERMDEF=/usr4040/mis/utils/mistermdef ;export MISTERMDEF EDITOR=vi ;export EDITOR LOGNAME=cmw ;export LOGNAME SPLPATH=/usr/lpd/qconfig ;export SPLPATH AIXSPLPATH=/usr/lpd/pio/custom ;export AIXSPLPATH MAIL=/usr/spool/mail/cmw ;export MAIL HOSTNAME=prod1 ;export HOSTNAME LOCPATH=/usr/lib/nls/loc ;export LOCPATH #PS1=[${HOSTNAME}:${PWD}]-!> ;export PS1 INFORMIXVER=2.0 ;export INFORMIXVER#APPL_NAME=Next Generation ;export APPL_NAME MALOC=-lc ;export MALOC TERMCAP=/usr4040/mis/utils/termcap ;export TERMCAP USER=cmw ;export USER MISINC=/usr4040/mis/include ;export MISINC MISPGM=osm ;export MISPGM SYSTEM=AIX ;export SYSTEM GSDB=g ;export GSDB MALLIB=/usr/lib ;export MALLIB SHELL=/bin/ksh ;export SHELL ODMDIR=/etc/objrepos ;export ODMDIR INFORMIXTERM=/usr4040/mis/utils/terminfo.ibm ;export INFORMIXTERMSQLFORMS=/usr4040/mis ;export SQLFORMS #DBPRINT=lp -dlp1 ;export DBPRINT MALLOC_LIB=/lib/libc.a ;export MALLOC_LIB HOME=/home/cmw ;export HOME INCLUDE=/usr/include ;export INCLUDE INFORMIXDIR=/informix5 ;export INFORMIXDIRGROUPNAME=system ;export GROUPNAME TERM=wyse50 ;export TERM #MAILMSG=[YOU HAVE NEW MAIL] ;export MAILMSG #CFLAGS=-c -g -DAIX ;export CFLAGS PWD=/dbtemp ;export PWD TERMINFO=/usr4040/mis/utils/terminfo.ibm ;export TERMINFO PSTATUS=/usr/lpd/qstatus ;export PSTATUS TZ=CST6CDT ;export TZ LPDEST=lp1 ;export LPDEST WPTERM51=wyse50 ;export WPTERM51 #CC2_FLAGS=-g -DAIX ;export CC2_FLAGS APPL=usr4040 ;export APPL CRONLOC=/usr/spool/cron/crontabs ;export CRONLOC A__z=! LOGNAME="*TMOUT ;export A__z LOGNAME isql -q mis_db -cr /usr4040/mis/sqlforms/ship ********************************************************* unload to "/tmp/transfer/ship.csv" select ordnum_ordera,shipattn_ordera,shipname_ordera,shipadr1_ordera, shipadr2_ordera,shipadr3_ordera,shipcity_ordera,shipstate_ordera, shipzip_ordera,"1" from ordera where ordnum_ordera not in (select unique ordernum_ordinpro from ordinpro) order by 3