Search found 3 matches

Go to advanced search

by choudary_sivaji
Fri Feb 20, 2009 5:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Invalid date from the source file
Replies: 5
Views: 4026

Hi,
use the below function to find valid dates.

If IsValid("DATE",StringToDate(input date column,"%yyyy%mm%dd") )=1 then StringtoDate() Else SetNull()

regards
sivaji
by choudary_sivaji
Fri Feb 20, 2009 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete on oracle taking long
Replies: 12
Views: 4908

Hi,
Are you selecting and deleting from same table?
if that is the case then it will lock.

regards
sivaji
by choudary_sivaji
Wed Aug 27, 2008 5:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max Date in Aggregator.
Replies: 5
Views: 3934

Hi,
you have to use 'preserve data type=true' option in aggregator stage.
and out columns change datatype to 'timestamp'.

regards
sivaji

Go to advanced search