![Laughing :lol:](./images/smilies/icon_lol.gif)
uv command to create ds project
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
INSERT INTO UV.ACCOUNT(@ID, PATH) VALUES ('ProjectName', '/dir/dir/projecctdir');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:You need to be in the UV account and in the dssh shell (uvsh shell) to execute this command.Code: Select all
INSERT INTO UV.ACCOUNT(@ID, PATH) VALUES ('ProjectName', '/dir/dir/projecctdir');
Wow, you must be a genius! Gee. I just inserted a record. But DS still can not recongnize this new project. By the way, do you know what's command to show the table structure, like the "DESC TABLE" of Oracle? Thanks again!
bored to death
c_wf,
the entry for a DataStage project in the UV.ACCOUNT file requires one additional field to be entered, the "NAME" column needs to have a string with a certain syntax in it. The values depend upon your version and license - you can use a SQL select or a DS "LIST" command to to show the values for another project on the same system and copy that value. I haven't followed the whole thread, but even though making this change will allow the DS clients to "see" the DS project I don't know if that is going to be enough. Keep up posted.
the entry for a DataStage project in the UV.ACCOUNT file requires one additional field to be entered, the "NAME" column needs to have a string with a certain syntax in it. The values depend upon your version and license - you can use a SQL select or a DS "LIST" command to to show the values for another project on the same system and copy that value. I haven't followed the whole thread, but even though making this change will allow the DS clients to "see" the DS project I don't know if that is going to be enough. Keep up posted.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Oops, forgot about the NAME column!
to see what Arnd means. You can probably figure out what you need to do to update or replace your particular entry.
If you're bored to death, why not establish your own personal centre of excellence in DataStage documentation, leaving all your DataStage jobs in a state such that a future developer will need to waste no time whatsoever figuring out what jobs do and which jobs are related to which?
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Code: Select all
SELECT @ID, NAME, PATH FROM UV.ACCOUNT;
If you're bored to death, why not establish your own personal centre of excellence in DataStage documentation, leaving all your DataStage jobs in a state such that a future developer will need to waste no time whatsoever figuring out what jobs do and which jobs are related to which?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks, Arnd and Ray!
'SELECT NAME FROM UV.ACCOUNT', I got different name for different projects. Such as 'DataStage\7.1\hostname\123456' and 'DataStage\7.1\hostname\123456'.
I don't know how DS assign that number. I inserted a new record with NAME = 'DataStage\7.1\hostname\123456'. After I assigned 'DataStage\7.1\hostname\123456' to my new uv account, DS did see the new project :D
But when I tried to log in, I got the following message:
Error calling subroutine: DSR_NLS (Action=14); check DataStage is set up correctly in project t2
(Unable to load subroutine on host (30105))
Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is set up correctly in project t2
(Unable to load subroutine on host (30105))
I am working on a conversion team in a DW project with DS, PL/SQL and KSH. I have finished all my work so far and waiting for the other teams. We have documentation template for every job and I believe I have done great documentation. So, I try to find some challenges. And it is fun to dig it out![Razz :P](./images/smilies/icon_razz.gif)
'SELECT NAME FROM UV.ACCOUNT', I got different name for different projects. Such as 'DataStage\7.1\hostname\123456' and 'DataStage\7.1\hostname\123456'.
I don't know how DS assign that number. I inserted a new record with NAME = 'DataStage\7.1\hostname\123456'. After I assigned 'DataStage\7.1\hostname\123456' to my new uv account, DS did see the new project :D
But when I tried to log in, I got the following message:
Error calling subroutine: DSR_NLS (Action=14); check DataStage is set up correctly in project t2
(Unable to load subroutine on host (30105))
Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is set up correctly in project t2
(Unable to load subroutine on host (30105))
![Shocked :shock:](./images/smilies/icon_eek.gif)
I am working on a conversion team in a DW project with DS, PL/SQL and KSH. I have finished all my work so far and waiting for the other teams. We have documentation template for every job and I believe I have done great documentation. So, I try to find some challenges. And it is fun to dig it out
![Razz :P](./images/smilies/icon_razz.gif)
Last edited by c_wf on Sun Nov 13, 2005 2:15 pm, edited 1 time in total.
bored to death
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's another phase. There are many verbs (references to routines) that have to be cataloged. Do you wish to proceed with this?
Get into another, "proper", account and execute the LISTV command. That shows all the verbs in the VOC file. Then switch to your newly-created project and LISTV again. A somewhat shorter list.
You can set up a pointer to the VOC file in the old, "proper" project and copy all verbs to the new project. If you are in the new project.
The two SELECT statements generate Select Lists (lists of keys in memory). MERGE.LIST performs a set operation on them to produce the difference as a resultant Select List. The COPYI verb processes the keys in that Select List, consuming the Select List as it does so.
Get into another, "proper", account and execute the LISTV command. That shows all the verbs in the VOC file. Then switch to your newly-created project and LISTV again. A somewhat shorter list.
You can set up a pointer to the VOC file in the old, "proper" project and copy all verbs to the new project. If you are in the new project.
Code: Select all
SET-FILE old_project_name VOC REALVOC
SELECT REALVOC WITH TYPE = "V" TO 1
SELECT VOC WITH TYPE = "V" TO 2
MERGE.LIST 1 DIFF 2 TO 0
COPYI FROM REALVOC TO VOC
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Code: Select all
SET-FILE old_project_name VOC REALVOC
SELECT REALVOC WITH TYPE = "V" TO 1
SELECT VOC WITH TYPE = "V" TO 2
MERGE.LIST 1 DIFF 2 TO 0
COPYI FROM REALVOC TO VOC
:D Thanks a lot!
I have done whatever you said. But I got the following error message when I tried to log in:
Failed to attach to 't2'.
Cannot open file UV.ACCOUNT.
I tried "CLEAN.ACCOUNT", but I still cann't log in.
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
bored to death
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can't open UV.ACCOUNT indicates a wider problem, which you may have introduced or may have just happened.
Get into the UV project via telnet, in dssh, and try a query against UV.ACCOUNT, such as
Let us know what error messages appear (if any).
Then try naming columns in the query.
Ditto.
Get into the UV project via telnet, in dssh, and try a query against UV.ACCOUNT, such as
Code: Select all
SELECT * FROM UV.ACCOUNT;
Then try naming columns in the query.
Code: Select all
SELECT @ID, NAME, PATH FROM UV.ACCOUNT;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
>SELECT @ID,NAME,PATH FROM UV.ACCOUNT;
Account... Owner name...... NT pathname.............
UV d:\ascential\Engine
uv d:\ascential\Engine
main DataStage\7.1\JACOB\123456 d:\ascential\Projects\main
test1 DataStage\7.1\jacob\123457 d:\ascential\Projects\test1
t2 DataStage\7.1\JACOB\123456 d:\ascential\Projects\t2
t2 is the new project that I created manually. Projects main and test1 are fine.
Thanks
Account... Owner name...... NT pathname.............
UV d:\ascential\Engine
uv d:\ascential\Engine
main DataStage\7.1\JACOB\123456 d:\ascential\Projects\main
test1 DataStage\7.1\jacob\123457 d:\ascential\Projects\test1
t2 DataStage\7.1\JACOB\123456 d:\ascential\Projects\t2
t2 is the new project that I created manually. Projects main and test1 are fine.
Thanks
Last edited by c_wf on Sun Nov 13, 2005 2:15 pm, edited 1 time in total.
bored to death
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
What you say is true now, but wasn't two years ago when the rest of the posts on this thread were made. Just goes to show that the vendor does listen occasionally!
What you say is true now, but wasn't two years ago when the rest of the posts on this thread were made. Just goes to show that the vendor does listen occasionally!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.