IBM Books

Nondelimited ASCII format (ASC)

Nondelimited ASCII format (ASCII) is a file format used to import or load data. An ASC data file is a stream of ASCII characters consisting of data values organized by row and column. Rows in the data stream are separated by line feed sequences. Each column within a row is defined by beginning and ending byte positions. The data type of a given column in the ASC file is determined by the type of the target column in the database table or view.

An example of an ASC file is:

3         4         5
0.........0.........0....
Smith,B.      4973  15.46
Jones,S.     12345  16.34
Davis,S.    452121  93.78

The first column begins in position 30, the second column begins in position 42, and the third column begins in position 50.

This file format can be used for data exchange with applications, including word processors, that create flat text files with aligned column data.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]