DSXchange

Hi, I am facing a new fatal error. Error accessing Parallel engine; possible bad value for environment variable 'APT_ORCHHOME', or machine permission / resource problem accessing '/opt/Ascential/DataStage/PXEngine/bin/osh'. Please tell me what needs to be done. Also where can I find all these config...

Hi , I have a requirement where I need to trim any numeric occurence in a string. For eg: "abc2def6rg" should be made :"abcdefrg" The length of numeric string at any occurence is variant. I thought Ereplace function wud help,but for this requirement it is not of much use. Thanx,

If u r sorting the records using the Sort stage,use the cluster key change feature to remove duplicates.
This works on the same logic as the StgVariables.

Hi,
If u r using OCI load stage ,on the Properties page in the Date format try using this format :YYYY-MM-DD.
Just chg those formats and try.

Hi, Sorry, due to an internal error my message got posted before completion. My application has the following input: COLUMNA COLUMNB 1 1 2 2 3 3 Then Output needs to be produced like: COLUMNA COLUMNB 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 3 3 I have used an Inner Join in the Join Stage where I get an outpu...

Hi,

My application needs an output of this kinf.

COLUMNA COLUMNB
1
2

Hi all, I have a complicated job where I look up on 7 tables and the match criteria for all is a Theater_Nr. The job after being compiled shows this fatal error :Fatal Error: Added field has duplicate identifier(): THEATER_NR [api/schema/schema.C:418] I have checked for all possibilities I can think...

Hi all, I am new to datastage. The current problem I am facing is that my query executes and gives the desired output when use PL/SQL developer. But when I paste the Same SQL in the SQL Query section In the Oracle Enterprise section,I get an output with the columns having NULL value. Is it something...