01-05-2016
Hi RudiC,
The query works perfectly.
My intention to store the result of the query in a variable which i cant do it through system function.
Is it the problem with AWK ?
Regards,
Nantha.Y
10 More Discussions You Might Find Interesting
1. AIX
Hi everyone.
I am currently looking for a monitor to monitor my DB2 UDB database, which runs on AIX 5.3. Does anyone here use any good ones or has anyone heard of any good ones?
I especially need to monitor which applications run at any given time, so that I am able to ballance the workload... (0 Replies)
Discussion started by: sprellari
0 Replies
2. UNIX for Dummies Questions & Answers
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. Shell Programming and Scripting
Hi Guys,
I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys.
MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' `
Harby. (4 Replies)
Discussion started by: hariza
4 Replies
4. Shell Programming and Scripting
Hi i am working on a script which takes a parameter file as input . this parameter file is having SQL statements. I am fetching column names from the output of SQL file using following code:
while read Record1
do
SQLQuery=`echo $Record1 | awk '{printf $0 }'`
... (2 Replies)
Discussion started by: manmeet
2 Replies
5. Shell Programming and Scripting
i want to run a db2 query though shell script
but i want my where condition element to chnage everytime like class_nm='abc' next time class_nm='def' next time
i want it to do by passing parameters to unix script
can someone give example how can i do it (0 Replies)
Discussion started by: er_zeeshan05
0 Replies
6. AIX
Dear friends I am going to study DB2 and i dont have any experience with any DB's.. Please provide me with some links or pdf's for DB2 starters.
any advice will be very usefull (2 Replies)
Discussion started by: Vit0_Corleone
2 Replies
7. Shell Programming and Scripting
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. (1 Reply)
Discussion started by: midhun19
1 Replies
8. Shell Programming and Scripting
Hi,
I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below...
if (start_new_rec=="true"){
exclude_user="false";
user=toupper($6);
match(user, "XXXXX.");
if (RSTART ==2 ) {
... (9 Replies)
Discussion started by: asandy1234
9 Replies
9. Shell Programming and Scripting
Guys,
My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe,
I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to get the base Table name.
I can parse easily through AWK but i could not execute db2 commands in... (1 Reply)
Discussion started by: Nandy
1 Replies
10. Shell Programming and Scripting
Hi ,
I am trying to use the below in awk but failed, any one assist please,
awk '{ print $0;
if ( $0 ~ /LOADTMP1/ )
{
print $4;
Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE
TD.BTYPE='T' AND... (2 Replies)
Discussion started by: Nandy
2 Replies
LEARN ABOUT ULTRIX
bsearch
bsearch(3) Library Functions Manual bsearch(3)
Name
bsearch - binary search a sorted table
Syntax
#include <stdlib.h>
void *bsearch (key, base, nel, sizeof (*key), compar)
void *key, *base;
size_t nel;
int (*compar)( );
Description
The subroutine is a binary search routine generalized from Knuth (6.2.1) Algorithm B. It returns a pointer into a table indicating where a
datum may be found. The table must be previously sorted in increasing order according to a provided comparison function. The key points
to the datum to be sought in the table. The base points to the element at the base of the table. The nel is the number of elements in the
table. The compar is the name of the comparison function, which is called with two arguments that point to the elements being compared.
The function must return an integer less than, equal to, or greater than zero according to whether the first argument is to be considered
less than, equal to, or greater than the second.
Diagnostics
A NULL pointer is returned if the key cannot be found in the table.
Notes
The pointers to the key and the element at the base of the table should be of type pointer-to-element, and cast to type pointer-to-charac-
ter.
The comparison function need not compare every byte, so arbitrary data may be contained in the elements in addition to the values being
compared.
Although declared as type pointer-to-character, the value returned should be cast into type pointer-to-element.
See Also
hsearch(3), lsearch(3), qsort(3), tsearch(3)
bsearch(3)