[progress Communities] [progress Openedge Abl] Return The Datatype Instead Of An Alias For...

  • Thread starter Thread starter Tim Kirwan
  • Start date Start date
Status
Not open for further replies.
T

Tim Kirwan

Guest
- What is being requested: Return the datatype instead of an alias for metadata calls with the Redshift JDBC driver - Reason for request: As an example Connect for JDBC Redshift driver returns column type as CHARACTER VARYING even though the column was defined as VARCHAR while creating the table Eg : create table category( catid smallint not null distkey sortkey, catgroup varchar(10), catname varchar(10), catdesc varchar(50)); getColumns() returns TYPE_NAME as CHARACTER VARYING for catgroup,catname and catdesc columns Expected Product Behavior: Always return Data type instead of Alias Per the customer, Other open source tool (such as SQL Workbench, recommended by Amazon) does this successfully, returning VARCHAR, not the alias. The request is for this behavior to apply to all types where there is an alias, not just to VARCHAR. - Possible workarounds: No workarounds.

Continue reading...
 
Status
Not open for further replies.
Back
Top