Hi all,
When we create project in Datastage contents of project are stored in Universal file or in database?
When i gone thru the forum one of datastage guru written like as follows
Select Count(*) FROM DS_JOBS where NAME NOT LIKE '\\%';
Select NAME FMT'50L' FROM DS_JOBS where NAME NOT LIKE '\\%';
Is that mean that Project is stored in database?
Please clarify my doubt.
regards,
Mohan
project creation
Moderators: chulett, rschirm, roy
project creation
MOHAN
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No. The project is a schema in the database. It is not "in" the database in any other sense. Existence of a project is recorded in system tables UV.ACCOUNT and UV_SCHEMA.
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.
-
- Participant
- Posts: 3
- Joined: Thu Mar 27, 2008 3:10 am
These are SQL queries on the DataStage engine, done either throught the TCL or from the command line utility in the Administrator.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3
- Joined: Thu Mar 27, 2008 3:10 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: