DSXchange

HI,
I have done one projetc where we have read 6 records with 420 columns.
I was able to read the data but it was very slow.

Regds,
Dilip

Hi,
Yes it is possible . Long back I have done it using ORAOCI stage .
write like

Begin
Procedure name
End;

Try in Before or After tab of ORAOCI stage.

Hi, I am trying to execute a job which extract data from oracle and write to Oracle.I am using the following software Datastge -5.2 OS-HP-UX Oracle client-8.1.7 While running the job it is giving the following error. InitLoadCustNodehistorystg1..Tfrmrows: C Stage PlugIn function "Get" requ...

Hi, In .profile we have set the path for oracle 9i and in dsenv file we need to set the LD_LIBRARY_PATH for oracle 8i. We missed out that entry and due to that it didnt work. Now we have updated the dsenv file and we can able to connect Oracle from datastage. We need to give 777 permission to dsenv ...

Hi, I can able to connect to Oracle from the server box I need to conenct to oracle 9i from datastage using oraoci8 stage So i have installed oracle 8i and 9i client in the server Following are the entries in .profile file for oracle ORACLE_BASE=/opt/oracle/product ORACLE_HOME=/opt/oracle/product/9....

Hi,
After updating dsenv file,I have restarted datastge. and When I am trying to import metadata thru import plug in metadata, it is giving the following error
Unable to initialize plug-in:

Dilip

HI, We have installed Datastge 7.0.1.1r4 on SunOS. We are trying to connect to Oracle thru oraoci8 stage.It is giving the following error ds_loadlibrary: error in dlopen of oraoci8.so - ld.so.1: dsapi_slave: fatal: libclntsh.so: open failed: No such file or directory We have installed oracle 8.1.7.0...

I have reimported the jobs and it is working fine.

Thanks
Dilip

Hi, We are having datastage 5 in SUN Solaris OS.When we are running a job we are getting the following error INSInsightCheckIndxAdcChargeCtl..JobControl (fatal error from DSRunJob): Job control fatal error (-99) (DSRunJob) Error writing to RT_STATUS89 We have cleared the status file, restarted the d...

I am trying to reinstall it.

Hi, I have installed datastage 5.2.2 in solaris. When I am starting up the server it is giving the following message ==================== /opt/ascential/DataStage/DSEngine/sample/ds.rc: bin/DBsetup: not found An error has occurred during uniVerse initialization Please contact the system administrato...

Hi,

Send me ur mail id I ll forward u the DSX file for this job

Regds,
Dilip

Thanks,

I have got it using @INROWNUM function.

Regds,
Dilip

Hi,
I am trying to get a sequential number in datastage.For example if I have 100 rows in my source, the couner column should contain 1 to 100.
How to do it in datastage?

Regds,
DD

Hi All,
Thanks for ur reply.Now I can able to run the job without user id and password. But still I am having the same proble if I am trying to run the job with a valid userid/password.

Regds,
Dilip