Iconv Date format from variable/parameter

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Iconv Date format from variable/parameter

Post by roy »

Hi All,
(thoght I posted it already :roll: )

Is there any way this can work?

Code: Select all

Iconv(link.col,myDateFormat)
Doesn't work in the current site,
was wondering is or should it be possible?

Tested hard coded conversion mask works.

Thanks,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If myDateFormat is a job parameter, have you tried enclosing it in hash marks?

Code: Select all

Iconv(link.col,#myDateFormat#)
If it isn't then please explain how you are setting it up...
-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 »

Where exactly are you trying to do this?

If you're trying to use a job parameter, you must select it using the expression editor - for some reason typing it in is not recognized.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's true... it doesn't always need to be enclosed as I noted and I forget where it doesn't want them. The expression editor always knows, however. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

ray.wurlod wrote:Where exactly are you trying to do this?

If you're trying to use a job parameter, you must select it using the expression editor - for some reason typing it in is not recognized.
I'll try it Ray, Thanks.
chulett wrote:That's true... it doesn't always need to be enclosed as I noted and I forget where it doesn't want them. The expression editor always knows, however. :wink:
Stage attributes need # signs
Basic expressions/code doesn't
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply