List of inbuilt routines

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
parangi.sheela
Participant
Posts: 4
Joined: Tue Jul 14, 2009 6:05 am

List of inbuilt routines

Post by parangi.sheela »

Can any body help me out to find out whether there are any inbuilt routines in DS which
1.Add integer number of days to a date
2.Add integer number of days to a timestamp??

Thanks in advance!!
Sheela
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome. Best to take a stab at the documentation first - bring up the docs Bookshelf from the Start menu and then open the Parallel Job Developer's Guide pdf. Appendix B lists all functions, and the first section has the Date & Timestamp specific functions. Keep in mind the fact that a day is 60*60*24 or 86400 seconds.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. Never reinvent the wheel if you don't have to. There are already written routines here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply