Search found 67 matches
- Tue Nov 27, 2007 11:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get the no of days between two dates
- Replies: 4
- Views: 2841
- Tue Nov 27, 2007 11:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get the no of days between two dates
- Replies: 4
- Views: 2841
how to get the no of days between two dates
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
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
- Tue Nov 27, 2007 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is the function to get the currentdate-1
- Replies: 4
- Views: 2638
- Tue Nov 27, 2007 6:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is the function to get the currentdate-1
- Replies: 4
- Views: 2638
- Tue Nov 27, 2007 5:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is the function to get the currentdate-1
- Replies: 4
- Views: 2638
what is the function to get the currentdate-1
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,
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,
- Fri Nov 23, 2007 4:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: the scenario is given below plz help how to find the end_d
- Replies: 3
- Views: 896
- Fri Nov 23, 2007 3:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: the scenario is given below plz help how to find the end_d
- Replies: 3
- Views: 896
the scenario is given below plz help how to find the end_d
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 ...
- Fri Nov 23, 2007 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how i find the end date based on the previus record eff_date
- Replies: 3
- Views: 2142
Re: how i find the end date based on the previus record eff_
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...
- Fri Nov 23, 2007 2:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how i find the end date based on the previus record eff_date
- Replies: 3
- Views: 2142
how i find the end date based on the previus record eff_date
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...
- Thu Oct 25, 2007 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to check the string contains A to Z or 0 to 9 Characters
- Replies: 9
- Views: 2991
- Thu Oct 25, 2007 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to check the string contains A to Z or 0 to 9 Characters
- Replies: 9
- Views: 2991
- Thu Oct 25, 2007 12:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to check the string contains A to Z or 0 to 9 Characters
- Replies: 9
- Views: 2991
- Thu Oct 25, 2007 12:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to check the string contains A to Z or 0 to 9 Characters
- Replies: 9
- Views: 2991
how to check the string contains A to Z or 0 to 9 Characters
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 ...
- Sat Feb 03, 2007 2:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: regarding Date difference (current date minus previous date)
- Replies: 2
- Views: 1703
regarding Date difference (current date minus previous date)
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
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
- Tue Jan 09, 2007 3:01 am
- Forum: General
- Topic: CIDocData operator=(char): String too long for field .
- Replies: 3
- Views: 3150
Hai
Hi Ray,
Thanks
Thanks