Create Table in database:
EXECUTE EXEC_SQL WITH QUERY='CREATE TABLE abc(a VARCHAR2(20),b INTEGER,c FLOAT)'
Register specific columns from an external table and create indexes on some of the columns:
REGISTER TABLE "abc" ("a" CHAR(20), "b" INT, "c" FLOAT,) WITH KEY "a", "b"
Return information from a registered table:
SELECT "a", "b" FROM "dm_dbo.abc"
Insert specified values into a registered table:
INSERT INTO "abc" ("a", "b", "c") VALUES ('Throttle',33347,450)
Insert values into a registered table based on a subquery:
INSERT INTO "ac" ("a", "b", "c") SELECT "p", "q", "r" from "pqr"
Modify rows in a registered table:
UPDATE "abc" SET "a" = 'Yoke' WHERE "a" = 'Throttle'
Remove rows from a registered table:
DELETE FROM "abc" WHERE "a" = 27344
Unregister a registered table;
UNREGISTER TABLE "abc"