DSXchange

Hello Niremy

Thanks allot for the information ... any advise on the options we have for managing the password used to logon to the remote server ?

Hello

could you please share the details of how you used the ssh connection to invoke the datastage job on the remote server.

Thanking you in advance.

Thanks all for your suggestions..

we want to copy the dataset from one server to another..

Is there a way to use orchadmin or other unix utility to ftp a dataset from one server to another? If so, what is the command?

Hi, We are using DB2 API stage in our 8.0.1 jobs. One day, the stage property(GUI)started looking a little different and it slows down work for us. It started looking something similar to a folder stage property tab. The original GUI is restored when this job is exported and imported to a new projec...

Try using this :

Dt_of_extrcn:date = date_from_string(Dt_of_extrcn)

Make sure the input data type is of Varchar and output data type is Date for this column .

Thanks for your reply.

Our Datastage is 32 bit, so in the LIBPATH we have put ${ORACLE_HOME}/lib32 before ${ORACLE_HOME}/lib, but still getting the same error.

anthing more needs to be configured, to import table definations using Import->Plug-in metadata option?

use the command orchadmin rm <datasetname>

I am also getting the same error message while trying to import table definations through Import->Table Definations->Plug-in Meta Data definations. But we are able to import table definations through Import->Table Definations->ODBC Table Definations. I searched the forum for this error message but I...

We are using Datastage version 7.5.1.

I had an idea that custom stages can be registered/unregistered, can Datastage default stages also be registered/unregistered?

Thanks for your answer.

We have tried with Oracle OCI stage and getting the same error.

Any solution to fix this?

I am also getting the same error.
Is there any way to resolve it?

Thanks for your reply.

We are using ORAOCI8 stage to connect to Oracle..

I am trying to run a job that takes Oracle Stage, a sequential file stage and a transformer in between. When I run the job, I get the following error message:

"...Sequential_File_1.IDENT1: C Stage PlugIn function "Get" required.."

What can be the possible cause for this error?