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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
