Why DB2 SQL Stored Procedure Need a C Compiler?

hiolgc · #1 (**permalink**) 04-18-04, 11:01

Hi everyone,

Why DB2 SQL stored Procedure need a c compiler? What's the reason for this setting and its advantage (or disadvantage)?

Thanks,

Steven Huang

sathyaram_s · #2 (**permalink**) 04-18-04, 12:58

The SQL Stored Procedure is converted into Embedded C code and precompiled, compiled etc etc ...

This is the reason you need a c compiler .

The next release of DB2, Stinger, will not need C compiler for SPs

Cheers
Sathyaram

Quote:

Originally posted by hiolgc
Hi everyone,

Why DB2 SQL stored Procedure need a c compiler? What's the reason for this setting and its advantage (or disadvantage)?

Thanks,

Steven Huang

Internet Services

Web Development

Digital Marketing

Consumer Tech