Hi,
Till now I am able to insert some data into Netezza database. Just today I am trying to extract( query) some data from Netezza in DataStage. But I am getting following error.
(40822) The source stage does not support output links.
Please let me know the issue. I am even unable to output link also.
Thanks
Kavuri
query data from netezza
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Extract data from Netezza table
Hi,
I am using Netezza_Enterprise_7 stage.
I want to extract data from a Netezza Table and load into a flat file. I am unable to extract data from table. Even design itself is not permitting.
Thanks
Bhargava
I am using Netezza_Enterprise_7 stage.
I want to extract data from a Netezza Table and load into a flat file. I am unable to extract data from table. Even design itself is not permitting.
Thanks
Bhargava
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Consult the manual for the Netezza stage. Does it describe the stage as being able to read from, or only to write to, Netezza? If it does say you can read, it will also tell you how. Otherwise use an ODBC Enterprise stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray,
I tried ODBC Enterprise stage. Its working. But able to connect to one Netezza box but not to other one ( I mean I am having 2 Netezza boxes or 2 Database servers both Netezza).
Similarly I checked from another Linux server to connect to both the Database servers, but unable to connect. Its not even giving warning messages.
I had posted the errors as a seperate topic.
Thanks
Bhargava
I tried ODBC Enterprise stage. Its working. But able to connect to one Netezza box but not to other one ( I mean I am having 2 Netezza boxes or 2 Database servers both Netezza).
Similarly I checked from another Linux server to connect to both the Database servers, but unable to connect. Its not even giving warning messages.
I had posted the errors as a seperate topic.
Thanks
Bhargava
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston