SQL Statement failing in COBOL program

[MichaelQuigley@xxxxxxxxxx]

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