Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stephenraj

    Hi, I want to know whether au

    Hi, I found the syntax for auto_increment column while creating the table. I want to know whether this auto_increment supports properties like INITIAL VALUE, INCREMENT VALUE, etc.. (similar to Cloudscape or IBM DB2)????????????? This is urgent, pls try to make it soon. Regards, Stephenraj
  2. stephenraj

    Hi, I want to know whether au

    Hi, I want to know whether auto increment column is supported in MySQL or Not? For example this is equivalent to IDENTITY column and sequence in case of IBM DB2. If this is supported in MySQL(either IDENTITY or SEQUENCE, or both) please provide the exact syntax for creating, altering...
  3. stephenraj

    How to get Sequence names from the DB2 database.

    Hi Sathyaram, Thanx a lot for for ur valuable help. Regards, stephenraj
  4. stephenraj

    About the sequence support.

    Hi Fernando, Thanx a lot for ur valuable information. I will try to get the Fixpaks. Regards, stephenraj
  5. stephenraj

    About the sequence support.

    Hi, Could u please tell me that sequences are supported in which version of IBM DB2. Right now IBM DB2 Universal Database Version - 7 is installed in my machine. Is Sequences supported in this version or not?? Please respond me immediately, Regards, stephenraj
  6. stephenraj

    How to get Sequence names from the DB2 database.

    Hi, How to retrieve the sequence names from the db2 database. It is retrieved by use of tables like USER_SEQUENCE and ALL_SEQUENCES in case of oracle. How it is done in case of DB2. If i can get the exact the SQL Statement for both these tables it is well and good. Please reply me...
  7. stephenraj

    About SERIAL datatype in Informix

    Hi Shriyan, I have asked for auto increment column support in Informix database, u have given a solution of a datatype called serial, thanks for the same. In ur example u have created a temporary table. Example Given by You. -------------------- create temp table tab1 (f1 serial) with no...
  8. stephenraj

    Support for Auto Increment Column.

    Hi, Thanks for your reply, 1. To add on , is the serial column applicable only for the temporary tables? 2. Can we alter a serial column, if so can i just get the corresponding alter statement Regards Stephen

Part and Inventory Search

Back
Top