project creation

mohandl · Post by **mohandl** » Wed Mar 26, 2008 3:03 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Mar 26, 2008 3:05 am

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.

Rashmi Goyal · Post by **Rashmi Goyal** » Thu Mar 27, 2008 4:39 am

Where are the tables stored in Datastge server.
where do we write above queries?

Rash

ArndW · Post by **ArndW** » Thu Mar 27, 2008 4:45 am

These are SQL queries on the DataStage engine, done either throught the TCL or from the command line utility in the Administrator.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 5:37 am

UV.ACCOUNT is not available (by default) from the Administrator client. UV_SCHEMA, however, is.

Rashmi Goyal · Post by **Rashmi Goyal** » Fri Mar 28, 2008 6:13 am

where can we find the command line utility of administrator

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2008 4:15 pm

Select the required project, click the command button captioned Command