DSXchange

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

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.

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

Rash

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

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

where can we find the command line utility of administrator

Select the required project, click the command button captioned Command