I keep getting this error...
/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.
any idea?
SCRIPT.................
#!/bin/ksh
set -x
# add the path to unl
#
export PATH=:/opt/apps/maximo/bin:${PATH}
# This script will unload the wostatus table from a Maximo 4i database
ERRTMP=/tmp/err.$$
MINSQL="SELECT NVL(MAX(TO_NUMBER(last_rowstamp)),0) FROM esmaximo.wdw_incr_rowstamp_pull
WHERE table_name = 'WOSTATUS' AND pull_status = 'C'"
MAXSQL="SELECT esmaximo.maxseq.nextval FROM dual"
# Get the lowest rowstamp to start from
#
MINRS=$(unl -c esmaxbat/imagine "${MINSQL}")
if [ "$?" -ne 0 ]
then
exit $?
fi
MINRS=${MINRS:-' '}
# Get the highest rowstamp to stop at
#
MAXRS=$(unl -c esmaxbat/imagine "${MAXSQL}")
if [ "$?" -ne 0 ]
then
exit $?
fi
DT=$(date +%Y%m%d%H%M%S)
# Add a new control record for this incremental pull of longdescription
#
sqlplus esmaxbat/imagine >${ERRTMP} 2>&1 <<-sulplqs
INSERT INTO esmaximo.wdw_incr_rowstamp_pull
(
table_name,
pull_date,
pull_status,
last_rowstamp,
pull_start_time
)
VALUES
(
'WOSTATUS',
TO_DATE('${DT}','YYYYMMDDHH24MISS'),
'C',
'${MAXRS}',
SYSDATE
);
COMMIT;
set heading off;
set feedback off;
set pagesize 50000;
set termout off;
set ttitle off;
set embedded on;
spool /var/opt/oracle/mp4/maximart/wostatus.dat;
set linesize 110
select WONUM||'|'||
STATUS||'|'||
to_char(CHANGEDATE, 'yyyy-mm-dd hh24:mi')||'|'||
CHANGEBY||'|'||
MEMO||'|'||
GLACCOUNT||'|'||
FINCNTRLID||'|'||
ROWSTAMP
from wOSTATUS
WHERE TO_NUMBER(rowstamp) BETWEEN ${MINRS} AND ${MAXRS};
spool off;
set linesize 8;
-- get counts use same where clause as above.
spool /var/opt/oracle/mp4/maximart/wostatus.cnt;
select ltrim(rtrim(count(*)))
from wostatus;
spool off;
sulplqs
exit;
/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.
any idea?
SCRIPT.................
#!/bin/ksh
set -x
# add the path to unl
#
export PATH=:/opt/apps/maximo/bin:${PATH}
# This script will unload the wostatus table from a Maximo 4i database
ERRTMP=/tmp/err.$$
MINSQL="SELECT NVL(MAX(TO_NUMBER(last_rowstamp)),0) FROM esmaximo.wdw_incr_rowstamp_pull
WHERE table_name = 'WOSTATUS' AND pull_status = 'C'"
MAXSQL="SELECT esmaximo.maxseq.nextval FROM dual"
# Get the lowest rowstamp to start from
#
MINRS=$(unl -c esmaxbat/imagine "${MINSQL}")
if [ "$?" -ne 0 ]
then
exit $?
fi
MINRS=${MINRS:-' '}
# Get the highest rowstamp to stop at
#
MAXRS=$(unl -c esmaxbat/imagine "${MAXSQL}")
if [ "$?" -ne 0 ]
then
exit $?
fi
DT=$(date +%Y%m%d%H%M%S)
# Add a new control record for this incremental pull of longdescription
#
sqlplus esmaxbat/imagine >${ERRTMP} 2>&1 <<-sulplqs
INSERT INTO esmaximo.wdw_incr_rowstamp_pull
(
table_name,
pull_date,
pull_status,
last_rowstamp,
pull_start_time
)
VALUES
(
'WOSTATUS',
TO_DATE('${DT}','YYYYMMDDHH24MISS'),
'C',
'${MAXRS}',
SYSDATE
);
COMMIT;
set heading off;
set feedback off;
set pagesize 50000;
set termout off;
set ttitle off;
set embedded on;
spool /var/opt/oracle/mp4/maximart/wostatus.dat;
set linesize 110
select WONUM||'|'||
STATUS||'|'||
to_char(CHANGEDATE, 'yyyy-mm-dd hh24:mi')||'|'||
CHANGEBY||'|'||
MEMO||'|'||
GLACCOUNT||'|'||
FINCNTRLID||'|'||
ROWSTAMP
from wOSTATUS
WHERE TO_NUMBER(rowstamp) BETWEEN ${MINRS} AND ${MAXRS};
spool off;
set linesize 8;
-- get counts use same where clause as above.
spool /var/opt/oracle/mp4/maximart/wostatus.cnt;
select ltrim(rtrim(count(*)))
from wostatus;
spool off;
sulplqs
exit;