|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
sqlload not found error
Post 302201413 by abhi_123 on Monday 2nd of June 2008 07:22:50 AM
06-02-2008
sqlload not found error
When i try to run a job in unix, i am getting
sqlload error as,
sqlload : file not found.
Can any one please let me know whats the reason for this..
The PATH & ORACLE_HOME paths names are correct...
thanks
hr is the script:
here is the script : plz hv a look
TABLE_NAME= tablename
CONTROL_FILE=ctrlname
typeset -i NO_OF_FILES= number
typeset -i I
((I = NO_OF_FILES - 1))
set -A TABLE_NAME_ARRAY table names
set -A LOG_NAME_ARRAY lognames
set -A DATA_FILE_ARRAY datafilesnames
set -A CONTROL_FILE_ARRAY control filesnames
set -A DR_IND_FILE_ARRAY ind filesnames
set -A CR_IND_FILE_ARRAY crind filenames
set -A ARCHIVE_FILE_ARRAY filenames
typeset -i INC=0
while ((INC <= I))
do
TABLE_NAME=${TABLE_NAME_ARRAY[$INC]}; export TABLE_NAME
LOG_NAME=${LOG_NAME_ARRAY[$INC]}; export LOG_NAME
DATA_FILE=${DATA_FILE_ARRAY[$INC]}; export DATA_FILE
CONTROL_FILE=${CONTROL_FILE_ARRAY[$INC]}; export CONTROL_FILE
DR_IND_FILE=${DR_IND_FILE_ARRAY[$INC]}; export DR_IND_FILE
CR_IND_FILE=${CR_IND_FILE_ARRAY[$INC]}; export CR_IND_FILE
TAR_FILE=${ARCHIVE_FILE_ARRAY[$INC]}; export TAR_FILE
date > ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/truncate_table.sql $TABLE_NAME $USER_ID >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE PRELOAD $TABLE_NAME 0 > /dev/null
# Run the load script
sqlload $USER_ID/$USER_PWD,\
CONTROL=${SCRIPT_HOME}/${CONTROL_FILE},\
DATA=${DATA_DIR}/${DATA_FILE},ROWS=4000,\
BINDSIZE=500000,\
BAD=/tmp/${LOG_NAME}.bad,\
LOG=${LOG_HOME}/${LOG_NAME}.log >> /dev/null
print Analyzing table ${TABLE_NAME}... >> ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/analyze_table.sql $TABLE_NAME >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE POSTLOAD $TABLE_NAME 0 > /dev/null
touch ${LOG_HOME_1}/${USER_ID}.${TABLE_NAME}.ready
((INC += 1))
done
sqlload error as,
sqlload : file not found.
Can any one please let me know whats the reason for this..
The PATH & ORACLE_HOME paths names are correct...
thanks
hr is the script:
here is the script : plz hv a look
TABLE_NAME= tablename
CONTROL_FILE=ctrlname
typeset -i NO_OF_FILES= number
typeset -i I
((I = NO_OF_FILES - 1))
set -A TABLE_NAME_ARRAY table names
set -A LOG_NAME_ARRAY lognames
set -A DATA_FILE_ARRAY datafilesnames
set -A CONTROL_FILE_ARRAY control filesnames
set -A DR_IND_FILE_ARRAY ind filesnames
set -A CR_IND_FILE_ARRAY crind filenames
set -A ARCHIVE_FILE_ARRAY filenames
typeset -i INC=0
while ((INC <= I))
do
TABLE_NAME=${TABLE_NAME_ARRAY[$INC]}; export TABLE_NAME
LOG_NAME=${LOG_NAME_ARRAY[$INC]}; export LOG_NAME
DATA_FILE=${DATA_FILE_ARRAY[$INC]}; export DATA_FILE
CONTROL_FILE=${CONTROL_FILE_ARRAY[$INC]}; export CONTROL_FILE
DR_IND_FILE=${DR_IND_FILE_ARRAY[$INC]}; export DR_IND_FILE
CR_IND_FILE=${CR_IND_FILE_ARRAY[$INC]}; export CR_IND_FILE
TAR_FILE=${ARCHIVE_FILE_ARRAY[$INC]}; export TAR_FILE
date > ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/truncate_table.sql $TABLE_NAME $USER_ID >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE PRELOAD $TABLE_NAME 0 > /dev/null
# Run the load script
sqlload $USER_ID/$USER_PWD,\
CONTROL=${SCRIPT_HOME}/${CONTROL_FILE},\
DATA=${DATA_DIR}/${DATA_FILE},ROWS=4000,\
BINDSIZE=500000,\
BAD=/tmp/${LOG_NAME}.bad,\
LOG=${LOG_HOME}/${LOG_NAME}.log >> /dev/null
print Analyzing table ${TABLE_NAME}... >> ${LOG_HOME}/${LOG_NAME}.out
sqlplus -s $USER_ID/$USER_PWD @${SCRIPT_HOME}/analyze_table.sql $TABLE_NAME >> ${LOG_HOME}/${LOG_NAME}.out
mfi.sh $DATA_FILE ${LOG_NAME}.log ${LOG_NAME}.out $CONTROL_FILE POSTLOAD $TABLE_NAME 0 > /dev/null
touch ${LOG_HOME_1}/${USER_ID}.${TABLE_NAME}.ready
((INC += 1))
done
Last edited by abhi_123; 06-02-2008 at 08:32 AM..
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
When I try to run this shell script (name txt1)
script -> txt1
------------------------
#!/usr/bin/ksh
x = "hello"
echo "$x"
------------------------
error while executing
------------------------
serv1> txt1
./txt1: x: not found
------------------------ (2 Replies)
Discussion started by: k_oops9
2 Replies
2. Programming
We are trying to execute C/C++ programs in SOlaris 8. Though the exes are compiled in g++, we donot have it installed in the target machine. We have the library files in the target machine and LD_LIBRARY_PATH is set correctly. Now when the exes are run, we are getting the error
$ seq
ld.so.1:... (1 Reply)
Discussion started by: virtual_j
1 Replies
3. Shell Programming and Scripting
Hi I have to move data to a file based on the valuies of first three characters in a file I am using the following script
FIN=$LOC/TEST.TXT
FEEDFILE=$LOC/TUE_GROSSJE.TXT
#Read the file
while read FDROW
do
FEEDROW=$FDROW;
DTYPE=`echo $FEEDROW |cut -c 1-3`
if ; then
$FEEDROW... (4 Replies)
Discussion started by: gander_ss
4 Replies
4. Shell Programming and Scripting
Hello everyone,
I am using Linux and tcsh shell. I am trying to run a free open source program( which is in the form of a binary file), but every time I run it it gives me an error saying:
newhtsg_v1.0:Command not found.
I have set permission also for the same.
What else can I do to make... (4 Replies)
Discussion started by: ad23
4 Replies
5. Shell Programming and Scripting
hello
every time i run the following code
for val in fileX fileY fileZ
do
$val=`ls -l $val | awk '{print $5}'`
done
i got error message command not found , i tried to add ' and " but nothing works
its only worked wen remove $val=
but i want the name of the file and the value
... (9 Replies)
Discussion started by: mogabr
9 Replies
6. Shell Programming and Scripting
Unix script for removing the footer from the datafile while loading into externaltable using sqlload
Hi,
Can you please tell me the Unix shell script for removing footer from the datafile while loading into external table using sqlloader
we will be skipping the header like this while creating the table
organization external
(
type oracle_loader
default directory directoryname... (5 Replies)
Discussion started by: srikanth_sagi
5 Replies
7. UNIX for Dummies Questions & Answers
Hi, I get a "FILEPATH: not found" error on the 3rd line and the line where it is within the case. Any idea as to why I'm getting this error time and time again?
Oh and FILEPATH will store the directory of the file.
I appreciate any help!
IAM=`basename $0`
RC=0
FILEPATH = ""... (1 Reply)
Discussion started by: MIA651
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I have written one shell script where I should call a function by passing variables to the actual function based on some condition.
Each time I run the script I am getting the below error
dsadm@bunyipd: /var/datastage/FRPDEVL/work/script> sh MClub_Validations.sh
Iteration: 1... (1 Reply)
Discussion started by: tpk
1 Replies
9. Shell Programming and Scripting
Hey, I'm trying to make an interactive perl program and while I'm not done I wanted to share the bit of code I have at the moment because I keep running into an error that says that it "Found = in conditional, should be ==" in my code. This is my code-
use warnings;
use strict;
my $i;
$i=0;... (2 Replies)
Discussion started by: Eric1
2 Replies
LEARN ABOUT PHP
odbc_tables
ODBC_TABLES(3) 1 ODBC_TABLES(3) odbc_tables - Get the list of table names stored in a specific data source SYNOPSIS
resource odbc_tables (resource $connection_id, [string $qualifier], [string $owner], [string $name], [string $types]) DESCRIPTION
Lists all tables in the requested range. To support enumeration of qualifiers, owners, and table types, the following special semantics for the $qualifier, $owner, $name, and $ta- ble_type are available: o If $qualifier is a single percent character (%) and $owner and $name are empty strings, then the result set contains a list of valid qualifiers for the data source. (All columns except the TABLE_QUALIFIER column contain NULLs.) o If $owner is a single percent character (%) and $qualifier and $name are empty strings, then the result set contains a list of valid owners for the data source. (All columns except the TABLE_OWNER column contain NULLs.) o If $table_type is a single percent character (%) and $qualifier, $owner and $name are empty strings, then the result set contains a list of valid table types for the data source. (All columns except the TABLE_TYPE column contain NULLs.) PARAMETERS
o $connection_id -The ODBC connection identifier, see odbc_connect(3) for details. o $qualifier - The qualifier. o $owner - The owner. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character). o $name - The name. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character). o $types - If $table_type is not an empty string, it must contain a list of comma-separated values for the types of interest; each value may be enclosed in single quotes (') or unquoted. For example, "'TABLE','VIEW'" or "TABLE, VIEW". If the data source does not sup- port a specified table type, odbc_tables(3) does not return any results for that type. RETURN VALUES
Returns an ODBC result identifier containing the information or FALSE on failure. The result set has the following columns: oTABLE_QUALIFIER oTABLE_OWNER oTABLE_NAME oTABLE_TYPE oREMARKS The result set is ordered by TABLE_TYPE, TABLE_QUALIFIER, TABLE_OWNER and TABLE_NAME. SEE ALSO
odbc_tableprivileges(3). PHP Documentation Group ODBC_TABLES(3)