× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Ashwini Chavan
ashwini.chavan reported 2014-02-25T11:26:04Z  · tariqrahiman last modified 2014-03-05T20:45:54Z

"time without time zone" and "timestamp without time zone" datatypes are gray out in Table Properties window for Aster 6.0


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 14.0
Aqua Data Studio 14.0.8 
Build #: 35460 
Built on: 2014-Jan-09 08:51:14 AM
Database-Teradata Aster
 
1.In ADS,connect to Teradata Aster then expand it
  Go to Databases object folder,expand it
  Select desired database("beehive"),expand it
  Go to public schema,expand it
  Go to Tables tree node,Open Query Analyzer using shortcut key(Ctrl+Q)
  In Query Analyzer execute the following query
  CREATE TABLE "public"."Table_1"  ( 
  "c1" time NULL,
  "c2" timestamp NULL 
  )
  DISTRIBUTE BY REPLICATION
  STORAGE ROW
  after creating table "time" and "timestamp" datatype cast to 
  "time without time zone" and "timestamp without time zone" datatypes respectively
  
2.Go to public schema,expand it
  Go to Tables tree node,right click then go to Tool->ER Diagram Generator option
  ER Diagram Generator window get opened
  In ER Diagram Generator window,check Tables object type
  Check "Table_1" under Objects pane and unchecked all remaining tables check boxes
  Click on Next  button
  ER diagram is generated for selected table
 
3.In ER diagram double click on Table_1 entity which is display in sheet
  Table properties window get opened
  In Table properties window we can see "time without time zone" and  "timestamp without time zone" datatypes are gray out
1 attachment
  •  
  •  
  • No shares
  •  
All Comments (4) Change History
Sort 

Issue #11770
Closed
Fixed
Resolved 2014-02-28T15:54:31Z
 
 
Completion
No due date
Fixed Build v14.0.8-22
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017