|
|
|
|
|||||||
| AIX AIX is IBM's industry-leading UNIX operating system that meets the demands of applications that businesses rely upon in today's marketplace. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| lom don't execute commands | pasalagua | SUN Solaris | 6 | 01-25-2008 12:22 PM |
| How to execute multiple commands via ssh | srage | Shell Programming and Scripting | 9 | 01-04-2008 11:18 PM |
| how do i get my script to execute multiple commands? | hvincent | Shell Programming and Scripting | 1 | 04-26-2006 05:19 AM |
| Execute commands parallel in a for loop ? | networkfre@k | Shell Programming and Scripting | 3 | 11-27-2005 03:26 PM |
| how to execute shell commands in awk script? | RishiPahuja | Shell Programming and Scripting | 1 | 09-02-2005 06:37 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
04-23-2008
|
|||
|
|||
|
Execute db2 commands in unix
Is there any possibility of executing a series of db2 queries in a unix script?
Please provide an example if possible. 
|
| Forum Sponsor | ||
|
|
|
04-24-2008
|
|||
|
|||
|
Here is a script that is run nightly through cron that backs up two databases:
Code:
#!/bin/sh backuplogfile="/law1/proddata/backup_log.$(date +'%m%d%y_%H%M%S')" echo "Remove backup files from previous day..." >> $backuplogfile 2>&1 rm /law1/proddata/PROD* >> $backuplogfile 2>&1 rm /law1/proddata/LOGAN* >> $backuplogfile 2>&1 echo "Establish environment variables..." >> $backuplogfile 2>&1 . /law1/gen/lawson/.profile >> $backuplogfile 2>&1 echo "Must stop the Lawson Application before backup" >> $backuplogfile 2>&1 stoplaw >> $backuplogfile 2>&1 echo "Backing up prod to /law1/proddata ..." >> $backuplogfile 2>&1 db2 backup database prod user db2inst1 using db2inst1 to /law1/proddata compress >> $backuplogfile 2>&1 echo "Backing up logan to /law1/proddata..." >> $backuplogfile 2>&1 db2 backup database logan user db2inst1 using PASSWORD to /law1/proddata compress >> $backuplogfile 2>&1 echo "Start the Lawson Application after backup..." >> $backuplogfile 2>&1 startlaw >> $backuplogfile 2>&1 The line ". /law1/gen/lawson/.profile sets up the environment so that I can execute the db2 commands and application commands. Last edited by jyoung; 04-24-2008 at 05:20 AM.
|
|
04-25-2008
|
|||
|
|||
|
**************
Get the input from the user say '123' (It varies) Then i want to connect to a database say "D1" then i want th extract from the database by giving "select * from tablename where input = '123' I also want to connect to another database "D2" then i want th extract from the database by giving "select * from tablename where input = '123' output should be displayed on the screen as it is when i execute the select statements individually. ******************************** This is what i want to do in a script Can you show a script for that(For eg)?
|
|||
| Google UNIX.COM |
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
