Re: Weird problem a customer is having with a file

Peter Lunde <[email protected]>
Newsgroups gmane.comp.lang.as400.mi
Message-ID <20060420202045.NEXK13653.tomts36-srv.bellnexxia.net@smtp1.sympatico.ca>
James,

Regardless of how the bad data got into the table, I think QuestView should fail gracefully rather than crashing.

Perhaps QuestView should display the hexadecimal value of the bad data.

Peter Lunde.

============================================================
From: "James H H Lampert" <[email protected]>
Date: 2006/04/20 Thu PM 12:51:35 EST
To: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [MI400] Weird problem a customer is having with a file

My fellow MI geeks and gurus:

One of our customers sent me a physical file that's 
crashing our QuestView product in a way that's like 
nothing I've ever seen before. It seems that the file 
(which appears to have been created in SQL) has a date 
field, and when we attempt to read the last record in the 
file, it produces a data mapping error on that date field, 
apparently because it fails a constraint.

I've heard of date fields producing data mapping errors on 
write operations, but never on read operations; moreover, 
I thought that in SQL files, all validation that's built 
into the file happens on the write, rather than the read.

Any idea what it is I'm looking at?

--
JHHL
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.
============================================================


_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.