DSXchange

Thanks Craig for the detailed explaination. I have one small clarification. Since the two stages 8i and 9i cannot be used in a single job, Is there a possibility that we can split the job into where the first job holds oracle8i and the second as 9i and then run the two jobs? Do we still have errors ...

How can we use Oracle 9i and Oracle 8i stages(Since we dont have Oracle 10g stage so I took 8i as an example) in a single job? Since we define the path for the ORACLE_HOME in Administrator, we can define either for 9i or 8i but not both rite?

Please let me know if I am missing some thing here.

I would like to know whether we can use Oracle 9i stage as well as Oracle 10g stage (if present) in the same job?

Hi All, I have a table A containing some amount of data in both Oracle 9i and Oracle 10g database. I have to extract data from both the database 9i and 10g using DataStage. I would like to know whether we need to install plug in for both oracle 9i and Oracle 10g. Also I would like to know whether th...

Hi All,

I am new to mainframes. I would like to know whether we can load Mainframe files into any other file in DataStage. If so, is there any stage to acheive the same?

Thanks,
Shyju.

Hi all,

Can Any help me " How would call an external Java function which are not supported by DataStage? "

Regards
Shyju

Hi All,

Can I have a sequential file whose input is from 3 different sources and the output of the sequential file pointing to a single file ?
For example the input has three different links and the output being a single file

Thanks,
Shyju.

Hi kcbland, Please correct me if i understood wrongly. The $ORACLE_HOME/network/admin/tnsnames.ora contains many database connections irrespective of which DS project we are using. The question is how will the jobs in a particula DS project understand to what Database it is connected to even by usin...

Hi All,

Can we connect two different oracle databases to a particular DataStage project at a time? If so then how can this be acheived?

Thanks,
Shyju.

Thanks andal... The information was very useful. I got the list of hash and sequential files by running the sqls in administrator in a single line.

Hi All,

I would like to know whether there is any command or any other way to know the list of hash files and sequential files (at a strech) and also in which job they are created in a particular project?

Thanks,
Shyju.

When u say sequential file as two objects, I assume that u meant the input pipe in one seq file and output pipe in another seq file. Even then I face the same problem...

I dont think so thats the problem ArndW. Because I find this kind of error when I run the job for the first time itself. Unless or untill i dont cat the file and say ctr+z, the job keeps aborting. Is it necessary that we have to open the named pipe before it read/writes?

Arndw, I have already mentioned what ever u have suggested. But I found something interesting with way the job was behaving. Initially i ran the job. The job got aborted with the error that i have mentioned. I gave the command cat <pipename> in unix machine. It hanged so i said ctrl+z. I again ran t...

I deleted the temporary sequential file and used the mkfifo command to create a named pipe also. But still it shows the following error:

"namedpipe..Sequential_File_3.DSLink10: ds_seqopen() - error in 'open()' - Interrupted system call "