Transfer Data from Traditional Ingres Table
Data can be transferred in either direction between traditional Ingres tables and X100 tables using either INSERT...SELECT or CREATE TABLE AS SELECT.
To transfer data from traditional Ingres using INSERT..SELECT
1. Create a destination table with X100 storage type:
CREATE TABLE dst (i INTEGER)
2. Issue INSERT...SELECT into that table:
INSERT INTO dst SELECT * FROM src
To transfer data from traditional Ingres using CREATE TABLE AS SELECT
Use a statement like the following:
CREATE TABLE dst AS SELECT FROM src
To create an Ingres table based on a table in X100
Assuming that the default setting is to create an X100 table, use a statement like the following:
CREATE TABLE dst_ing AS SELECT FROM src_vw WITH STRUCTURE = HEAP
Note: You must be licensed to use HEAP tables in X100.
Last modified date: 01/30/2023