Hi we need delete few rows from hash file on linux.
please let us know the way.
delete data from hash file
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Terminology: it's hashed file, not hash file.
It is not possible to delete rows from a hashed file from a parallel job.
There is no support for hashed files in parallel jobs (other than by including a server Shared Container).
It is not possible to delete rows from a hashed file from a parallel job.
There is no support for hashed files in parallel jobs (other than by including a server Shared Container).
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.
Create a Pointer to the 'hash' file in VOC file and use an universe editor or SQL 'DELETE ' statement .
If i knew the record id , I would use Universe editor ( ED ) .
Also as ray notes , a hashed file has no business in a parallel forum.
The simplest approach however if you still have the source of this hashed file available - would be to recreate the file ( use 'clear file before write' option ) maybe with a one time job , selecting from source ONLY the records that you really need .
If i knew the record id , I would use Universe editor ( ED ) .
Also as ray notes , a hashed file has no business in a parallel forum.
The simplest approach however if you still have the source of this hashed file available - would be to recreate the file ( use 'clear file before write' option ) maybe with a one time job , selecting from source ONLY the records that you really need .