Trending September 2023 # How Does Load Command Work In Db2 With Example? # Suggested October 2023 # Top 15 Popular

You are reading the article How Does Load Command Work In Db2 With Example? updated in September 2023 on the website Chivangcangda.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How Does Load Command Work In Db2 With Example?

Introduction to DB2 load

DB2 provides the LOAD online utility to the user, in which we can load more than one table into the tablespace. By LOAD online utility, we can load different records into the table and create, or we can, say, build any index defined on them. Sometimes tables contain some records. At that time, we have two options. First, we can add new records to the table, and the second option is that we can replace the existing records at the time of the LOAD utility. After Load operation, we are able to perform the different kinds of operation such as edit or validation etc.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

load from specified file name with file extension del insert into specific table name;

Explanation

In the above example, we use the load command to load the content of the specified file into the specified table by using the insert into the statement.

How does load command work in DB2?

Now let’s see how the load command works in DB2 as follows. How the LOAD utility Load DB2 tables as follows:

Utilize the LOAD utility to load more than one table into the tablespace, or at least one partition of table space. The LOAD utility works on table space, so you should have the authority of all tables’ access in the tablespace when we need to run the LOAD command.

Moreover, you can utilize the LOAD utility to perform the following task as follows.

We can compress the data and build the directory as per the requirement.

By using the LOAD command, we can convert the records into the compatible data format and between the encoding schemas.

By using the LOAD command, we can load multiple tables into a solitary table space.

a) Delimited input and output files

The LOAD and UNLOAD utilities can acknowledge or create a delimited record or files, which is a consecutive BSAM document with row delimiters and column delimiters. You can dump information from different frameworks into at least one document that utilizes a delimited record arrangement and afterwards utilize these delimited records as for contributions for the LOAD utility. Likewise, you can dump DB2 information into delimited documents by utilizing the UNLOAD utility and afterwards utilising these records to contribute to another DB2 data set.

b) INCURSOR choice

The INCURSOR choice of the LOAD utility indicates a cursor for the info informational collection. Utilize the EXEC SQL utility control proclamation to proclaim the cursor prior to running the LOAD utility. You characterize the cursor with the goal that it chooses information from another DB2 table. The segment names in the SELECT proclamation should be indistinguishable from the segment names of the table that is being stacked. The INCURSOR alternative uses the DB2 cross-loader work.

c) CCSID alternative option

You can load input information into ASCII, EBCDIC, or Unicode tables. The ASCII, EBCDIC, and UNICODE alternatives on the LOAD utility proclamation let you indicate whether the configuration of the information in the info record is ASCII, EBCDIC, or Unicode. The CCSID choice of the LOAD utility articulation allows you to indicate the CCSIDs of the information in the info record. On the off chance that the CCSID of the information doesn’t coordinate with the CCSID of the tablespace, the information fields are changed over to the CCSID of the tablespace before they are stacked.

d) Accessibility during load

For non-parcelled tablespaces, information for different tables in the tablespace that isn’t important for the table that is being loaded is inaccessible to other application programs during the heap activity except for LOAD SHRLEVEL CHANGE. For divided tablespaces, information that is in the tablespace that is being loaded is likewise inaccessible to other application programs during the heap activity except for LOAD SHRLEVEL CHANGE. Furthermore, some SQL proclamations, like CREATE, DROP, and ALTER, may encounter disputes when they run against another tablespace in a similar DB2 information base while the table is being loaded.

e) Default esteems for a column.

At the point when you load a table and don’t supply an incentive for at least one of the sections, the move DB2 makes relies upon the conditions.

On the off chance that the segment is a ROWID section that utilizes the GENERATED BY DEFAULT alternative, DB2 creates an extraordinary worth.

On the off chance that the segment is a personality section that utilizes the GENERATED BY DEFAULT alternative, DB2 offers a predetermined benefit.

With XML sections, if there is a certainly made DOCID segment in the table, it is made with the GENERATED ALWAYS trait.

You can’t supply worth for ROWID or character segments that utilize the GENERATED ALWAYS choice since this alternative implies that DB2 consistently offers a benefit.

Examples

Now let’s see the different examples of load command as follows.

db2 –tvf demoload.txt

The end output of the above statement we illustrate by using the following screenshot as follows.

load from chúng tôi of ixf replace into emp_copy

After that, run a select statement to see the result as follows.

select * from emp_copy;

Explanation

In the above example, we use a select statement to see the load command result. The end output of the above statement we illustrate by using the following screenshot as follows.

Conclusion

We hope from this article you have understood about the DB2 Load command. From the above article, we have learned the basic syntax of the load command, and we also see different examples of Load command. We also learned the rules of the load command. From this article, we learned how and when we use the DB2 Load command.