467,925 Members | 1,880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

Simple SQLj question ....

UDB V8.1.3 on XP. While trying out SQLj procedures, I just 'compile'
my stored procedure code (by command sqlj program-name.sqlj) and run
it. That's it. So, how and when is db2profc and all the other commands
needed? The stored procedure seems to run without executing these
commands as well. In fact, I experience no difference between methods
of preparing JDBC or SQLj procedures other than the fact that JDBC
procedures are compiled with 'javac' command (as opposed to 'sqlj'
command for SQLj procedures.

What am I missing.

TIA
Raquel.
Nov 12 '05 #1
  • viewed: 1320
Share:
2 Replies
Raquel wrote:
UDB V8.1.3 on XP. While trying out SQLj procedures, I just 'compile'
my stored procedure code (by command sqlj program-name.sqlj) and run
it. That's it. So, how and when is db2profc and all the other commands
needed? The stored procedure seems to run without executing these
commands as well. In fact, I experience no difference between methods
of preparing JDBC or SQLj procedures other than the fact that JDBC
procedures are compiled with 'javac' command (as opposed to 'sqlj'
command for SQLj procedures.

What am I missing.

TIA
Raquel.


Trying to remember way back with my teeny brain, but I believe that if
you don't run db2profc to customize the generated serialized profiles
that the sqlj command produces, you're effectively running your stored
procedure as a JDBC stored procedure.

db2profc is the command that actually creates and binds the static
packages in the database, theoretically increasing the execution of any
SQL in your SQLJ procedure. Otherwise everything reverts back to being
dynamically prepared and executed.

I /think/ that's what you're missing. But I reserve the right to be wrong :)

Dan
Nov 12 '05 #2
Thanks Ron. Believe you are correct.

Regards,
Raquel.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Paul Reddin | last post: by
reply views Thread by Bernard Dhooghe | last post: by
10 posts views Thread by Raquel | last post: by
12 posts views Thread by Rhino | last post: by
7 posts views Thread by Jean-Marc Blaise | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.