Sponsored Content
Top Forums Shell Programming and Scripting Problem in connecting to db in a loop Post 302970714 by anijan on Monday 11th of April 2016 06:27:55 AM
Old 04-11-2016
when i give a newline at the end of county_list file, the output is as follows:

Code:
/home/devdbg2/uat_report>./UAT_usr_login_report.sh
Connecting to county 1
PRINTING STATUS 0
SEARCHING FOR ERROR IN LOG FILE
no match with the pattern
OUT OF IF LOOP

Connecting to county 7
PRINTING STATUS 1
OUT OF WHILE LOOP

exit code is captured as 1 but the while loop exits which should not happen
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Problem Connecting from Windows base OS to linux

I have a network consisting of Linux Server, Win-Nt & 95 OS. I am able to connect from Linux to Win-NT using either ftp / telnet in time. But it takes me around & more than 50 seconds to connect from Wint -Nt/95 to Linux using either ftp/telnet. My network is small & it hardly consists 20-25... (3 Replies)
Discussion started by: S.Vishwanath
3 Replies

2. UNIX for Dummies Questions & Answers

Connecting with X-win problem

Hello all, I am trying to connect to my Solaris 8 system with X-win. However, when i try to connect, a black screen comes up, then closes up immediatley. I have checked /var/dt/Xerrors, and I am getting the folllowing: Warning: Missing charsets in String to FontSet conversion Warning:... (2 Replies)
Discussion started by: dragunu
2 Replies

3. UNIX for Dummies Questions & Answers

Having A Problem Connecting to Oracle Using Cron

Can someone tell me how to prevent this? stty: standard input: Invalid argument ERROR: ORA-12154: TNS:could not resolve the connect identifier specified SP2-0306: Invalid option. Usage: CONN where <logon> ::= <username> | / ERROR: ORA-12162: TNS:net service name is incorrectly... (1 Reply)
Discussion started by: goodmis
1 Replies

4. Programming

Problem Connecting to Socket

Can anyone help? I'm trying to write a program which will write to a socket. I can get the server to run, but always get an error when I try to connect. It gives me an error at the "connect" command. It's probably a simple error, but I can't seem to find it. #include <sys/socket.h>... (6 Replies)
Discussion started by: Stevhp
6 Replies

5. Shell Programming and Scripting

Error connecting oracle from inside while loop

Hi, I m trying to connect oracle database from inside while loop. I m trying to put the output of sql query in a flat file. Anyone please help me out. cat $FILE_NAME | \ while read da_name do $ORACLE_HOME/bin/sqlplus -s user_name/password@instance << EOF >> $OUTPUT_FILE select... (3 Replies)
Discussion started by: Devesh5683
3 Replies

6. Post Here to Contact Site Administrators and Moderators

Problem connecting to www.unix.com

I've been having a problem connecting to the forum. I know it is just something with my computer but I have no idea what it is. It started last week. Every time I connect I get this: <?xml version="1.0" encoding="ISO-8859-1" ?> - <rss version="2.0"... (2 Replies)
Discussion started by: Vi-Curious
2 Replies

7. Shell Programming and Scripting

Problem in Connecting to Oracle Database using KornShell

Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it. #!/bin/ksh ssh -X root@192.168.2.127 <perimuka> sleep 5 su - oracle sqlplus <mraghunandanan>/<peri123> <<eof Can anyone tell what is wrong... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

8. UNIX for Dummies Questions & Answers

Problem connecting with Reflection X 14.1

Other people at work are able to connect but I am not. I am not sure if there is a setting that I am missing. Connecting from Win7 to Solaris 10. Connection attempt log: gnome-session Connecting 144.243.90.235 via TELNET Thu Mar 29 15:15:32 2012 login: *** Password: ******* Last login: Thu... (2 Replies)
Discussion started by: SIFT3R
2 Replies

9. UNIX for Dummies Questions & Answers

Problem connecting FreeBSD VM(Hyper-v) to internet

I created a VM for FreeBSD on hyper-v and i am having trouble connecting it to the internet. My virtual machine config are as below: 100 GB HD 1GB RAM Generation 1 Two Network adapters 1. Legacy Network Adapter 2. Network Adapter both are connected to network switch "Internet" which... (2 Replies)
Discussion started by: Vishawdeep
2 Replies

10. Shell Programming and Scripting

Sqlplus not connecting the 2nd time in for loop

Hi, I am trying to get the rows(First step is to get the poolid's and then second step run a loop to get the output based on each pool id and third connection is to get the member id and pool id based on a different condition) where based of certain conditions and storing it in a file. I wrote the... (6 Replies)
Discussion started by: ajayakunuri
6 Replies
HTML::Template::Compiled::Reference(3pm)		User Contributed Perl Documentation		  HTML::Template::Compiled::Reference(3pm)

NAME
HTML::Template::Compiled::Reference - A quick reference for HTML::Template::Compiled syntax TAGSTYLES
<TMPL_IF var><TMPL_VAR foo></tmpl_if var> <!-- TMPL_IF var --><!-- TMPL_VAR foo --><!-- /tmpl_if var --> <%if var %><%= foo %><%/if var %> Optional tagstyle 'tt': [%if var %][%= foo %][%/if var %] ACCESSING VARIABLES
<%= _.foo %> outputs foo in the cuurent position of the stash and is the same as <%= foo %> <%= .config.url %> goes to root of parameter stash; like $params->{config}->{url} <%= ..foo %> goes one level up in stash <%= list[3].keyname.method %> acts like: $stash->[3]->{keyname}->method TAGS
VAR <%var foo%> or <%= foo%> IF, IF_DEFINED, UNLESS, ELSIF, ELSE conditions like in Perl LOOP, WHILE, EACH for-loop and while-loop like in Perl. <%loop cds%><%= __counter__%>. Title: <%= _.title%><%/loop cds%> <%loop cds join=", " %><%= _.title%><%/loop cds%> <%while resultset.next%><%= __counter__%>. <%= _.foo %><%/while %> <%each hashref%><%= __key__ %>=<%= __value__ %><%/each %> (sorted alphanumeric) <%each hashref sort=alpha %><%= __key__ %>=<%= __value__ %><%/each %> (sorted alphanumeric) <%each hashref sort=num %><%= __key__ %>=<%= __value__ %><%/each %> (sorted numeric) <%each hashref sort=0 %><%= __key__ %>=<%= __value__ %><%/each %> (not sorted) WITH <%with cds[0].artist.fanclub%><%= _.address%><%= _.homepage%><%/with %> INCLUDE, INCLUDE_VAR <%include template.htc%> <%include_var param_with_template_name%> COMMENT, VERBATIM, NOPARSE <%comment explanation %> This will not appear in the rendered template. blah blah... <%/comment explanation %> SWITCH, CASE <%switch .config.language%> <%case de%>Hallo <%case es%>Hola <%case en,default%>Hello <%/switch .config.language%> PERL See section Perl in HTML::Template::Compiled ATTRIBUTES
Each attribute can be written as attribute=foo attribute="some thing" attribute='some "thing"' NAME You can omit the 'name=' here. <%if var%>var<%elsif name=var2%>var4<%/if%> Can be used in all tags. ESCAPE <%= message escape=html %> <%= params escape=url %> <%= params escape=js %> <%= some_var escape=dump|html%> Can be used in "VAR"-tags. DEFAULT <%= this.var.might_be_undef default="my fault" %> Can be used in "VAR"-tags. ALIAS <%loop cds alias="cd" %><%= cd.title %><%/loop cds %> Can be used in "LOOP" and "WHILE". Works like "SET_VAR" and is short for <%loop cds %><%set_var cd value=_ %><%= cd.title %><%/loop cds %> Useful for nested loops. SET_VAR <%set_var myvar value=.another.var %> <%set_var myvar2 expr="60 * 60 * 24" %> This creates a variable similar to local() in perl. To use such a var or an alias in includes, you must use "USE_VARS" in the include. USE_VARS <!-- recognize myvar and myvar2 as variables not parameter stash --> <%use_vars myvar,myvar2 %> myvar: <%= myvar %> JOIN <%loop cds join=", " %><%= _.title%><%/loop cds%> can be used in "LOOP" BREAK <%loop cds break="3" %> <%= _.title%><%if __break__ %> </%if %> <%/loop cds%> Sets "__break__" to 1 every xth loop. Can be used in "LOOP", "WHILE" and "EACH" OPTIONS
(loop)_context_vars <%= __index__ %> the current loop index starting at 0 <%= __counter__ %> the current loop index starting at 1 <%= __first__ %> true if first iteration <%= __last__ %> true if last iteration <%= __odd__ %> true if __counter__ is odd <%= __inner__ %> true if not last or first iteration <%= __key__ %> the key of an EACH iteration <%= __value__ %> the value of an EACH iteration <%= __break__ %> see L<"BREAK"> above <%= __filename__ %> filename of current template (since 0.91_001) <%= __filenameshort__ %> short filename of current template (since 0.91_001) perl v5.14.2 2012-05-26 HTML::Template::Compiled::Reference(3pm)
All times are GMT -4. The time now is 01:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy