|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
select values from db1 table and insert into table of DB2
Post 302394230 by aemunathan on Wednesday 10th of February 2010 10:35:58 PM
02-10-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
i have a file tabel.out which contain table name in this format.
xyz
abc
qwe
Plz help me writing one script which actually takes tablename from file table.out file one by one and then select count (*) from $tablename limit 10; and print error in output file if any tabel is not... (4 Replies)
Discussion started by: netdbaind
4 Replies
4. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
5. 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
6. Programming
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies
7. Programming
HI team
Is it possible to track DB2 table on the data insertion,deletion and updates on daily basis . Do we have any inbuilt feature to handle audit analysis ?
Any help appreciated (1 Reply)
Discussion started by: Perlbaby
1 Replies
8. Shell Programming and Scripting
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
9. Programming
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted... (1 Reply)
Discussion started by: Perlbaby
1 Replies
10. Programming
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted entire table .... (1 Reply)
Discussion started by: Perlbaby
1 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::db2
SQL::ReservedWords::DB2(3pm) User Contributed Perl Documentation SQL::ReservedWords::DB2(3pm) NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2 SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) { print "$word is a reserved DB2 word!"; } DESCRIPTION
Determine if words are reserved by DB2. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8. is_reserved_by_db2v5( $word ) Returns a boolean indicating if $word is reserved by DB2 5. is_reserved_by_db2v6( $word ) Returns a boolean indicating if $word is reserved by DB2 6. is_reserved_by_db2v7( $word ) Returns a boolean indicating if $word is reserved by DB2 7. is_reserved_by_db2v8( $word ) Returns a boolean indicating if $word is reserved by DB2 8. reserved_by( $word ) Returns a list with DB2 versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_db2v5 is_reserved_by_db2v6 is_reserved_by_db2v7 is_reserved_by_db2v8 reserved_by words SEE ALSO
SQL::ReservedWords <http://www-306.ibm.com/software/data/db2/udb/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)