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 1674
"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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |