Search found 116 matches

by prasannakumarkk
Wed Mar 06, 2013 10:34 am
Forum: General
Topic: getting list of jobs and sequences
Replies: 9
Views: 2946

You have to navigate to the datastage installation directory and in bin folder you have to invoke dsjob . In the above echo if you have not received any output then I guess you are in a Unix box where datastage is not installed or the user doesnt have proper privilege
by prasannakumarkk
Wed Mar 06, 2013 10:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to call oracle functions in datastage.
Replies: 19
Views: 15865

I don't know what the system source batch Will return . If it is a DS macro it has to be within hash .
by prasannakumarkk
Wed Mar 06, 2013 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to call oracle functions in datastage.
Replies: 19
Views: 15865

Didnt you get additional warning or info along with this warning in director. If there are any share it
by prasannakumarkk
Wed Mar 06, 2013 10:00 am
Forum: General
Topic: Passing Environment variable in Parameters
Replies: 4
Views: 1801

Am not sure whether it will work. When giving value in parameter set try giving hash in front and back of environment variable
by prasannakumarkk
Wed Mar 06, 2013 9:43 am
Forum: General
Topic: getting list of jobs and sequences
Replies: 9
Views: 2946

echo $DSHOME
Go to this path.in bin folder run the command

Give your project name not project
by prasannakumarkk
Wed Mar 06, 2013 8:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to call oracle functions in datastage.
Replies: 19
Views: 15865

What is the value you are passing to the function. You can make a call in after sql
by prasannakumarkk
Wed Mar 06, 2013 12:18 am
Forum: General
Topic: Passing read rows from one job activity to other in seq
Replies: 17
Views: 7960

Simar, Sequence 1: Job Activity --> Execute Command --> Start Loop --> Execute Command (triggers Sequence 2 with different jobs) --> End Loop Are you able to run the jobs in parallel. I guess inside a loop, a activity cant start until the previous counter got completed. In the execute command activi...
by prasannakumarkk
Tue Mar 05, 2013 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion from "string" to string[max=2
Replies: 9
Views: 5556

Which stage is feeding data to this stage.
by prasannakumarkk
Tue Mar 05, 2013 11:41 pm
Forum: General
Topic: getting list of jobs and sequences
Replies: 9
Views: 2946

there are lot of ways to acheive it.

Predominant way of getting the list is by using
dsjob -ljobs project
command. You can even specify the category/folder from where things have to be pulled

if you have dsadmin with you. Hit the xmeta to get the complete metadata of jobs.
by prasannakumarkk
Tue Mar 05, 2013 3:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SEQ File Issue
Replies: 2
Views: 1735

In the before job subroutine, use the sed command to replace double quotes with nothing.
by prasannakumarkk
Tue Mar 05, 2013 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture no of rows processed on link in parallel job
Replies: 18
Views: 7312

"I have to insert the no of rows each DS job Inserts/update/Deletes to the target tables to another table which keeps track of all the DS job info " If you want to get the number of records processed, the easiest way is to ask the DBMS itself. What is the underlying database. What stage is...