For this, you need to keep a log; bulk load and import programs often log to a file, but inside the database you need to use a table.
为此,需要维护一个日志;批量装载和导入程序常常将日志写入一个文件,但是在数据库中需要使用一个表。
The DB2 UDB import utility writes data from an input file to a database table or updatable view.
DB 2UDBimport工具将数据从输入文件写到数据库表或可更新视图。
Click the Files TAB in the Import table task assistant, and use the data file you created.
单击Import table任务助手中的Files标签,并使用您创建的数据文件。
Using the DB2 import command, we then populate this new table with data contained in the large del file: import from staffdata.del of del modified by chardel coldel, decpt. insert into newstaff.
然后我们使用DB 2import命令,用大型del文件中包含的数据填充这个新表:importfrom staffdata . del of del modifiedby chardel “ ” coldel, decpt . insert into newstaff。
Create the following customer1.del file to import a record in the T1 table, which has 111 in the ID column, and the content of the customer1.xml.
创建以下customer1 . del文件来导入t1表中的一条记录,该记录的ID列为111,xmldata列为customer1 . xml文件的内容。
identitymissing no yes yes Specifies that the import or load input file does not contain any values for the identity column in the target table. Given load input file custdata.del
identitymissing noyes yes指定导入或载入输入文件不包含任何目标表中标识列的值。
Table 2 shows that in terms of server space, when using the import command, the most space-efficient storage method is to store the binaries in a single, compressed file.
表2表明,在服务器空间方面,当使用import命令时,空间效率最高的方法是以单个压缩文件的形式存储二进制文件。
To populate the table, simply import the file using an SQL command, as shown in Listing 3 (it might be necessary to increase the size of the DB2 log file first).
要填充该表,只需使用SQL命令导入文件即可,如清单3中所示(可能需要先增加DB 2日志文件的大小)。
To populate the table, simply import the file using an SQL command, as shown in Listing 3 (it might be necessary to increase the size of the DB2 log file first).
要填充该表,只需使用SQL命令导入文件即可,如清单3中所示(可能需要先增加DB 2日志文件的大小)。
应用推荐