How to connect DB2 table using shell script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Python Script to take file count and insert into DB2 table

Team I have files in different directories . How can i take the count of latest file and insert into Db2 table . I am using awk 'END{print NR+1-ARGC}' (File name) to get the counts. How can i take 1.The count of latest file 2.Insert into Db2 table( File Name and Counts) . cd...

2. UNIX and Linux Applications

[Solved] How to connect DB2 from UNIX shell script?

Hi all, I have a requirement to connect DB2 database and do some operations and generate a report through shell script. Can anyone please tell me how can i connect DB2 from unix shell script? Thanks in ADV.

3. Shell Programming and Scripting

Read parameter file in a shell script to unload a DB2 Table???

Hi , I Have following requirement: DB2 Sql query to pass from a parameter file for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt How to write/modify below ksh script to...

4. Shell Programming and Scripting

connect to db2 using shell script

Guys, I am trying to write a shell script that connect to wcsprod database and read the query #!/bin/ksh sqlplus -s < connect to wcsprod user wcsadm using pwd > select * from catentry fetch first 1 row only with ur; databse: wcsprod user: wcsadm pwd: pwd thanks

5. Shell Programming and Scripting

Connect status of db2 in Unix shell script

Hi I am trying to connect to db2 database from Unix shell script (k shell) I need to catch the status of connect whether it is succesful or not. ---------------------------------------------------------- # Read login credentials for db2 tput clear echo "Please enter your Userid:\c"...

6. Shell Programming and Scripting

Connect db2 using db2 connect

I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box. Is this acheivable using db2 connect? pls help me with a sample script which can perform the same.

7. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is...

8. Shell Programming and Scripting

Connect to DB2 table using Shell scripts

Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram

9. Linux

Help req for...shell script to catch "db2 connect" errors ...

Hello friends, Assume that, I am trying to execute a "db2 connect" command from Linux shell prompt via a shell script called "sample" sample db2 connect to bas39 $sample If the database is not present its should display a custom error message by catching the error message given by db2....

10. 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.

LEARN ABOUT REDHAT

adsl-connect

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

NAME

       adsl-connect - Shell script to manage a PPPoE link

SYNOPSIS

       adsl-connect [config_file]

       adsl-connect interface user [config_file]

DESCRIPTION

       adsl-connect  is  a  shell  script  which  manages  an ADSL connection using the Roaring Penguin user-space PPPoE client.  If you omit con-
       fig_file, the default file /etc/sysconfig/network-scripts/ifcfg-ppp0 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 adsl-connect directly.  Instead, use adsl-start to bring up the ADSL connection.

       adsl-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 adsl-connect re-establishes the connection.	In addition, each time the connection is dropped or cannot be  established,  adsl-
       connect executes the script /etc/ppp/adsl-lost if it exists and is executable.

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

TECHNICAL DETAILS

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

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

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

       PIDFILE
	      A  file in which to write the process-ID of the adsl-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 adsl-start and adsl-stop.

AUTHOR

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

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

SEE ALSO

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

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

Shell Programming and Scripting