Re: SQL Field Selection

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Neil Palmer wrote:

> Dave Mahadevan wrote:
>
> >
> > Talking about the two stroke thing, I cant seem to be able to pick
> > more than one
> > field on the fields display on interactive SQL (STRSQL).
>
> PTF SF38007 (V3R2M0) fixes this.  Available 1997/02/11 - but for some
> strange reason it hasn't been placed on a cum PTF package yet (not even
> the latest C7231320).  Actually, SF38007 has been superseded by SF42820
> (available 1997/08/18).
>
>   CIRCUMVENTION:
>   To reset an ISQL session so that the selection of more than one
>   column name is allowed again, do the following:
>
>     - STRSQL <Enter>
>     - CREATE TABLE <F4>
>     - Type in a table name and define 1 column.
>     - Press <F4> to prompt on the column just defined.
>     - Change Column CONSTRAINT to "Y" and press <Enter>.
>     - Press <Enter> to add a constraint.
>     - Change the Type to 3 (FOREIGN KEY) and press <Enter>.
>     - Type in an existing file name for the REFERENCES File and
>       press <F4> from the REFERENCES Column field.
>     - Exit from the CREATE TABLE prompt <F3>.
>

Neil:

Thanks, the circumvention worked (no idea why it does).  I will try to get the
SF42820.  BTW I am curious, how did you get this info?  Does the IBM service 
site
allow for detail search on the APARs? (Probably you need a support line
contract?)  Folks, can we name Neil as the PTF Guru?

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---