DSXchange

Thanks KoolNitz

Hi all,

i have to columns(defaultdate,current date ) i want to get difreence between these two columns .output column is days the datatype of this field id smallint..if any body have some idea please let me know

thanks

Thanks KOOLnitz..its working fine

Hi Ray,

i had one stagevariable name Stgvar1 it contains the 1999-12-31. i want to get the stagevar1-1 value like 1999-12-30 like this

Hi all,
is there any function to get the currentdate-1.if not please give me the suggestions to get this value.that was very helpful to me

Thanks,

Hi dsusr,

i understand what u r saying but my doubht is how i pass the previous effectve date to the particular satge variable.if u dont mine can u explain brefly..that was very help ful to me

Based on the effective date I aam sorting the records based on descending No Name bank flag Eff_d End_d 1 aaa city Y 2007-11-22 9999-12-31 1 aaa hdfc N 2007-11-19 9999-12-31 1 aaa icici N 2007-11-18 9999-12-31 Based on this I wnt to derive END_DATE based on the effective date of the prevous records ...

this is the example My source is DB2 No Name Bank Flag Eff_date End date 1 aaa city Y 2007-11-22 9999-12-31 1 aaa hdfc N 2007-11-19 9999-12-31 1 aaa icici N 2007-11-18 9999-12-31 Based on this I want to derive END_DATE based on the effective date of the prevous records when ever the sourgate key co...

this is the example My source is DB2 No Name Bank Flag Eff_date End date 1 aaa city Y 2007-11-22 9999-12-31 1 aaa hdfc N 2007-11-19 9999-12-31 1 aaa icici N 2007-11-18 9999-12-31 Based on this I want to derive END_DATE based on the effective date of the prevous records when ever the sourgate key col...

Hi i am getting 1000000 rec perday which i need to check one varchar2 (255) column this column contains average of 30 char " srini#vas is a go@od b|ye " how to work on this .

i am not sure which are all spcial charectors are coming becaiuse of that we need check input string contains A to Z and 0 to 9 otherwise we need put space

I Request for forgiveness posting Double time. can any one hands on this.


Thanks in Advance

Hi i am getting one string in that i need to check if the string is contains any spcial charecters, if contains i need to convert space for this i need to check the string . string A to Z and 0 to 9 other than this i need to convert space how to do this ? now iam checking the key board special char ...

hi All,

I have one senario, having 2 dates ie 20-09-2006 and 23-03-1983.
these are the dates ,my requirement is to calculate the difference between those two dates in days format. how to approch this ....any idea
this is in server jobs


regards
shrini

Hi Ray,
Thanks