SQL Statement failing in COBOL program

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