Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Read parameter file in a shell script to unload a DB2 Table???
Top Forums Shell Programming and Scripting Read parameter file in a shell script to unload a DB2 Table??? Post 302580767 by Corona688 on Friday 9th of December 2011 01:40:12 PM
Old 12-09-2011
Running db2 9,000 times to process 9,000 lines doesn't sound very efficient. You can feed them in direct and run db2 only once.

You didn't specify what to do with the 'name=' parameter so my script ignores it, chops off the 'Query=' from the front, and prints direct:

Code:
while read LINE
do
        # Skip lines that aren't queries
        [ "${LINE:0:6}" = "Query=" ] || continue

        echo "${LINE:6}" # Echo everything after Query=
done < inputfile | db2

This User Gave Thanks to Corona688 For This Post:
developer.dwh9
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read from file as script parameter

I have a file with userIDs, one per line no spaces. I have a script that accepts userIDs as a parameter and outputs information about them. What I have had to do in the past was to modify each line of the file with userIDs to call the script with the userID and pipe the output to a data file. ... (2 Replies)
Discussion started by: vmaxx
2 Replies

2. Shell Programming and Scripting

How to connect DB2 table using shell script

Hi All, I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same. Thanks, Durwas (0 Replies)
Discussion started by: dtidke
0 Replies

3. Shell Programming and Scripting

shell script to read data from text file and to load it into a table in TOAD

Hi....can you guys help me out in this script?? Below is a portion text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies

4. Shell Programming and Scripting

How to pass a variable as a parameter to DB2 database from shell script

I need to pass a variable as a parameter from shell script into a DB2 database. var=bhuk_1123_Q_11/22/09 select * from tbl1 where serial_id='$var'; I have tried executing it using db2 -tvf scriptname Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Discussion started by: ss3944
2 Replies

5. 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 (1 Reply)
Discussion started by: onlyraja
1 Replies

6. Shell Programming and Scripting

How to read a directory as parameter in shell script?

Hi All, I have written a shell script to compile an oracle R12 form and also a procedure is called from it. The procedure registers the form, function and creates a menu entry. I took directory as a parameter. Code is as below: #!/bin/ksh echo... (3 Replies)
Discussion started by: veena484
3 Replies

7. Shell Programming and Scripting

Read parameter file for a shell script

Hi All, I need urgent Help from all of you here. Below is my code- ================================================== #!/usr/bin/sh cd $1 cat $2 | tr -ds "$" "" > parameter_file.param export `parameter_file.param` chmod 777 parameter_file.param echo $1 echo $2 cd $prmDirInput... (5 Replies)
Discussion started by: Amit786
5 Replies

8. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

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

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... (4 Replies)
Discussion started by: Perlbaby
4 Replies

10. UNIX for Beginners Questions & Answers

Shell Script to read hive table and send email

HI Team, I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body. below script: #!/bin/bash hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies

LEARN ABOUT DEBIAN

rdf::query::federate

RDF::Query::Federate(3pm)				User Contributed Perl Documentation				 RDF::Query::Federate(3pm)

NAME

       RDF::Query::Federate - A subclass of RDF::Query for efficient federated query execution.

VERSION

       This document describes RDF::Query::Federate version 2.908.

SYNOPSIS

	my $service = RDF::Query::ServiceDescription->new( $url );
	my $query = new RDF::Query::Federate ( $sparql );
	$query->add_service( $service );
	my $stream = $query->execute();

DESCRIPTION

       ...

METHODS

       "new ( $query, \%options )"
       "new ( $query, $base_uri, $languri, $lang )"
	   Returns a new RDF::Query::Federate object for the specified $query.	The query language defaults to SPARQLP, but may be set
	   specifically by specifying either $languri or $lang, whose acceptable values are:

	     $lang: 'rdql', 'sparql11', or 'sparql'

	     $languri: 'http://www.w3.org/TR/rdf-sparql-query/', or 'http://jena.hpl.hp.com/2003/07/query/RDQL'

       "add_service ( $service_description )"
	   Adds the service described by $service_description to the query's list of data sources.

       "services"
       "algebra_fixup ( $algebra, $bridge, $base_uri, $ns )"
	   Called in the fixup method of ::Algebra classes, returns either an optimized ::Algebra object ready for execution, or undef (in which
	   case it will be prepared for execution by the ::Algebra::* class itself.

AUTHOR

	Gregory Todd Williams <gwilliams@cpan.org>

perl v5.14.2							    2012-01-31						 RDF::Query::Federate(3pm)
All times are GMT -4. The time now is 08:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy