Connect to database with shell output Post: 303008137

Sponsored Content

Top Forums Shell Programming and Scripting Connect to database with shell output Post 303008137 by Don Cragun on Monday 27th of November 2017 03:52:50 PM

11-27-2017

Registered User

Quote:

Originally Posted by grvk101

Dear RUDIC,

Thnx for the edit.

@DON,

I made changes and the script is executing. But the output which I am getting is not a single in but in iterations.
The input file has 3 lines and output generated is as follows.

OUTPUT

Code:

select * from tablename where sdigits in
(990099110300112517)
select * from tablename where sdigits in
(990099110300116099,
990099110300112517)
select * from tablename where sdigits in
(990099110300116094,
990099110300116099,
990099110300112517)

The above output is from a single file only.

Regards.
GVK

Please try using the code I suggested in post #2:

Code:

filedate=$(date '+%d%m%Y')
awk '
/H\|/ {	pn[substr($0, 9, 18)]
}
END {	print "select * from tablename where sdigits in"
	sep = "("
	for(i in pn) {
		printf("%s%s", sep, i)
		sep = ",\n"
	}
	print ")"
}' $filedate*lpn*

exactly as shown above without removing line breaks and without adding line breaks that are in the above suggestion. There is a HUGE difference in the behavior of:

Code:

END { ... }

and:

Code:

END
{ ... }

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can i connect from a .sh or .sc to a database?

please, help me-.... i need connect to a database Sybase IQ 12 and I don't know if i can do it using a shell program. if it's posibble, please tell me how... please, help me, because I don't know what to do.... thanks... jonathan

2. Programming

How to connect database in TC

Anybody please help me how connect a database file in TC for windows. regards Senthil. K

3. Shell Programming and Scripting

Connect to sybase database using Korn shell script

Hi, Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP. Please help. Thanks, Gops

4. IP Networking

how you connect to a database

i am working on informix database can any body helps me with coding how to connect to it on solaris

5. Shell Programming and Scripting

How to connect to database db2 through Unix Shell Script

I am trying to connect to database db2 through shell script. The process I am trying is > db2 It gives me error Access Denied. While checking for access I have the rights. Is there ant other way round..? Please help.

6. Shell Programming and Scripting

how will i connect postgres database from unix shell script

I have got the solution so just closing this issue.

7. UNIX for Dummies Questions & Answers

Shell scripting+connect to oracle database+spooling

Hi! Everyone I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv file then email to customer. Can anybody let me know how to go about that. I have create...

8. Shell Programming and Scripting

Shell Linux to connect to a database and execute store procedure

HI, i want to write a script (Linux) that: 1) connect to a database oracle 2) execute some store procedure. Can anybody help me, please? Thanks a lot Andrew

9. Shell Programming and Scripting

Shell Script to connect to the oracle database

Hi Unix Gurus, I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any...

10. Shell Programming and Scripting

How to connect to Oracle database using shell script?

Hi All, I am newbie to unix shell scripting. I want to connect to oracle database using shell script. I know how to connect DB using user name and password but my question is if my password is having '@' sign then how to connect. I have tried like below, cnt=`sqlplus -s /nolog << EOFSQL ...

LEARN ABOUT DEBIAN

pppoe-connect

PPPOE-CONNECT(8)					      System Manager's Manual						  PPPOE-CONNECT(8)

NAME

       pppoe-connect - Shell script to manage a PPPoE link

SYNOPSIS

       pppoe-connect [config_file]

       pppoe-connect interface user [config_file]

DESCRIPTION

       pppoe-connect  is  a  shell  script  which  manages a PPPoE connection using the Roaring Penguin user-space PPPoE client.  If you omit con-
       fig_file, the default file /etc/ppp/pppoe.conf is used.	If you supply interface and user, then they override the  Ethernet  interface  and
       user-name settings in the configuration file.

       Note that normally, you should not invoke pppoe-connect directly.  Instead, use pppoe-start to bring up the PPPoE connection.

       pppoe-connect  first  reads a configuration file.  It then brings up a PPPoE connection.  If the connection ever drops, a message is logged
       to syslog, and pppoe-connect re-establishes the connection.  In addition, each time the connection is dropped  or  cannot  be  established,
       pppoe-connect executes the script /etc/ppp/pppoe-lost if it exists and is executable.

       The shell script pppoe-stop causes pppoe-connect to break out of its loop, bring the connection down, and exit.

TECHNICAL DETAILS

       pppoe-connect uses the following shell variables from the configuration file:

       ETH    The Ethernet interface connected to the DSL modem (for example, eth0).

       USER   The PPPoE user-id (for example, b1xxnxnx@sympatico.ca).

       PIDFILE
	      A file in which to write the process-ID of the pppoe-connect process (for example, /var/run/pppoe.pid).  Two additional files ($PID-
	      FILE.pppd and $PIDFILE.pppoe) hold the process-ID's of the pppd and pppoe processes, respectively.

       By using different configuration files with different PIDFILE settings, you can manage multiple PPPoE connections.  Just specify  the  con-
       figuration file as an argument to pppoe-start and pppoe-stop.

AUTHOR

       pppoe-connect was written by David F. Skoll <dfs@roaringpenguin.com>.

       The pppoe home page is http://www.roaringpenguin.com/pppoe/.

SEE ALSO

       pppoe(8),  pppoe-start(8),  pppoe-stop(8), pppd(8), pppoe.conf(5), pppoe-setup(8), pppoe-status(8), pppoe-sniff(8), pppoe-server(8), pppoe-
       relay(8)

4th Berkeley Distribution					 21 February 2000						  PPPOE-CONNECT(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can i connect from a .sh or .sc to a database?

Discussion started by: DebianJ

2. Programming

How to connect database in TC

Discussion started by: Senthil

3. Shell Programming and Scripting

Connect to sybase database using Korn shell script

Discussion started by: bhgopi

4. IP Networking

how you connect to a database

Discussion started by: ramneek

5. Shell Programming and Scripting

How to connect to database db2 through Unix Shell Script

Discussion started by: ankitgupta

6. Shell Programming and Scripting

how will i connect postgres database from unix shell script

Discussion started by: jambesh

7. UNIX for Dummies Questions & Answers

Shell scripting+connect to oracle database+spooling

Discussion started by: Mr Mo

8. Shell Programming and Scripting

Shell Linux to connect to a database and execute store procedure

Discussion started by: manichino74

9. Shell Programming and Scripting

Shell Script to connect to the oracle database

Discussion started by: bshivali

10. Shell Programming and Scripting

How to connect to Oracle database using shell script?

Discussion started by: pmotewar

LEARN ABOUT DEBIAN

pppoe-connect