read hash file from unix

[ysrinu]

Hi,
how can i read hash file using shell scripts, without writing any new ds routines?

Thanks,
-srinivas yelamanchili

[ArndW]

There is no utility to directly read hashed files from UNIX. You would need to invoke the dssh to get into the DataStage command environment, and then issue the appropriate LIST or SELECT clause. In a simplified form, you can attach to the correct project directory and issue something like

Code: Select all

dssh "COUNT VOC"

[ray.wurlod]

OK here's the deal.

A hashed file (note: it's not a "hash" file) is a "UniVerse" database table.

So, you tell me how to read, say, an Oracle table from UNIX and I'll respond with how to read a UniVerse table from UNIX.

[arjun_004]

Hi Ray,

I am not sure about how to read the oracle table from the shell scripts
but in the teradata we can write the bteq command in the shell scripts or we can call the bteq scripts.


Now kindly let us know how to read the hash file in unix.

OK here's the deal.

A hashed file (note: it's not a "hash" file) is a "UniVerse" database table.

So, you tell me how to read, say, an Oracle table from UNIX and I'll respond with how to read a UniVerse table from UNIX.

[ray.wurlod]

Very good.

For UniVerse, you use a dssh command or script.

The simplest of these will contain just the SELECT statement you require.

Code: Select all

$DSHOME/bin/dssh "SELECT NAME, JOBNO FROM DS_JOBS WHERE NAME NOT LIKE '\\%';