BMC Catalog Manager question: Moving back between LOB T/S & Aux t/s

PK Ganapathy

BMC Catalog Manager question: Moving back between LOB T/S & Aux t/s
HI,

Is there a one-line command like AUXTS or TS or TB within BMC Catalog
Manager, that will allow me to switch back and forth between a LOB
auxilliary table and its regular "parent" table?

Currently, I use the DDL command on the auxilliary table to find the parent
table(one that occures after the STORES keyword).

I tried searching using the CMD command to see the list of commands, but
did not find any referencing LOBs.

We are using BMC Catalog Manager Version 7.2.01. We plan to upgrade to
7.4.01 soon.

Thanks,
-PK.Ganapathy
IBM Certified v8.1 DBA for z/OS & LUW

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: BMC Catalog Manager question: Moving back between LOB T/S & Aux t/s
(in response to PK Ganapathy)
If you're looking at the LOB table, you can enter XT to get the corresponding
AUX table. I couldn't find anything for going the other way, although I
didn't look too closely.

Tina

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
P K.Ganapathy
Sent: Tuesday, January 18, 2005 2:09 PM
To: [login to unmask email]
Subject: [DB2-L] BMC Catalog Manager question: Moving back between LOB T/S &
Aux t/s

HI,

Is there a one-line command like AUXTS or TS or TB within BMC Catalog
Manager, that will allow me to switch back and forth between a LOB
auxilliary table and its regular "parent" table?

Currently, I use the DDL command on the auxilliary table to find the parent
table(one that occures after the STORES keyword).

I tried searching using the CMD command to see the list of commands, but
did not find any referencing LOBs.

We are using BMC Catalog Manager Version 7.2.01. We plan to upgrade to
7.4.01 soon.

Thanks,
-PK.Ganapathy
IBM Certified v8.1 DBA for z/OS & LUW

-----------------------------------------------------------------------------
----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

PK Ganapathy

Re: BMC Catalog Manager question: Moving back between LOB T/S & Aux t/s
(in response to Tina Hilton)
Thanks Tina.
That was what I was looking for.

-PK.

On Tue, 18 Jan 2005 14:49:53 -0500, Hilton, Tina <[login to unmask email]>
wrote:

>If you're looking at the LOB table, you can enter XT to get the
corresponding
>AUX table. I couldn't find anything for going the other way, although I
>didn't look too closely.
>
>Tina
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of
>P K.Ganapathy
>Sent: Tuesday, January 18, 2005 2:09 PM
>To: [login to unmask email]
>Subject: [DB2-L] BMC Catalog Manager question: Moving back between LOB T/S
&
>Aux t/s
>
>HI,
>
>Is there a one-line command like AUXTS or TS or TB within BMC Catalog
>Manager, that will allow me to switch back and forth between a LOB
>auxilliary table and its regular "parent" table?
>
>Currently, I use the DDL command on the auxilliary table to find the parent
>table(one that occures after the STORES keyword).
>
>I tried searching using the CMD command to see the list of commands, but
>did not find any referencing LOBs.
>
>We are using BMC Catalog Manager Version 7.2.01. We plan to upgrade to
>7.4.01 soon.
>
>Thanks,
>-PK.Ganapathy
>IBM Certified v8.1 DBA for z/OS & LUW
>
>---------------------------------------------------------------------------
--
>----
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-
l.org.
>The IDUG List Admins can be reached at [login to unmask email]
Find
>out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>
>---------------------------------------------------------------------------
------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm