List all routines in the project

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramudwhelp
Participant
Posts: 24
Joined: Mon Jul 24, 2006 12:30 am

List all routines in the project

Post by ramudwhelp »

Hi,

Is there any command to list all the routines in a project ?

Thanks in advance
Ramakrishna
dspxguy
Participant
Posts: 156
Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA

Post by dspxguy »

TCL prompt

LOGTO project
COUNT DS_ROUTINES
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

COUNT does not list them. LIST does. Or you can use SQL.

Code: Select all

SELECT @ID FROM  DS_ROUTINES WHERE @ID NOT LIKE '\\%';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply