DSXchange

thanks Ray
Where can i find pre sql option in oracle enterprise stage for truncating existing records and then insert new records

hi i have a requirement such that we need to delete existing data on oracle database table and load new data for each job run. what is the best approach where we can do delete and insert operations in the same job flow? i didn't find any of the write options in oracle enterprise stage where we can d...

hi, i have import all the job designs from Dev to Test environment. i compiled all the jobs in test environment. when i try to run the job, it is giving an error- Before job routine is not working.. error as follows CVPayTerms..BeforeJob (ExecSH): Error when executing command: /apps/Ascential/Projec...

i am using DataStage v 7.5.1a.
i have another doubt that using $Projdef, can we define any number of user defined env variables ?
how could we define the below user defined env variables having default values using $Projdef?
$Par_SrcFilePath
$Par_TrgFilePath
$Par_remoteUserID
$SRC_DBNAME

Hi, i have read some posts regarding $Projdef project specific env variable. i am not still understanding the use of $Projdef env variable. how to use exactly this variable ? i have created some env variables at dsadmin like $Par_SrcFilePath $Par_TrgFilePath $Par_remoteUserID $SRC_DBNAME etc where s...

In log file also it is the same error "Invalid Username/Password; logon denied" but it working if select writemode as upsert option with same username and password and i have checked table priveleges and all are fine. what could be the reason, is there anything that i need to take care at ...

Hi, i wanted the exact parallel function to format a value. eg:- i need to generate a 6 digit number like FMT(@OUTROWNUM,"6''0'R") "000001" "000002" FMT does not work on parallel transformer and i should not use Basic transformer here for this formatting. is there any p...

Hi, i am loading the data from source sequential file to oracle database with oracle enterprise stage with Target properties Write Method = Load and Writ Mode = Append. When i try to insert the data it is giving error ORCL_REQ_HEADER,0: SQL*Loader-128: unable to begin a session ORCL_REQ_HEADER,0: OR...

jasper,
here hashfile is disabled in palette if you parallel job.
and also i am extracting data from source database table, so how do we need to pass that parameter in a query?
can you explain more on this

Sure roy why not... I have selected env variable $APT_DISABLE_COMBINATION operator and set to True(meaning that " it prevents operators from being combined into the process") in job parameters tab then i ran the job. In log file , it's clearly given the warning message pointed at transform...

i have extracted MAX(LAST_EXT_ID) from first job and how to pass that value as a parameter to the second job's query where i need to do filter condition like this SELECT A.INDATE,A.PRJNAME,B.SRID FROM PRIME.PROJECT A, PRIME.SECTION B, A.PRJID = B.SRID AND A.PRID > #PARAMETER# can anybody help me out...

thanks all of you for your information. but i could not find exact parallel function for 1) Ereplace. Convert funtion is there, but it is not exactly matching my requirement. eg:- field = "4778 "J" STREET SW" should be formatted to "4778 ""J"" STREET SW&q...

Thanks a lot roy
job is perfectly working without losing any source data...

Hi, i am getting the following error APT_CombinedOperatorController,0: Field 'REGN_I' from input dataset '0' is NULL. Record dropped. source is DB2 and field REGN_I data type is varchar, it contains Null values. source is extracting the data correctly, but at the time of transformation , it is trunc...

hi jasper,
your said logic seems to good and i have doubt that how to pass parameter from one to another job.
can you explain me breifly