Search found 57 matches
- Mon Mar 21, 2005 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: question regding if then else
- Replies: 12
- Views: 8468
I cant use business rule stage, coz all my transformation is done in transformer stage , I just want a way to keep track of the number of invalid i/ps if I use business stage I would lose that information or else I have to move all transofrmations into business rule stage. Neway Thanks once again. S...
- Mon Mar 21, 2005 9:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting parameters from two different files
- Replies: 2
- Views: 1877
- Mon Mar 21, 2005 8:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: question regding if then else
- Replies: 12
- Views: 8468
IF COND=1 THEN VAR+1 ELSE IF COND=2 THEN VAR+2 END I understand that if first if condition turns out to be true it doesnt check for the second condition. What if I want to check for all the conditons. I mean instead of if then else. I want if then end, if then end. Can I have more than two if stmts...
- Fri Mar 18, 2005 1:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: question regding if then else
- Replies: 12
- Views: 8468
* is a comment line. Also BASIC if then else is different than one used in a transformation. In a transformation it is treated as a single line statement therefore there is no end like a multiple line if then else. if x = 1 then 10 else 20 This will assign a 10 or 20 to column in a transform. Yeh t...
- Fri Mar 18, 2005 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: question regding if then else
- Replies: 12
- Views: 8468
It's end else if <condition> then <expression1> <expression2> end else <expression3> <expression4> end [/quote][/quote] But I dont want to return any thing from <expression2> I mean based on that condition I want to increment the counter variable. e.g., if var1=0 then var2 count:=count+1 end will th...
- Fri Mar 18, 2005 11:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: question regding if then else
- Replies: 12
- Views: 8468
question regding if then else
Hi,
I have this question regding if then -else.
Can we acheive
if <condition>
then <expression1> <expression2>
else
<expression3><expression4>
end
i.e., performing multiple actions based on single condition checking.
Let me know if I am not clear.
Thanks
srikie
I have this question regding if then -else.
Can we acheive
if <condition>
then <expression1> <expression2>
else
<expression3><expression4>
end
i.e., performing multiple actions based on single condition checking.
Let me know if I am not clear.
Thanks
srikie
- Fri Mar 18, 2005 9:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting parameters from two different files
- Replies: 2
- Views: 1877
getting parameters from two different files
Hi,
I would like to know if it is possible to get parameters from two different files. As, we could only specify one file name in job properties-parameters.
I am using Data Stage mvs 7.5
Thanks
srikie
I would like to know if it is possible to get parameters from two different files. As, we could only specify one file name in job properties-parameters.
I am using Data Stage mvs 7.5
Thanks
srikie
- Tue Mar 08, 2005 4:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 12:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 11:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 11:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
srikie, I don't have access to a mainframe to try some options, but this is what I would assume would be the way that CAST AS TIMESTAMP would work: 1) If character, I would expect that you would have to provide a 26-character string in standard DataStage timestamp format. 2) If date, I would expect...
- Fri Mar 04, 2005 11:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 11:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
- Fri Mar 04, 2005 11:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: cyymmdd to timestamp
- Replies: 19
- Views: 11099
But the delimiters could be anythg right? I mean 'hh.mm.ss.ssssss' or should it only be 'hh:mm:ss.sssssss'Mike wrote:srike,
I think Sainath.Srinivasan has probably nailed your problem. The CAST function expects a DataStage format timestamp (i.e. without the dash between the date and time portions).
Mike