DSXchange

Hi,
I am new to QS tool. I understand that the repository is maintained in a mdb file and this file can be opened via a QS Designer UI. Can i know what would be the password to open a mdb file in MS Access directly and try and understand how the meta tables are organised ?

Cheers,
Sidhartha

Thanks, once i was in the project directory it works. Currently, i get the below output, Job name. Actual job Name Category. Actual Category Name I am trying to improvise the output format such that both the column values (DS_JOBS.NAME JobName, DS_JOBS.CATEGORY) are 1. Separated by comma (,) 2. Both...

Hi, I was trying to fire a simple DS repository query, Following are the steps followed, test> pwd /app/test/Ascential/DataStage/DSEngine/bin test> ls -l *uv* -rwx------ 1 test dstage 1993 Mar 22 2005 lduv -rwxr-x--x 1 test dstage 1882200 Mar 22 2005 portuv -rwxr-x--x 1 test dstage 1880292 Mar 22 20...

Thanks guys for all your helping hand.

Cheers,
Sid

Now i have two columns (job name against the category) of my output. Now i need to fetch the last run time information for each job. I know it is there somewhere in the repository. Is there a way i can know the DS Repository Objects, like ALL_OBJECTS/ALL_TABLES Master Meta-data object in oracle. Thi...

Sorry, i had missed out semi-colon (;) to close the query. Its working now.

Thanks a ton,

Cheers,
Sidhartha

Hi,
Thanks for your valuable input.
I did fire the command . There was an ouputput window with "SQL+" alone and not any record record. Am i missing out any point ?

Cheers,
Sidhartha

Hi, I have a task in my hand where i need to pull out all the Job name from the repository sorted on the recent Job run and i need to associate the job name against the category in which they are available. I know that using DSGETJOBINFO and DSPROJECT i can get the entire job details and its last ru...