Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.
Closed 4 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(4)
当然,您可以在 Netezza 中编写程序。 Netezza 的 SQL (NZSQL) 最初基于 PostgreSQL (http://www.enzeecommunity.com/message/ 1400)。它具有用户定义的函数和过程(http:// /www.enzeecommunity.com/servlet/JiveServlet/previewBody/1161-102-1-1107/Netezza_database_users_guide.pdf)。
Netezza 的 Aginity Workbench 是编写存储过程的好方法 (http://www.aginity.com/workbench/ )。免责声明 - 我为 Aginity 工作。
Sure you can write procedures in Netezza. Netezza's flavor of SQL (NZSQL) was originally based on PostgreSQL (http://www.enzeecommunity.com/message/1400). It has user defined functions and procedures (http://www.enzeecommunity.com/servlet/JiveServlet/previewBody/1161-102-1-1107/Netezza_database_users_guide.pdf).
The Aginity Workbench for Netezza is a great way to author stored procedures (http://www.aginity.com/workbench/). Disclaimer - I work for Aginity.
查看免费的 Aginity 工作台工具。它是专门为 Netezza 和 Netezza 编写的。支持存储过程维护。网址为:http://www.aginity.com/workbench/
Check out the free Aginity workbench tool. It's written specifically for Netezza & supports stored proc maintenance. URL is: http://www.aginity.com/workbench/
是的,您可以使用nzplsql语言来编写程序。
如果您使用的是 Windows,请安装 Netezza Windows 客户端,您将在开始菜单中找到“Stored procedure Guide.pdf”。
如果您想查看一些过程示例,我为 Netezza 编写了一组使用存储过程实现的开源实用程序。
您可以在此处查看 nz-util 文档: http://g14n.info/nz-util 。还应该有一个 GitHub 存储库的链接,您可以在其中查看源代码。
Yes, you can use nzplsql language to write procedures.
If you are on Windows, install the Netezza Windows Client and you will find a "Stored Procedure Guide.pdf" in your start menu.
If you want to see some examples of procedures, I wrote an open source set of utilities for Netezza that is implemented with stored procedures.
You can see the nz-util documentation here: http://g14n.info/nz-util . There should be also a link to the GitHub repo where you can see sources.
如果您想编写具有多个 dml 操作的存储过程,请参阅 http: //www.dataplatformexperts.com/writing-stored-procedure-in-netezza/
if you want to write stored procedure with multiple dml operation then refer to article at http://www.dataplatformexperts.com/writing-stored-procedure-in-netezza/