Return
-
Title
Incorrect scripts created for views with Netezza/ODBC connection. -
Description
TDA cannot regenerate the view definition when connected to Netezza. Right clicks on the view in the Explorer | Generate SQL | To Editor | Creation Script generates incorrect scripts.
>>>Expected script to create viewCREATE VIEW VW_TEST AS
SELECT a.*
, CASE WHEN b.some_status = 'Completed' and REVENUE > 0 then 'Y'
WHEN b.some_status <> 'Completed' and CUSTOM > 0 then 'Y'
ELSE 'N'
END IS_VALID_REVENUE
FROM DEAL_FEES a join HIST_DEAL_STATUS b on
a.status_dim_id = b.status_id
;
>>>Actual script Toad regenerates (From < table_name> is wrong and there is no definition of IS_VALID_REVENUE).CREATE VIEW VW_TEST AS
SELECT INTERVAL, INTERVAL_ID,….., IS_VALID_REVENUE FROM <table_name>;
-
Resolution
WORKAROUND:
none
STATUS:
Waiting for fix in a future version of Toad for Data Analysts.
-
Defect ID
ST80162