DSXchange

No, I did not get prompted for anything when I login manually through the script. It is clean login. And the ssh command that I execute is a pretty simple command that executes fine even if I take that out from the script and execute hat directly through my script. ssh user@host "ls -l" >>...

Yes, I am using the same user to run the script manually and I have setup the passwordless authentication for the same user. I am using the same user when running the Jobs.

Hello Friends, Our DataStage installation is on Windows 2008 Server R2 and our version is the IIS v9.1.2.0. Now I have developed some SSH scripts to remotely execute netezza scripts on the Linux Netezza Server since NZSQL tool does not have a Windows equivalent. The Shell script that is using the SS...

Hello Friends, I am trying to load data from a sequential file after some data type conversions into a Netezza Table. The DataStage version is 9 and Netezza Version is 7.0.4. Some of the smaller files are quickly loaded using the Netezza Connector Stage: Options: Table Action: Truncate and Write Mod...

Thanks Ray & Ernie.

Friends- I am facing a problem on how to invoke a RESTful Web Service from DataStage Parallel canvas. I have done the following analysis on this already, and I believe there are two ways: Option #1: Get a WSDL (v2.0) for the RESTful Web Service since WADL or XSD is not supported in DataStage Web Ser...

Yes Robert - You are absolutely correct. Once I created the IADB DSN using the 32 bit ODBC Administrator I could see it was loaded in the Analysis Database ODBC DSN dropdown. However since I had installed the 64 bit InfoSphere Information Server suite, I fail to understand why the application is exp...

Hello Friends- I am trying to configure the Console Tool for Information Analyzer. The IADB is on DB2 v10.1 and I have created a System DSN with the driver: IBM DB2 ODBC DRIVER which was installed while installing the InfoSphere Suite v9.1. Now when I login into Console and go to Configuration -> An...

Thanks, I thought so. However what is the reason: Does DataStage source dsenv file while starting a Job? And The server here is running multiple projects with different configuration files. When I run the orchadmin command, I believe DataStage opens a shell and runs the command. How is the configura...

As per my belief:

When we run orchadmin through datastage:
(i) We do not need to source dsenv because datastage already does that
(ii) We do not need to export APT_CONFIG_FILE

However I would like to know the reasons behind these?

Without doing this it is causing a reply=127 (Command not found) error. So, if I am calling orchadmin from DataStage (using Execute command activity stage) then explicitly setting APT_CONFIG_FILE is not needed. Since the command will be executed in UNIX how will the UNIX know which configuration fil...

Hi Friends, In our environment, we have multiple projects with their own configuration files. I need to delete datasets using orchadmin command in the execute command activity. The datastage admin has advised me to include the following statements: (i) Source the dsenv file (ii) Export APT_CONFIG_FI...

All, Please reply Hello ALL, We are currently using Datastage server edition 7.5. We currently use the Siebel pack to connect to siebel 7.5 . We use the siebel plug ins and connect to their business component using the siebel object manager, siebel gateway server, siebel enterprise server. siebel in...

THANKS TO RAY the reason i was told is, the siebel's functionality for audit trail has changed . this is for the call center module of siebel crm. now they are going to keep a encoded data set of all audit trail and decode it while processing. but they have managed to keep their own presentation lay...

Hello ALL, We are currently using Datastage server edition 7.5. We currently use the Siebel pack to connect to siebel 7.5 . We use the siebel plug ins and connect to their business component using the siebel object manager, siebel gateway server, siebel enterprise server. siebel in here is now upgra...