Hashed file

veera24 · Post by **veera24** » Tue Dec 30, 2008 8:47 pm

Hi all,
Do we have any command to analyze the hashed file struture through UNIX box like ANALYZE.FILE <File name> in UNIVERSE fILE STRUCTURES?Kindly forgive me if i mentioned anything amiss. Because i'm not aware about UNIVERSE fILE and all.

Your time will be highly appreciated.

Thanks in advance
veera

chulett · Post by **chulett** » Tue Dec 30, 2008 8:53 pm

Oddly enough, that is the command you would use.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 31, 2008 12:27 am

Moderator: please move to server forum

veera24 · Post by **veera24** » Wed Dec 31, 2008 3:02 am

chulett wrote:Oddly enough, that is the command you would use. ...

When i tried to use the command thru UNIX box, i got an error saying that, 'ANALYZE.FILE' not found.
So it means that the command is not present in the data stage dictionary list (Kindly let me know if i'm wrong). So how do i can add the command into the dictionary?

Your time will be highly appreciated.

Thanks in advance,
Veera

veera24 · Post by **veera24** » Wed Dec 31, 2008 3:07 am

ray.wurlod wrote:Moderator: please move to server forum ...

Ray,

Kindly apologize me for posted the topic in wrong place. Could you tell me how to move from parallel to server forum? (Dont get irritated as i'm asking a silly question. As i haven't came across this kind of situation, i didn't use that yet. Thats why i'm asking.)

Thanks,
Veera

ray.wurlod · Post by **ray.wurlod** » Wed Dec 31, 2008 3:16 am

You can't. Only the Moderator can.

chulett · Post by **chulett** » Wed Dec 31, 2008 8:17 am

Didn't mean it was an O/S command. You'd either need to run it from a dssh 'session' or leverage dssh to run it directly. For example:

viewtopic.php?t=124090

veera24 · Post by **veera24** » Fri Jan 02, 2009 12:13 am

veera24 wrote:
chulett wrote:Oddly enough, that is the command you would use. ...
When i tried to use the command thru UNIX box, i got an error saying that, 'ANALYZE.FILE' not found.
So it means that the command is not present in the data stage dictionary list (Kindly let me know if i'm wrong). So how do i can add the command into the dictionary?

Your time will be highly appreciated.

Thanks in advance,
Veera

Craig,
I've added ANALYZE.FILE command through DS administrator. Here i've a question. Where do i can execute this command?i mean which path?
Let me clearly explain you.

I wanna analyze the hash file characteristics which is already created by some job.
I got an info from UNIVERSE FILE STRUCTURE saying that, " ANALYZE.FILE <Hash file name> " command will analyze the structure of hash files in terms of GROUP SIZE, MODULO,Number of records and so on. Similarly what should i do to get the same in our usual thing?

Kindly forgive me if i've confused you anywhere.

Your time will be highly appreciated.

Thanks in advance
Veera

chulett · Post by **chulett** » Fri Jan 02, 2009 8:55 am

The hashed file will either need to have been created in an account, or a VOC entry created for a 'pathed' file using SETFILE, in order to use this command.

veera24 · Post by **veera24** » Mon Jan 05, 2009 4:25 am

chulett wrote:The hashed file will either need to have been created in an account, or a VOC entry created for a 'pathed' file using SETFILE, in order to use this command. ...

I've created the hashed file in my path and also have added the command in DS dictionary. I've executed the command in the path where the hashed file resides. But i got an error saying that ANALYZE.FILE not found. So i want to know where do i can execute the command in the path?

Could you pls tell me about "a VOC entry created for a 'pathed' file using SETFILE". I couln't get your point thats why.

Your time will be highly appreciated.

Thanks in advance
Veera

chulett · Post by **chulett** » Mon Jan 05, 2009 8:12 am

You run ANALYZE.FILE from a dssh session or the Administrator. Search for SETFILE for syntax and usage help. You "added the command" in DS dictionary? What "command"?