Re: Example

[Doug Palme <DPalme@xxxxxxxxxxx>]

   ooooooooo Rob you used the death word there :)

   From:     rob@xxxxxxxxx                                                    
   To:       Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>  
   Date:     08/15/2008 11:49 AM                                              
   Subject:  Re: Example                                                      

     ----------------------------------------------------------------------

   > CREATE TABLE ROB.DOUGIE
    (MYKEY INT NOT NULL AS IDENTITY,
     MYDATA CHAR (5 ) NOT NULL WITH DEFAULT,
    PRIMARY KEY (MYKEY))
    Table DOUGIE created in ROB.
   > INSERT INTO ROB.DOUGIE (MYDATA) VALUES('TEST')
   > INSERT INTO ROB.DOUGIE (MYDATA) VALUES('ALPHA')
   > SELECT * FROM ROB.DOUGIE
   ....+....1....+....2..
          MYKEY   MYDATA
              1   TEST
              2   ALPHA
   ********  End of data  ********

   Rob Berendt
   --
   Group Dekko Services, LLC
   Dept 01.073
   Dock 108
   6928N 400E
   Kendallville, IN 46755
   http://www.dekko.com

   Doug Palme <DPalme@xxxxxxxxxxx>
   Sent by: midrange-l-bounces@xxxxxxxxxxxx
   08/15/2008 12:23 PM
   Please respond to
   Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

   To
   Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
   cc

   Subject
   Example

     I am looking for an example of a sql statement that I can use in a
   CREATE
     TABLE that will auto_increment a fields numeric value....as in a
   primary
     key field.

     Does anyone have an example I can use? I have been trying to come up
   with
     one from the SQL reference book, but I not getting it coded correctly.
     This transmission may contain information that is privileged,
   confidential
     and/or exempt from disclosure under applicable law. If you are not the
     intended recipient, you are hereby notified that any disclosure,
   copying,
     distribution, or use of the information contained herein (including any
     reliance thereon) is STRICTLY PROHIBITED. If you received this
     transmission in error, please immediately contact the sender and
   destroy
     the material in its entirety, whether in electronic or hard copy
   format.
     Thank you.
   --
   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.

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

   This transmission may contain information that is privileged, confidential
   and/or exempt from disclosure under applicable law. If you are not the
   intended recipient, you are hereby notified that any disclosure, copying,
   distribution, or use of the information contained herein (including any
   reliance thereon) is STRICTLY PROHIBITED. If you received this
   transmission in error, please immediately contact the sender and destroy
   the material in its entirety, whether in electronic or hard copy format.
   Thank you.