06-19-2007
Urgent help needed
Hi
I am using DB2 as the database and i am reading syscat.columns from the database.
I want to manipulate the rows returned by running SQL query from the shell script. The manipulation involves addition and deletion of the rows from the resultset.
All the above i want to do using SQL cursors.
Please provide me a code example for the same.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have a script, which is continuously looping. i want to view the script name when i use ps command... it is only showing -sh ...
UID PID PPID C STIME TTY TIME COMMAND
informix 8533 20923 0 18:19:28 pts/ta 0:00 -sh
but i dont have my scriptname displayed .... how can i do that my script is... (0 Replies)
Discussion started by: guhas
0 Replies
2. Shell Programming and Scripting
Ok I admit it I am stumped and I would appreciate any and all help
Here is what I am trying to do.
Korn Shell script
I am setting a variable to another shell script that I want to invoke in my main script like so:
GETDIR=/vol100/cfg/.getdir
The .getdir shell script take a parameter,... (4 Replies)
Discussion started by: Batch
4 Replies
3. Shell Programming and Scripting
hi i want solution regarding usage of array. i m having code which is written using if-
elif and can i use or access using arrays.
here i wana use array values along with if -elif condition. i dnt wana use command line argument
parameter1=(scram no_scram)
if ; then
... (0 Replies)
Discussion started by: manish1
0 Replies
4. Windows & DOS: Issues & Discussions
Hi, Please accept my apologies if I have not explained anything clearly enough but i am a little old on new lingo!!!
I am running XP from home and last night the following happened.
After being logged on for pretty much the full day, I had what seemed like a pop up come up. Although most pop... (3 Replies)
Discussion started by: nike1601
3 Replies
5. UNIX for Advanced & Expert Users
--------------------------------------------------------------------------------
hy guys,
i got few interview questions i need someone to answer urgently:
1)If you cant get to the root, you try to fsck it, but gets errors to read file systems. What steps do you take to recover the host... (1 Reply)
Discussion started by: charneet
1 Replies
6. Shell Programming and Scripting
Hi,
Below is my issue which I desperately need and I want a shell script which can do this job.
I need this script as I m planning to put this for a system health check. Please assist me.
1. There are 10 log files in a particular location.
2. open each log file. Goto to the end of the... (1 Reply)
Discussion started by: kashriram
1 Replies
7. UNIX for Dummies Questions & Answers
Hello Friends,
I am a Graduate in Computers. I completed BCA degree this year. I want to make my career in UNIX. But, unfortunately I don't know anybody who can guide me. I am totally confuse because I don't know where to start and what are the future prospect in UNIX.
Please give your... (4 Replies)
Discussion started by: Luckyless
4 Replies
8. Shell Programming and Scripting
Hi,
I have a directory, where i get 4 files for each day... The files will be generated at any time. I am trying for a shell script for copying the file from this directory whenever new file is generated.
Say for example : If the directory X has following files A1,A2,A3,A4,B1,B2,B3,B4...... (2 Replies)
Discussion started by: krishh.kk
2 Replies
9. Programming
KING KONG ELECTRICITY AUTHORITY
BILL CALCULATOR
You are required to develop a script that will enable KING KONG ELECTRICITY AUTHORITY to
calculate customer bills based on their meter readings.
The customers are categorized into the following categories:
Residential customers
Commercial... (1 Reply)
Discussion started by: watisevil
1 Replies
10. Shell Programming and Scripting
Hi
I want to create a script which deleted files in the following folders older than 30 days. There are a particular version of files inside it to be deleted
Folders :
/files0/interfaces/ResponsysSavedList/BackInStock/EmailContent/backup... (3 Replies)
Discussion started by: Scudza
3 Replies
LEARN ABOUT DEBIAN
class::dbi::query
Class::DBI::Query(3pm) User Contributed Perl Documentation Class::DBI::Query(3pm)
NAME
Class::DBI::Query - Deprecated SQL manager for Class::DBI
SYNOPSIS
my $sth = Class::DBI::Query
->new({
owner => $class,
sqlname => $type,
essential => @columns,
where_columns => @where_cols,
})
->run($val);
DESCRIPTION
This abstracts away many of the details of the Class::DBI underlying SQL mechanism. For the most part you probably don't want to be
interfacing directly with this.
The underlying mechanisms are not yet stable, and are subject to change at any time.
OPTIONS
A Query can have many options set before executing. Most can either be passed as an option to new(), or set later if you are building the
query up dynamically:
owner
The Class::DBI subclass that 'owns' this query. In the vast majority of cases a query will return objects - the owner is the class of which
instances will be returned.
sqlname
This should be the name of a query set up using set_sql.
where_clause
This is the raw SQL that will substituted into the 'WHERE %s' in your query. If you have multiple %s's in your query then you should supply
a listref of where_clauses. This SQL can include placeholders, which will be used when you call run().
essential
When retrieving rows from the database that match the WHERE clause of the query, these are the columns that we fetch back and pre-load the
resulting objects with. By default this is the Essential column group of the owner class.
METHODS
where()
$query->where($match, @columns);
This will extend your 'WHERE' clause by adding a 'AND $column = ?' (or whatever $match is, isntead of "=") for each column passed. If you
have multiple WHERE clauses this will extend the last one.
perl v5.12.4 2004-04-25 Class::DBI::Query(3pm)