Re: XMLTABLE and fn:string-join

On Wed, Sep 27, 2017 at 4:11 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

On Wed, Sep 27, 2017 at 3:47 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

I know, I was was there :) Haven't gotten the slides from it yet have

you?

It sometimes takes a few weeks after the event for Joe Wood to send out the
presentation materials. I cut him some slack. He's doing a great job with
quality presentations.

​Agreed, wasn't meant as a complaint.​

I don't think so, as
, category1 varchar(100) path 'category[1]'
, category2 varchar(100) path 'category[2]'
, category3 varchar(100) path 'category[3]'
, category4 varchar(100) path 'category[4]'
, category5 varchar(100) path 'category[5]'

works just fine....

Why not use that syntax instead?

​I don't know how many categories might be used.​

I think it's got to due with how I'm invoking the fn:string-join...

Perhaps the i doesn't support it, but I'd expect a different error in

that

case.

In the IBM i Knowledge Center 7.3 I do see references to fn:string-length,
but I don't see fn:string-join.

Sure enough...looks like string-join isn't supported on the i.

string-concat is there, but it won't work in this situation...

Charles​