Cursors in Quiz/HP-UNIX/Oracle
Petura James (Van)
james.petura@artioslink.com
Wed, 13 May 1998 15:29:40 -0700
after a compile; a partial listing using show items shows the columns of
the cursor
FRED:
Please note the Calc_Column*
FRED TYPE SCALE SCALE DEC PICTURE
CSPR.PROD_KEY CHAR X(8)
CSPR.CUST_ID CHAR X(8)
CSPR.CSPR_VALUE_TEXT CHAR X(20)
SHIP.ADR_ID CHAR X(16)
SHIP.SHIP_CODE CHAR X(2)
ADR.ADR_ADDRESS1 CHAR X(36)
ADR.ADR_ADDRESS2 CHAR X(36)
ADR.ADR_CMPY_NAME1 CHAR X(36)
ADR.ADR_CMPY_NAME2 CHAR X(36)
ADR.ADR_CITY_CODE CHAR X(4)
ADR.ADR_PROV_CODE CHAR X(2)
ADR.ADR_CTRY_CODE CHAR X(4)
ADR.ADR_POSTAL_CODE CHAR X(15)
CTRY_DESC VARCHAR X(40)
Calc_Column_15 CHAR X(3)
Calc_Column_16 CHAR X(1)
Calc_Column_17 CHAR X(1)
Calc_Column_18 CHAR X(1)
PROD.PROD_DESC_TEXT1 CHAR X(35)
PROD.SPEC_KEY_TYPE_CODE CHAR X(1)
PROD.SPEC_KEY_ID CHAR X(10)
PROD.PROD_TEMPLATE_ID CHAR X(8)
PROD.PROD_INVT_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_PRODN_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_ALT_CONV_FACTOR NUM 0 0 0
^^^,^^^.^^^
PROD.PROD_INVT_UNIT_CODE CHAR X(3)
PROD.PROD_PRICE_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_MKT_CLASS_CODE CHAR X(1)
PROD.PROD_PRICE_UNIT_CODE CHAR X(3)
after exiting quiz , rentering and recompiling:
FRED TYPE SCALE SCALE DEC PICTURE
CSPR.PROD_KEY CHAR X(8)
CSPR.CUST_ID CHAR X(8)
CSPR.CSPR_VALUE_TEXT CHAR X(20)
SHIP.ADR_ID CHAR X(16)
SHIP.SHIP_CODE CHAR X(2)
ADR.ADR_ADDRESS1 CHAR X(36)
ADR.ADR_ADDRESS2 CHAR X(36)
ADR.ADR_CMPY_NAME1 CHAR X(36)
ADR.ADR_CMPY_NAME2 CHAR X(36)
ADR.ADR_CITY_CODE CHAR X(4)
ADR.ADR_PROV_CODE CHAR X(2)
ADR.ADR_CTRY_CODE CHAR X(4)
ADR.ADR_POSTAL_CODE CHAR X(15)
CTRY_DESC VARCHAR X(40)
Calc_Column_15 CHAR X(3)
CUST.CUST_CURR_EXCH_CODE CHAR X(1)
Calc_Column_17 CHAR X(1)
CUST.CUST_VENDOR_FLAG CHAR X(1)
PROD.PROD_DESC_TEXT1 CHAR X(35)
PROD.SPEC_KEY_TYPE_CODE CHAR X(1)
PROD.SPEC_KEY_ID CHAR X(10)
PROD.PROD_TEMPLATE_ID CHAR X(8)
PROD.PROD_INVT_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_PRODN_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_ALT_CONV_FACTOR NUM 0 0 0
^^^,^^^.^^^
PROD.PROD_INVT_UNIT_CODE CHAR X(3)
PROD.PROD_PRICE_UNIT_QTY NUM 0 0 0 ^^^,^^^
PROD.PROD_MKT_CLASS_CODE CHAR X(1)
PROD.PROD_PRICE_UNIT_CODE CHAR X(3)
Why aren't the Calc_Column_1* experiencing problems being resolved
correctly/ consistently?
The cursor fred follows:
decl fred cursor for &
select prod_key, &
cspr.cust_id, &
cspr_value_text,&
ship.adr_id, &
ship.ship_code, &
adr_address1, &
adr_address2, &
adr_cmpy_name1, &
adr_cmpy_name2, &
adr_city_code, &
adr_prov_code, &
adr_ctry_code, &
adr_postal_code, &
substring (ctry.ctd_desc_text from 1 for 20) as ctry_desc,
&
cust.cust_curr_code, &
cust.cust_curr_exch_code, &
cust.cust_internal_flag, &
cust.cust_vendor_flag, &
prod.prod_desc_text1, &
prod.spec_key_type_code, &
prod.spec_key_id, &
prod.prod_template_id, &
prod.prod_invt_unit_qty, &
prod.prod_prodn_unit_qty, &
prod.prod_alt_conv_factor, &
prod.prod_invt_unit_code, &
prod.prod_price_unit_qty, &
prod.prod_mkt_class_code, &
prod.prod_price_unit_code &
from cspr, prod, ship, adr, ctd ctry, cust &
where cspr.cust_id = ship.cust_id &
and cspr_rec_type_code = 'CPN' &
and prod_key = prod.prod_id &
and ship.adr_id = adr.adr_id &
and adr.adr_ctry_code = ctry.ctd_code &
and ctry.ctm_id = 'CTRY' &
and cspr.cust_id = cust.cust_id
I have also attempted to have this cursor to make multiple references to
the same table (CTD) using different aliases and the number of record
complexes increased from 2 to 66 when looking full descriptions for city
and country.
Obviously there are limitations in what cursors can do in HP/UNIX -
PowerHouse - Oracle world.
Does anybody know what they are?
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.