Columns name to SeqNameThis is a discussion on Columns name to SeqName within the db2-udb forums in Other Databases category; How to get the sequence name from the table.column name? Assume Column name is primary name. Thanks.... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-25-2007, 04:16 AM
|
 Columns name to SeqName How to get the sequence name from the table.column name? Assume Column name is primary name. Thanks.  |
|
#2
09-25-2007, 05:42 AM
|
| Re: Columns name to SeqName calvinscy-at-hotmail.com wrote: > How to get the sequence name from the table.column name? > Assume Column name is primary name. A sequence is not tied to a column. So could you describe what exactly you mean? -- Knut Stolze DB2 z/OS Utilities Development IBM Germany |
|
#3
09-25-2007, 06:06 AM
|
| Re: Columns name to SeqName Yes! I just confirm this... So sequence number is act more like a GLOBAL variable. It can use by any table any time they want.... B4 that I thought it is tied with column and table. BUT I am wrong...:< Thanks. |
|
#4
09-25-2007, 07:16 AM
|
| Re: Columns name to SeqName calvinscy-at-hotmail.com wrote: > Yes! > I just confirm this... > > So sequence number is act more like a GLOBAL variable. > It can use by any table any time they want.... > > B4 that I thought it is tied with column and table. > BUT I am wrong...:< IDENTITY columns are tied to a table. -- Knut Stolze DB2 z/OS Utilities Development IBM Germany |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 05:33 AM.
