Posted
by san6086
on Stack Overflow
See other posts from Stack Overflow
or by san6086
Published on 2010-06-11T09:33:43Z
Indexed on
2010/06/11
16:23 UTC
Read the original article
Hit count: 226
Hi .. currently i use db visualiser for connecting the netezza database. can you suggest any otehr alternative (freeware) for the same.
© Stack Overflow or respective owner
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option.
In this case we do not require an existing backup, the active datafiles will be used as the source for the clone.
In order to clone with the source database…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I'm using cPickle to save my Database into file. The code looks like that:
def Save_DataBase():
import cPickle
from scipy import *
from numpy import *
a=Results.VersionName
#filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently.
Here is a quick definition of the subject from Book On Line:
A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Database ??
Database ???????
Database ??????????
Java
WebLogic Server/????????·????
SOA/BPM/?????
???????/????
ID??/??????
?????EPM/BI
EPM/BI ???????
EPM/BI ????
OS/???
????
?????
MySQL
Database ??
????
??
?????????
???
??
ORACLE MASTER…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
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.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
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
?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
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
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi .. currently i use db visualiser for connecting the netezza database. can you suggest any otehr alternative (freeware) for the same.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am executing a shell script to execute my user defined aggregate which is taking inputs yavg=nzsql -c 'select avg(x) from Input1' which is giving output like this
AVG ---------- 2.000000 (1 row)
I want to pass only the numeric(double) value which is 2.0000(where xavg is expected) from this to…
>>> More
