Datastage adminstrator

[mayura]

Hi,
Please let me know the command to view the routine in datastage admin command line.

thanks,
Datastagepx

[dsouza.adithfrancis]

This is a command line input in DS Adminstrator .
SELECT * FROM DS_ROUTINES WHERE NAME ='ROUTINE NAME' ;

regards
Francis Adith

[ray.wurlod]

Hi,
Please let me know the command to view the routine in datastage admin command line.

thanks,
Datastagepx

Why?

The routine source code is stored in a database table. It is not one of the fields displayed by SELECT * FROM DS_ROUTINES; query.

What do you actually need to achieve?

[chulett]

And are we talking a Server routine or a Parallel one as the post is marked?

[mayura]

Hi,
Please let me know the command to view the routine in datastage admin command line.

thanks,
Datastagepx

Why?

The routine source code is stored in a database tab ...

hey routines are not stored in database.It is datastage..
and need command to view routines by login to datastage admin and select project name -> command -> and then command to view routines ...

[mf_arts]

Hi Mayura,

Create a Server job insert either an Universe Stage or a Hash File Stage as a source stage, put some transformer in the middle and a Sequence File as Target stage, link source to transformer and transformer to target stage.
To configure UV stage in Stage tab define Data Source Name as localuv, in Outputs tab define Table Names as DS_ROUTINES in Columns define a field called DSRID Varchar 255 and if you need, other field called CATEGORY again Varchar 255, on Selection tab define Where clause: DSRID NOT LIKE '\\%' ORDER BY DSRID ASC. In the View SQl tab you should see the follow: SELECT DSRID FROM DS_ROUTINES WHERE DSRID NOT LIKE '\\%' ORDER BY DSRID ASC;

To configure Hash File stage, in the Stage tab select User Account Name, define the same columns as for UV stage (DSRID and CATEGORY) and view data.

The Universe File structure for DS_ROUTINES is the follow:
DSRID
READONLY
OLETYPE
CATEGORY
DESC
ROUTINETYPE
JOBTYPEIND
PLATFORMTYPE
JOBTYPE
Do not do any changes on this table if you're not having work experience with Universe, the UV file can become corrupt and your project crash. Take all necessary measures in order to backup your work before doing any kind of experiments.

Regards,