I have hash-files all over in my jobs.
*) I want to know by default whether these hash files are overwritten or appended everytime those jobs are exectued.
*) also is there any harm in checking the box - 'Clear file before writing' ? in the Input tab for Hash File?
*) and also why is the option 'Create File' and the 'Options' tab along with it.
Hash file Overwrite or Append by Default ?
Moderators: chulett, rschirm, roy
Check out this post, I believe I answered all and more of your questions:
viewtopic.php?t=85364&highlight=hash+files+abused
viewtopic.php?t=85364&highlight=hash+files+abused
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: Hash file Overwrite or Append by Default ?
Kenneth,
That was a wonderfull explaination of the Hash File usage.
NEVER MIND I FOUND THE ANSWER !!
Thanks for your help ANYWAYS..
That was a wonderfull explaination of the Hash File usage.
NEVER MIND I FOUND THE ANSWER !!
Thanks for your help ANYWAYS..
Last edited by raju_chvr on Tue Nov 04, 2003 1:09 pm, edited 1 time in total.
Re: Hash file Overwrite or Append by Default ?
1. If you don't check the clear box, the default is not to clear. This means existing data, where the primary key matches, will be overwritten. Non-matching data will be added to the hash file. You really need to comprehend what I wrote, because it explains things in detail.raju_chvr wrote:I have hash-files all over in my jobs.
*) I want to know by default whether these hash files are overwritten or appended everytime those jobs are exectued.
*) also is there any harm in checking the box - 'Clear file before writing' ? in the Input tab for Hash File?
*) and also why is the option 'Create File' and the 'Options' tab along with it.
2. Clearing the file before writing is okay, if you want a clear file. If there's data you need, well, it's gone. If you have multiple instances of a job simultaneously access the hash file, and clear file is checked, well, each job will clear the file, no matter if another instance has cleared and started adding data. This would be bad.
3. Create file is there to automatically create the file if the hash file isn't there. It has tuning capabilities. Creating a hash file in an instantiated job without parameterizing the hash file name or location/path is an unwise choice, as any of the simultaneous instances could "see" there's no hash file and both issue the create file statement.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Aborted How many rows will be committed ?
raju_chvr wrote:I have hash-files all over in my jobs.
*) I want to know by default whether these hash files are overwritten or appended everytime those jobs are exectued.
*) also is there any harm in checking the box - 'Clear file before writing' ? in the Input tab for Hash File?
*) and also why is the option 'Create File' and the 'Options' tab along with it.
Aborted How many rows will be committed ?
I wanted to know how many rows will be committed to the DB when the job aborts. I know this is the multiple of Transaction Number in my target OCI/ODBC stage.
I want to clarify this before I come to my own conclusion.
I am sure this is duplicate posting. Please excuse me for this.
I want to clarify this before I come to my own conclusion.
I am sure this is duplicate posting. Please excuse me for this.