Mumbai, India
ecmnotes.com parag@ecmnotes.com

Registered tables

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 "a<strong>c</strong>" ("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"

Leave a Reply