regarding query repository

[avi21st]

hi,
iam trying to query universe through datastage administrator. i have given command LIST.DICT DS_JOBOBJECTS.The error which iam getting is syntax error:un expected sentence without filename. plz help me.

cheers;
abhi

[kumar_s]

Change it to LIST DICT DS_JOBOBJECTS. (No dot'.' next to LIST)

[ray.wurlod]

The dot between LIST and DICT is OK.
Were you able to generate this error twice?
There's no dot at the end of DS_JOBOBJECTS by the way.
If that doesn't work, try the following and let us know the outcome.

Code: Select all

SELECT * FROM DICT DS_JOBOBJECTS;

[avi21st]

Hi,
This works.what is the difference between the listing from the dictionary and selecting from the dictionary.

my query LIST DICT DS_JOBOBJECTS didn't work
but my query select * from DS_JOBOBJECTS works.

thanks very much, i want to know why the list comand didn't work and why the select command works and whats the difference between two.
plz help me in clearing .

cheers;
abhi

[ray.wurlod]

Some specific commands are blocked in the Administrator client. You can successfully executed them from a telnet session. I didn't think that LIST DICT was one of them, however. It may be that the particular table name is blocked - that would be easily gotten around by defining a synonym.

You did not include DICT in your SQL query. Try it with the DICT keyword.

You may find it useful to sort the query.

Code: Select all

SELECT * FROM DICT DS_JOBOBJECTS ORDER BY "TYPE", "KEYCODE";

If you still get "table not found" error, chances are that someone has deleted either the dictionary reference in the VOC entry, or the dictionary itself. Try:

Code: Select all

LIST.ITEM VOC "DS_JOBOBJECTS"

[avi21st]

Hi Gurus;
when i type the command LIST.ITEM VOC "DS_JOBOBJECTS"

it displays 001 Fardent datastage repository file.
002 DS_JOBOBJECTS
003 D_DS_JOBOBJECTS.

result is different from select statement. i can understand the result of select statement, plz help me out what is these list command displaying.

cheers;
abhi

[kumar_s]

Hi Abhi,

The output for LIST DICT or LIST ITEM and SELECT will be different.
Select will give the list of data available in the Hashed table. LIST DICT will give the data dictionary(Metadata) for the table.
You can use LIST DS_JOBOBJECTS to get the similar result of SELECT * FROM DS_JOBOBJECTS.
Similarly LIST DS_JOBS "JobName" will give the records details about the Jobname given which present in the DS_JOBS file.
LIST.ITEM will give the output in the page wise with the line number of the D type columns.
Sure Ray can add up in this.

[ray.wurlod]

The LIST.ITEM command was to ensure that your VOC entry describing the DS_JOBOBJECTS table is intact. It is.

You now need to check that D_DS_JOBOBJECTS exists in the file system, and that you can read it. Please execute this command and report the result.

Code: Select all

SH -c "ls -l D_DS_JOBOBJECTS"