Questions about netezza
Read more about netezza
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to SET NOCOUNT ON/OFF inside a Netezza stored procedure?
Based on NZ documentation, it seems NZSQL equivalent command NO_ROWCOUNT will suppress row count information. But how do I execute/apply it inside a NZ stored procedure?
I've tried to create and execu...
Megat Shamsul
Votes: 0
Answers: 0
What is the difference when using a case statement or max before the case statement?
I just started as a data analyst and have a question on case statements. Specifically, I have two stored procedures that pull video customers so the company can count current active accounts. I noti...
1Hunter1983
Votes: 0
Answers: 1
Last day of the next month in Netezza
I have a table that brings in monthly customer accounts on the last day of the month. If an account existed in the prior month, but not in the current month, I create add a 'D' for drop to the next mo...
1Hunter1983
Votes: 0
Answers: 1
Netezza to Redshift Conversion - _v_table and _v_relation_columns alternatives
What are the alternatives for the below Netezza Tables and columns that I could use in Redshift?
_v_table (columns used: 'RELVERSION' and 'OBJTYPE')
_v_relation_columns (columns used: 'NAME' and 'AT...
prsng_2022
Votes: 0
Answers: 1