Search found 32 matches

by AshishDevassy
Tue Mar 17, 2015 1:35 pm
Forum: General
Topic: datastage scheduler running jobs one hour prior to the sched
Replies: 4
Views: 2547

Re: datastage scheduler running jobs one hour prior to the s

Did you check the time on the Infosphere Server ?
Restarting services wont help unless the server times are updated as well.
by AshishDevassy
Tue Mar 17, 2015 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TrimLeadingTrailing NULLS
Replies: 9
Views: 6914

Re: TrimLeadingTrailing NULLS

Convert Low values to spaces first and then trim the column and then compare with NULL.
What we have seen here is ;
There are cases when a char column may be padded by Spaces or by Lowvalues. (a normal sql client wont show any difference until you look at the hex values for the column)