Aginity Workbench is an interface used for working with IBM Netezza database. For cloud data warehouse, IBM has launched dashDB for which we use the Aginity for DashDB workbench.
Queries we use in both Aginity and Aginity for DashDb are very similar with a few differences. In this blog, I would like to share the differences in query between DashDB and Netezza.
In Select Clauses
| CsWebServiceConfiguration Parameter | Description |
|---|---|
| ShowJoinUsingLegacyClientLink | If set to True, users joining a meeting by using a client application other than Lync will be given the opportunity to join the meeting. The default value is False. |
| ShowAlternateJoinOptionsExpanded | When set to True, alternate options for joining an online conference will automatically be expanded and shown to users. When set to False (the default value), these options will be available, but the user will have to display the list of options for themselves. |
Stored Procedure
Below are the differences between creation and execution using a stored procedure.
| CsWebServiceConfiguration Parameter | Description |
|---|---|
| ShowJoinUsingLegacyClientLink | If set to True, users joining a meeting by using a client application other than Lync will be given the opportunity to join the meeting. The default value is False. |
| ShowAlternateJoinOptionsExpanded | When set to True, alternate options for joining an online conference will automatically be expanded and shown to users. When set to False (the default value), these options will be available, but the user will have to display the list of options for themselves. |
Note: In dashDB, there is a global variable SQL_COMPAT. By setting it to ‘NPS’ we can compile Netezza statements (NZPLSQL statements) when the create Procedure statement is invoked. In some cases, the compilation of NZPLSQL statements is not possible.
Useful blog. Thank you!