with Tags:
order
X

50 DB2 Nuggets #25 : Tech Tip - Upon load/import of data you may see additional data in the first row inserted.
Using a simple test case. This can be easily observed. Document was exported using a utility that applies a byte order mark to text documents. db2 "create table numbers (col1 char(10),col2 char(10),col3 char(10))" DB20000I The SQL command completed successfully. [db2v97@ts-carose2 ~]$ db2 import from numbers.csv of del insert into numbers SQL3109N The utility is beginning to load data from file "numbers.csv". SQL3110N The utility has completed processing. "2" rows... [More]
Tags:  load db2_techtip mark order byte 50_db2_nuggets import db2 export |