Querying with Datastage repository

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
aschindler
Participant
Posts: 30
Joined: Wed May 15, 2013 1:22 am
Location: Bangalore

Querying with Datastage repository

Post by aschindler »

Hi,

I need to retrieve the job details specific to a particular folder within my datastage project,i'm using ds_jobs,ds_jobobjects tables for querying.

Please help.
Cheers,
Schindler
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What kind of help do you need?
-craig

"You can never have too many knives" -- Logan Nine Fingers
aschindler
Participant
Posts: 30
Joined: Wed May 15, 2013 1:22 am
Location: Bangalore

Post by aschindler »

while querying the data from ds_jobs and ds_jobobjects tables,i'm getting entire list of jobs from the project.

I need to restrict that to a specific folder,please help with a query
Cheers,
Schindler
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Filter on CATEGORY.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply