Netezza Performance Server

View Only

Quick Links

Featured Articles

NEW! Check out the latest from Netezza Performance Server as-a-Service:

Announcements

RE: to_number template - Way to Set All '9's'?

By: David Briars , 3 days ago

Thank you Mark and Kiran. Exactly what I needed. -Dave ------------------------------ David Briars ------------------------------
RE: to_number template - Way to Set All '9's'?

By: Kiran Kumar Gahlot , 9 days ago

Does following solve your problem? SYSTEM.ADMIN(ADMIN)=> create table testtbl(a1 int, a2 varchar(10)); CREATE TABLE SYSTEM.ADMIN(ADMIN)=> insert into testtbl values(1, '1234567890'); INSERT 0 1 SYSTEM.ADMIN(ADMIN)=> select to_number(a2, repeat('9', length(a2))) ...

1 person likes this.
RE: to_number template - Way to Set All '9's'?

By: Kiran Kumar Gahlot , 9 days ago

Does following solve your issue. create table testtbl(a1 int, a2 varchar(10)); insert into testtbl values(1, '1234567890'); select to_number(a2, repeat('9', length(a2))) from testtbl; TO_NUMBER ------------ 1234567890 (1 row) ------------------------------ ...

Share your insights, get rewarded!

By: Mihaela Nedelescu 12 days ago

Write a review of your experience with IBM Netezza Performance Server , and you will receive a $25 gift card via email as our thank you when your G2 review is published. Help other professionals like you to pick the right solution based on real user ...
Netezza Ground-to-cloud Migration with nzbackup/nzrestore

By: Ashley Bassman 13 days ago

Netezza Performance Server is a purpose-built, standards-based, data and AI system that integrates database, server, storage, and advanced analytic capabilities into a single, easy-to-manage system. Take advantage of the new Netezza Performance Server ...
Announcement: Superset now supports IBM Netezza Performance Server

By: Abhishek Jog 10 months ago

What is Superset Apache Superset is a widely popular, opensource, web-based business intelligence application. It is known to be very fast, light weight and an easy to use application. It is very intuitive and loaded with configurable features that ...
Why we NEED workload management for Cloud Data warehouse products?

By: Pawan Powar 11 months ago

Scaling Cloud only database’s focus is to let you run your workloads irrespective of resource limitations. A n d this focus translated into Scaling the data warehouse by different means scale up, scale out… A common use case advocated to exemplify scaling ...