06-17-2008
Hi Hanu
Could you Please explain me what you are trying to do in your code as I am not very good in shell.
Y I am passing the ,sql file name as a paramater is mainly because code resuablity.
so could you please explain what you are passing as a parameter to you procedure.
Thanks,
Hema.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
2. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
5. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
6. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
7. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
8. Programming
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. UNIX for Beginners Questions & Answers
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT DEBIAN
globus_errno_error_object
Error Construction(3) globus common Error Construction(3)
NAME
Error Construction -
Macros
#define GLOBUS_ERROR_TYPE_ERRNO
Construct Error
globus_object_t * globus_error_construct_errno_error (globus_module_descriptor_t *base_source, globus_object_t *base_cause, const int
system_errno)
Initialize Error
globus_object_t * globus_error_initialize_errno_error (globus_object_t *error, globus_module_descriptor_t *base_source, globus_object_t
*base_cause, const int system_errno)
Detailed Description
Create and initialize a Globus Errno Error object.
This section defines operations to create and initialize Globus Errno Error objects.
Macro Definition Documentation
#define GLOBUS_ERROR_TYPE_ERRNO
Error type definition.
Function Documentation
globus_object_t* globus_error_construct_errno_error (globus_module_descriptor_t *base_source, globus_object_t *base_cause, const
intsystem_errno)
Allocate and initialize an error of type GLOBUS_ERROR_TYPE_ERRNO. Parameters:
base_source Pointer to the originating module.
base_cause The error object causing the error. If this is the original error, this paramater may be NULL.
system_errno The system errno.
Returns:
The resulting error object. It is the user's responsibility to eventually free this object using globus_object_free(). A
globus_result_t may be obtained by calling globus_error_put() on this object.
globus_object_t* globus_error_initialize_errno_error (globus_object_t *error, globus_module_descriptor_t *base_source, globus_object_t
*base_cause, const intsystem_errno)
Initialize a previously allocated error of type GLOBUS_ERROR_TYPE_ERRNO. Parameters:
error The previously allocated error object.
base_source Pointer to the originating module.
base_cause The error object causing the error. If this is the original error this paramater may be NULL.
system_errno The system errno.
Returns:
The resulting error object. You may have to call globus_error_put() on this object before passing it on.
Author
Generated automatically by Doxygen for globus common from the source code.
Version 14.7 Tue Nov 27 2012 Error Construction(3)