public class DB_Sequence
extends java.lang.Object
Constructor | Description |
---|---|
DB_Sequence() |
Modifier and Type | Method | Description |
---|---|---|
private static java.lang.String |
createSequenceString(java.lang.String fullName,
java.lang.String dataTypeName,
long startValue,
long minimumValue,
long maximumValue,
long increment,
java.lang.String cycleOption) |
Generate DDL for a specific sequence.
|
static void |
doSequences(java.sql.Connection conn) |
Generate the DDL for all sequences and output it via Logs.java.
|
private static java.lang.String |
stripNotNull(java.lang.String datatypeName) |
Strip the trailing NOT NULL off of the string representation of a datatype
|
public static void doSequences(java.sql.Connection conn) throws java.sql.SQLException
Generate the DDL for all sequences and output it via Logs.java.
conn
- Connection to the source database.java.sql.SQLException
private static java.lang.String stripNotNull(java.lang.String datatypeName)
private static java.lang.String createSequenceString(java.lang.String fullName, java.lang.String dataTypeName, long startValue, long minimumValue, long maximumValue, long increment, java.lang.String cycleOption) throws java.sql.SQLException
Generate DDL for a specific sequence.
fullName
- Fully qualified name of the sequencedataTypeName
- Name of the datatype of the sequencestartValue
- First value to use in the range of the sequenceminimumValue
- Smallest value in the rangemaximumValue
- Largest value in the rangeincrement
- Step size of the sequencecycleOption
- CYCLE or NO CYCLEjava.sql.SQLException
Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.