Jon,

As of V5R3, SQL automatically CASTs values to the appropriate type.
Sometimes that's handy, but it has burned me at times. SQL will CAST
BRQDVA in the first REPLACE function. I believe the result of this would
be a character string.

For reference see, "What's new for V5R3 in the SQL Reference Book" at:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/db2/rbafzmstwhatsnew.htm

It lists, "Implicit conversion between strings and numeric data types".
Under the REPLACE function (around page 396) it states, "A numeric
argument is cast to a character string before evaluating the function."

Michael Quigley
AS/400 Programming Section
The Way International
www.TheWay.org

---------------Original Message---------------


date: Wed, 22 Aug 2007 21:10:14 -0400
from: "Jon Paris" <Jon.Paris@xxxxxxxxxxxxxx>
subject: Re: [COBOL400-L] SQL Statement failing in COBOL program

Maybe I'm just missing something - but how can you replace characters in a
packed field? It doesn't have any.
. . .
. . .
. . .

Jon Paris
Partner400

www.Partner400.com



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.