DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
smahendra_s
Participant



Joined: 22 Feb 2011
Posts: 1
Location: Bangalore
Points: 15

Post Posted: Sat Feb 26, 2011 3:49 pm Reply with quote    Back to top    

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

pls replay

Tnks n advance

_________________
Regards
Mahendra
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Sat Feb 26, 2011 3:57 pm Reply with quote    Back to top    


Three admonishments:

1. Always post in the correct forum. The one you chose is to suggest ideas for formal FAQ articles. If this is a DataStage question, post either in the Server job forum or the Enterprise Edition (parallel job) forum or, if you are not sure of the job type, in the General forum.

2. Do not use all capitals. This is bad "netiquette" and is considered "shouting", which is offensive.

3. Always choose meaningful subjects. "HI" does not help anyone searching for answers in future

Two more admonishments:

4. Do not start new threads when "Reply to Topic" on the original topic is the more appropriate thing to do. The database is big enough as it is!

5. Do not demand responses. DSXchange is an all-volunteer forum, whose members post as, when and if they can. This is particularly the case on weekends, when most of us are actually attending to a good work/life balance.

Bonus admonishment:

6. Please strive for a professional standard of written English, paying attention to spelling and grammar. Many of our members do not have English as their first language, so misspellings and SMS-style abbreviations only make their understanding more difficult.


At some time a moderator will move your thread to a more appropriate forum. You might aid that process by posting here (use Reply) to indicate what job type and what software version you are using.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42796
Location: Denver, CO
Points: 220596

Post Posted: Sat Feb 26, 2011 4:11 pm Reply with quote    Back to top    

... and here we are off in our new home, with both errant posts and their accompanying admonishments combined. Since we're talking parameters and probably Sequence jobs and / or command line stuffs, seemed like here would be as good a place as any.

smahendra_s - please go back and edit your post here to add your particulars, primarily O/S and version, which could help in getting your problem solved. Worst case you could tone down all the shouting.

_________________
-craig

"I don't mind you comin' here and wastin' all my time time"
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Sat Feb 26, 2011 4:25 pm Reply with quote    Back to top    

Assming you're assigning a job parameter value in a job activity in a sequence job, then you need to obtain the system date (either as the system variable @DATE or function Date()) and convert it to y ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours