CREATE TABLE t1(name varchar(30));
INSERT INTO t1 values (
SELECT * from t1;
Table function example:
In the following example, the value of Color is extracted as VARCHAR. The examples assume that you are using the DB2 command shell, in which you do not need to type "DB2" at the beginning of each command.
'/Order/Part/@color')) AS X;
Here are my list of questions.
1. Because DB2XML.XMLFile reads the file from physical location, does the size of the file matters.
2. I want to extract more than one parameter for example key and quantity,
How can I specify both elements?