Re: What are ways I can use SQL and system commands to compare...

The simple answer is, "Query the catalogs." A more detailed answer
would have comments about using the ANS & ISO catalog VIEWs like
SYSCOLUMNS et al, from the libraries QSYS2 and SYSIBM.

The OP has a history of arguing that DB2 for i5/OS is not a /real/
database. I was unnecessarily curt, given the many past unwarranted
vitriolic comments about the DB2 for i5/OS. So having only alluded to
the ability in /real/ databases, to effect the same type of comparison,
that same action should be investigated first for viability. No reason
to leave the SQL to obtain the answer; since having to, would only give
more ammunition for disparaging the DB2 for i5/OS, because a task
could [only] be accomplished by some i5/OS feature invocation.

http://archive.midrange.com/cgi-bin/htsearch?config=archive&source=&restrict=%2Fmidrange-l&exclude=&format=bultin-long&method=and&sort=score&words=databases+%22dave+odom%22

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer

Mark S. Waterbury wrote:

Can you please enlighten those of us who are not sure what you mean by,
"Just do the same as you would on any real database"?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.