Netezza database question

[mjcotter]

I'm hoping someone here can help. Doesn't seem to be much info on the web on Netezza... We have a Netezza box and have imported some of our database tables into the Netezza database. Our DBA claims that the Netezza database cannot handle uppercase table names and columns. It needs them in lowercase for whatever reason. Does anyone know if this is a true statement??? I need them to be in uppercase b/c we are using the Cognos suite for reporting and everything has already been created on that end, looking for uppercase.

Thanks!

 

[mrdenny]

Without knowwing more about Netezza I can't say for sure. But I can tell you that some database servers are picky about that. For example Oracle has all object names in upper case. With the correct collation set SQL Server is also case sensitive.

So it may be entirly possible. Ask your DBA if he has a book you can borrow to learn more about the system.

Denny

--Anything is possible. All it takes is a little research. (Me)