UNCLASSIFIED: RE: DSTATS bug??

Steve Tennant

UNCLASSIFIED: RE: DSTATS bug??
Thanks Mark, a colleague suggested the same last night, but I get the same
results.

-----Original Message-----
From: Doyle Mark [mailto:[login to unmask email]
Sent: Tuesday, 7 December 2004 02:37
To: [login to unmask email]
Subject: Re: UNCLASSIFIED: DSTATS bug??


Steve,

Try it with the Userid in double quotes: "$YOCMB".BBL_BILL.etc --
haven't tried it but theoretically it should work.

Mark

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Sunday, December 05, 2004 6:07 PM
To: [login to unmask email]
Subject: UNCLASSIFIED: DSTATS bug??


Hi,
(archive search did not help on this one..)

We have a standard which requires an eye catcher in 'DBA' user
ids, this is usually $ or #.

When I run DSTATS with a parameter like:
$YOCMB.BBL_BILL.L_HSE_A_WYBLL_ID,BBL_HSE_WYBLL_ID I get an error saying
INVALID PARAMETER. If I remove the $, I get a message saying unknown
user-id (Which is correct).

Does anyone else have these characters in their user ids and are
you using DSTATS? Do you have a work around?

Regards,

Steve T


************************************************************************
IMPORTANT:

* This transmission is intended for the use of the addressee only and
might contain sensitive or legally privileged information. If you are
NOT the intended recipient, you are notified that any use or
dissemination of this communication is strictly prohibited. If you
receive this transmission in error, please notify the author immediately
by telephone and delete all copies of this transmission together with
any attachments.

* The Australian Customs Service DOES NOT AUTHORISE the recipient to
further disclose this email or its contents without permission of the
originator.

* Unsolicited commercial emails MUST NOT be forwarded to the originator
of this transmission unless prior consent has been given.


***********************************************************************

------------------------------------------------------------------------
---------
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

---------------------------------------------------------------------------------
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

Terry Purcell

Re: UNCLASSIFIED: RE: DSTATS bug??
(in response to Steve Tennant)
Hi Steve,

Make sure you have the latest version of DSTATS that was updated 12 months
ago. This issue "should" now be resolved.

Checkout the download from this site:
http://www-1.ibm.com/support/docview.wss?
rs=64&context=SSEPEK&q1=dstats&uid=swg24001598&loc=en_US&cs=utf-8&lang=en

Regards
Terry Purcell

On Tue, 7 Dec 2004 07:36:37 +1100, [login to unmask email] wrote:

>Thanks Mark, a colleague suggested the same last night, but I get the same
>results.
>
>-----Original Message-----
>From: Doyle Mark [mailto:[login to unmask email]
>Sent: Tuesday, 7 December 2004 02:37
>To: [login to unmask email]
>Subject: Re: UNCLASSIFIED: DSTATS bug??
>
>
>Steve,
>
>Try it with the Userid in double quotes: "$YOCMB".BBL_BILL.etc --
>haven't tried it but theoretically it should work.
>
>Mark
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of [login to unmask email]
>Sent: Sunday, December 05, 2004 6:07 PM
>To: [login to unmask email]
>Subject: UNCLASSIFIED: DSTATS bug??
>
>
>Hi,
>(archive search did not help on this one..)
>
> We have a standard which requires an eye catcher in 'DBA' user
>ids, this is usually $ or #.
>
> When I run DSTATS with a parameter like:
>$YOCMB.BBL_BILL.L_HSE_A_WYBLL_ID,BBL_HSE_WYBLL_ID I get an error saying
>INVALID PARAMETER. If I remove the $, I get a message saying unknown
>user-id (Which is correct).
>
> Does anyone else have these characters in their user ids and are
>you using DSTATS? Do you have a work around?
>
>Regards,
>
>Steve T
>
>
>************************************************************************
>IMPORTANT:
>
>* This transmission is intended for the use of the addressee only and
>might contain sensitive or legally privileged information. If you are
>NOT the intended recipient, you are notified that any use or
>dissemination of this communication is strictly prohibited. If you
>receive this transmission in error, please notify the author immediately
>by telephone and delete all copies of this transmission together with
>any attachments.
>
>* The Australian Customs Service DOES NOT AUTHORISE the recipient to
>further disclose this email or its contents without permission of the
>originator.
>
>* Unsolicited commercial emails MUST NOT be forwarded to the originator
>of this transmission unless prior consent has been given.
>
>
>***********************************************************************
>
>------------------------------------------------------------------------
>---------
>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
>
>---------------------------------------------------------------------------
------
>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