MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2013

Re: SQL with concantenate:



fixed

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





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact