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



Joined: 28 Jun 2018
Posts: 5

Points: 56

Post Posted: Sun Jul 01, 2018 2:14 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a requirement to pass timestamp value which I got it from unix command in sequence job. One of the parallel jobs required parameter to be passed into it.

But sequence job got failed because of Invalid param/limit value. Kindly suggest how to handle this scenario and pass date time value.

Value which I am trying to pass is in this format : 2018-01-07T14:30:03.832-0700

In parallel job I have defined this parameter as string datatype and appended quotes then also it was getting aborted with the same reason.
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42766
Location: Denver, CO
Points: 220381

Post Posted: Sun Jul 01, 2018 6:53 am Reply with quote    Back to top    

It would need to be a string parameter in the Sequence job as well. The "T" separator, the milliseconds and time zone are issues that would cause the error noted if you used any other type. Shouldn't be a need for quotes either. Pass it as a string and convert it inside the Parallel job... if indeed it needs to be converted at all.

What is your target for this string? How do you plan/need to handle both the milliseconds and the time zone? The "T" is simple to convert to a space or whatever else you may need to do with it.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
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: 54400
Location: Sydney, Australia
Points: 295062

Post Posted: Mon Jul 02, 2018 1:38 am Reply with quote    Back to top    

Alternately you could look into changing the expected timestamp format. The project default is set in the Administrator client, but this can be overridden at the job level, or when applying timestamp ...

_________________
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