List of Contributions

Mr. John Skier

IBM

Contact Details

IBM

My Content

1 to 12 of 12 total

RE: GROUP_CONCAT() - ERROR: String returned from Lua is larger than state value definition!

Posted By John Skier Fri July 15, 2022 03:58 PM
Found In Egroup: Netezza Performance Server \ view thread
NPS Max size for CHAR, VARCAHR is 64000 bytes, NCHAR, NVARCHAR is 16,000 these are hard limits. LUA's limit is greater, so Lua should not be the limiting factor. If your not using varchar(ANY) you may want to consider changing your code. ------------------------------ John Skier Integration Architect ...

RE: NPS v11 emulator

Posted By John Skier Mon March 07, 2022 05:47 PM
Found In Egroup: Netezza Performance Server \ view thread
Now Available: Netezza Performance Server Developer Edition v11.2.2.1 this week. For those who don't know about developer edition, its a standalone prototype of IBM NPS on VirtualBox platform. For download refer: https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-im-ibmndn ------ ...

RE: MinIO support in CP4D 2.0

Posted By John Skier Fri February 25, 2022 11:37 AM
Found In Egroup: Netezza Performance Server \ view thread
Turns our we released Netezza Performance Server Developer Edition v11.2.2.1 this week. For those who don't know about developer edition, its a standalone prototype of IBM NPS on VirtualBox platform. For download refer: https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-im-ibmndn ...

RE: MinIO support in CP4D 2.0

Posted By John Skier Fri February 25, 2022 10:42 AM
Found In Egroup: Netezza Performance Server \ view thread
Great question. I'll need to check on emulator update plans. I'll get back to you. ------------------------------ John Skier Integration Architect IBM 682 220 6587 ------------------------------

RE: MinIO support in CP4D 2.0

Posted By John Skier Wed February 23, 2022 10:49 AM
Found In Egroup: Netezza Performance Server \ view thread
Adam Your on release 11.2.1.4 and the support note is for 11.2.2.0 . If you upgrade to 11.2.2 you'll likely see MiniIO listed as supported. If your using the 7.2 clients to connect to the 11.2 server you'll need to upgrade your 7.2 clients to the 11.2 client driver before upgrading to 11.2.2 to avoid ...

RE: Support Netezza Performance Server with FOURJS Genero

Posted By John Skier Tue January 11, 2022 02:35 PM
Found In Egroup: Netezza Performance Server \ view thread
Adam, Thank you for posting the process you used to convert the VBox image to VMWare. People who use VMWare will likely find this useful. While I'm confident the NPS engine will work as expected for SQL Clients and it will likely work for development of user defined functionality. However, if ...

RE: NPS v11 emulator

Posted By John Skier Fri January 07, 2022 12:29 PM
Found In Egroup: Netezza Performance Server \ view thread
A number of folks have said they could get the emulator but not the clients. Here is a link to the client kits that does not require a license. https://www.ibm.com/support/fixcentral/swg/selectFixes?product=ibm%2FWebSphere%2FIBM+Cloud+Private+for+Data+System&release=NPS_11.2&platform=All&function=fi ...

RE: Support Netezza Performance Server with FOURJS Genero

Posted By John Skier Tue January 04, 2022 12:41 PM
Found In Egroup: Netezza Performance Server \ view thread
There is no plan to provide the emulator natively under VMWare. You can obtain the emulator here using an IBMID which is free if you don't have one. The Emulator is packaged for use on Mac, Windows and there are instructions for installing the emulator on virtual box as well. You may be able to use the ...

RE: Support Netezza Performance Server with FOURJS Genero

Posted By John Skier Wed January 13, 2021 12:20 PM
Found In Egroup: Netezza Performance Server \ view thread
It appears there is a lot of demand. I'd like to better understand your needs, use case. We have a number of solutions .. please email me jskier@us.ibm.com ------------------------------ John Skier Integration Architect IBM 682 220 6587 ------------------------------

RE: SQL Extensions Toolkit - installation and access

Posted By John Skier Thu July 02, 2020 05:00 PM
Found In Egroup: Netezza Performance Server \ view thread
The SQLToolkit isn't a product per se. It was built to fill in gaps in the Netezza offering by a Netezza partner and picked up by Netezza to ensure support for the customer base. If new functions are built by the user community they could become part of the toolkit. New functions developed by IBM will ...

RE: SQL Extensions Toolkit - installation and access

Posted By John Skier Thu July 02, 2020 10:49 AM
Found In Egroup: Netezza Performance Server \ view thread
Chris, What features are you looking for? I urge you and everyone else in the community to look at, vote on, comment on, and add feature request in the AHA portal. This is used to prioritized enhancements. There are AHA enhancement pages for most IBM offerings. In today's container world it's possible ...

RE: SQL Extensions Toolkit - installation and access

Posted By John Skier Thu July 02, 2020 09:58 AM
Found In Egroup: Netezza Performance Server \ view thread
It's best to install the toolkit in a single location because it makes debugging and updating easier. While it's likely best to use fully qualified references to toolkit functions it's a fair amount of typing, so an alternative is to set the PATH session variable to include the toolkit location. The ...