Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Exit out of the Script Command inside a Script Post 302289764 by jmungai on Friday 20th of February 2009 11:26:20 AM
Old 02-20-2009
I'm looping through different oracle databases and running some PL/SQL scripts. Currently there are no database links so I can't run the script on one DB across many. I was hoping to capture the output of the PL/SQL in one file.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

using exit command in a shell script

Can it be done? If so, how? I would like a script to contain the exit command, and log me off at script completion. thanks (1 Reply)
Discussion started by: jpprial
1 Replies

2. UNIX for Advanced & Expert Users

Emdedding my script in to exit command

Hi, How can I call my shell script, when I execute 'exit' command? For eg. I am logging out the root login by 'exit' command. My script 'colinfo' shold execute before logging out. I don't want to use any wrapper script. (2 Replies)
Discussion started by: sharif
2 Replies

3. Shell Programming and Scripting

Help with EXIT command inside if

Hi All, I want to use EXIT command in a particular scenario. In my script,its like that:- if($vairable -eq 1);then do this thing do this do this fi if($var2 -eq 1);then do this do this fi like this there are three four if conditions. now I want is that if second condition is... (2 Replies)
Discussion started by: aruncser
2 Replies

4. Shell Programming and Scripting

Need help! command working ok when executed in command line, but fails when run inside a script!

Hi everyone, when executing this command in unix: echo "WM7 Fatal Alerts:", $(cat query1.txt) > a.csvIt works fine, but running this command in a shell script gives an error saying that there's a syntax error. here is content of my script: tdbsrvr$ vi hc.sh "hc.sh" 22 lines, 509... (4 Replies)
Discussion started by: 4dirk1
4 Replies

5. Shell Programming and Scripting

How to get the exit status of a command in nner script to the outer script?

Hi all, I have a shell script inside which i am executing another shell script. In the inner script im executing a command. i want the status of that command in the outer script to perform some validations. How to get its status please help!!1 Im using ksh. (2 Replies)
Discussion started by: Jayaraman
2 Replies

6. Shell Programming and Scripting

Exit script when shutdown or reboot command is given

This is probably a simple question, but I'm new with writing scripts for Linux (IPFire in this case) and Google wasn't helpful with this. When creating a script, what is the best and/or proper way to have it exit automatically if the reboot or shutdown command is given? If that's even... (2 Replies)
Discussion started by: bartgrefte
2 Replies

7. Shell Programming and Scripting

Executing 'exit' command from shell script

Hi, I am writing shell script to automate few use cases for CLI interface. We have CLI interface which has bunch of commands. I am trying to execute one of the commands 'exit' as part of automation to exit from CLI object (not from shell script) in my shell script. My intension is to execute... (4 Replies)
Discussion started by: Mahesh Desai
4 Replies

8. Shell Programming and Scripting

Using script command inside a script or emulating it

My script needs to take a folder path to the location of a C program, and run the program until the user selects exit in his C program. The script needs to create a transcript to a text file while the C program is running. Creating a transcript can be easily done with the script command but it... (2 Replies)
Discussion started by: syntax_eror
2 Replies

9. UNIX for Beginners Questions & Answers

Linux shell | how to exit a script if any command fails.

Hi, i am new here let me say HI for all. now i have a question please: i am sending one command to my machine to create 3 names. if one of the names exists then the box return error message that already have the name but will continue to create the rests. How i can break the command and... (7 Replies)
Discussion started by: Amiri
7 Replies
PDO_SQLSRV-DSN(3)							 1							 PDO_SQLSRV-DSN(3)

PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases

	The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		- The DSN prefix is sqlsrv:.

	      o APP - The application name used in tracing.

	      o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).

	      o Database - The name of the database.

	      o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).

	      o Failover_Partner  - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
		server is unavailable.

	      o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.

	      o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).

	      o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use  legacy  Transact-SQL  rules  (0	or
		false).

	      o Server - The name of the database server.

	      o TraceFile - Specifies the path for the file used for trace data.

	      o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.

	      o TransactionIsolation   -  Specifies  the  transaction  isolation  level.  The  accepted  values  for  this  option  are  PDO::SQL-
		SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
		SRV_TXN_SERIALIZABLE.

	      o TrustServerCertificate	-  Specifies  whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
		tificate.

	      o WSID - Specifies the name of the computer for tracing.

       Example #1

	      PDO_SQLSRV DSN examples

	       The following example shows how to connecto to a specified MS SQL Server database:

	      $c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

	       The following example shows how to connect to a MS SQL Server database on a specified port:

	      $c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");

	       The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you  connect  to  SQL
	      Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).

	      $c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");

PHP Documentation Group 													 PDO_SQLSRV-DSN(3)
All times are GMT -4. The time now is 01:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy