Questions regarding Hash files and hash file stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That design operates as two jobs, even though it's one. For a sufficiently small reference data set the hashed file write cache and read cache can be used, so that lookups are performed in memory, which should be faster than performing them to disk.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Only if there is a VOC entry for the hashed file, from what I recall. That is, only if it is in an 'account' rather than a 'directory', that or you've manually created one for it using the SET.FILE command.
There's also a 'Clear' option if you need to do that inside a job in the Hashed File stage but I'm sure you knew that.
There's also a 'Clear' option if you need to do that inside a job in the Hashed File stage but I'm sure you knew that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well, I've seen plenty of places that have jobs that do just that.mavrick21 wrote:In that job the hashed file was used as reference and I couldn't find the job which populated it. Didn't want to waste my time creating a new job to clear it
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
mavrick21 wrote:I was about to ask - Can data in Hashed file be cleared without deleting DATA.30, OVER.30 and the VOC entry?
And I found out I can
DELETE FROM <HASHED FILE>
Posted here hoping this might be useful for others
Code: Select all
CLEAR.FILE <hashedfile>
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hello,
Below is the LIST.DICT of HASHED_STORE_DEL
Below is a sample entry in the hashed file.
My question- Can I manually insert a record into the hashed file? If so what's the syntax?
Thanks.
Below is the LIST.DICT of HASHED_STORE_DEL
Code: Select all
Type &
Field......... Field. Field........ Conversion.. Column......... Output Depth &
Name.......... Number Definition... Code........ Heading........ Format Assoc..
@ID D 0 HASHED_STORE_DE 10L S
L
Jobname D 0 Jobname 10L S
CURR_DEL D 1 CURR_DEL 10L S
@KEY PH Jobname
@ PH Jobname
CURR_DEL
ID.SUP
5 records listed.
Below is a sample entry in the hashed file.
Code: Select all
Jobname... CURR_DEL..
SFCO_CS9_E
PM9
J_Stage_PS E
_VAR_DATA_
SFPA_CS9_E
PM9
265 records listed.
>
>COUNT HASHED_STORE_DEL
265 records counted.
Thanks.
A hash value is computed for the key fields (thus the name) and that is used to store the value. I seem to recall a Ken Bland post here with all kinds of gory details about hashed files... and I'm sure Ray has a thing or two up his sleeve.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers