Hi All,
I would like to know a way to implement the equivalent of 'Weekdayfromdate' function job sequence.Can this be achieved somehow in Job sequence?
Basically, I have the date in 'yyyy-mm-dd' format in a unix file.In the execute command activity, I can use
You can use the Oconv() BASIC function with date conversion codes like W for the day number of the week or WA for the name of the day of the week. See the DataStage BASIC Reference Guide for details.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Could you please tell me what is the need for replacing @FM with " " and what will happen if we remove convert and trim functions in the above derivation?
The @FM is the trailing linefeed. If you don't remove that, then the Iconv() function won't work. Trim() gets rid of extraneous white space, just in case there is any.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks for quick reply
one small clarification and I saw so many posts in dsecxhange replacing @FM with '' incase of sequence jobs especially wherever ExeCommand.$CommandOutput is used.
1)In which scenario Datastage will generate trailing linefeed because I got confused when to replace @FM with '' ?
2)Is the generation of trailing linefeed is specific to the particular activity in Job sequence?
vamsi.4a6 - Pleasestop quoting everything every time you post here, it creates unnecessary work for the moderator who (being an anal soul) has to constantly come along and clean up after you.
There is a perfectly lovely functional Reply to topic button, use that instead of Reply with quote... unless you have a good reason for quoting some or all of a previous message.
-craig
"You can never have too many knives" -- Logan Nine Fingers