Search found 4 matches

by bagus
Fri May 27, 2011 2:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic to find no. of saturdays and sundays betwen two dates.
Replies: 17
Views: 6793

vinothkumar wrote:Why cant you write a simple server routine for this and call in your job.

couldn't agree more
by bagus
Tue Feb 08, 2011 3:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify stage truncate my string
Replies: 3
Views: 1918

solved by explicitly declaring the column is 160 character in specification. thanks.
by bagus
Tue Feb 08, 2011 2:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify stage truncate my string
Replies: 3
Views: 1918

checked, same 160 nullable varchar
by bagus
Tue Feb 08, 2011 2:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify stage truncate my string
Replies: 3
Views: 1918

modify stage truncate my string

Hi all,
i have a strange problem. i try to drop columns using modify stage. but strangely one of the varchar column i keep losing it values from 160 character to 100. like somebody put substring[0,100] to that column, only it isn't. anyone experience the same thing ?