472,958 Members | 1,984 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

Source code resource

Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.
Nov 12 '05 #1
7 1664
"Bob Stearns" <rs**********@charter.net> wrote in message
news:Xx******************@fe02.lga...
Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other users
have learned.


There some examples in the samples directory. However, I would look at DB2
books on the subject to get a better of idea of good coding practices. Try
searching Amazon.
Nov 12 '05 #2
> Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.


Yep, this is a major issue with db2, and many other products as well.
But in the case of db2 it is particularly inexcusable - give that the
product is over twenty years old.

If you're using db2 for zos then there's a shared source library
somewhere on the ibm site.

If you're not, then the db2 cookbook is probably your best bet. It's
extremely good, the best db2 resource available for any money in my
opinion, and it's a free download off the web:
http://ourworld.compuserve.com/homep...l/HTM_COOK.HTM

buck

Nov 12 '05 #3
"Buck Nuggets" <bu*********@yahoo.com> wrote in message

Yep, this is a major issue with db2, and many other products as well.
But in the case of db2 it is particularly inexcusable - give that the
product is over twenty years old.

If you're using db2 for zos then there's a shared source library
somewhere on the ibm site.

If you're not, then the db2 cookbook is probably your best bet. It's
extremely good, the best db2 resource available for any money in my
opinion, and it's a free download off the web:
http://ourworld.compuserve.com/homep...l/HTM_COOK.HTM

buck


The DB2 cookbook doesn't seem to have much for procedures, functions, and
triggers as requested by the OP. There are some good books on the subject,
but they are generally not free.
Nov 12 '05 #4
Buck Nuggets wrote:
Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.

Yep, this is a major issue with db2, and many other products as well.
But in the case of db2 it is particularly inexcusable - give that the
product is over twenty years old.

If you're using db2 for zos then there's a shared source library
somewhere on the ibm site.

If you're not, then the db2 cookbook is probably your best bet. It's
extremely good, the best db2 resource available for any money in my
opinion, and it's a free download off the web:
http://ourworld.compuserve.com/homep...l/HTM_COOK.HTM

buck

Thank you, looks good.
Nov 12 '05 #5
> The DB2 cookbook doesn't seem to have much for procedures, functions, and
triggers as requested by the OP. There are some good books on the subject,
but they are generally not free.


Well, this subject could be an entire book by itself - and Paul Yip did
produce one. Haven't seen this book, but have heard it was good.

Still, the book Graeme Birchall has been updating it a couple of times
a year, and in the last few years has been adding substantial chapers
on stored procedures, udfs, recursion, and triggers. Am looking for a
detailed chapter on SPL.

buck

Nov 12 '05 #6
My sqllib\samples directory is full of sample code. Also, try

http://www.developer.ibm.com/isv/tech/sampdb2.html

http://www-306.ibm.com/software/data...8/samples.html

Larry Edelstein

Bob Stearns wrote:
Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.

Nov 12 '05 #7
Bob Stearns wrote:
Does any one know of a source of (preferably DB2) sql code examples:
triggers, functions, procedures etc.? While it is all doable using the
manuals and the product, it would be much simpler to see what other
users have learned.


i have the 2nd edition of the procedure book from IBM, prentice hall. i
found it quite good. skip the first edition, if you happen across one.
not so good.

Bob
Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

188
by: Ilias Lazaridis | last post by:
I'm a newcomer to python: - E01: The Java Failure - May Python Helps? http://groups-beta.google.com/group/comp.lang.python/msg/75f0c5c35374f553 - I've download (as suggested) the python...
9
by: Michael Dekson | last post by:
Hello, Can I exe file made in Microsoft Visual C++ decompile into source code. If it is possibly please tell me how. Thanks
14
by: Hugh Cowan | last post by:
Hello, I am looking at getting a simple compiler for Windows that I can use to play around with different Open Source software. I am not a full-time programmer (anymore), nor do I plan to...
1
by: LidorP | last post by:
Hello All, My problem is as follows: I have an assembly which holds a number of WebForms. In order to use these WebForms in my WebApplication i have to extract them out of the assembly (using...
1
by: Samuel R. Neff | last post by:
Are there any tools available to parse source code and extract strings to an external resource file, replacing the string by a resource retrieval? Thanks, Sam
5
by: anon | last post by:
I am relatively new to vb.net having used vb4/5/6 for a while, and wonder if there are any good websites with sample code. I have located a couple, but their samples are limited. I would...
3
by: Jackie | last post by:
Hi all, I am new to visual c++, and found that each C++ project automatically generates source files and resource files, what are their roles, respectively? Thanks a lot.
135
by: Xah Lee | last post by:
Tabs versus Spaces in Source Code Xah Lee, 2006-05-13 In coding a computer program, there's often the choices of tabs or spaces for code indentation. There is a large amount of confusion about...
16
by: graham.keellings | last post by:
hi, I'm looking for an open source memory pool. It's for use on an embedded system, if that makes any difference. Something with garbage collection/defragmentation would be nice. It should have...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.