Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / January 2006

Tip: Looking for answers? Try searching our database.

Stored Procedures

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
2803stan@gmail.com - 24 Jan 2006 23:46 GMT
In the past I spent hours and hours and hours writing, editing and
compiling stored procedures (I am not a pro).  It could take me two
days to get a single stored procedure to work.

Then came the revolutionalry Development Center.  On one single window
(UDB for Windows 32) came about eight different panes with bewildering
names and no function.  There was always, and I mean always, an error
message.

Now there is the new Development Center in Windows v8.2 which has even
more panes (it seems to me), almost all of them hidden.  There is no
way to know where a particular SP is stored, and that causes lack of
ability to find a "Project," whatever that is -- as it is different
from a database Project, but the same name is used.

Clicking on almost anything brings up a psychedelic whirl of more and
more panes, none of which mean anything reasonable.  It is also written
in Java, the worst thing ever to happen to programming.  This means
that, when one is obviously in the wrong pane, pressing anything causes
everything to hang.

I have asked in this forum (and I see that others have also asked) for
a reference to an explanation of this GUI, but no one has ever
answered.

Are stored procedures only for the cognoscenti of DB2, or may we
ordinary folk enter into the inner sanctum too?  If so, where do I get
initiated into the mysteries of the Development Center?

Those who know Die Zauberflaute have a feeling for what I mean.  Where
is my magic flute?
Eugene F - 25 Jan 2006 03:27 GMT
IMHO, the DB2 V8.1.x Development Center is kind of cumbersome (the
V7.2's one was better to me in that sense). So, if you don't like the
DC as it is, you better use scripts and the DB2 application development
client (ADCL) software for your development platform and, by the way,
you'll have more flexibility  for create/deploy your stored procedures
than the DC provides (I found some of commands behind build/deploy are
just hardcoded in the DC and not customize-able at all). There are
plenty of samples in $INSTHOME/sqllib/samples/sqlproc that'll help you
being the templates for creating/buildiing your stored procedure
scripts. However, the DC gives you the DB2 stored procs debugger which
is a unique facility that no other vendor provides (AFAIK).

Regards
-Eugene
Serge Rielau - 25 Jan 2006 07:58 GMT
> In the past I spent hours and hours and hours writing, editing and
> compiling stored procedures (I am not a pro).  It could take me two
[quoted text clipped - 27 lines]
> Those who know Die Zauberflaute have a feeling for what I mean.  Where
> is my magic flute?

Google? Type: DB2 Development Center

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.