05-02-2008
i) code something using a framework like e.g. Perl DBI or Java JDBC
ii) Does it have to be a standalone script? Install the free DB2 kit on some machine and copy'n'paste in some queries.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
2. Shell Programming and Scripting
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
3. Shell Programming and Scripting
Hi,
I have a shell script to query the database to get the statistics of tables like sum,max,min,etc of all numeric columns,max and min of date columns and length of varchar columns for each and every table. There are nearly 1600 tables. My script queries few tables like about 100 tables and... (3 Replies)
Discussion started by: ragavhere
3 Replies
4. UNIX and Linux Applications
Hi folks,
I am looking for a clue to install db2 in cygwin.....kindly help.;) (0 Replies)
Discussion started by: frozensmilz
0 Replies
5. Shell Programming and Scripting
Hi,
I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not?
Can anyone help me in this regard?
Appreciate your help and concern.
Thanks,
Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies
6. Shell Programming and Scripting
Hi everyone!!
I need help regarding this.
How can we load data from DB2 Database tables into a Comma Separated File?
I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file?
It is very urgent for me. Please help me out guys.
... (1 Reply)
Discussion started by: ss3944
1 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi all,
In my concern they gave a task to me do cran job like
To write a shell script for
To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour
I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies
LEARN ABOUT DEBIAN
module::install::share
Module::Install::Share(3pm) User Contributed Perl Documentation Module::Install::Share(3pm)
NAME
Module::Install::Share - Install non-code files for use during run-time
SYNOPSIS
# Put everything inside ./share/ into the distribution 'auto' path
install_share 'share';
# Same thing as above using the default directory name
install_share;
DESCRIPTION
As well as Perl modules and Perl binary applications, some distributions need to install read-only data files to a location on the file
system for use at run-time.
XML Schemas, YAML data files, and SQLite databases are examples of the sort of things distributions might typically need to have available
after installation.
"Module::Install::Share" is a Module::Install extension that provides commands to allow these files to be installed to the applicable
location on disk.
To locate the files after installation so they can be used inside your module, see this extension's companion module File::ShareDir.
TO DO
Currently "install_share" installs not only the files you want, but if called by the author will also copy .svn and other source-control
directories, and other junk.
Enhance this to copy only files under share that are in the MANIFEST, or possibly those not in MANIFEST.SKIP.
AUTHORS
Audrey Tang <autrijus@autrijus.org>
Adam Kennedy <adamk@cpan.org>
SEE ALSO
Module::Install, File::ShareDir
COPYRIGHT
Copyright 2006 Audrey Tang, Adam Kennedy.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
perl v5.14.2 2012-03-01 Module::Install::Share(3pm)