|
|
| |
 |
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Oracle Data Warehouse Design
Creating An SQL Generating Front End
Listing 4.2 A REXX routine to generate SQL from screen values.
/* ------------------------------------------
Add SQL command to input stream...
------------------------------------------ */
sql_write:
queue "SET CURRENT SQLID = 'AUTOC';"
if XBILL = ' ' &,
XSNUM = ' ' &,
XDATE = ' ' &,
XSITE = ' ' &,
XADDR = ' ' &,
XCITY = ' ' &,
XSTATE = ' ' &,
XZIP = ' ' &,
XACCT = ' ' &,
XACTIVE = ' ' &,
XREQ = ' ' &,
XTIME = ' ' &,
XTYPE = ' ' then
queue "SELECT * "
else
queue "SELECT "
COMMA = ' '
if SUMMARY ^= ' ' then
do
/* add summary stuff here */
if XACCT ^= ' ' then
do
queue " TOT_USER_SITES"
COMMA = ','
end
if XACTIVE ^= ' ' then
do
queue COMMA " ACTIVE_USER_SITES"
COMMA = ','
end
end
if XDATE ^= ' ' then
do
queue COMMA " DATE_YYMM"
COMMA = ','
end
if XSITE ^= ' ' then
do
queue COMMA " NAME_LINE_1"
COMMA = ','
end
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|