Sponsored Content
Top Forums Shell Programming and Scripting Line break in sqlplus output through ksh script Post 302995754 by Sumit Arora on Tuesday 11th of April 2017 04:35:19 PM
Old 04-11-2017
Thanks everyone for prompt response.
Found that it was issue while copying the file from unix to local system and opening in Notepad. converting the file into text mode while copying solved the issue.
In server files were ok.
 

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... (4 Replies)
Discussion started by: gsatch
4 Replies

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... (7 Replies)
Discussion started by: j2owilson
7 Replies

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,... (6 Replies)
Discussion started by: rwunwla
6 Replies

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)... (2 Replies)
Discussion started by: decci_7
2 Replies

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... (2 Replies)
Discussion started by: pacifican
2 Replies

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... (3 Replies)
Discussion started by: steve701
3 Replies

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... (5 Replies)
Discussion started by: nkm0brm
5 Replies

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 ... (5 Replies)
Discussion started by: Abu Rayane
5 Replies

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... (3 Replies)
Discussion started by: Indra2011
3 Replies

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... (2 Replies)
Discussion started by: newbie_01
2 Replies
uucp(1c)																  uucp(1c)

Name
       uucp, uulog, uuname - unix to unix copy

Syntax
       uucp [option...] source-file...	destination-file

       uulog [option...]

       uuname [option...]

Description
       The  command  copies  files  named by the source-file arguments to the destination-file argument.  A file name either may be a path name on
       your machine or may have the form

	      system-name!pathname

       where `system-name' is taken from a list of system names which knows about.  Shell metacharacters ?*[] appearing in the pathname part  will
       be expanded on the appropriate system.

       Pathnames  may  be  a  full  pathname, a pathname preceded by ~user, where user is a userid on the specified system and is replaced by that
       user's login directory, or anything else prefixed by the current directory.

       If the result is an erroneous pathname for the remote system, the copy will fail.  If the destination-file is a directory, the last part of
       the  source-file  name is used.	If a simple ~user destination is inaccessible to data is copied to a spool directory and the user is noti-
       fied by

       The command preserves execute permissions across the transmission and gives 0666 read and write permissions.  For further information, see

Options
       The following options are interpreted by

       -d Creates all necessary directories for the file copy.

       -c Uses the source file when copying out rather than copying the file to the spool directory.

       -m Sends you mail when the copy is complete.

       -nrec
	  Sends mail to the recipient.

       -W Expands only local files.  Normally files names are prepended with the current working directory if a full path is not  specified.   The
	  -W tells to expand local files only.

       The command prints a summary of and transactions that were recorded in the file

       The options cause to print logging information:

       -ssys
	  Displays information about work involving specified system.

       -uuser
	  Displays information about work involving specified user.

       The command lists the uucp names of known systems.

       -l Lists local system name.

Warnings
       The  domain  of	remotely  accessible  files  can (and for obvious security reasons, usually should) be severely restricted.  You will very
       likely not be able to fetch files by pathname.  Ask a responsible person on the remote system to send them to you.  For the  same  reasons,
       you will probably not be able to send files to arbitrary pathnames.

Restrictions
       All files received by will be owned by uucp.
       The  -m	option	will  only work sending files or receiving a single file.  (Receiving multiple files specified by special shell characters
       ?*[] will not activate the -m option.)

Files
       /usr/spool/uucp - spool directory
       /usr/lib/uucp/* - other data and program files
       /etc/acucap - shared autodial modem database

See Also
       mail(1), uux(1c), acucap(5)
       "Uucp Implementation Description," ULTRIX Supplementary Documentation, Vol. III:System Manager

																	  uucp(1c)
All times are GMT -4. The time now is 01:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy