Append records to a hash file
Moderators: chulett, rschirm, roy
Append records to a hash file
How do I append records to the existing hash file.
Ok, specific.
I have Job1 to create and write records to HashFile1. My properties here are checked the "Create File" and checked the ""Delete file before create" in the Options.
In my Job2, I want to add new records to the same file HashFile2.
On the General tab, which properties should I use to make sure the records gets added.
I have Job1 to create and write records to HashFile1. My properties here are checked the "Create File" and checked the ""Delete file before create" in the Options.
In my Job2, I want to add new records to the same file HashFile2.
On the General tab, which properties should I use to make sure the records gets added.
Append to Hash File
Be aware that writing to a file with a duplicate keyed record will over write the existing record
Actually, the only one you need to uncheck is the 'Delete file before create' one. The create one is safe to leave alone as it just gives you the option of overriding defaults when the file is created. And it is only created if it doesn't already exist. Which actually happens whether that option is checked or not.vsi wrote:Uncheck both of them
That being said, uncheck both so your intentions to 'append' data to an existing hashed file are more clearer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Write caching disabled is a normal informational message and isn't a problem. Something else caused your issue. You need to post the actual message from the log - don't paraphrase or type it here by hand, cut and paste it please. Just saying "it aborted" doesn't tell us anything.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Actually its safe to leave both 'create file' and 'delete file before create' options checked in job1 if thats the job that always runs first and creates a fresh hashed file. Its just job2 where you need to uncheck both these options and use the name of the same hashed file as job1.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.