Re: AW: SQL with concantenate:

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Thanks Brigitta, we did try that, it fails too.   We also just found it 
only fails when it comes from the web site, not when run natively.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 7/8/2013 8:43 AM, Birgitta Hauser wrote:
> What if you replace the double pipe with CONCAT?
> (The double pipe is not international and may cause some problems)
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von:midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jim Oberholtzer
> Gesendet: Monday, 08.7 2013 15:32
> An: Midrange Systems Technical Discussion
> Betreff: SQL with concantenate:
>
> 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
>
> --