Re: SQL with concantenate:

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Thank Rob.  We've narrowed it down to it only failing when the SQL is 
part of a web page.  I works when you use  System i Nav SQL scripts ( I 
did not know that when I posted it, just tried it ) and Squirrel.

I suspect we have an issue with the SQL interface in the web server at 
this point.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 7/8/2013 8:39 AM, rob@xxxxxxxxx wrote:
> Instead of any cool tool use DSPFFD on this table.  Paste the full
> definition of both the original columns.  Field type, size, CCSID,
> everything.
>
> Any warnings, etc from the joblog?
>
> This works:
> CREATE TABLE ROB/JIMO (FRBKNBR DEC (7 , 0), FRBKRQST DEC (5 , 0),
> FRBKNBRA CHAR (7 ), FRBKRQSTA CHAR (5 ))
>
> INSERT INTO ROB/JIMO VALUES(1, 1, '1', '1')
>
> SELECT FRBKNBR as REQ,
> FRBKRQST as RQST,
> (FRBKNBR || ' - ' || FRBKRQST) as DESCRIPTION
> from rob/jimo
>
> ....+....1....+....2....+....3..
>        REQ     RQST   DESCRIPTION
>          1        1   1 - 1
> ********  End of data  ********
>
> That was concatenating the numerics.
>
>
>
>
> Rob Berendt
> -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 
> 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 
> 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: Jim 
> Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx> To: Midrange Systems 
> Technical Discussion <midrange-l@xxxxxxxxxxxx>, Date: 07/08/2013 09:29 
> AM Subject: SQL with concantenate: Sent by: 
> midrange-l-bounces@xxxxxxxxxxxx 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