Re: Ruh Roh, STRSQL

[Luis Rodriguez <luisro58@xxxxxxxxx>]

OK, got it.

As I see it, the prompter does not support a lot of things (at least on
V5R3). Try to do a CREATE TABLE AS, or a CTE. Total failure. In fact, even
the iSeries Nav wizard (mine is V5R4) isn't very good either (try to do a
complex join).

Thanks for the explanation.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Jan 17, 2011 at 6:05 PM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

> Alan wrote:
>  They haven't made any changes that I know of for forever.
>  It still doesn't support ansi joins and that would be so simple to add.
>
> Then Luis wrote:
>  Excuse my ignorance but, how do ANSI joins differ from DB2's?
>  I thought that DB2, from V5R4 (IIRC) was 100% ANSI compatible...
>
>
>
> Luis -
>
> I think what Alan really intended to say is that the /prompter/ in STRSQL
> does not support ANSI joins.  However, if you know the correct syntax you
> can type in the ANSI query and run it within STRSQL...
>
> - sjl
>
>
>
>
>
>
>
>
>
> --
> 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.