Line break in sqlplus output through ksh script Post: 302995754

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh script: 'exit' being treated as 'break 2'

hi, in a korn shell script, has anyone ever seen an 'exit' being treated as a 'break 2'? I have a script which has 3 nested loops. Within the inner most loop, i'm trying to exit the script on a fault condition. instead of exiting, it's acting as a 'break 2' and then continuing on with the...

2. Shell Programming and Scripting

Need help with ksh script that uses sqlplus, called from PHP

I have a ksh script that connects to sqlplus and dumps the query results into a file. The script works file when I run it from the command line, however, when I call it from PHP using system(), exec(), or shell_exec() commands, the script doesn't seem to run the query. It will create the text file...

3. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,...

4. UNIX for Advanced & Expert Users

sqlPlus output with new line character

Hi, I have a script which calls a sqlplus command and i'm saving the output in a variable. Z=`sqlplus -s $TC_ORACLE_USER/$TC_ORACLE_PASSWORD@$TC_CONNECT_STRING <<eof set echo off set head off set serveroutput on; set feedback off; select description from period where trunc(sysdate)...

5. Shell Programming and Scripting

KSH script to run other ksh scripts and output it to a file and/or email

Hi I am new to this Scripting process and would like to know How can i write a ksh script that will call other ksh scripts and write the output to a file and/or email. For example ------- Script ABC ------- a.ksh b.ksh c.ksh I need to call all three scripts execute them and...

6. Solaris

sqlplus output from ksh.

Hi All, I have the below simple script. It runs just fine by itself when I manually invoke it. But once I put it in the crontab with entry: * * * * * /users/myuser/test.ksh >> /users/myuser/log/test.txt" It does NOT print the returned value ($REMAIN) from the DB!? The result in the...

7. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where...

8. Shell Programming and Scripting

Output result with break line

Hello, I am coding a script to check mysql databases using bash script, I would like to check if the status of a table is not 'OK', will return the table name and do some more actions: check.log table1 OK table2 Some error here table3 ...

9. UNIX for Beginners Questions & Answers

awk script for pattern match and line break

Hi, I have input which reads like 9089.00 ----- kl jkjjljk lkkk; (909099) 9097.00 ----- HGJJHHJ jcxkjlkjvhvlk jhdkjksdfkhfskd 898.00 ----- HHHH I am trying to do something like this - As soon as I found pattern match "XYZ.00-----" it will insert a line break to the input and will go to...

10. Shell Programming and Scripting

Oracle/SQLPlus help - ksh Script calling .sql file not 'pausing' at ACCEPT, can't figure out why

Hi, I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop. The first SQL file is basically a connection test and it is supposed to sort...

LEARN ABOUT LINUX

pam_issue

PAM_ISSUE(8)							 Linux-PAM Manual						      PAM_ISSUE(8)

NAME

       pam_issue - PAM module to add issue file to user prompt

SYNOPSIS

       pam_issue.so [noesc] [issue=issue-file-name]

DESCRIPTION

       pam_issue is a PAM module to prepend an issue file to the username prompt. It also by default parses escape codes in the issue file similar
       to some common getty's (using x format).

       Recognized escapes:

       d
	   current day

       l
	   name of this tty

       m
	   machine architecture (uname -m)

       

	   machine's network node hostname (uname -n)

       o
	   domain name of this system

       
	   release number of operating system (uname -r)

       	
	   current time

       s
	   operating system name (uname -s)

       u
	   number of users currently logged in

       U
	   same as u except it is suffixed with "user" or "users" (eg. "1 user" or "10 users")

       v
	   operating system version and build date (uname -v)

OPTIONS

       noesc
	   Turns off escape code parsing.

       issue=issue-file-name
	   The file to output if not using the default.

MODULE TYPES PROVIDED

       Only the auth module type is provided.

RETURN VALUES

       PAM_BUF_ERR
	   Memory buffer error.

       PAM_IGNORE
	   The prompt was already changed.

       PAM_SERVICE_ERR
	   A service module error occurred.

       PAM_SUCCESS
	   The new prompt was set successfully.

EXAMPLES

       Add the following line to /etc/pam.d/login to set the user specific issue at login:

		   auth optional pam_issue.so issue=/etc/issue

SEE ALSO

       pam.conf(5), pam.d(5), pam(7)

AUTHOR

       pam_issue was written by Ben Collins <bcollins@debian.org>.

Linux-PAM Manual						    06/04/2011							      PAM_ISSUE(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh script: 'exit' being treated as 'break 2'

Discussion started by: gsatch

2. Shell Programming and Scripting

Need help with ksh script that uses sqlplus, called from PHP

Discussion started by: j2owilson

3. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Discussion started by: rwunwla

4. UNIX for Advanced & Expert Users

sqlPlus output with new line character

Discussion started by: decci_7