Re: SQL .. samples...

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Hi, Tim, I recommend going to <www.iseries.ibm.com/db2>, where you can find 
a number of things. I think thisi sone of the best-kept secrets on IBM web 
sites, BTW. On the main page there is a link to "Coding Examples".

Some books can be found at iseriesnetwork.com and elsewhere.

As far as other examples, they convert fairly easily to AS/400 SQL - there 
is a standard, after all, that each platform hohors, for the most part. 
Sometimes the difference is merely removing a semicolon from the end of a 
statement. Other areas that have some differences are in date calculations.


At 12:51 PM 1/20/03 -0800, you wrote:
> I was wondering if anybody would be interested in posting SQL statements
> they have used in the past, that goes beyond the basic select statement.  I
> would like to use SQL for more complicated queries, but my knowledge is
> limited in what it can really do...  I have looked through the red books,
> but all I see our the keywords and not any real examples.  And when I try
> some of the examples I see on the web pages in the world, they work for MS
> sql, but not our DB2 flavor.
>
> Ideas,  (case, unions, subselects, pivots)
>
> Or whats the best iseries sql book, with nice examples...
>
> Thanks, tim