DSXchange

Hi to all

I am working on server jobs along with that I planned to learn Parallel.
I created simple job reading data from OCI and writing it to OCI.I specified all the required fields in the source OCI but when I tried to view data I got the error as follows

Error executing view data command

##E TOSH 000205 12:15:57(004)<main_program> PATH search
failure:

Please help what other settings I have to do so that I can view the data.

Thanks in advance
Mohanraj

Check for all the parameters for DB name, user id, password. Try to import metadata from Database, it will give you the information on connectivity to the database.

Hi Kumar

Its asking only table name,user and password and I supplied correct values for all the three.

By the way I am working on 7.5x2 version on windows XP

mohan

mohanraj wrote:Hi Kumar

Its asking only table name,user and password and I supplied correct values for all the three.

By the way I am working on 7.5x2 version on windows XP

mohan

Hi Mohan,
apart from User name and Pwd you will also have to specify which server you want to connect,provided u r not having local system server.for this.. click on Connections ...u will get one option called Remote Server.here u will have to Specify ur server name.i think this will do for u???if not plz revert back.

Thanks.

Have you done anything to configure DataStage for the OCI stages? Read the DataStage Plug-In Installation and Configuration Guide pdf for the details. You need an Oracle client installed and configured to stand any chance of them working...

Hi ambasta and chulett

Thanks for your replies,but server is installed locally in my machine and oracle client also.

Thanks
mohan