How to list the component using istool?

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
dsdoubt
Participant
Posts: 106
Joined: Sat Jul 15, 2006 12:17 am

How to list the component using istool?

Post by dsdoubt »

I wanted to export all Jobs / Table definitions / Routines / Shared containers individually to its corresponding folder in Unix. So that I can do the version control.
If get the list, I can export using istool export command.
dsjob -ljobs gives me just the list of jobs and not the other component.
How do I get the list of other types of component?
And how do I get the component type extensions for each type of component (.pjb, .qjb etc)?

If not clear... I can explain more.
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Use istool export with -pre -incdep...
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

JR, I think the request was for each item to be extracted into it's individual ISX file, not one ISX file that contained all of the dependent items.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I think we need to call in their Explain More marker.
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

If I understand the question - this is how I normally do it:

Craft a shell script to dump the list of projects and job names as required into files. Use those files to feed a loop that processes each job one at a time.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

How would you dump a table definition by itself into an ISX file?

Auto find the name, and dump to a unique ISX for itself.
dsdoubt
Participant
Posts: 106
Joined: Sat Jul 15, 2006 12:17 am

Post by dsdoubt »

Thanks all for your replies.

May be I should ask this.

I want to list all the components from a project.

*.pjb, *.qjb, *.prt etc

How do I do it using istool.

So that I can export each and every component individually.
dsdoubt
Participant
Posts: 106
Joined: Sat Jul 15, 2006 12:17 am

Post by dsdoubt »

As JR mentioned, export -preview with datastage component as '"proj/*/*.*"' helped!!
Post Reply