268 DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
machine receives the data, conversion is from the database code page to the
application code page.
When a client or application that imports or loads a file runs in a code page
different from the file being imported or loaded.
7.2.3 Stored procedures
Stored Procedures (SPs) are programs running in the database environment.
SPs can be written in SQL, C and Java and help to reduce the network traffic. In
any case, procedures are typically written to contain multiple SQL data
manipulation language (DML) statements as well as procedure logic constructs
such as loops and if/else statements. Therefore, stored procedures are
conceptually similar to “small” applications, provid ...