Unix/Linux Go Back    


Shell Programming and Scripting Unix shell scripting - KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and shell scripts and shell scripting languages here.

Run DB2 export command in loop

Shell Programming and Scripting


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 08-04-2010
srimitta srimitta is offline
Registered User
 
Join Date: Mar 2009
Last Activity: 13 May 2014, 8:25 AM EDT
Location: Indianapolis
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Run DB2 export command in loop

Hi All,

I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop.

Please help me with script.


Code:
db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name from file>"

Thanks
Srimitta

Last edited by Scott; 08-04-2010 at 06:55 PM.. Reason: Added code tags
Sponsored Links
    #2  
Old Unix and Linux 08-04-2010
Scott's Unix or Linux Image
Scott Scott is offline Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 25 July 2016, 2:41 AM EDT
Location: Zürich
Posts: 8,595
Thanks: 342
Thanked 1,091 Times in 948 Posts

Code:
$ cat file_with_table_names
table1
table2
table3

$ xargs -I{} echo db2 EXPORT TO \~/data_export/{}.ixf OF IXF MESSAGES messages.txt \"SELECT \* FROM ITG.{}\" < file_with_table_names | sh


Last edited by Scott; 08-04-2010 at 06:26 PM..
Sponsored Links
    #3  
Old Unix and Linux 08-04-2010
srimitta srimitta is offline
Registered User
 
Join Date: Mar 2009
Last Activity: 13 May 2014, 8:25 AM EDT
Location: Indianapolis
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Hi Scott,

Thanks for the reply.

I ran script and getting below error message, any idea.


Code:
$ ksh -x export_db2_tables.ksh
+ cd /home/db2inst2/data_export/scripts/
+ cat table_names
table1
table2
table3
+ db2 connect to ITG

   Database Connection Information

 Database server        = DB2/AIX64 9.5.2
 SQL authorization ID   = DB2INST1
 Local database alias   = ITG

+ xargs -I{} db2 EXPORT TO ~/data_export/{}.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.{}"
+ 0< table_names
+ sh
sh: SQL0104N:  not found.
sh[2]: found:  not found.
sh[4]: SQL0104N:  not found.
sh[5]: found:  not found.
sh[7]: SQL0104N:  not found.
sh[8]: was:  not found.

Thanks
Srimitta

Last edited by Scott; 08-04-2010 at 06:56 PM.. Reason: Added code tags
    #4  
Old Unix and Linux 08-04-2010
Scott's Unix or Linux Image
Scott Scott is offline Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 25 July 2016, 2:41 AM EDT
Location: Zürich
Posts: 8,595
Thanks: 342
Thanked 1,091 Times in 948 Posts
Hi.

Sorry about that Linux


Code:
while read TABLE; do
  db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.$TABLE"
done < file_with_table_names

My globbing brain is not engaged! If it doesn't work, try changing * to \*
Sponsored Links
    #5  
Old Unix and Linux 08-05-2010
srimitta srimitta is offline
Registered User
 
Join Date: Mar 2009
Last Activity: 13 May 2014, 8:25 AM EDT
Location: Indianapolis
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks Scott, Excellent it's working.

Srimitta
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Export Command chpraveen_862 Shell Programming and Scripting 3 03-19-2009 04:29 AM
awk/sed Command : Parse parameter file / send the lines to the ksh export command rajan_san Shell Programming and Scripting 4 11-06-2008 12:29 PM
Export command prakash.kudreka UNIX for Advanced & Expert Users 3 11-20-2007 07:37 AM
export command radhika03 UNIX for Dummies Questions & Answers 2 12-16-2005 08:25 AM
using export command sveera Shell Programming and Scripting 4 04-01-2005 10:05 AM



All times are GMT -4. The time now is 07:05 AM.