× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2017-05-26T18:09:57Z  · last modified 2017-05-31T15:03:14Z

Netezza -> extraction of data fails due to casing of string in extraction sql


customer request
Priority Major
Complexity Unknown
Component DB - Netezza
Version 18.0

customer reported issue with extraction of his procedure:

CREATE OR REPLACE PROCEDURE "nulla"() 
  RETURNS INTEGER 
  EXECUTE AS OWNER 
  LANGUAGE NZPLSQL 
  AS 
    BEGIN_PROC 
      BEGIN 
        return(1); 
      END 
    END_PROC
GO

It would appear that the objType string is stored as 'procedure' in customers catalog table.  A non-modified catalog table would store this string as 'PROCEDURE' but the catalog data can be modified.  We need to enhance extraction so that modification to the catalog tables in this way will not affect our extraction.  Data is still case sensitive.

Documentation on how to modify catalog data: link

Issue #15276

Closed
Fixed
Resolved 2017-05-30T21:18:57Z
 
 
Completion
No due date
Fixed Build v19.0.0-alpha-18, v18.0.13-2
No time estimate

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