| I can't get BREAK to work [message #291006] |
Wed, 02 January 2008 11:27  |
bwhitejr
Messages: 2
Registered: January 2008
Location: Missouri City, Texas
|
Junior Member |
|
|
I can't get BREAK to work in a *.sql file. Is there a setting I should use to make it active. The command is ignored.
TIA
bwhitejr
|
|
|
|
|
|
|
|
| Re: I can't get BREAK to work [message #291009 is a reply to message #291006] |
Wed, 02 January 2008 11:39  |
bwhitejr
Messages: 2
Registered: January 2008
Location: Missouri City, Texas
|
Junior Member |
|
|
-- **********************************************************************************************************************
-- ****************************************** Loads, By CWP, By Area ****************************************************
Spool LoadsByCWP.txt
ACCEPT schema PROMPT "Enter SPEL Plant schema name: " DEF 'GMEP.'
ACCEPT schema_el PROMPT "Enter SPEL Main schema name: " DEF 'GMEPEL.'
ACCEPT schema_d PROMPT "Enter SPEL Data schema name: " DEF 'GMEPELD.'
-- ACCEPT schema_ref PROMPT "Enter SPEL Reference schema name: " DEF 'GMEPELREF.'
BREAK ON B.CODELIST_TEXT SKIP 1 ON &schema.T_PLANTGROUP.NAME ON &schema.T_PLANTITEM.ITEMTAG ON &schema_el.T_MODELITEM.DESCRIPTION NODUP
select B.CODELIST_TEXT||CHR(9)||&schema.T_PLANTGROUP.NAME||CHR(9)||&schema_el.T_PLANTITEM.ITEMTAG||CHR(9)||&schema_el.T_MODELITE M.DESCRIPTION
from &schema_el.T_EQUIPMENT,
&schema_el.T_ELECTRICALEQUIPMENT,
&schema.T_PLANTGROUP,
&schema_el.T_PLANTITEM,
&schema_el.T_MODELITEM,
&schema_d.CODELISTS B,
&schema_el.T_LOAD
-- &schema_el.T_MOTOR,
-- &schema_el.T_HEATER,
-- &schema_el.T_HEATTRACE,
-- &schema_el.T_CAPACITOR,
-- &schema_el.T_RESISTOR,
-- &schema_el.T_HARMONICFILTER,
-- &schema_el.T_OTHERELECTEQUIPMENT
where &schema.T_PLANTGROUP.PARENTID = &schema_el.T_PLANTITEM.SP_PLANTGROUPID and
&schema_el.T_PLANTITEM.SP_ID = &schema_el.T_EQUIPMENT.SP_ID and
&schema_el.T_PLANTITEM.SP_ID = &schema_el.T_MODELITEM.SP_ID and -- Process Description of Device
&schema_el.T_EQUIPMENT.SP_ID = &schema_el.T_ELECTRICALEQUIPMENT.SP_ID and
&schema_el.T_EQUIPMENT.ELECTRICALEQUIPMENTCLASS = 2 and -- Code List 278 CodeListConstraint "Electrical Equipment"
&schema_el.T_EQUIPMENT.ELECTRICALEQUIPMENTSUBCLASS IN(8,14,15,16,35,45,47) and -- Code List 278 CodeListIndex "Heater","Resistor","Harmonic Filter","Capacitor","Motor",OEE","Heat Trace"
&schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_LOAD.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_MOTOR.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_HEATER.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_HEATTRACE.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_CAPACITOR.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_RESISTOR.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_HARMONICFILTER.SP_ID and
-- &schema_el.T_ELECTRICALEQUIPMENT.SP_ID = &schema_el.T_OTHERELECTEQUIPMENT.SP_ID and
B.CODELIST_INDEX = &schema_el.T_PLANTITEM.CWP_NO and -- Code List for CWP No's
B.CODELIST_NUMBER = 12001 and -- Code List for CWP No's
B.CODELIST_INDEX = &schema_el.T_PLANTITEM.CWP_NO
ORDER BY B.CODELIST_TEXT,&schema.T_PLANTGROUP.NAME,&schema_el.T_PLANTITEM.ITEMTAG,&schema_el.T_MODELITEM.DESCRIPTION asc;
Spool Off
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
