Sorry team , let me provide more info..
1.Firstly, it checks for the sql db connection. If connection is success it will execute script/file , if not it prints connection failed and wont execute any scripts.
2.Secondly all my files content resides in sqlfiles, whereas just filename is given in master.sql
3.Finally, if any of the script failed it should come out from the loop.
Eg: if 2.sql is failed with some error
remaining file/script should not get executed and come out of the loop.
Moderator's Comments:
Please do wrap your samples in CODE TAGS as per forum rules, see how I wrapped your given error, use [CODE]your samples/errors/codes/etc[/CODE] as an example.
Last edited by Don Cragun; 03-12-2019 at 08:44 AM..
Reason: Fix mismatched CODE/ICODE sample tags.
Hi,
I have a cron job which executes daily once 9 PM.
The script is like
if
then
TYPE=OC
elif
then
TYPE=i
elif
then
TYPE=mmc
elif
then
TYPE=CB
elif
then
TYPE=oth
fi (1 Reply)
Hi all,
I am working on a c source code nearly 2000 line . it contains one big for( i=0; i< 200 ; i++ ) loop of around 600 lines
could any tell me how to break the execution of prog when the value of i is 50 in for loop so that i can check
inside the loop.
Thanks.. (1 Reply)
Hello
i want to incorporate of piece of code in the shell script which checks whether same script is already running or not. If it is already running i want to come out (exit) if its not then continue with the execution of the script.
Any help would be very much appreciated
Thanks (3 Replies)
Hi all,
Is there any command in Unix, which will stop the load process if any error is found in the i/p file?
I am trying to load 5 files sequentially.
A then
B then
C then
D then
E end;
1) If A encounter's any error while data load, the load process should stop, and it should not... (5 Replies)
I have a shell script that writes some data in a file. I want to stop the script after one hour from start of execution using "EXIT 1".
how to do it. I don't want to use CRONTAB. (5 Replies)
Hi,
I run an awk script and I got the error attached below:
here are the lines that the compiler point to as an error:
duration = timeEnd1-timeBegin1;
print "Transmission: type of traffic " flow1 ;
print - Total transmitted bits = totalBits1 bits;
print - duration = ... (2 Replies)
Script:
#!/sbin/sh
echo "Welcome to my First Script"
echo "Enter a word"
read PASS
if then
echo "You are correct"
elif then
echo "Thats incorrect"
else
echo "Bye"
fi
When i run the script shell says:
Syntax error at line 7:'elif' is not expected
I ran through some old posts and... (3 Replies)
hi guys
i have a question
my cron should start executing minute but it sould stop execute only i have tried tis
10 * * * * /home/sample.sh >>
/data/band/cron_$(date+|%Y|m|d).log (2 Replies)
I am writing a bash shell script for GarazLab's "WP EMAIL CRAWLER - AUTO SCRAPER & REAL TIME EXTRACTOR". it contains some commands. I want to stop the shell execution as soon as it encounters an error. how to do it? (8 Replies)
Discussion started by: tahsin352
8 Replies
LEARN ABOUT CENTOS
dblink_open
DBLINK_OPEN(3) PostgreSQL 9.2.7 Documentation DBLINK_OPEN(3)NAME
dblink_open - opens a cursor in a remote database
SYNOPSIS
dblink_open(text cursorname, text sql [, bool fail_on_error]) returns text
dblink_open(text connname, text cursorname, text sql [, bool fail_on_error]) returns text
DESCRIPTION
dblink_open() opens a cursor in a remote database. The cursor can subsequently be manipulated with dblink_fetch() and dblink_close().
ARGUMENTS
conname
Name of the connection to use; omit this parameter to use the unnamed connection.
cursorname
The name to assign to this cursor.
sql
The SELECT statement that you wish to execute in the remote database, for example select * from pg_class.
fail_on_error
If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally.
If false, the remote error is locally reported as a NOTICE, and the function's return value is set to ERROR.
RETURN VALUE
Returns status, either OK or ERROR.
NOTES
Since a cursor can only persist within a transaction, dblink_open starts an explicit transaction block (BEGIN) on the remote side, if the
remote side was not already within a transaction. This transaction will be closed again when the matching dblink_close is executed. Note
that if you use dblink_exec to change data between dblink_open and dblink_close, and then an error occurs or you use dblink_disconnect
before dblink_close, your change will be lost because the transaction will be aborted.
EXAMPLES
SELECT dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
(1 row)
SELECT dblink_open('foo', 'select proname, prosrc from pg_proc');
dblink_open
-------------
OK
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_OPEN(3)