DSXchange

Theere is no unique issues here as I am able to execute the build index statements successfully after the load is complete. After talking to IBM they suggested that this could be because of oracle client incompatibility for direct path load. And since orchoracle.o is already pre-linked to point to 1...

Why do you say that? In any case went for the work around. Got rid of the enterprise stage, developed a ksh script to do the load from dataset. It is working. But, it should work the way you suggested. the problem is I guess AIX, the way it loads and caches the library is not helping in this case. T...

Thanks Chutlet. I've AIX running 8.1 Fx pack 1. I tried setting LIBPATH and PATH to point to oracle 9i client. Before running the direct path load I defined the following export APT_ORACLE_LOAD_OPTIONS='OPTIONS(DIRECT=TRUE, PARALLEL=FALSE, SKIP_INDEX_MAINTENANCE=TRUE,SILENT=FEEDBACK)' Added the foll...

I've oracle 10g client installed on the datastage server. The necessary oracle orch libraries are linked to it. I 've some 9i databases for which I need to run jobs that does direct path load. With 10g client I am unable to do this. I installed the 9i client in a separate location. Is there a way I ...

Did you get this resolved. I am getting the same error. My look up size is really small. So, it should fit in. Just wondering if you managed to get this working.

Note. I am getting this error only 8.1 not in 7.5.x. Same job runs fine.

Thanks
Rati

Thank you guys for suggestions. I found out that I'd not restarted the dsengine after changes to dsenv. I recycled the ds engine and then recreated the projects. Now it is working, I am able to see them in the DS administrator window.

Thanks
Rati

I created projects successfully using the administrator UI. But, only the project that was created during isntallation is showing up in the admin window. When I use dsjob -lprojects from UNIX I see all the projects created, but the GUI (client admin piece) does not list the projects. Am I missing an...

Thank you all the same.

Can you use CFF stage? It should meet your need.

Ray,
I'd like to know more about global cataloging. Does it include both the jobs and routines?

Will appreciate your inputs. To begin with please suggest some reading materials where I can find some more information on this so that I can come back with more precise questions.

thanks
Rati

Thank you Chulett. I am looking dir direct usage if possible, not via shell wrapper. I am thinking in terms a common project which would have the utility routines and the jobs. Any developer working in different projects should be able to reference them (not copy to their project) via some mechanism.

Hi,
Is it possible to call a routine and/or job that reside in project say 'common' from another project s say 'finance' , 'hr' etc.

I'd like to call them from a sequence(preferable) or a stub subroutine.

Thanks
Rati

Join with one input from the file and the other via aggregate stage followed by a filter stage whould work in this case.

In our development project developers have created thousands of table definitions. I think this is affecting the performance when we are trying to store new definitions (in a much more organized way!) Is there any easy way to delete the table definition by providing the name of the definition root? ...

Thanks for your help. I will rather pick a fight with DBAs to change the password.