×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
