Sponsored Content
Full Discussion: for loop with db2 command
Top Forums Shell Programming and Scripting for loop with db2 command Post 302139332 by Vaddadi on Friday 5th of October 2007 11:15:00 AM
Old 10-05-2007
for loop with db2 command

Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more )
in the variable. I want to get one at a time to process.

I am new to unix scripting so please bear with my question and appreciate your reply. I think this can also me done my awk command but I don't know how.. So appreciate your help.

Shell script is
=================
table_name='TAB_NAME'
schema_name='SCH_NAME'
db2 "connect to DB2D"

tempfile1=`db2 -x "select concat(pkgschema,concat('.',pkgname)) from
syscat.packagedep where bname='"$table_name"' and
bschema='"$schema_name"' with ur "`
echo ' ---tempfile after the db2 command ------- ' $tempfile1
for variable in $tempfile1; do
echo $tempfile1[0]
done

db2 "connect reset"


After the db2 command tempfile1 looks like ( 3 words seperated by blank)
sch1.package1 sch2.package2 sch3.package3

In the for loop also it shows like
sch1.package1 sch2.package2 sch3.package3 [0]
sch1.package1 sch2.package2 sch3.package3 [0]
sch1.package1 sch2.package2 sch3.package3 [0]


Expected output is
====================
sch1.package1
sch2.package2
sch3.package3
 

10 More Discussions You Might Find Interesting

1. AIX

db2 command on the AIX mechine

Hello, can any one help me to debug the following command. db2 -stec +pc ; Regards, SM (2 Replies)
Discussion started by: smolgara
2 Replies

2. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

3. UNIX for Dummies Questions & Answers

Unable to get the db2 command prompt in unix

Hi, When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt. The error i get is... (4 Replies)
Discussion started by: ragavhere
4 Replies

4. Shell Programming and Scripting

Executing DB2 command without using the DBI module

Hi Guys, I wonder if possible to execute a Db2 commands within a perl scripts without installing or invoking the DBI modules. I have a script that is written in kron shell and it looks like : DB=`db2 list db directory | egrep "Database alias|Directory entry type"|awk '{printf $0 ;... (0 Replies)
Discussion started by: arizah
0 Replies

5. Shell Programming and Scripting

Run DB2 export command in loop

Hi All, I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop. Please help me with script. db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name... (4 Replies)
Discussion started by: srimitta
4 Replies

6. Shell Programming and Scripting

how do i access db2 instance via telnet command prompt

Hi I have a perl script code in which connecting with db2 database and doing some process. My perl script code and db2 database server present in the same unix server. I am connecting and executing perl script code via windows telnet. Now my question is i could not able to connect db2 server... (4 Replies)
Discussion started by: solo123
4 Replies

7. Shell Programming and Scripting

DB2: load command in unix

I am currently trying to load data from e.txt into tablea. I am getting error. db2 connect to qw01p user wcs using abc db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt REPLACE into WCSADM.TABLEA... (1 Reply)
Discussion started by: skatpally
1 Replies

8. Shell Programming and Scripting

How to create DB2 Connections in While loop using shell script

Hi , I have to create a db2 connection for the while loop in shell scripting. Below is the connection for DB2 I have to establish connect to TABLESCHENMA user $USERID using $PASSWORD Below is the while loop. while read TABLE; do db2 LOAD CLIENT FROM $DIRECTORY/$TABLE.ixf OF ixf INSERT... (1 Reply)
Discussion started by: vikyalex4
1 Replies

9. UNIX for Dummies Questions & Answers

Db2 command issues with cron

Hi, I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds... (2 Replies)
Discussion started by: VeePee
2 Replies

10. UNIX for Beginners Questions & Answers

Troubles running DB2 command in shell script via cron

Hi there, Now I'm facing error regarding running shell script via cron. The shell script which is required to get value from database. Below is the main part of shell script. #/bin/bash #connect to database(1) db2 connect to $database user xxxx using yyyy #set values from... (3 Replies)
Discussion started by: Rohan Kishibe
3 Replies
yum(8)																	    yum(8)

NAME
yum - Yellowdog Updater Modified SYNOPSIS
yum [options] [command] [package ...] DESCRIPTION
yum is an interactive, automated update program which can be used for maintaining systems using rpm command is one of: * install package1 [package2] [...] * update [package1] [package2] [...] * check-update * upgrade * remove [package1] [package2] [...] * list [...] * info [...] * provides [...] * clean [packages | headers | old-headers | all] Unless the --help or -h option is given, one of the above commands must be present. install is used to install the latest version of a package or group of packages while ensuring that all dependencies are satisfied. If no package matches the given package name(s), they are assumed to be a shell glob and any matches are then installed. update If run without any packages, update will update every currently installed package. If one or more packages are specified, Yum will only update the listed packages. While updating packages, yum will ensure that all dependencies are satisfied. If no package matches the given package name(s), they are assumed to be a shell glob and any matches are then installed. check-update Implemented so you could know if your machine had any updates that needed to be applied without running it interactively. Returns exit value of 100 if there are packages available for an update. Also returns a list of the pkgs to be updated in list format. Returns 0 and no packages are available for update. upgrade takes no arguments, this performs a complete upgrade of the system - good for distro-version changes as it includes packages obso- leting other packages in its updating calculations. remove is used to remove the specified packages from the system as well as removing any packages which depend on the package being removed. list can be used to list various information about available packages; more complete details are available in the List Options section below. provides can be used to find out which package provides some feature or file. Just use a specific name or a file-glob-syntax wildcards to list the packages available or installed that provide that feature or file. info can be used to list a description and summary information about available packages; takes the same arguments as in the List Options section below. clean is used to clean up various things which accumulate in the yup cache directory over time. More complete details can be found in the Clean Options section below. GENERAL OPTIONS
Most command line options can be set using the configuration file as well and the descriptions indicate the necessary configuration option to set. -h, --help Help; display a help message and then quit. -y Assume yes; assume that the answer to answer to any question which would be asked is yes. Configuration Item: assume-yes -r Replace conflicting files (equivalent to the RPM option of '--replacefiles --force'). Attention, this has a high 'shoot your own foot' possibility. Configuration Item: replacefiles -c [config file] Specifies the config file location. -d [number] Sets the debugging level to [number] - turns up or down the amount of things that are printed. -e [number] Sets the error level to [number] 0 - 10. 0 means print only critical errors about which you must be told. 1 means print all errors, even ones that are not overly important. 1+ means print more errors (if any) -e 0 is good for cron jobs. -t Tells yum to be tolerant of errors on the command line with regard to packages on the commandline. For example: if you request to install foo, bar and baz and baz is installed; yum won't error out complaining that baz is already installed. -R [time in minutes] Sets the maximum amount of time yum will wait before performing a command - it randomizes over the time. -C Tells yum to run entirely from cache - does not download or update any headers unless it has to to perform the requested action. LIST OPTIONS
The following are the ways which you can invoke yum in list mode. Note that all list commands include information on the version of the package. yum list [available] list all packages in the yum repositories available to be installed. yum list updates list all packages with updates available in the yum repositories. yum list [args] list the packages specified by args. If an argument does not match the name of a package, it is assumed to be a shell-style glob and any matches are printed. yum list installed list the packages specified by args. If an argument does not match the name of an available package, it is assumed to be a shell-style glob and any matches are printed. yum list extras list the packages installed on the system that are not available in any yum repository listed in the config file. CLEAN OPTIONS
The following are the ways which you can invoke yum in clean mode. yum clean packages Eliminate any cached packages from the system. Note that packages are not automatically deleted after they are downloaded. yum clean headers Eliminate all of the files which yum uses to determine the remote availablility of packages. Using this option will force yum to download all the headers the next time it is run. yum clean oldheaders Eliminate the old headers that yum no longer needs to determine the remote availablility of packages. yum clean [all] Runs yum clean packages and yum clean oldheaders as above. MISC
Proxy configuration If you would like to use a proxy with yum you can simply set a shell environment variable of http_proxy. Set it to the url for your proxy. Ex: "http://your_proxy:port/" FILES
/etc/yum.conf /var/cache/yum/ SEE ALSO
yum-arch (8), yum.conf (5) AUTHORS
Seth Vidal <skvidal@phy.duke.edu> BUGS
There of course aren't any bugs, but if you find any, they should be sent to the mailing list: yum@dulug.duke.edu Seth Vidal 2002 Jun 8 yum(8)
All times are GMT -4. The time now is 06:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy