Search found 48 matches

by Pravenai
Sun May 29, 2011 11:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operators and Players
Replies: 5
Views: 3227

Operators and Players

What is the difference between operators and players?
by Pravenai
Wed Apr 29, 2009 1:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can i use a CASE statement in a SELECT statement ?
Replies: 11
Views: 8001

DataStage/SQL does not support a CASE structure. You can, as Kim noted, use an I-descriptor or EVAL field modifier to build a nested If..Then..Else expression that would be equivalent. ... hi Ray, You said SQL does not support a CASE statement. Do you mean CASE statement cannot be used while fetchi...
by Pravenai
Thu Apr 09, 2009 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Subtract minutes
Replies: 8
Views: 2053

Hi,

You can try this function
timestampfromsecondssince(-300,<column with timestamp value>)