Re: SQL Field Selection

[Neil Palmer <NPalmer@xxxxxxxxxxx>]

Dave Mahadevan wrote:
> 
> Neil Palmer wrote:
> 
> > Dave,
> >
> > The trick with the two stroke thing is to use the correct oil/gas
> mix ratio.   :)
> >
> > ...Neil
> >
> 
> 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).    You prompt
> the select *
> from filea and then hit the F4 on select fields.  Now you should be
> able to pick
> fields by placing a number against the field.  It now allows only one
> selection.  It
> gives message SQL6318 (Only one selection allowed).  Previously you
> could pick any
> number of fields.  I cant remember which PTF did this.  Do you know
> (The list has
> designated you the official PTF chap?)  I am on V3R2 on the last CUM
> package 97126.
> 
> I wonder if IBM is subtly putting in such irritations to force us V3R2
> cheapos to
> move up ;-)


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).

For RISC models, APAR SA60910 shows SF38423 (V3R6M0 - not on a cum
package) and SF38008 (V3R7M0 - this for some reason DID make it to a cum
package - C7042370).

Here's the detail from APAR SA60867:



Item SA60867

  APAR Identifier ...... SA60867       Last Changed..97/08/18  
  SQL-MSGSQL6318-F/QSQICOLL FROM COLUMN SELECTION DISPLAY
 
 
  Symptom ...... IN INCORROUT         Status ........... CLOSED  PER
  Severity ................... 3      Date Closed ......... 97/01/10
  Component .......... 5763SS1DB      Duplicate of ........
  Reported Release ......... 320      Fixed Release ............ 999
  Component Name 5763 OS/400 DAT      Special Notice
  Current Target Date ..97/01/24      Flags
  SCP ...................
  Platform ............
 
  Status Detail: SHIPMENT - Packaged solution is available for
                            shipment.
 
  PE PTF List:
 
  PTF List:
  Release 320   : SF42820 available 97/08/18 (1000 )
 
 
  Parent APAR:
  Child APAR list: SA60910
 
 
  ERROR DESCRIPTION:
  THIS APAR WAS SYSROUTED TO R370 SA60910.
   When in an interactive SQL session and prompting on column
   selection and sequencing for a SELECT statement only one
   column is allowed to be selected.
   MSGSQL6318 F/QSQICOLL X/085D T/QSQICOLL X/085D is received.
 
  Additional symptom:
   Prompt of SQL UPDATE of a file that contains a period in the
   name will fail with msgSQL6314. For example, "FP.OPEND".
 
 
  LOCAL FIX:
 
 
  PROBLEM SUMMARY:
  FROM interactive SQL (ISQL), the user prompts (F4) on the
  "SELECT columns" field from the SELECT prompt screen.  When the
  user tries to select more than one column name, the error
  MSGSQL6318 (Only one selection allowed) is issued.  The user
  should be able to select more than one column from this prompt
  screen.  Only one user on this system is encountering this
  problem.
 
 
 
 
  PROBLEM CONCLUSION:
  Interactive SQL (ISQL) has been changed to always allow the
  selection of more than one column name when appropriate.
 
  NOTE:  If a user's session only allows one column to be selected
        prior to applying this PTF, the user will need to reset
        their session.  To reset their session, the user will
        be required to press the prompt key (F4) from the "ISQL
        Statement Entry" screen.
 
  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 Palmer                                      AS/400~~~~~      
... NxTrend Technology -Canada       ____________          ___  ~     
... Thornhill, Ontario, Canada       |OOOOOOOOOO| ________  o|__||=   
... Phone: (905) 731-9000 x238       |__________|_|______|_|______)   
... url:http://www.NxTrend.com        oo      oo   oo  oo   OOOo=o\   
... mailto:NPalmer@NxTrend.com     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+---
| 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
+---