Re: SQL with concantenate:

[Alexei Baranov <ABaranov@xxxxxx>]

probably strdbmon can help? you can use it to see real sql statement(s)

Alexei

-------- Original Message --------
Subject : SQL with concantenate:
From    : Jim Oberholtzer midrangel@xxxxxxxxxxxxxxxxx
To      : Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc      : 
Date    : 8 июля 2013 г. 16:48

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
> > >
> > >  --