SQL Coding Standards

David (cahoot) Wilson

SQL Coding Standards
> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share
> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Thol Chidambaram

Re: SQL Coding Standards
(in response to David (cahoot) Wilson)
Dave,

Following document might help you.

http://www-5.ibm.com/no/software/data/ug/pdf/ohmulienlah.pdf

Regards
Thol


-----Original Message-----
From: Wilson, David (cahoot) [mailto:[login to unmask email]
Sent: Thursday, December 18, 2003 11:32 AM
To: [login to unmask email]
Subject: SQL Coding Standards

> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share
> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

cliff boley

Re: SQL Coding Standards
(in response to Thol Chidambaram)
Thol,
nice document.
Do you know if its going to be updated for v7/v8??
cliff:-)

-----Original Message-----
From: Chidambaram, Thol [mailto:[login to unmask email]
Sent: Thursday, December 18, 2003 12:04 PM
To: [login to unmask email]
Subject: Re: SQL Coding Standards


Dave,

Following document might help you.

http://www-5.ibm.com/no/software/data/ug/pdf/ohmulienlah.pdf

Regards
Thol


-----Original Message-----
From: Wilson, David (cahoot) [mailto:[login to unmask email]
Sent: Thursday, December 18, 2003 11:32 AM
To: [login to unmask email]
Subject: SQL Coding Standards

> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share
> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Christopher Tee

Re: SQL Coding Standards
(in response to cliff boley)
David

Have you had a look at Graeme Birchall's excellent DB2 UDB SQL Cookbook? I
don't have web access at the moment and I can't remember the URL but a
search on Google should find it.

Chris Tee
DBA Support
IT Service Delivery
Emerald House
Internal Phone No: 7-430-4655
External Phone No: 0207 902 4655
mailto:[login to unmask email]


-----Original Message-----
From: Wilson, David (cahoot) [mailto:[login to unmask email]
Sent: 18 December 2003 16:32
To: [login to unmask email]
Subject: SQL Coding Standards


> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share
> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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


---------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 25 Gresham Street, London, EC2V 7HN. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are authorised and
regulated by the Financial Services Authority and represent only the
Scottish Widows and Lloyds TSB Marketing Group for life assurance,
pensions and investment business.

Signatories to the Banking Codes.
---------------------------------------------------------------------------------------------------------------


---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Philip Gunning

Re: SQL Coding Standards
(in response to Christopher Tee)
On Thu, 18 Dec 2003 16:32:10 -0000, Wilson, David (cahoot)
<[login to unmask email]> wrote:

>> Hi listers,
>> I have been asked to provide a set of SQL coding standards for DB2/AIX
>> and, rather than dream these up from scratch, thought I might find
>> something in either the DB2-L archives or documents. No luck.
>> Can anyone point me to a site that might have such a thing or indeed
share
>> their own with me?
>> Many thanks,
>>
>> David Wilson
>> DBA, Web Support
>> cahoot.com
>> Tel : 01494-835672 (W)
>> 07791-096762 (M)
>>
>>
>>
>
>
>*********************
>Internet communications are not necessarily secure and may be intercepted
or
>changed after they are sent. cahoot does not accept liability for any such
>changes.
>If you wish to confirm the origin or content of this communication, please
>contact the sender using an alternative means of communication.
>
>This communication does not create or modify any contract.
>
>This email may contain confidential information intended solely for use by
>the addressee. If you are not the intended recipient of this communication
>you should destroy it without copying, disclosing or otherwise using its
>contents.
>
>Please notify the sender immediately of the error.
>
>cahoot is a division of Abbey National plc.
>Abbey National plc is registered in England, registered number 2294747.
>Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
>London, NW1 3AN.
>
>---------------------------------------------------------------------------
------
>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". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] 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

David, Checkout the new redbook, DB2 UDB ESE V8 Performance Guide for High
Perfomance OLTP and BI,
http://publib-
b.boulder.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246432.html?Open

Chapter 3, which addresses predicates,index and data sargable predicates,
and best practices for application desin. Rgds, Phil

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Neil Courtney

Re: SQL Coding Standards
(in response to Philip Gunning)
David, Chris,
Graeme's great DB2 Cookbooks can be found here.

http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM
< http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM >




Cheers,
Neil Courtney
IS Consultant
Business Systems Support
TelstraClear
mailto:[login to unmask email]
<mailto:[login to unmask email]>
Ph. 64 09 912-4927
"MG - Life's too short not to"

-----Original Message-----
From: Tee, Christopher [mailto:[login to unmask email]
Sent: Saturday, December 20, 2003 4:46 AM
To: [login to unmask email]
Subject: Re: SQL Coding Standards



David

Have you had a look at Graeme Birchall's excellent DB2 UDB SQL Cookbook? I
don't have web access at the moment and I can't remember the URL but a
search on Google should find it.

Chris Tee
DBA Support
IT Service Delivery
Emerald House
Internal Phone No: 7-430-4655
External Phone No: 0207 902 4655
mailto:[login to unmask email]
<mailto:[login to unmask email]>


-----Original Message-----
From: Wilson, David (cahoot) [ mailto:[login to unmask email]
<mailto:[login to unmask email]> ]
Sent: 18 December 2003 16:32
To: [login to unmask email]
Subject: SQL Coding Standards


> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share

> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or

changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

----------------------------------------------------------------------------
-----
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
< http://www.idugdb2-l.org/archives/db2-l.html > . From that page select "Join
or Leave the list". If you will be out of the office, send the SET DB2-L NO
MAIL command to [login to unmask email] 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
< http://conferences.idug.org/index.cfm >



----------------------------------------------------------------------------
-----------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 25 Gresham Street, London, EC2V 7HN. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are authorised and
regulated by the Financial Services Authority and represent only the
Scottish Widows and Lloyds TSB Marketing Group for life assurance,
pensions and investment business.

Signatories to the Banking Codes.
----------------------------------------------------------------------------
-----------------------------------
----------------------------------------------------------------------------
----- 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". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

&icirc;&eacute;&euml;&agrave;&igrave; &igrave;&eacute;&aacute;&oslash;&icirc;&iuml;

Re: SQL Coding Standards
(in response to Neil Courtney)
Thanks,
i didn't know that such book was exsits.
it looks like a good one.
strongly recommended.




Michael Liberman
Chief DBA
Mivtachim


_____

From: Neil Courtney [mailto:[login to unmask email]
Sent: Sunday, December 21, 2003 10:24 PM
To: [login to unmask email]
Subject: Re: SQL Coding Standards


David, Chris,
Graeme's great DB2 Cookbooks can be found here.

http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM




Cheers,
Neil Courtney
IS Consultant
Business Systems Support
TelstraClear
mailto:[login to unmask email]
Ph. 64 09 912-4927
"MG - Life's too short not to"

-----Original Message-----
From: Tee, Christopher [mailto:[login to unmask email]
Sent: Saturday, December 20, 2003 4:46 AM
To: [login to unmask email]
Subject: Re: SQL Coding Standards



David

Have you had a look at Graeme Birchall's excellent DB2 UDB SQL Cookbook? I don't have web access at the moment and I can't remember the URL but a search on Google should find it.

Chris Tee
DBA Support
IT Service Delivery
Emerald House
Internal Phone No: 7-430-4655
External Phone No: 0207 902 4655
mailto:[login to unmask email]


-----Original Message-----
From: Wilson, David (cahoot) [mailto:[login to unmask email]
Sent: 18 December 2003 16:32
To: [login to unmask email]
Subject: SQL Coding Standards


> Hi listers,
> I have been asked to provide a set of SQL coding standards for DB2/AIX
> and, rather than dream these up from scratch, thought I might find
> something in either the DB2-L archives or documents. No luck.
> Can anyone point me to a site that might have such a thing or indeed share
> their own with me?
> Many thanks,
>
> David Wilson
> DBA, Web Support
> cahoot.com
> Tel : 01494-835672 (W)
> 07791-096762 (M)
>
>
>


*********************
Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
changes.
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its
contents.

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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



---------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 25 Gresham Street, London, EC2V 7HN. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are authorised and
regulated by the Financial Services Authority and represent only the
Scottish Widows and Lloyds TSB Marketing Group for life assurance,
pensions and investment business.

Signatories to the Banking Codes.
---------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------- 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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