AW: Cleaning up garbage in packed numeric fields??

Hi,

just try the following:
Create a physical file with the same layout, but with the SQL statement
CREATE TABLE. 
With iSeries Navigater you can get the SQL-statement for the original file.
Then try to copy the original file with CPYF to the SQL file.
I think the bad records will not be copied.

May be this helps?!

Birgitta

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David C. Shea
Gesendet: Freitag, 12. August 2005 14:56
An: Midrange Systems Technical Discussion
Betreff: Cleaning up garbage in packed numeric fields??

I have a data file with some packed numeric fields.  On some records,
instead of 12345F, there is 1b73x1 or some other gibberish that is
obviously not valid numeric data.  It's not null, it's garbage.

A few bad apples are ruining the whole bunch.

I'm trying to CPYTOIMPF from this DDS file to a delimited stream file.
Because of this bad data, I get some records approaching the bad record,
but nothing afterwards.

I've tried CPYF to see if that would initialize the bad stuff, but no
good.

Any ideas how I can clean up these records - maybe reinitialize these
fields to zeroes?