Re: SQL with concantenate:

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

> --