DSXchange

BMSK wrote:Hi,

Thank you all,,

when I use the function Getenvironment('$Enttest')

My probelm was solved

thanks nikhilanshuman


BMSK.

Welcome!!

The error lies with this line : 0011: ustring $Enttest Are you using any Env variable "$Enttest" in a transformer? This is the cause of the error. Solution : use GetEnvironment ('$Enttest') in your transformer stage The error lines from your post : ##E IIS-DSEE-TFTK-00001 18:15:35(003) <tr...

Hi, I am getting the below warning message for every job that i execute in parallel, please help me in fixing it. main_program: Warning: the value of the PWD environment variable (/opt/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/opt/Ascential/Da...

Mod function returns "Remainder" of a division which can never be decimal.

do you have write privileges on the database?

You will have to add a dummy attribute to the tag <ServiceCh> The tag will look like then... <ServiceCh dummy=1> After this,the element will be repeated. In the transformer,add a column Dummy and set its value to 1. Now declare the XPATH for the attribute dummy. Attribute can be declared in XPATH by...

check this topic...

viewtopic.php?t=128039&highlight=current+date

I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht..... I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available? Moreover don't i ...

Ok.Then have you selected the property "Remote Server" under "connection" in your OCI stage ?By default,this property does not appear.And because of this the error "TNS could not resolve" ...appears

please check...

Have you made the correct settings in tnsnames.ora file on your datastage server?in tnsnames.ora file,there should be entry for your oracle server.

Sparse Lookup : This method is preferred when the rato from source data and reference data is 1:1000.I mean when the source records are very less than the reference records,the Sparce lookup is used.In this way of lookup,for each source record,a query is fired to get the reference data. Normal Looku...

In routines,the variables do not contain $ symbol. Try this : *Check if the variable JobName value is getting printed properly INCLUDE DSINCLUDE JOBCONTROL.H JobName = "YouJobName" *Check if the variable JobName value is getting printed properly Call DSLogInfo("The Job Name is":J...

We know this error but we wanted to know why it is coming and to get rid of this error. We want to perform truncate and load option in orcale stage. Try executing truncate from Sqlplus/Rapidsql.If there also same error is coming then contact your dba and get the session killed. DBA would be able to...

check this link...

http://www.shutdownabort.com/errors/ORA-00054.php

Arun, This can be used using two transformer stages. From the first transformer stage take two output link say Err_out and Clean_Out For the link Err_Out,put the conditions in the constraints for checking null values. e.g. ISNULL(Link_Name.Column_Name) or ISNULL(Link_Name.Column_Name) The output Err...