netezza

Netezza SQL syntax to convert numeric YYYYMMDD format into date

We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731). What is the best Netezza syntax to use to convert this into date format? eg SELECT somefunction(20090731) as NZDATE ? ...

SSAS data sourcing with Netezza

We were extracting data out of Netezza into txt files, loading into SQL Server and processing our SSAS cube(s) from there. We want to change that and load the cube directly from Netezza. What are the things to keep in mind for this? ...

Netezza, Teradata, DB2 Parallel/Enterprise, ... versus Hadoop or others?

I'm looking at building some data warehousing/querying infrastructure, right now on top of Map/Reduce solutions like Hadoop. However, it strikes me that all the M/R work is just repeating what the RDBMS guys have solved for the last 20 years with parallel SQL databases. Parallel SQL implementations scale reads and writes across nodes, j...

Multiple-step OLE DB operation generated errors

I am running a simple FillSchema from a Netezza data source dss = new DataSet(); ad = new OleDbDataAdapter(cmd); ad.SelectCommand = new OleDbCommand("SELECT * FROM " + objTable.name); ad.SelectCommand.Connection = cn; ad.FillSchema(dss, SchemaType.Source); I get the following error: System.Data.OleDb.OleDbException: Multiple-step OLE...

LINQ to NETEZZA

Does anyone know if it is possible to use LINQ to query a NETEZZA back-end? Update: I've tried both the ODBC and OLEDB Netezza drivers, but neither work. Both give a "The selected object(s) use an unsupported data source" error. ...

What's netezza's "rownum" equivalent? Or how do you take a "head" of a netezza table in netezza sql?

I want to run a basic query, but return only the first ten rows of the table from Netezza select a.* from some_schema.some_table a where rownum < 10 What is the Netezza way of looking at just those few rows? ...

Data Warehouse: One Database or many?

At my new company, they keep all data associated with the data warehouse, including import, staging, audit, dimension and fact tables, together in the same physical database. I've been a database developer for a number of years now and this consolidation of function and form seems counter to everything I know. It seems to make securi...

Please provide an alternative for DB visualiser for handling netezza database

Hi .. currently i use db visualiser for connecting the netezza database. can you suggest any otehr alternative (freeware) for the same. ...

need an alternative tool for DB visualiser..

Hi, I am having netessa db as the backend for my application.I need to write procedure so as to handle many complex logic but my db visualiser version doesnt support procedures. Please suggest me a tool instead of this db visualiser. A freeware would be preferable. Please suggest ...

Can netezza database handle procedures?

Hi I am having Netezza Database. I am querying the tables through DB visualiser. Since my table creation involves complex, I am interested to use procedures but I am unable to write it in DBvisualiser. I am confused whether the problem is with the tool that I use or in Netezza? Please advice ...

How do i convert date in Netezza to yyyymmdd from timestamp format

How do i convert date in Netezza to yyyymmdd from timestamp format ...

How to create a netezza UDF in C++ for string replace function???

Hi all, I need to know how to write a UDF for String replace function in SQL??? Please help. ...

Can anyone help me write a sql query...

jkdfhdjfhjh&name=ijkjkjkjkjkjk&id=kdjkjkjkjkjkjjjd&class=kdfjjfjdhfjhf The above string has some characters starting with & and ending with = for example we have &name= and I just need this from the above string. similarly I need &id=, &class= I need the output under a single column. Final Extract ---------------------- &id=, &class...

Netezza Sql query

Hi, I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables. Can anyone provide me the query. ...