You can use a type definition (typedef) within a declare section to declare variables. For example:
exec sql begin declare section;
/*
** The typedef and the use of the typedef
** can be in separate declare sections
** if the typedef comes first.
** The typedef can even be in an “exec
** sql include file”.
*/
typedef int STORE_ID;
STORE_ID current_ID;
exec sql end declare section;
exec sql select store_ID into :current_ID
from sales_table where
store_name = 'Furniture Kingdom';
