regarding universe command utility

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

regarding universe command utility

Post by vijaykumar »

Hi Gurus,
one of my team member is saying that using the command
SORT.DICT DSJOBS, we can extract the entire metadata of the objects in the universe.is that correct.

why is my command SORT.DICT DSJOBS returning error, comes up with the error message VERB SORT.DICT is not in your VOC.

i could understand that there is no corresponding entry in VOC FILE.

can anyone help me plz , is my syntax wrong or how to make corresponding entry in VOC FILE.

cheers;
vijay
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Re: regarding universe command utility

Post by narasimha »

vijaykumar wrote: one of my team member is saying that using the command
SORT.DICT DSJOBS , we can extract the entire metadata of the objects in the universe.is that correct.
Don't know about that but try without the .

Code: Select all

SORT DICT DS_JOBS
you get results. Is that what you want?
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

Well!

Code: Select all

LIST DICT DS_JOBS
or

Code: Select all

LIST.DICT DS_JOBS
or

Code: Select all

LIST.DICT
gives the same result as

Code: Select all

SORT DICT DS_JOBS
I wonder what's the difference :? .

May be Universe gurus can help.

Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Ok I guess I did not make it clear there..
I wanted to rectify if the OP had used DSJOBS over DS_JOBS, which I did, but mentioned only the . :roll:
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

The syntax error that was corrected is lucid. But I was wondering about the differences in the commands that I listed and the usage/role of DICT (dictionary).

Thanks,
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Lucid for you, not for the OP, unless it is a typo ;)
Just put forward my two cents
I am wondering about the difference too, watching for Universe Gurus to share their universe of knowledge!
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Never heard or saw SORT.DICT
I know there exists SORT.LABEL and SORT.ITEM which use the reserved word DICT but not SORT.DICT.
But then again i am not a Universe guru. Still learning :)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

"LIST DICT" and "LIST.DICT" are synonyms. The default sort order for the DICT listing happens to be the same as a simple SORT command, so produce the same ordering.
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

Post by vijaykumar »

hi gurus;
when i use the command LIST.DICT DS_JOBS;
iam getting the query o/p as

@id D 0
name D 0
readonly D 1
oletype D 2

i understood that its displaying the column names- metadata information.

but what does 'd ' mean and what does 0
here means.

plz help me
cheers;
vijaykumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

LIST.DICT is a paragraph (macro, if you like) that invokes LIST DICT but prompts for the file name if you forgot it give it on the command line.

The default display for file dictionaries, governed by the @ phrase in the dictionary for dictionaries, specifies sorting by TYPE then by KEY.CODE, so that the SORT verb is redundant. And that's why there's no SORT.DICT.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply