Data export command: Migration from a DB2 table to a flat file

Please help us with this query.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT DBMS and data warehousing Definition of primary, super, foreign and candidate key in the DBMS What is the difference between a logical and physical warehouse design? What are some emerging data warehouse and DBMS trends? How to get data/database independence with a three-tier architecture How to select an MPP database: DB2 vs. Teradata What comes first — the data mart or the data warehouse? What are the top database management systems (DBMS)? What is the role of DBMS in RDBMS? Is an Inmon-modeled BI system, like Madison, the future of data warehousing? What are the benefits and disadvantages of a RDBMS? IBM DB2 management How to select an MPP database: DB2 vs. Teradata What are the top database management systems (DBMS)? Are there benefits to using both Teradata and a DB2 database? Tips for evaluating top database management systems and choosing a small DBMS Exec explains IBM's Information On Demand (IOD) initiative IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 7 IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 6 IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5 DB2 basics IBM DB2 basics

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

You need to run an export command specifying the proper file format. The export command exports data from a database to an operating system file, which can be in one of several external file formats.

The following information is required when exporting data using the export command/utility:

• An SQL SELECT statement specifying the data to be exported.
• The path and name of the operating system file that will store the exported data.
• The format of the data in the file. This format can be IXF, WSF, or DEL.

You might want to download a (free) copy of the IBM DB2 Data Movement Utilities Guide and Reference which contains information on how to formulate your export command and definitions of each of the various types of formats.

Quickly though, perhaps you are interested in creating a comma-delimited file. In that case, you would use the DEL format (delimited ASCII). A Delimited ASCII (DEL) file is a sequential ASCII file with row and column delimiters. Each DEL file is a stream of ASCII characters consisting of cell values ordered by row, and then by column. Rows in the data stream are separated by row delimiters; within each row, individual cell values are separated by column delimiters. When creating an ASCII delimited file (specifying a comma as the delimiter) you're file output would look something like this:

"Smith, Bob",4973,15.46
"Jones, Bill",12345,16.34
"Williams, Sam",452,193.78

Here is an example of an export requesting ASCII delimited output:

db2 export to test.del of del select tabname from syscat.tables where tabschema ='VSC';

• Learn how using the data export command or copy utility is the best way to backup a database with SQL.