Search found 20 matches

by Amarpreet
Mon Jun 12, 2006 12:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to execute DB2 command through UNIX command line
Replies: 2
Views: 4786

How to execute DB2 command through UNIX command line

I want to execute DB2 command using TELNET session. What is the directory path to get to the DB2 prompt. Then how can I connect to my database in particular instance. I want to use executecommand stage in my sequence to execute one DB2 command. what should I write in the stage(starting from connect ...
by Amarpreet
Fri Jun 09, 2006 12:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Have to call a DB2 stored procedure
Replies: 9
Views: 6265

Thanks for the answer. But I have no idea that how to execute db2 stored procedure from command line. what has to be written in executecommandactivity to execute db2 stored procedure from command line.
by Amarpreet
Thu Jun 08, 2006 11:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Have to call a DB2 stored procedure
Replies: 9
Views: 6265

Have to call a DB2 stored procedure

I have a scenario, where in I am using a loop to execute a job 20 times with some different variable each time. I want to execute/call a DB2 stored procedure after end of the loop. How can I achieve this in parallel jobs?
by Amarpreet
Tue Jun 06, 2006 9:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To find out duplicate records
Replies: 9
Views: 6536

Thanks all.
Its working fine.
by Amarpreet
Thu Jun 01, 2006 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To find out duplicate records
Replies: 9
Views: 6536

To find out duplicate records

I have some duplicate records in my source, which are getting rejected at the target. I can use remove duplicate stage to remove those records. But I need to capture those records in some other table/file. How can I do this? Reject link from transformer is not working, as the records are getting rej...