ALLBASE/SQL Reference Manual (36216-90216)

Chapter 8 233
Expressions
Expression
table:
BULK INSERT INTO PurchDB.OrderItems VALUES (?,?,?,?)
See the syntax descriptions for each DML statement, and for the PREPARE,
DESCRIBE, EXECUTE, and OPEN statements for details of dynamic parameter usage.
Example
The result length of PartNumber || VendPartNumber is 32 in this example.
CREATE TABLE PurchDB.SupplyPrice
(Part Number CHAR(16) NOT CASE SENSITVE not null unique,
VendorNumber INTEGER
VendPartNumber CHAR(16) lang=german,
UnitPrice DECIMAL (10,2),
Delivery Days SMALLINT,
DiscountQty SMALLINT)
SELECT PartNumber || VendPartNumber, UnitPrice from PurchDB.SupplyPrice;