mayura wrote: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 ...
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,
Mario Fernandes
An expert is one who knows more and more about less and less. - Nicholas Murray Butler