Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calling sql file from shell script with parameters.
Top Forums Shell Programming and Scripting Calling sql file from shell script with parameters. Post 302433663 by durden_tyler on Wednesday 30th of June 2010 08:04:05 AM
Old 06-30-2010
"[" is a shell builtin test operator. And because it is an operator, it should be surrounded by spaces. Otherwise the shell gets confused (because the operand and the operator are indistinguishable).

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies

2. Shell Programming and Scripting

Problem with Calling sql file from shell script

I have created abc.sh file which will set the environment variables (UNIX env variables as well as ORACLE required variables like ORACLE_SID,ORACLE_HOME etc) and then calls a function file which checks for starts some logs and then it will try to execute the .sql file. The .sh, function file are as... (1 Reply)
Discussion started by: sskc
1 Replies

3. UNIX for Advanced & Expert Users

Calling PL/SQL Script in Shell Programming

Hi all, In a shell script I need to pass two parameters to a pl/sql script and get the ouput of the pl/sql script and use it in shell script. For example Shell script : test.sh PL/SQL script : get_id.sql parameter1 parameter2 Actually get_id.sql has a select statement something... (1 Reply)
Discussion started by: lijju.mathew
1 Replies

4. Shell Programming and Scripting

calling sql file from shell script

Hello everybody I need help calling sql file from shell script. Can anyone help me creating a small shell script which calls an sql file . The .sql file should contain some select statements like select emp_no from emp_table; select emp_id from emp_table; And the results should be... (6 Replies)
Discussion started by: dummy_needhelp
6 Replies

5. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

6. Shell Programming and Scripting

Calling sql in shell script with parameters

Dear All, I want to call an sql script within a unix shell script. I want to pass a parameter into the shell script which should be used as a parameter in teh sql script. e.g $ ./shell1.sh 5000129 here 5000129 is a prameter inside shell script i am calling one sql script e.g. ... (2 Replies)
Discussion started by: Radhe
2 Replies

7. UNIX for Advanced & Expert Users

Calling sql file from shell script

Hi I have a shell script that call a sql file. The sql file will create a spool file. My requirement is, when ever i get an OS error like file not found. I have to log it in a log file. Could some who worked in a like scenario help me by giving the code sample. Many Thanks.. (1 Reply)
Discussion started by: chintapalli001
1 Replies

8. Shell Programming and Scripting

calling a sql file in my shell script

Hi, I want to call a sql file in my shell script. see the below code:- if ] then ( isql -U${S_USER} -S${S_SERV} -w100 -b -h0 <<ENDSQL | sed -e "s/Password://" ${S_PWD} set nocount on go use ${S_DB} go // need to call a file name... (16 Replies)
Discussion started by: dazdseg
16 Replies

9. Shell Programming and Scripting

shell script hangs while calling sql file

I have a master shell script which calls some 40 shell scripts. All the shell scripts calls a sql file which executes some sql statements. I run these scripts in parallel such that it saves me time. When i executed them i saw some strange behavior. Firstly, I found that some scripts among the 40... (1 Reply)
Discussion started by: sushi
1 Replies

10. Shell Programming and Scripting

[Solved] Calling PL/SQL Block into Shell Script

Hi, i have one simple PL/SQL Block and i have saved it as .sql file, which i am trying to call from UNIX script. PL/SQL block structure CONNECT DB_NAME/PWD@Database whenever SQLERROR EXIT 1; Declare ..Variables... BEGIN --Code-- exception END; exit; I have save this block as... (3 Replies)
Discussion started by: abhii
3 Replies

LEARN ABOUT CENTOS

std::decimal::decimal128

std::decimal::decimal128(3)				     Library Functions Manual				       std::decimal::decimal128(3)

NAME

       std::decimal::decimal128 -

SYNOPSIS

   Public Types
       typedef float __decfloat128 __attribute__ ((mode(TD)))

   Public Member Functions
       decimal128 (decimal32 d32)
       decimal128 (decimal64 d64)
       decimal128 (float __r)
       decimal128 (double __r)
       decimal128 (long double __r)
       decimal128 (int __z)
       decimal128 (unsigned int __z)
       decimal128 (long __z)
       decimal128 (unsigned long __z)
       decimal128 (long long __z)
       decimal128 (unsigned long long __z)
       decimal128 (__decfloat128 __z)
       __decfloat128 __getval (void)
       void __setval (__decfloat128 __x)
       decimal128 & operator*= (decimal32 __rhs)
       decimal128 & operator*= (decimal64 __rhs)
       decimal128 & operator*= (decimal128 __rhs)
       decimal128 & operator*= (int __rhs)
       decimal128 & operator*= (unsigned int __rhs)
       decimal128 & operator*= (long __rhs)
       decimal128 & operator*= (unsigned long __rhs)
       decimal128 & operator*= (unsigned long long __rhs)
       decimal128 & operator*= (long long __rhs)
       decimal128 & operator++ ()
       decimal128 operator++ (int)
       decimal128 & operator+= (int __rhs)
       decimal128 & operator+= (decimal32 __rhs)
       decimal128 & operator+= (decimal64 __rhs)
       decimal128 & operator+= (decimal128 __rhs)
       decimal128 & operator+= (unsigned int __rhs)
       decimal128 & operator+= (long __rhs)
       decimal128 & operator+= (unsigned long __rhs)
       decimal128 & operator+= (long long __rhs)
       decimal128 & operator+= (unsigned long long __rhs)
       decimal128 & operator-- ()
       decimal128 operator-- (int)
       decimal128 & operator-= (long __rhs)
       decimal128 & operator-= (int __rhs)
       decimal128 & operator-= (long long __rhs)
       decimal128 & operator-= (unsigned long long __rhs)
       decimal128 & operator-= (unsigned long __rhs)
       decimal128 & operator-= (decimal128 __rhs)
       decimal128 & operator-= (unsigned int __rhs)
       decimal128 & operator-= (decimal32 __rhs)
       decimal128 & operator-= (decimal64 __rhs)
       decimal128 & operator/= (decimal32 __rhs)
       decimal128 & operator/= (long long __rhs)
       decimal128 & operator/= (unsigned long long __rhs)
       decimal128 & operator/= (unsigned long __rhs)
       decimal128 & operator/= (decimal64 __rhs)
       decimal128 & operator/= (unsigned int __rhs)
       decimal128 & operator/= (decimal128 __rhs)
       decimal128 & operator/= (long __rhs)
       decimal128 & operator/= (int __rhs)

Detailed Description
       3.2.4 Class decimal128.

       Definition at line 393 of file decimal.

Constructor &; Destructor Documentation
   std::decimal::decimal128::decimal128 (__decfloat128__z) [inline]
       Conforming extension: Conversion from scalar decimal type.

       Definition at line 418 of file decimal.

Author
       Generated automatically by Doxygen for libstdc++ from the source code.

libstdc++							  Tue Jun 10 2014				       std::decimal::decimal128(3)
All times are GMT -4. The time now is 08:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy