07-28-2011
So you are saying :
You run sqlldr from command line with file1.par as parameter and it works ?
But after you put it in a shell script, you are getting error above ?
If above is true please :
Put set -x as second line of the script.
Put exec 2>>/path/to/log.log as next line
Also you might want to put some echo $test aswell.
Run the script and post the output of script and log.log here.
Regards
Peasant.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed
2. I have seven different files each of which needs to... (1 Reply)
Discussion started by: systemsb
1 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
Can anyone know how to get the error codes from 'sqlldr' ?While am trying to load some 'ISO-8859-1' data file into 'utf8' oracle database,some records are rejected.I want to know the reason,whether it is due to charset mismatch or some other issues.How come i to know that ?
... (3 Replies)
Discussion started by: DILEEP410
3 Replies
3. Shell Programming and Scripting
Hi,
I've a batch program that load data from a file like:
00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|
I used the sqlldr command in this way:
sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG... (2 Replies)
Discussion started by: raippl
2 Replies
4. Shell Programming and Scripting
Hola,
Genere un proceso en proC que me inserta registros a oracle, el cual ejecuto desde un shell en Unix. Por otro lado tengo un sqlldr que me hace el trabajo en un 25 % de tiempo que mi proceso en C.
Se que puedo ejecutar mi sqlldr desde un shell, pero no se como hacer, alguien tiene un... (0 Replies)
Discussion started by: marcoinxs
0 Replies
5. Shell Programming and Scripting
Hello all,
I know this is Unix forum, but i also know that there are some experts here who can help me out with this situation;
I am loading a data file into oracle table using Perl script by calling sqlldr script.
It does not do anything, and no data is getting loaded.
Any help,... (2 Replies)
Discussion started by: msrahman
2 Replies
6. Shell Programming and Scripting
How can i check if sqlldr has been installed on my AIX/UNIX mechine?
Is there any unix script to check this one out.... (0 Replies)
Discussion started by: msrahman
0 Replies
7. Shell Programming and Scripting
Guys i am facing two problems :
(1) when i create the sql loader file the date format i m getting is this
28-DEC-11 12.03.14.107137 AM;
for this i m using this script but unable to load the files
trailing nullcols
(
SERIALNO,
AMOUNT,
CLASS,
MDN,
VDATE "to_date(:TIMESTAMP, 'DD-MON-YY... (6 Replies)
Discussion started by: xal_kaushi
6 Replies
8. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
9. Shell Programming and Scripting
Good morning,
I'm attempting to call sqlldr via shell script and it is prompting endIf is unec
#!/bin/sh
cd /tmp/v_tst
FILENAME_WANTED=`date +"HourlyData_%Y%m%d_%H00.txt"`
echo "FILENAME_WANTED = ${FILENAME_WANTED}"
LIST_OF_FILES=`ls -rt HourlyData*.txt |tail -1`
LIST_OF_FILES=`basename... (4 Replies)
Discussion started by: V1l1h1
4 Replies
LEARN ABOUT PHP
ignore_user_abort
IGNORE_USER_ABORT(3) 1 IGNORE_USER_ABORT(3)
ignore_user_abort - Set whether a client disconnect should abort script execution
SYNOPSIS
int ignore_user_abort ([string $value])
DESCRIPTION
Sets whether a client disconnect should cause a script to be aborted.
When running PHP as a command line script, and the script's tty goes away without the script being terminated then the script will die the
next time it tries to write anything, unless $value is set to TRUE
PARAMETERS
o $value
- If set, this function will set the ignore_user_abort ini setting to the given $value. If not, this function will only return the
previous setting without changing it.
RETURN VALUES
Returns the previous setting, as an integer.
EXAMPLES
Example #1
A ignore_user_abort(3) example
<?php
// Ignore user aborts and allow the script
// to run forever
ignore_user_abort(true);
set_time_limit(0);
echo 'Testing connection handling in PHP';
// Run a pointless loop that sometime
// hopefully will make us click away from
// page or click the "Stop" button.
while(1)
{
// Did the connection fail?
if(connection_status() != CONNECTION_NORMAL)
{
break;
}
// Sleep for 10 seconds
sleep(10);
}
// If this is reached, then the 'break'
// was triggered from inside the while loop
// So here we can log, or perform any other tasks
// we need without actually being dependent on the
// browser.
?>
NOTES
PHP will not detect that the user has aborted the connection until an attempt is made to send information to the client. Simply using an
echo statement does not guarantee that information is sent, see flush(3).
SEE ALSO
connection_aborted(3), connection_status(3), Connection Handling for a complete description of connection handling in PHP. .
PHP Documentation Group IGNORE_USER_ABORT(3)