I'm having the following problem: I would like to retrieve the names of all of the projects in my DataStage Server together with their path.
I can get this information if I execute "DSR_LICENSE" in uv when I'm located in a project directory. This gives me back a list containing all projects, the DataStage version and the path of the projects.
So far so good. The only problem I now have is that to execute DSR_LICENSE I have to be in a project directory, I can't execute the DSR_LICENSE while being in the main DataStage directory because then I get "Verb DSR_LICENSE is not in your VOC".
Is there a way to get a list of project and directories without first having to be in a project first?
Regards,
Ogmios
Chicken and egg problem with DSR_LICENSE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The column wrap you are seeing results from the default display criteria specified in the file dictionary of UV.ACCOUNT. These can be overridden in your query.
Note, also, that two query languages are available, "native" (which is called RetrieVe) and SQL.
DataStage only uses three columns, called @ID, NAME and PATH. @ID is the name of the project, NAME contains a pipe-delimited string full of licensing stuff, and PATH is the location of the project directory.
SELECT @ID FMT '20L' COL.HDG 'Project Name', PATH FMT '40L'
FROM UV.ACCOUNT
WHERE @ID NOT IN ('UV','uv')
ORDER BY 1;
SORT UV.ACCOUNT @ID FMT "20L" COL.HDG "Project Name" PATH FMT "40L" ID.SUP WITH @ID CONV "MCU" NE "UV" HDR.SUP
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Note, also, that two query languages are available, "native" (which is called RetrieVe) and SQL.
DataStage only uses three columns, called @ID, NAME and PATH. @ID is the name of the project, NAME contains a pipe-delimited string full of licensing stuff, and PATH is the location of the project directory.
SELECT @ID FMT '20L' COL.HDG 'Project Name', PATH FMT '40L'
FROM UV.ACCOUNT
WHERE @ID NOT IN ('UV','uv')
ORDER BY 1;
SORT UV.ACCOUNT @ID FMT "20L" COL.HDG "Project Name" PATH FMT "40L" ID.SUP WITH @ID CONV "MCU" NE "UV" HDR.SUP
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518