Data conversion errors

Oran Shapitka oran@intertechsystems.com
Wed, 19 Jul 2000 15:12:41 -0600


Start eliminating fields until you find the offending field(s).  Then
evaluate the records using a define x char * n = ascii(offending_field) and
report on x to find what values are causing the errors.  A common culprit is
a date field that was initialized or updated from a non-PowerHouse program,
or a field that is defined as character and then redefined as being zoned.

Oran Shapitka, ISP
Intertech Business Systems, Inc.
1564, 10303 Jasper Ave	Email:	oran@intertechsystems.com
Edmonton, AB  T5J 3N6  Canada	Voice:	(780) 413-0400	Fax:	(780) 413-0398

<http://www.intertechsystems.com/>


-----Original Message-----
From: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Boris Kortiak
Sent: Wednesday, July 19, 2000 2:45 PM
To: powerh-l@sphere.swau.edu
Subject: Data conversion errors


While using QUIZ 7.29 on HP e3000 MPE/iX 5.5pp7 I get the above error
message when processing a file.  The process I am performing is to create a
SUBFILE which is an ASCII flat file copy of a dataset on the mainframe.  The
only elements that I believe could be causing these problems are numeric
values which I am formatting for the flat file and seem to contain
non-numeric data.

Is there a way to identify which row or element within row is causing this
problem?

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.