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. 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.
> 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
"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.
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.
> 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
|
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...
|
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...
|
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
|
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...
|
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.
|
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...
|
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...
|
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=()=>{
|
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...
|
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...
|
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...
|
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 :...
|
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...
|
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...
|
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...
|
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...
| |