|
On 10/31/2014 1:03 PM, Daron Whitehouse wrote:
Daron, looks as if I'll have to take another look - was probably
What does IBM Data Studio not find valid about DDS objects? The
Objects are visible to DS when the DB2 for i connection is defined
as using "naming=system" <<SNIP>>
using *SQL naming.
But maybe what I refer to is the list of tables in a library - SQL
statements work fine, no problem there, might be just the list of
things that show tables and indexes and views and not PFs or LFs -
will confirm.
OK, I tried the Database Developer perspective - It does list all
PFs - not sure about those created using CRTPF with RCDLEN.
I saw views - these were the LFs created using DDS.
There were no apparent indexes listed, even if there are key fields
in an LF. This doesn't surprise me - there is no specific SQL index
object in that case. And there are usually no constraints, so those
do not show up either.
<<SNIP>>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.