RE: Issue with Created Index Where...

Thanks Charles and Rob.

I had a conference handout up (from WMCPA) as well as the SQL reference. The conference handout made no mention of the field issue, and I was a bit baffled b/c all fields were included prior without me specifying "ADD ALL COLUMNS." I suppose I should have read the entire CREATE INDEX entry in the reference manual. Your answers came back much quicker, though.

Back in business.

-Kurt



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, February 23, 2012 2:50 PM
To: Midrange Systems Technical Discussion
Subject: Re: Issue with Created Index Where...

From the manual

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzxcindx.htm

--+---------------------------------------------------+-------->

| .-ADD ALL COLUMNS----------. |
'-RCDFMT--format-name--+--------------------------+-'
+-ADD KEYS ONLY------------+
| .-,---------------. |
| V | |
'-ADD------column-name---+-'


Rob Berendt