Assigning value of a select count(*) from tablename ( run on db2 ) to a unix variable Post: 302456965

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select count(*) into a variable

Hi, Could anybody help me how can I assign the value of "select count(*) from table1" to a variable in an unix shell script. Thanks.

2. Shell Programming and Scripting

DB2 and Unix Variable .....

Guys Quick help... ---------------------------- #!/usr/bin/ksh db2 -x "select count(*) from ${SCHEMA}.EMP"> $HOME/count.dat COUNT=`cat $HOME/count.dat` echo Table Count: $COUNT if ( $COUNT -eq 0 ); then echo Record Count in Table is 0 exit 1 fi echo Records Exist...

3. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

4. Shell Programming and Scripting

Storing count(*) into unix variable

Hi, I've just started on unix shell scripting a few days ago. I tried look for the solution to my problem over the net but to no avail. The objective of my script is to count the number of records in a particular table from a Oracle database. Ok, here's my problem, when I run this script: ...

5. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Hi, I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use.. Please can any body help me in this regards Thanks & Regards Abdul Hafeez Shaik

6. UNIX for Dummies Questions & Answers

using unix variable in select column in awk

Hi, I have file on below pattern, and i want to write a generic awk to handle all cases. input_file: col1~col2~col3~col4~col5~col6 I need to generate 4 files something like this File1: col1~~col2~~col3 File2: col1~~col2~~col4 File3: col1~~col2~~col5 File4: col1~~col2~~col6

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

8. UNIX for Advanced & Expert Users

Using xml to run db2 commands

Hi, Strange problem I'm having here and not sure what to do. I have here a xml that is supposed to execute the next value in the schema but it isn't do the job it's supposed to do. I'm not a dba or a developer so I'm sorry in advance if there are some things i don't understand. when we run...

9. Shell Programming and Scripting

Expect - assigning UNIX command output to a variable

Hi, I'm writing a script that connects through ssh (using "expect") and then is supposed to find whether a process on that remote machine is running or not. Here's my code (user, host and password are obviously replaced with real values in actual script): #!/usr/bin/expect set timeout 1...

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

LEARN ABOUT PHP

wtmpx

utmpx(4)							   File Formats 							  utmpx(4)

NAME

       utmpx, wtmpx - utmpx and wtmpx database entry formats

SYNOPSIS

       #include <utmpx.h>
       /var/adm/utmpx
       /var/adm/wtmpx

DESCRIPTION

       The utmpx and wtmpx files are extended database files that have superseded the obsolete utmp and wtmp database files.

       The  utmpx database contains user access and accounting information for commands such as who(1), write(1), and login(1). The wtmpx database
       contains the history of user access and accounting information for the  utmpx database.

USAGE

       Applications should not access these databases directly, but should use the functions described on the getutxent(3C) manual page to  inter-
       act with the utmpx and wtmpx databases to ensure that they are maintained consistently.

FILES

       /var/adm/utmpx	       user access and adminstration information

       /var/adm/wtmpx	       history of user access and adminstrative information

SEE ALSO

       getutxent(3C), wait(3C)wait.h(3HEAD)

SunOS 5.10							    22 Feb 1999 							  utmpx(4)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select count(*) into a variable

Discussion started by: nguda

2. Shell Programming and Scripting

DB2 and Unix Variable .....

Discussion started by: freakygs

3. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

4. Shell Programming and Scripting

Storing count(*) into unix variable

Discussion started by: mervinboyz