Try this:
SELECT f1.f2.etc. from Datafile where substr(OrderQty,1,1) = x'40'
Replace the f1,f2,etc with field names from the file, but not the OrderQty
which SQL will see as invalid data.

On Mon, Feb 11, 2013 at 11:34 AM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

I have a file with hex '40' spaces in a field OrderQty defined to DDS as
pack numeric.

I am using SQL to read the file and SQL croaks when it reads these nasty
invalid records.

Is it possible to filter out these records in SQL?

For example something like:

SELECT * from Datafile where left(OrderQty,1) = *blanks

Here is the SQL error:
Data mapping error on member SQLTEMP1.
A data mapping error occurred on field OrderQty in

1 -- There is data in a decimal field that is not valid.

This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page