DSXchange

Hi, I have a requirement in such a way that, i want to extract the data from two different database tables like SELECT A.INDATE,A.PRJNAME,B.SRID FROM PRIME.PROJECT A, PRIME.SECTION B, A.PRJID = B.SRID AND A.PRID > (SELECT MAX(LAST_EXTID) FROM VEND_EXTRACT) ORDER BY 1; Here LAST_EXTID is the column n...

Hi, currently i am using OConv and FMT transforms in Basic Transformer. now i wanted to use normal transformer(parallel) with the same transforms. but it is not allowing OConv and FMT transforms. are there any other transform that suits best for parallel transformer. for eg:- 1) i wanted to convert ...

here i am using the following query to extract the data from oracle9i database through Oracle Enterprise stage ##W TCOS 000049 23:26:35(000) <main_program> Parameter specified but not used in flow: DSProjectMapName ##W TDOR 000062 23:26:39(001) <Oracle_Enterprise_12> Column HOURS floating point deci...

hi, i want to insert date and time in oracle date format and the field datatype is timestamp. for eg:- 8/17/2005 11:35:15 AM can anybody give the exact function in ds. i have tried oconv(iconv(@Date,"DYMD"),"D/MDY[2,2,4]"):" ":oconv(@Time,"MTHS") but i am gett...

I want to generate a sequence number starts from 000000 and increment by 1 for each load. for eg:- if source contains 1000 records for first load, sequence number should start from 000001 and ends at 001000. for second load, if source contains 2000 records, then sequence number should start from 001...

hi, one of oracle 9i table has field indate with datatype timestamp. when i am inserting the data on that field using this logic OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:") value is storing like this 15-AUG-05 0 suppose if i use this logic OCONV(DATE(),...

Arnd Ereplace alone doesn't work for the above examples. i just want to add another double quote if any field value contains one double quote and i don't want to replace anything. if i replace anything i may lose the exact data value. i think you are understanding my point. how do we do pattern matc...

Hi, i want to replace single " (double) quote character with "" two double quotes in between field value. for eg:- 1) field1 = "WEST WOODS" FIRE" it should be replaced as "WEST WOODS"" FIRE" 2) field2 = "SCOT 1" J S FIST" KNOCK" i...

env variable is working fine in After job routine.
we should give parameter as '$TargetFilePath' and include
#INCLUDE DSINCLUDE JOBCONTROL.H

Thanks all of you.... :D

Hi, I would like to pass environment variable $TargetFilePath into server routine. if i write this code, it is giving an error strFileLoc = DSGetParamInfo(DSJ.ME,"#$TargetFileDir#", DSJ.PARAMVALUE) Call DSLogInfo("strACRFileLoc :":strFileLoc, DSJ.ME) how to read environment varia...

Hi, I am using joiner stage to join 3 inputs. 1) oracle database table contains (locationtype and costcenter) 2) sequentail file contains (locationtype) 3) another sequential file contains (costcenter) i need to map locationtype,costcenter fields with the above inputs and transform the data to desti...

thanks chulett... i want just total amount by calculating all the amounts from source records (suppose say 1000 records) and same is the case with total openamounts. here i want a seperate file which contains all the detials like in the same format in a text file like this. Total Amount : 9999.99 To...

i have written the routine code like this #INCLUDE DSINCLUDE JOBCONTROL.H #INCLUDE DSINCLUDE DSJ_XFUNCS.H intTotAmount= 0.00 intTotOpenAmount= 0.00 OpenSeq '/Ascential/datastage/Projects/Account.txt' To objFileVar Else Create objFileVar Else ErrorCode =1 WeofSeq objFileVar intNoRecLoaded = DSGetLink...

yeah right saravanan but is there any predefined function to call the column value from dsjob function? if we call that amount value from source database we can easily calculate total amount in after job routine by using for loop. i don't have exact idea how to calculate the total amount in after jo...

Hi, i have a requirement in such a way that, i need to calculate TotalAmount,Amount being one of the source column and i need to report the total amount into a control file through After job routine. here my question is how to trap that single column Amount value in a routine? i think if use After j...