Help with Fastexport

Tools & Utilities

Help with Fastexport

I am getting the following error when I run my FastExp script(below).

Thanks

**** 10:27:28 UTY8724 Select request submitted to the RDBMS.
**** 10:27:45 UTY8725 Select execution completed. 98 data blocks generated.
**** 10:27:45 UTY8713 RDBMS failure, 2593: The Select request is not completed yet.
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 10:27:47 UTY1001 Unexpected parcel: 11, expected 10.
**** 10:27:48 UTY6212 A successful disconnect was made from the RDBMS.
**** 10:27:48 UTY2410 Total processor time used = '0.59 Seconds'
. Start : 10:27:24 - WED JUL 23, 2008
. End : 10:27:48 - WED JUL 23, 2008
. Highest return code encountered = '12'.

Script
--------------------------------------------------------------
#!/usr/bin/ksh

MASTER=/raddata/appl/FAA

fexp <<-EOF

.LOGTABLE WORK_DB.DF_STEP0_LOG;
.RUN FILE $MASTER/radadmn;

.BEGIN EXPORT
SESSIONS 8;

.EXPORT OUTFILE step0.dat
MODE RECORD FORMAT TEXT;

lock millie.dartfaa_cac for access;
lock tirks.vctn014_tirks_circuit for access;
sel unique sbc_company_cd (char(5)),
sbc_system_cd (char(1)),
circuit_Access_cd (char(7)),
circuit_identification_cd (char(7)),
circuit_location_a_clli_cd (char(11)),
circuit_location_z_clli_cd (char(11))
from tirks.vctn014_tirks_circuit t, millie.dartfaa_cid d
where index(t.circuit_identification_cd,d.cid) > 0;

.END EXPORT;
.LOGOFF;

EOF
--------------------------------------------------------------
1 REPLY
Enthusiast

Re: Help with Fastexport

lock millie.dartfaa_cac for access;
lock tirks.vctn014_tirks_circuit for access;
sel unique sbc_company_cd (char(5)),
sbc_system_cd (char(1)),
circuit_Access_cd (char(7)),
circuit_identification_cd (char(7)),
circuit_location_a_clli_cd (char(11)),
circuit_location_z_clli_cd (char(11))
from tirks.vctn014_tirks_circuit t, millie.dartfaa_cid d
where index(t.circuit_identification_cd,d.cid) > 0;

In this remove ; in the first 2 line

so

lock millie.dartfaa_cac for access
lock tirks.vctn014_tirks_circuit for access
sel unique sbc_company_cd (char(5)),
sbc_system_cd (char(1)),
circuit_Access_cd (char(7)),
circuit_identification_cd (char(7)),
circuit_location_a_clli_cd (char(11)),
circuit_location_z_clli_cd (char(11))
from tirks.vctn014_tirks_circuit t, millie.dartfaa_cid d
where index(t.circuit_identification_cd,d.cid) > 0;