Re: SQL with concantenate:

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Digging into that now.  I suspect the Web Server is at issue at this point.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 7/8/2013 8:57 AM, Charles Wilt wrote:
> Strange...
>
> How is the web page sending the query?
>
> Charles
>
>
> On Mon, Jul 8, 2013 at 9:48 AM, Jim Oberholtzer<midrangel@xxxxxxxxxxxxxxxxx
> > >  wrote:
> > >  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
> > > > > >  >>  >
> > > > > >  >>  >    --
> > >  --