| Author |
Message
|
| ydsk |
 Posted: Tue May 31, 2005 6:19 am Post subject: How to create a catalog in "Throw User Exception" |
 |
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Can somebody give me some sample code for creating a catalog ? We are trying to use one in "throw user exception" statements. There is no documentation available on how to create one. I know the default catalog uses message numbers between 3051 and 3099.
I know the catalog is optional and we can work without it. But I want to know the feature. Also, the message flows manual says ( page 406 ) it is a file and we can provide a fully qualified file name in a trace node, for example.
Appreciate any help.
Thanks. |
|
| Back to top |
|
 |
| RocknRambo |
| Posted: Tue May 31, 2005 6:26 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
I dont understand...how exactly the Catalog helps...when reading the failure trace...
wanna try this...
THROW USER EXCEPTION CATALOG 'WMQIv210' MESSAGE 2949 VALUES('The SQL State: ', SQLSTATE, 'The SQL Code: ', SQLCODE, 'The SQLNATIVEERROR: ', SQLNATIVEERROR, SQLERRORTEXT ) ;
-RR |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 31, 2005 6:31 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| ydsk |
| Posted: Tue May 31, 2005 6:31 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Hi,
I think what you mentioned is the default catalog. I am not looking for it because even if you don't specify anything it assumes the default product catalog.
Let me re-phrase my question: Does anyone know how to create a catalog ?
Thanks in advance. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 31, 2005 6:32 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
See the help link I posted (apparently simultaneously while you were posting).
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Tue May 31, 2005 6:49 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| There is no documentation available on how to create one |
You can also find instructions in the v2.1 Programming Guide, page 100. |
|
| Back to top |
|
|
| ydsk |
| Posted: Tue May 31, 2005 7:27 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Jeff,
Thanks very much for the information. I wouldn't have found it if you hadn't sent the link.
But it talks about Windows platform only. Is there documentation on how to create a catalog on unix ? All our brokers are on AIX.
Please let me know.
Thanks. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 31, 2005 7:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
JT's link has more instructions on building XPG4 catalogs.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ydsk |
| Posted: Tue May 31, 2005 7:44 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Ok thanks.
Let me go through it and get back to this forum if I have more questions.
But I still have a question now...As I understand it, the catalog can be used in esql / C plug-in / java plug-in.
The esql catalog should be independent of platform. Right ? Correct me if I am wrong.
Thanks. |
|
| Back to top |
|
|
|
|
