Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Looping/Reading file contents not working
Top Forums UNIX for Dummies Questions & Answers Looping/Reading file contents not working Post 302764363 by gary_w on Thursday 31st of January 2013 11:03:10 AM
Old 01-31-2013
Works for me with a cpl of minor tweaks on SUN against Oracle 11g:
Code:
 
$ cat x.dat
DB1
DB2
DB3
DB4
$
$ cat x
#!/bin/ksh
dbcontent=x.dat
echo "Enter userid"
read USERID
echo "Enter passwd:"
stty -echo
read -s PASSWD
stty echo
while read dbname
do
#Connect to SQLPlus
sqlplus -S ${USERID}/${PASSWD}@${dbname} << EOF
select ora_database_name from dual;
prompt my name is $USERID and my password is $PASSWD;
exit;
EOF
done < $dbcontent
exit 0
$
$ ./x
Enter userid
myusername
Enter passwd:
<NUNYO_BUSINESS>
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB1.WORLD
my name is MYUSERNAME and my password is NUNYO_BUSINESS
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB2.WORLD
my name is MYUSERNAME and my password is NUNYO_BUSINESS 
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB3.WORLD
my name is MYUSERNAME and my password is NUNYO_BUSINESS 
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB4.WORLD
my name is MYUSERNAME and my password is NUNYO_BUSINESS 
$

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading specific contents from a file and appending it to another file

Hi, I need to write a shell script (ksh) to read contents starting at a specific location from one file and append the contents at specific location in another file. Please find below the contents of the source file that I need to read the contents from, File 1 -----# more... (5 Replies)
Discussion started by: dnicky
5 Replies

2. Shell Programming and Scripting

Reading and printing one by one contents of a file

I have a file which has following contents: localhost_IP_SIP_1233026552455.xml localhost_IP_SIP_1233026552460.xml localhost_IP_SIP_1233026552467.xml localhost_IP_SIP_1233026552759.xml localhost_IP_SIP_1233026552969.xml localhost_IP_SIP_1233026552975.xml ... (2 Replies)
Discussion started by: Aditya.Gurgaon
2 Replies

3. Shell Programming and Scripting

reading file,looping and limitation

I have 2 functions on AIX. Func_A () { .... .... } Func_B () { .... .... } And I have a abc.txt file (multiple lines) and I would like to read line by line and pass line by line to Func_A & Func_B. once Func_A is done,pass same value to Func_B and in the mean time get second line from... (5 Replies)
Discussion started by: Jang
5 Replies

4. Shell Programming and Scripting

Formatting Report and Reading data and fetching the details from contents file

Data I was trying to write shell script which will be return the output in the below format First i was trying to do these using sed. sed -n '/.ksh/p' mainksh.ksh sed -e 's/*\(.*\)/\1/g' mainksh.ksh $RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file. when i am... (0 Replies)
Discussion started by: rameshds
0 Replies

5. Shell Programming and Scripting

While or For with looping contructs? to create files from contents of a text file

Hi so far I created this script: vi loop.beta.sh for i in `cat extract.filenames.tabc` do echo $i done>$i === This is the original text file. $ more tabc.txt -rwx------- 1 alice staff 1586 2010-11-05 02:27 request-key .conf -rwx------- 1 ted staff 126 ... (3 Replies)
Discussion started by: wolf@=NK
3 Replies

6. Shell Programming and Scripting

Reading file contents until a keyword

Hi Guys, I need to read a file until I find a blank line. and in the next iteration I want to continue reading from the line I find a keyword. For ex: my file looks like PDS_JOB_ALIAS CRITERIA_ITEM_TYPE PDS_JOB_CRITERIA_ITEM CRITERIA_ITEM_TYPE First I want to read the file... (2 Replies)
Discussion started by: infintenumbers
2 Replies

7. Shell Programming and Scripting

Reading the contents of the file and splitting using ksh

We're using a ksh script for installing one product. I've another config file, I'd need to read this configuration file from my main script Content of the Configuration file:... (2 Replies)
Discussion started by: bittu129
2 Replies

8. Shell Programming and Scripting

Need help with looping through file contents

Hi, I have a several files with ".out" extension in a folder and each file has the below like contents .... appname: wonder1 ..... logname78.log logname88.log ..... CAP: 2 ..... appname: wonder54 ...... logname28.log logname58.log logname54.log ..... CAP: 3 ..... (4 Replies)
Discussion started by: mohtashims
4 Replies

9. Emergency UNIX and Linux Support

sed replace file contents by reading from another file

Hello, My input file1 is like this by tab-delimited chr1 mm10_knownGene stop_codon 3216022 3216024 0.000000 - . gene_id "uc007aeu.1"; transcript_id "uc007aeu.1"; chr1 mm10_knownGene CDS 3216025 3216968 0.000000 - 2 gene_id "uc007aeu.1"; transcript_id "uc007aeu.1"; ... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

10. Shell Programming and Scripting

ksh Script, Reading A File, Grepping A File Contents In Another File

So I'm stumped. First... APOLOGIES... my work is offline in an office that has zero internet connectivity, as required by our client. If need be, I could print out my script attempts and retype them here. But on the off chance... here goes. I have a text file (file_source) of terms, each line... (3 Replies)
Discussion started by: Brusimm
3 Replies

LEARN ABOUT OSX

slapd-passwd

SLAPD-PASSWD(5) 						File Formats Manual						   SLAPD-PASSWD(5)

NAME

       slapd-passwd - /etc/passwd backend to slapd

SYNOPSIS

       /etc/openldap/slapd.conf

DESCRIPTION

       The  PASSWD  backend  to slapd(8) serves up the user account information listed in the system passwd(5) file.  This backend is provided for
       demonstration purposes only.  The DN of each entry is "uid=<username>,<suffix>".  Note that non-base searches scan the  the  entire  passwd
       file, and are best suited for hosts with small passwd files.

CONFIGURATION

       This slapd.conf option applies to the PASSWD backend database.  That is, it must follow a "database passwd" line and come before any subse-
       quent "backend" or "database" lines.  Other database options are described in the slapd.conf(5) manual page.

       file <filename>
	      Specifies an alternate passwd file to use.  The default is /etc/passwd.

ACCESS CONTROL

       The passwd backend does not honor any of the access control semantics described in slapd.access(5).  Only read (=r)  access  to	the  entry
       pseudo-attribute  and  to  the other attribute values of the entries returned by the search operation is honored, which is performed by the
       frontend.

FILES

       /etc/openldap/slapd.conf
	      default slapd configuration file

       /etc/passwd
	      user account information

SEE ALSO

       slapd.conf(5), slapd(8), passwd(5).

OpenLDAP 2.4.28 						    2011/11/24							   SLAPD-PASSWD(5)
All times are GMT -4. The time now is 04:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy