Search found 3 matches

by lannguyen
Tue Mar 27, 2012 1:53 am
Forum: General
Topic: Using job having paramter set from command prompt
Replies: 2
Views: 1495

Re: Using job having paramter set from command prompt

Yes you can, suppose you have 2 parameters

dsjob -server xxx -user xxx -password xxx -run -mode NORMAL -jobstatus -param name_param1=value_param1 -param name_param2=value_param2 project_name job_name
by lannguyen
Tue Mar 27, 2012 1:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find max sal using remove duplicate stage
Replies: 4
Views: 2331

Re: How to find max sal using remove duplicate stage

Remove duplicate :
- key = deptno.
- In the Partition tag: choose Hash on deptno and sort (desc) on sal
by lannguyen
Tue Mar 27, 2012 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Modify Stage - Substring function
Replies: 15
Views: 18399

I had the same problem.

when I used
NAME2:String[max=100] = substring[1,100] (NAME1)
it returns a warning, I must use NOWARN.

I found a solution for the substring without warning:
NAME2:string[max=100]=string_trim(NAME1)