query data from netezza

[kavuri]

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

[kumar_s]

What is your job design? Does the Netezza stage has only one output link and nothing else?

[ray.wurlod]

In particular what stage type are you using?

[ray.wurlod]

In particular what stage type are you using?

[kavuri]

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

[ray.wurlod]

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.

[kavuri]

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

[Aruna Gutti]

You need to set two different ODBC connections for two Netezza Boxes. Define two different DSN in odbc.ini file with connection information. That is how we are connecting to two Netezza Boxes.