un-delete records in a table

[jamief]

Written by: Dave McKenzie
Zbig Group, Inc.

2006/01/18

UNDEL2 is a freeware utility which allows you to view, copy and un-delete
deleted records in a physical file. You can interactively display active and
deleted records, scan for deleted records and un-delete them. In addition,
you can copy records to print or to an outfile or un-delete them without
displaying them.

save file is @ v5r3 but program CRTUNDEL2 is @ v5r2...
so once you restore just call program CRTUNDEL2 to recreate objects...

kinda a cool tool to have laying around!

jamie

[sharafnta7]

Re: un-delete records in a table

this is a great program i will try it

[CessnaDriver]

Re: un-delete records in a table

Wow, very cool, I can't wait to try this out

[jamief]

Re: un-delete records in a table

just throw a beating on the customer master file by deleting all records using
SQL ...Now That would be a cool test


Just to let you know I did test this and it works just fine!

[Leguar]

Re: un-delete records in a table

Hi Jamie...

Seems there's some difference between your version (243KB) and mine (227KB).
Dont know why, but Dave has pushed his latest version (as far as I know) to my
site: Think400

[samujsu]

Re: un-delete records in a table

just throw a beating on the customer master file by deleting all records using
SQL ...Now That would be a cool test


Just to let you know I did test this and it works just fine!

Hi Jamie,

I have tried deleting few records from a file and performed UNDEL2 on those records in the file. The status did changed to Active but the contents are still appearing as Blanks for character fields and 0's for numeric fields. The iSeries I am using is on V5R4M0. Any leads on where I may have gone wrong!

[gregmonay]

Re: un-delete records in a table

Hi Jamie,

Can you post the V5r2 savf please?

Thanks a lot.

Greg

[gregmonay]

Re: un-delete records in a table

I have downloaded and was able to use the undel2 from the link above Think400.com. Thanks

[jamief]

Re: un-delete records in a table

Good Leif is a great guy & he does own my second favorite site


jamie

[Leguar]

Re: un-delete records in a table

Thank you... Thank you... Jamie :-)

Old thread... but Dave McKenzie has sent me a new version of UNDEL2.
Both the former version and the new one can be downloaded from Think400.dk

Leif

[bigredtruck]

Re: un-delete records in a table

Lifesaver!! We had a programmer confuse his logic and delete the opposite of what he wanted to this morning in our email address file.

Thanks

[K2r400]

Re: un-delete records in a table

If the file is journaled it's easy to retreive the records without any tools

[bigredtruck]

Re: un-delete records in a table

Alas, the business unit owners never set DR requirements for this box (other than 21 save, weekly & daily backups, and have the box back up in three days) or I'd have a journal on it for replication purposes. If we had the extra space I'd journal more than we do for times when this particular programmer goes rogue.

[jamief]

Re: un-delete records in a table

Glad we could help ....... DBU also has a undelete function and comes with DBUJRN (journals)..
all for a very cheap price...

Jamie