DSXchange

Administrative rights with full access to everything including (Registry key in the registry)

Hi All,

In one of the parallel job uses Before job subroutine and we are getting the below error in project A.
Job stopped - before-job routine returned error: Cataloged routine DSU.ExecSH - unable to open object DSU_BP.O/DSU.ExecSH

the same job when executed in project B,completes Successfully.

Hi there,

What are the Tasks need to be performed for maintaining the datastage11.5 on Linux system. Like cleanup , disk space etc.and what files can be cleaned up for good performance overall.

Thanks in Advance

please let me know where to check these parameters..

Hi , Im facing below error while reading xslx file from Unstructured stage. Excel file is having around 2 lakh record.For less records,job works fine. Below is error. : JVMDUMP039I Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" JVMDUMP032I JVM requested Sys...

Hi all, I have a comma delimited file for which i had defined the schema file .But for one of the column i am getting comma in the value for one of the file.How should i define this property in schema file. question 2 I wanted to know if we can mention "First Line is Column Names=FALSE/TRUE&quo...

Hi ,

could any body confirm please whether we can use first name column property in schema file definition....

Thanks in advance

How was the metadata imported

Here is the value i passed for my first multi-instance run and complted sucessfully--- drop A_DUMMY;drop B_DUMMY; IC_ID : string [16] = IC_ID

In second multi-instance run, i not passing any thing to parameter as there are no transformation required.Pls suggest..

Hi sir,

It's a job parameter where iam using for dropping columms and changing datatypes.For one of the run, i have my source metadata &target metadata with same layout which doesn't require that job paramater in modify stage.How to proceed in that scenario...

Hi All, I had parmeterized the modify stage specification to make my multi-instance job generic and reusable.In one of the execution, the job does not require the paramater. In that case i didn't pass anything to job parameter,It aborts.Could any body help what to pass in specification parameter if ...

you need to write logic using stage variables.

first keep a flag for new and repeated values of emid and slao take counter in another stage var.
in third stage varible based upon the flag of 1 stage varoiable coancate the salmnt &sal.

then sort and rove dups..

What is the exam code for DataStage administration.
where can we find it

Hi,

It's mentioned in help to use longnvarchar,but still the job get aborted.

Ray,Thanks for your reply. But when we remove CLOB datatype column,the job works fine without errors . we had tried with other option too.In oracle connector stage properties ,we had given the LOB preference and mentioned the CLOB column name .this time we get the below error log as The OCI function...