David Gibbs wrote:
Anyone know where I can find information on the structure of the
data area created for an SQL Sequence?

I need to figure out how to de-construct a sequence.

The *DTAARA object which /implements/ the sequence, because it is merely an implementation object, is AFaIK documented only internal to IBM. As implementations are subject to change, dependencies coded to an implementation may be adversely impacted by any changes, and any external documentation of the implementation object made generally available would probably dictate the implementation does not change due to possible coded dependencies. If information is required of the SQL sequence, the database SQL interfaces provided to access details about the sequence should be utilized & referenced. For example, there is the SYSSEQ catalog VIEW in QSYS2.

Regards, Chuck

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].