Hello Oleg,
Sunday, August 12, 2001, 12:17:43 AM, you wrote:
ON> Hello Oleg,
ON> On Saturday 11 August 2001 15:25, Oleg V Alexeev wrote:
>> Hello Oleg,
>>
>> Saturday, August 11, 2001, 1:18:29 AM, you wrote:
>>
>> ON> On Friday 10 August 2001 20:06, Oleg V Alexeev wrote:
>> >> I add test table and class to my testing environment. Table with
>> >> sequence generator under DB2.
>> >>
>> >> Sequence key-generator -
>> >>
>> >> <key-generator
>> >> name="SEQUENCE"
>> >> alias="test_seq"/>
>>
>> ON> Is "test_seq" the name the sequence?
>>
>> For my mind, DB2 has not named sequences as for Oracle... Every
>> sequence in table specific.
ON> Below is an example of sequence creation provided by Pierre Andersson,
ON> who proposed to add support for DB2 in SEQUENCE key generator and sent me his
ON> code for that, I slightly refactored it and committed to CVS.
ON> I guess Pierre is on vacation now, that is why I asked you to test.
ON> CREATE SEQUENCE tablename_seq
ON> � � � START WITH 1
ON> � � � INCREMENT BY 1
ON> � � � NOMAXVALUE
ON> � � � NOCYCLE
ON> � � � CACHE 24;
Wow! Its first time I here about it.
I'l try it some days later - now I am on vacation too... 8)
--
Best regards,
Oleg mailto:[EMAIL PROTECTED]
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
