Aug 9, 2010

Unix: Export command in Unix

prddwl1a /folder1/folder2 >db2

db2 => connect to database

   Database Connection Information

 Database server        = DB2/AIX64 9.5.1
 SQL authorization ID   = XXXXX
 Local database alias   = XXXXXX

db2 => export to /opt/pcntr_dv/file.dat of del modified by coldel| messages /folder1/XXXX.dat select * from schema.tablename

No comments:

Post a Comment