by: Hans-Dieter Franz |
last post by:
Hello,
I have a problem with a Java user-defined stored procedure
and the "alter sequence" statement. I use DB2 8.1.2 and had the
same problem with 8.1.0, but not with 7.*.
I get the following...
|
by: gimme_this_gimme_that |
last post by:
Hi,
I Oracle one can have :
select to_char(a_id_seq.nextval,'0000') from dual
Which fetches a sequence value and pads it with zeros
on the left. When the sequence value is more than
4...
|
by: Shea Martin |
last post by:
I am moving my database from a machine running 7.4 to a machine running 7.2. My
sequences are not out of wack, is there a way to set the current value of a
sequence? I though ALTER SEQUENCE would...
|
by: Oscar Tuscon |
last post by:
I'm looking at ways to get batches of sequence values s faster. I don't want to set cache or increment to a large number for a variety of reasons. I need to grab id's in batches of varying numbers at...
|
by: Sim Zacks |
last post by:
I am in the process of converting an existing database to PostGreSQL
and wrote a generic script to update all of the sequences as they default at 1.
I thought it would be useful to other people who...
|
by: tojigneshshah |
last post by:
Hi,
How to restart sequence number once the data is imported/loaded into
the tables?
Please advise.
regards
Jignesh
|
by: zgh1970 |
last post by:
Hi,
We have some tables with db2 generated field.
How can I find the next generated sequence fot those fields.
Thanks,
|
by: wmos4995 |
last post by:
Hi,
I am writing a procedure to alter the value of a sequence to max value of the table column.
This is what i have written till now.
CREATE PROCEDURE RESET_SEQ
(
IN TABNAME VARCHAR(50),...
|
by: Mikelowe |
last post by:
Would like to know is there an automated way to copy the maxvalue of sequence number from db2 production to db2 test.
When we copy data from our production that uses a sequence number value as its...
|
by: asiangirl |
last post by:
I am doing db2 database migration to 10.5 from 9.5. After loading data. I'll need to reset all sequence value. I have this shell script produce a file after executing below SQL. But it gave me...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
4
