How to reset auto generated id in a DB2 table

anuritab

Hi
Is there a way to reset the auto generated id for this table. Drop
table and recreating does not work.

Jun 27 '08 #1

Subscribe Post Reply

8458

Mark A

<an******@gmail.comwrote in message
news:eb**********************************@i18g2000 prn.googlegroups.com...

Hi
Is there a way to reset the auto generated id for this table. Drop
table and recreating does not work.

If you have DB2 for LUW, the information you want is in the SQL Reference
Vol 2, under ALTER TABLE. Look at the ALTER COLUMN section and the "RESTART
WITH n" clause.

If you have DB2 for z/OS the SQL Reference is in a single volume (last time
I checked).

If you don't have a SQL Reference manual, you can download a searchable PDF
version for free.

Jun 27 '08 #2

Karl Hanson

Mark A wrote:

<an******@gmail.comwrote in message
news:eb**********************************@i18g2000 prn.googlegroups.com...
>Hi
Is there a way to reset the auto generated id for this table. Drop
table and recreating does not work.

If you have DB2 for LUW, the information you want is in the SQL Reference
Vol 2, under ALTER TABLE. Look at the ALTER COLUMN section and the "RESTART
WITH n" clause.

If you have DB2 for z/OS the SQL Reference is in a single volume (last time
I checked).

If you don't have a SQL Reference manual, you can download a searchable PDF
version for free.

And if you have DB2 for i5/OS (also supports ALTER .. RESTART WITH n),
the SQL Reference is here:
http://publib.boulder.ibm.com/infoce...ode=int_213704

--
Karl Hanson

Jun 27 '08 #3

Similar topics

Auto-Counter Reset

by: Earl Anderson | last post by:

KB Article Q140908 provided the following function to create an Auto Incrementing Counter: Function Next_Custom_Counter () On Error GoTo Next_Custom_Counter_Err Dim MyDB As Database Dim...

Microsoft Access / VBA

What is the largest "auto number" that can exist in an Access database? How to reset autonumber to start at 1?

by: John Baker | last post by:

Hi: I know this is a strange question, but I have inherited a system where files are copied and records re auto numbered (as an index field) )frequently, and I am wondering how high the number...

Microsoft Access / VBA

Reset Auto Number Fields

by: trueblue7 | last post by:

I apologize if this question has been asked before... I'm trying to reset autonumber fields back to 1. The autonumber fields are part of the composite primary keys. I followed the MS help with...

Microsoft Access / VBA

What to do with AUTO-ID column when I add a new record to the data

by: Alpha | last post by:

I retrieve a table with only 2 columns. One is a auto-generated primary key column and the 2nd is a string. When I add a new row to the dataset to be updated back to the database. What should I...

C# / C Sharp

SQL programming. Working with auto-generated data objects.

by: Viorel | last post by:

Working as a beginner with data objects in Visual Studio 2003 and C#, I use the "Generate Dataset" command in order to generate automatically the dataset objects based on data adapters. Generated...

C# / C Sharp

Redefining an auto-generated primary key constraint name

by: danielbuus | last post by:

Hey there :) I'm using Ruby on Rails to create a migration of a legacy database on an MS SQL Server. I'd like to name my constraints myself, such as 'pk_authors', but in the cases where a table...

Microsoft SQL Server

Auto Increment and Reset Number Sequence in a Table

by: Wayne L | last post by:

I have searched and could not find my solution to my problem. I have a table that has a field that I want to start at 0001 and go to 1999. Once it reaches 1999 I want the field to reset to 0001. I...

Microsoft Access / VBA

how to parse data from different tables to creat an auto generated number

by: zimes | last post by:

I am working with Microsoft Access 2003 from the Office XP pro suite. I have created several tables that have to do with Asset tracking along with purchasing. I have a table called Purchasing,...

Microsoft Access / VBA

Re: How to reset auto generated id in a DB2 table

by: Frank Swarbrick | last post by:

>>On 6/10/2008 at 4:30 PM, in message <ebf88f96-d8b0-4dfc-85ed-a3a5c44ae4dd@i18g2000prn.googlegroups.com>, <anuritab@gmail.comwrote: Seems like that would work, unless you are actually using a...

DB2 Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing