Re: SQL with concantenate:

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Charles:

Good call on the CCSID I'll check that.  CONCAT failed as well.   We 
have narrowed it down to only failing when the SQL comes from the web 
page, not a native interface, so we know it's not the SQL engine.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 7/8/2013 8:43 AM, Charles Wilt wrote:
> Any chance you're doing this on a non-english system?
>
> The pipe , |, character is not one of the invariant characters and is thus
> not supported for every CCSID.
>
> Try using the CONCAT function instead.
>
> Charles
>
>
> On Mon, Jul 8, 2013 at 9:31 AM, Jim Oberholtzer<midrangel@xxxxxxxxxxxxxxxxx
> > >  wrote:
> > >  V7R1 with current cumulative and reasonably close groups:
> > >
> > >
> > >  When we try to run a statement with that concatenates fields (in this
> > >  case concatenating a couple fields to form a DESCRIPTION), the result is
> > >  always null. When we remove the || and just return one of the fields
> > >  without any concatenation, it comes back fine.   Both columns are
> > >  defined as DDS character.
> > >
> > >  Example:
> > >
> > >  SELECT FRBKNBR as REQ,
> > >
> > >  FRBKRQST as RQST,
> > >
> > >  (FRBKNBR || ' - ' || FRBKRQST) as DESCRIPTION
> > >
> > >     We get REQ and RQST just fine, but DESCRIPTION comes back as null
> > >
> > >  SQL gurus:  Any thoughts?
> > >
> > >  --
> > >  Jim Oberholtzer
> > >  Chief Technical Architect
> > >  Agile Technology Architects
> > >
> > >  --