DSXchange

target datatype is Date and i have also tried with function also but getting NULL as output not valid dates present in input. if isnull(select_stats.RENEWAL_DATE) then setnull() else if IsValid('Date' ,StringToDate(select_stats.RENEWAL_DATE, "%mm%dd%yyyy")) Then StringToDate(select_stats.R...

i tried with that too still not getting output for vaild dates i have also tried by using the function below if isnull(select_stats.MATURITY_DATE) or select_stats.MATURITY_DATE=0 then setnull() else if (IsValidDate(StringToDate(select_stats.MATURITY_DATE,"%mm%dd%yyyy"))=1) then StringToDat...

i used now
Still getting the Null output.

hi , i am read the date column MATURITY_DATE(VARCHAR) with length 8 and converting into Date by using the function given below but getting NULL as output. if isnull(select_stats.MATURITY_DATE) then setnull() else if IsValid("Date" , select_stats.MATURITY_DATE, "%yyyy%mm%dd") Then...

Can somebody help me on thi.s

i use the following function as suggested Still the same error is coming( Conversion error calling conversion routine decimal_from_string data may have been lost)

hi,. i tried to insert the column CYCLE_DAY_OF_MONTH varchar(2) to decimal CYCLE_DAY_OF_MONTH(decimal(5)) however i getting error conversion error decimal from string data may have been lost. i have search a lot of forums and then tried with function StringToDecimal(select_stats.CYCLE_DAY_OF_MONTH[5...

i have tried again by using the function given below and also by transfrom varchar(255) to char(15) but getting same result as getting by the functions below StringToDecimal(select_stats.AVG_NET_PAR_BAL_C[14,2]) . Also tried by StringToDecimal(select_stats.AVG_NET_PAR_BAL_C[14,2],"ceil") a...

increase the length in target DECIMAL(19,2) still getting the same error APT_CombinedOperatorController,1: Conversion error calling conversion routine decimal_from_string data may have been lost. The data from source is coming as "+ 000000000000.00" i have doubt about "+" sign co...

hi, i have input column apt_source(varchar 255) having records like "+ 000000000000.00" and needs to covert to target datatype decimal(14,2) but getting errors APT_CombinedOperatorController,1: Conversion error calling conversion routine decimal_from_string data may have been lost. the job...

i have tried by the following way to get mmddyy in between 86 and 20 '86': lnk_cpy.PARTY_ACCT_RELSHP_SNAP_DATE[6,1]:lnk_cpy.PARTY_ACCT_RELSHP_SNAP_DATE[9,1]:lnk_cpy.PARTY_ACCT_RELSHP_SNAP_DATE[3,4]:'20' the result coming like this 861213-120. i need 8611211320. Can you please help me to correct the ...

hi, I am generating a fixed width file and I need output based on the following requirement '86' || mmddyy || '20'. The mmddyy should correspond to the party_acct_relshp_snap_date value column as getting from source and the date is coming as 2013-11-21. I tried the following way: '86': lnk_cpy.PARTY...

please check the if then else nested as per ray suggested

if select_stats.OBG_NO= '10000241' else if select_stats.DS_LOAN_DESC='PARTIC' then select_stats.DS_LOAN_DESC+1 else select_stats.DS_LOAN_DESC

i have tried with stage variable

select_stats.DS_LOAN_DESC='PARTIC' =stgvar
stgvar+1 =stgvar2


then in derivation using

if select_stats.OBG_NO= '10000241' then stgvar1 else select_stats.DS_LOAN_DESC


but this giving me the same result that is 'PARTIC'.

hi, i have extracting the data from DB2 and loading into oracle stage. the out put i need is given below. No AP BK_NO VER SHORT_NAME DS_LOAN_DESC 10000241 1 1 1 CIT FINANCE LLC PARTIC01 10000241 1 1 1 BMO PARTIC02 if no=10000241 and shortname=CIT FINANCE LLC then i need PARTIC01 similary if no=10000...