Product: Aqua Data Studio
Version: 17.0.0-dev-78
Build #: 44704
Build Date: 2015-Jul-13 10:59:39 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=954,728,448; Total=836,763,648; Free=125,847,992; CPUs=8
Database: SAP Hana
Scenario 1:
1.Connect to SAP Hana database.
2.Expand Schemas object folder.
3.Expand your own schema & go to Tables object folder.
4.Right click on Tables object folder & select "Create Table" option.
5.In Create Table window:
-Enter Table name.
-Add one column having Integer datatype.
-Under Column pane for "Identity" option select "Yes".
6.Go to Storage Tab & select "Column" option from drop down list for "Table Type".
7.Go to Preview SQL tab, create table script is displayed.
8.Click on Create.
9.Table is created sucessfully.
10.Right click on created table & select "Table Properties" option.
11.In Properties window for Identity column "No" option is selected but we have applied identity on column.
Scenario 2:
1.Open Query Analyzer & execute following query
CREATE COLUMN TABLE "T_PRODUCT_DETAILS1"
("PID" BIGINT CS_FIXED GENERATED BY DEFAULT AS IDENTITY,
"NAME" VARCHAR(30),
"DESCRIPTION" VARCHAR(40),
"PRICE" INTEGER CS_INT,
PRIMARY KEY ("PID"))
This will create the column table T_PRODUCT_DETAILS1 with an identity column “PID” which by default will start from 1
2.Right click on created table "T_PRODUCT_DETAILS1" & select "Table Properties" option.
3.In Properties window for Identity column "No" option is selected but we have applied identity on "PID" column.
Issue is in extraction and is now fixed. Identity information is stored in 2 different columns in the table_columns catalog view. If not identity specifics is given and only the generate as identity is specified the one column I was using in the extraction is left empty as it has no details specified. Using both columns to extract info now, should no longer experience this issue.