Stored Procedures

[2803stan]

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]

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]

28******@gmail.com wrote:

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?

Google? Type: DB2 Development Center

Cheers
Serge

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