Hash file

vikas gupta · Post by **vikas gupta** » Wed Jan 19, 2005 1:32 am

Is it any way to count hash file stored in local directory not in project directory.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 19, 2005 1:59 am

You really should post server questions in the server forum, rather than the parallel forum.

By "count" do you mean count how many hashed files there are, or do you mean count the number of records in a particular hashed file?

vikas gupta · Post by **vikas gupta** » Wed Jan 19, 2005 4:09 am

Sorry! I posted in Parallel extender.
Count number of records in hashed file, which is not stored under the Project directory. It is stored in local path

chucksmith · Post by **chucksmith** » Wed Jan 19, 2005 8:23 am

You can use my Create a VOC pointer to a hash file in another directory routine to create a pointer to the hash file, then you can use the COUNT YourHashFileVocPointerName command to get your record count. Use DSExecute() to run the count command.

You can find my tools on the DataStage Tools page of www.anotheritco.com.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 19, 2005 3:06 pm

Search the Forum for SETFILE, which is a DataStage command for creating a pointer. Or use the tool that Chuck has provided.

Once you have the pointer, you can use standard queries, such as

Code: Select all

SELECT COUNT(*) from hashedfilename;

or

Code: Select all

COUNT hashedfilename

vikas gupta · Post by **vikas gupta** » Sat Jan 22, 2005 1:18 am

I used SETFILE as follows for count hash file but it gives error and hash file H_Cmd_HS file is strored in path /u05/PRODDSS/data3/srcfiles/cmd/hash
>SETFILE /u05/PRODDSS/data3/srcfiles/cmd/hash H_Cmd_HS OVERWRITING
*** Warning *** The DICT file pathname "/u05/PRODDSS/data3/srcfiles/cmd/D_hash"
does not exist.

Pointer "H_Cmd_HS" established in VOC file.

rasi · Post by **rasi** » Sat Jan 22, 2005 2:16 am

Hi

Check your path and hash file folder

example

SETFILE /usr/prod/hashfiles/CLIENT CLIENT OVERWRITING

Thanks

vikas gupta · Post by **vikas gupta** » Sat Jan 22, 2005 3:27 am

I know only that path using for hash file, outside project directory

Vikas Gupta

vikas gupta · Post by **vikas gupta** » Sat Jan 22, 2005 3:40 am

I got it.

Thanks to all.

Vikas Gupta

ray.wurlod · Post by **ray.wurlod** » Sat Jan 22, 2005 3:28 pm

Please share your solution. The error message suggested that you were trying to create a pointer to the directory /u05/PRODDSS/data3/srcfiles/cmd/hash, rather than to the hashed file /u05/PRODDSS/data3/srcfiles/cmd/hash/H_Cmd_HS

Your correct syntax therefore should have been

Code: Select all

SETFILE /u05/PRODDSS/data3/srcfiles/cmd/hash/H_Cmd_HS H_Cmd_HS OVERWRITING