bootstrap is complete

Configuration Details

JADE Config Property Values

KEY	VALUE
BDS_ADD_SOFTCONF.	viewbean: com.ibm.ediag.bdsadmin.bean.AddSoftConfViewBean target: /index_AddSoftConf.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_ADD_TYPE.	viewbean: com.ibm.ediag.bdsadmin.bean.AddTypeViewBean target: /index_AddType.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_CREATE_SOFTCONF.	viewbean: com.ibm.ediag.bdsadmin.bean.ListSoftConfViewBean target: /index_ListSoftConf.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_CREATE_TYPE.	viewbean: com.ibm.ediag.bdsadmin.bean.ListTypeViewBean target: /index_ListType.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_DISPLAY_FUNCTIONALITIES_DATABASE.	viewbean: com.ibm.ead4j.jade.bean.EmptyViewBean target: /index_CleanUpDatabase.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_EDIT_SOFTCONF.	viewbean: com.ibm.ediag.bdsadmin.bean.EditSoftConfViewBean target: /index_EditSoftConf.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_EDIT_TYPE.	viewbean: com.ibm.ediag.bdsadmin.bean.EditTypeViewBean target: /index_EditType.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_ERROR.	viewbean: com.ibm.ediag.bdsadmin.bean.ErrorViewBean target: /index_Error.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_LIST_BUNDLE.	viewbean: com.ibm.ediag.bdsadmin.bean.ListBundleViewBean target: /index_ListBundle.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_LIST_CONSOLE.	viewbean: com.ibm.ediag.bdsadmin.bean.ListConsoleViewBean target: /index_ListConsole.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_LIST_SOFTCONF.	viewbean: com.ibm.ediag.bdsadmin.bean.ListSoftConfViewBean target: /index_ListSoftConf.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_LIST_TYPE.	viewbean: com.ibm.ediag.bdsadmin.bean.ListTypeViewBean target: /index_ListType.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_MAIN_MENU.	viewbean: com.ibm.ediag.bdsadmin.bean.MainMenuViewBean target: /index_HomePage.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_RESET_DATABASE.	viewbean: com.ibm.ediag.bdsadmin.bean.MainMenuViewBean target: /index_HomePage.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_UPDATE_SOFTCONF.	viewbean: com.ibm.ediag.bdsadmin.bean.ListSoftConfViewBean target: /index_ListSoftConf.jsp target method: FORWARD attributes: {content-type=text/html}
BDS_UPDATE_TYPE.	viewbean: com.ibm.ediag.bdsadmin.bean.ListTypeViewBean target: /index_ListType.jsp target method: FORWARD attributes: {content-type=text/html}
JADE_EMPTY_STATE_KEY.	viewbean: com.ibm.ead4j.jade.bean.EmptyViewBean target: empty.jsp target method: FORWARD attributes: {content-type=text/html}
JADE_MESSAGE_TYPE_ERROR	JADE_MESSAGE_TYPE_ERROR
JADE_MESSAGE_TYPE_INFO	JADE_MESSAGE_TYPE_INFO
JADE_MESSAGE_TYPE_SUCCESS	JADE_MESSAGE_TYPE_SUCCESS
JADE_MESSAGE_TYPE_WARNING	JADE_MESSAGE_TYPE_WARNING
application.property.key	/appl/
bds.message.basename	appl/i18n/bdsMessages
ead4j.config.codebase	/ead4jConfig/
ead4j.context.class	com.ibm.ead4j.common.config.EAD4JContextJ2EEImpl
ead4j.cryptography.class	com.ibm.ediag.util.config.crypto.EdiagEAD4JCryptographyUtil
ead4j.traceState.key	ON
html.doubleClick.name	jade_doubleClick.html
html.errorPage.name	index_InternalError.jsp
html.homePage.name	index.html
html.invalidSessionPage.name	jade_invalid_session.html
jade.LookupContext.class	com.ibm.ead4j.jade.config.LookupContextDefaultImpl
jade.ProcessContractMediator.class	com.ibm.ead4j.jade.contract.ProcessContractMediatorDefaultImpl
jade.action.extension	.go
jade.action.filename	actionHandler.xml
jade.action.key	jadeAction
jade.action.path	/config/
jade.actionContext.class	com.ibm.ead4j.jade.action.ActionHandlerContextJ2EEImpl
jade.applicationContext.class	com.ibm.ead4j.jade.config.ApplicationContextJ2EEImpl
jade.configContext.class	com.ibm.ead4j.jade.config.ConfigContextJ2EEImpl
jade.content.type.key	content-type
jade.default.device.type	StandardBrowser
jade.default.multipartReader.class	com.ibm.ead4j.jade.util.MultipartReaderImpl
jade.devices.filename	device.xml
jade.double.click.elapsed.time.key	5000
jade.hasUndo.key	true
jade.html.filename	html.xml
jade.i18n.basename.key	appl/i18n/i18nText
jade.i18n.path	/i18n/
jade.i18nContext.class	com.ibm.ead4j.jade.config.I18NContextDefaultImpl
jade.locale.parameter.key	jadeLocale
jade.localeHelper.class	com.ibm.ead4j.jade.util.LocaleHelperSimpleImpl
jade.logRequest.value	false
jade.mapping.filename	mapping.xml
jade.message.filename	message.xml
jade.messagebean.default.type	com.ibm.ead4j.jade.bean.MessageBeanImpl
jade.messagebean.message.type	JADE_MESSAGE_TYPE_ERROR
jade.method.forward	forward
jade.method.include	include
jade.method.send.redirect	sendRedirect
jade.method.transcode	transcode
jade.multipartReader.class	com.ibm.ead4j.jade.util.MultipartReaderImpl
jade.parameter.class	com.ibm.ead4j.jade.util.ParametersImpl
jade.property.filename	property.xml
jade.property.path	/config/
jade.session.auto.create	false
jade.session.type	com.ibm.ead4j.jade.session.JadeHttpSession
jade.siteDebug.value	false
jade.store.bean.option	request
jade.version.number	3.2.0
resultBean.currentResult.key	currentResultBean
resultBean.messageBean.key	resultBean_messageBean_key
resultBean.previousResult.key	resultBean_previousResult_key
state.currentState.key	JADE_CURRENT_STATE
state.undoState.key	JADE_UNDO_STATE

**Action Handlers**
KEY	VALUE
BDS_ADD_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.AddSoftConfActionHandler>>BDS_ADD_SOFTCONF_HANDLER
BDS_ADD_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.AddTypeActionHandler>>BDS_ADD_TYPE_HANDLER
BDS_CREATE_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.CreateSoftConfActionHandler>>BDS_CREATE_SOFTCONF_HANDLER
BDS_CREATE_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.CreateTypeActionHandler>>BDS_CREATE_TYPE_HANDLER
BDS_DELETE_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.DeleteSoftConfActionHandler>>BDS_DELETE_SOFTCONF_HANDLER
BDS_DELETE_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.DeleteTypeActionHandler>>BDS_DELETE_TYPE_HANDLER
BDS_DISPLAY_FUNCTIONALITIES_HANDLER	class com.ibm.ediag.bdsadmin.action.DisplayFunctionalitiesActionHandler>>BDS_DISPLAY_FUNCTIONALITIES_HANDLER
BDS_EDIT_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.EditSoftConfActionHandler>>BDS_EDIT_SOFTCONF_HANDLER
BDS_EDIT_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.EditTypeActionHandler>>BDS_EDIT_TYPE_HANDLER
BDS_LIST_BUNDLE_HANDLER	class com.ibm.ediag.bdsadmin.action.ListBundleActionHandler>>BDS_LIST_BUNDLE_HANDLER
BDS_LIST_CONSOLE_HANDLER	class com.ibm.ediag.bdsadmin.action.ListConsoleActionHandler>>BDS_LIST_CONSOLE_HANDLER
BDS_LIST_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.ListSoftConfActionHandler>>BDS_LIST_SOFTCONF_HANDLER
BDS_LIST_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.ListTypeActionHandler>>BDS_LIST_TYPE_HANDLER
BDS_MAIN_MENU_HANDLER	class com.ibm.ediag.bdsadmin.action.MainMenuActionHandler>>BDS_MAIN_MENU_HANDLER
BDS_RESET_DATABASE_HANDLER	class com.ibm.ediag.bdsadmin.action.ResetDatabaseActionHandler>>BDS_RESET_DATABASE_HANDLER
BDS_UPDATE_SOFTCONF_HANDLER	class com.ibm.ediag.bdsadmin.action.UpdateSoftConfActionHandler>>BDS_UPDATE_SOFTCONF_HANDLER
BDS_UPDATE_TYPE_HANDLER	class com.ibm.ediag.bdsadmin.action.UpdateTypeActionHandler>>BDS_UPDATE_TYPE_HANDLER
JADE_DEFAULT_ACTION_HANDLER_KEY	com.ibm.ead4j.jade.action.DefaultActionHandler@6d12d605

TOPAZ Configuration Details

TOPAZ BOOTSTRAP Properties

PERSISTENCE TECHNOLOGY

jdbc

HBA JDBC Configuration Details

TOPAZ JDBC Bootstrap properties

Property	Value
topaz.jdbc.connectionPool	null
topaz.jdbc.dataSource	null
sql.pad.char	0
sql.pad.direction	LEFT

TOPAZ JDBC Config Directories

CONFIG DIRECTORY

appl/config

TOPAZ JDBC SQL Directories

CONFIG DIRECTORY

appl/config/sql

TOPAZ JDBC Database Config Values

KEY	VALUE
SESSION	com.ibm.ead4j.topaz.common.jdbc.DatabaseContextConfig Name : session Impl Class : com.ibm.ediag.as.jdbc.util.DatabaseContextWAS6Impl Data Source Name : session_ds Data Source : alias/session_ds JDBC Driver Class : null Connect URL : null UserID : null Password : null

TOPAZ JDBC Queries

TOPAZ JDBC has82 Queries.

No variables.

Query Type

Query String

# Query Variables

Query Variables

name

type

is Nullable

prefix

suffix

precision

Prepared

SELECT COUNT(PK_TYPE_ID) FROM TYPE WHERE FK_SOFT_ID = ?

SOFTCONFVERSION

VARCHAR

null

Prepared

Select PK_TYPE_ID, NAME, FK_SOFT_ID From TYPE ORDER BY NAME,FK_SOFT_ID

PreparedUPDATE TYPE SET FK_SOFT_ID=null WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedSelect PK_SOFT_ID, FK_PARN_ID, MCC, DDC, SHARED_CONTEXT From SOFT_CONF LEFT JOIN EXT_SOFT_CONF ON SOFT_CONF.PK_SOFT_ID = EXT_SOFT_CONF.FK_SOFT_ID ORDER BY PK_SOFT_ID, PK_EXT_CONF_IDNo variables. PreparedINSERT INTO BUNDLE_SOFT (PFK_SOFT_ID,PFK_BUND_ID,ORDR) VALUES (?,?,?)3

SOFTCONFVERSION	CHAR	null	null	null
IDBUNDLE	INT	null	null	null
ORDER	INT	Y	null	null

PreparedSelect PK_TYPE_ID, NAME, FK_SOFT_ID From TYPENo variables. PreparedSELECT COUNT(PFK_BUND_ID) COUNT FROM BUNDLE_SOFT WHERE PFK_BUND_ID = ?1

IDBUNDLE

VARCHAR

null

PreparedSelect PK_BUND_ID, NAME, VERS, CRC From BUNDLE ORDER BY UPPER(NAME)No variables. PreparedSelect PK_CONL_ID, MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID From CONSOLE Where UPPER(CONSOLE.PCI) = UPPER(CAST(? AS VARCHAR(80)))1

CONSOLEPCI

CHAR

null

PreparedSELECT FK_PARN_ID FROM SOFT_CONF WHERE PK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedINSERT INTO SOFT_CONF (PK_SOFT_ID,CRET_DATE,UPDT_DATE,FK_PARN_ID) VALUES (?,CURRENT DATE,CURRENT DATE,?)2

SOFTCONFVERSION	CHAR	null	null	null	0
DEPENDANT	CHAR	Y	null	null	0

PreparedSELECT COUNT(PK_CONL_ID) FROM CONSOLE WHERE UPPER(PCI) = UPPER(CAST(? AS VARCHAR(80)))1

CONSOLEPCI

VARCHAR

null

StandardDELETE FROM TYPENo variables. PreparedUPDATE CONSOLE SET MAC = ?, PCI = ?, MAC_PCI = ?, FK_SOFT_ID = ?, FK_TYPE_ID = ? WHERE PK_CONL_ID = ?6

CONSOLEMAC	CHAR	Y	null	null
CONSOLEPCI	CHAR	Y	null	null
CONSOLEIDTYPE	CHAR	null	null	null
SOFTCONFVERSION	CHAR	Y	null	null
TYPEID	CHAR	Y	null	null
CONSOLEID	CHAR	null	null	null

PreparedSelect PK_CONL_ID, MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID From CONSOLE ORDER BY FK_SOFT_ID,FK_TYPE_IDNo variables. PreparedWITH TEMP (PK_SOFT_ID,FK_PARN_ID)AS( Select DISTINCT PK_SOFT_ID, FK_PARN_ID From SOFT_CONF,BUNDLE_SOFT WHERE SOFT_CONF.PK_SOFT_ID = BUNDLE_SOFT.PFK_SOFT_ID ) SELECT PK_SOFT_ID, FK_PARN_ID,EXT_SOFT_CONF.MCC,EXT_SOFT_CONF.DDC,EXT_SOFT_CONF.SHARED_CONTEXT FROM TEMP LEFT JOIN EXT_SOFT_CONF ON TEMP.PK_SOFT_ID = EXT_SOFT_CONF.FK_SOFT_ID ORDER BY EXT_SOFT_CONF.FK_SOFT_IDNo variables. PreparedUPDATE CONSOLE SET FK_TYPE_ID=null WHERE FK_TYPE_ID = ?1

TYPEID

CHAR

null

PreparedINSERT INTO EXT_SOFT_CONF (PK_EXT_CONF_ID,FK_SOFT_ID,MCC,DDC,SHARED_CONTEXT) VALUES (NEXT VALUE FOR OAUQN_EXTCONF_F,?,?,?,?)4

SOFTCONFVERSION	CHAR	null	null	null
MCC	CHAR	Y	null	null
DDC	CHAR	Y	null	null
SHARED_CONTEXT	CHAR	Y	null	null

PreparedVALUES (NEXTVAL for OAUQN_BUNDLE_F)No variables. PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE ORDER BY UPPER(NAME),VERSNo variables. PreparedSelect PK_CONL_ID, MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID From CONSOLE Where UPPER(CONSOLE.MAC) = UPPER(CAST(? AS VARCHAR(80)))1

CONSOLEMAC

CHAR

null

PreparedSelect CONT From BUNDLE where UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80))) and VERS = ?2

BUNDLENAME	CHAR	null	null	null	0
BUNDLEVERSION	CHAR	null	null	null	0

PreparedSELECT COUNT(PK_BUND_ID) FROM BUNDLE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80))) AND VERS = ? AND PK_BUND_ID!= ?3

BUNDLENAME	VARCHAR	null	null	null
BUNDLEVERSION	VARCHAR	null	null	null
IDBUNDLE	VARCHAR	null	null	null

PreparedUPDATE CONSOLE SET FK_SOFT_ID= ? WHERE PK_CONL_ID IN ?2

SOFTCONFVERSION	CHAR	null	null	null	0
CONSOLEID	CHAR	null	null	null	0

PreparedINSERT INTO CONSOLE (PK_CONL_ID,MAC,PCI,MAC_PCI,FK_SOFT_ID,FK_TYPE_ID) VALUES (?,?,?,?,?,?)6

CONSOLEID	INT	null	null	null
CONSOLEMAC	CHAR	Y	null	null
CONSOLEPCI	CHAR	Y	null	null
CONSOLEIDTYPE	CHAR	null	null	null
SOFTCONFVERSION	CHAR	Y	null	null
TYPEID	CHAR	Y	null	null

PreparedDELETE FROM TYPE WHERE PK_TYPE_ID = ?1

TYPEID

INT

null

PreparedUPDATE CONSOLE SET FK_TYPE_ID=null WHERE FK_TYPE_ID = ?1

TYPEID

CHAR

null

PreparedSELECT PK_TYPE_ID,NAME,FK_SOFT_ID FROM TYPE WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedDELETE FROM SOFT_CONF WHERE PK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedDELETE FROM BUNDLE_SOFT WHERE PFK_BUND_ID = ?1

IDBUNDLE

CHAR

null

PreparedDELETE FROM BUNDLE WHERE PK_BUND_ID = ?1

IDBUNDLE

CHAR

null

PreparedSELECT COUNT(PK_CONL_ID) FROM CONSOLE WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

VARCHAR

null

StandardALTER SEQUENCE OAUQN_TYPE_F RESTART WITH 2000No variables. PreparedSELECT count(PK_SOFT_ID) FROM SOFT_CONF WHERE FK_PARN_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedSELECT PK_SOFT_ID, FK_PARN_ID FROM SOFT_CONF WHERE FK_PARN_ID = ?1

DEPENDANT

CHAR

null

PreparedDELETE FROM BUNDLE_SOFT WHERE PFK_BUND_ID = ? AND PFK_SOFT_ID = ?2

IDBUNDLE	INT	null	null	null	0
SOFTCONFVERSION	CHAR	null	null	null	0

PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE WHERE PK_BUND_ID = ?1

IDBUNDLE

CHAR

null

PreparedSELECT COUNT(PK_SOFT_ID) FROM SOFT_CONF WHERE FK_PARN_ID = ?1

DEPENDANT

VARCHAR

null

PreparedSELECT COUNT(PK_SOFT_ID) FROM SOFT_CONF WHERE PK_SOFT_ID = ?1

SOFTCONFVERSION

VARCHAR

null

PreparedVALUES (NEXTVAL for OAUQN_CONSOLE_F)No variables. StandardALTER SEQUENCE OAUQN_BUNDLE_F RESTART WITH 2000No variables. PreparedUPDATE SOFT_CONF SET FK_PARN_ID = null WHERE FK_PARN_ID = ?1

DEPENDANT

VARCHAR

null

PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE ORDER BY VERS,UPPER(NAME)No variables. PreparedWITH TEMP (PK_EXT_CONF_ID) AS ( SELECT PK_EXT_CONF_ID FROM EXT_SOFT_CONF WHERE FK_SOFT_ID = ? AND ( (MCC = CAST(? AS VARCHAR(255))) AND (DDC = CAST(? AS VARCHAR(255))) AND (SHARED_CONTEXT = CAST(? AS VARCHAR(255))) ) )SELECT * FROM TEMP WHERE TEMP.PK_EXT_CONF_ID = (SELECT MAX(EXT_SOFT_CONF.PK_EXT_CONF_ID) FROM EXT_SOFT_CONF WHERE FK_SOFT_ID = CAST(? AS VARCHAR(255)))5

SOFTCONFVERSION	CHAR	null	null	null
MCC	CHAR	null	null	null
DDC	CHAR	null	null	null
SHARED_CONTEXT	CHAR	Y	null	null
SOFTCONFVERSION	CHAR	null	null	null

PreparedUPDATE TYPE SET FK_SOFT_ID= ? WHERE PK_TYPE_ID IN ?2

SOFTCONFVERSION	CHAR	null	null	null	0
TYPEID	CHAR	null	null	null	0

PreparedSelect PK_BUND_ID, NAME, VERS, CRC From BUNDLE, BUNDLE_SOFT where BUNDLE.PK_BUND_ID=BUNDLE_SOFT.PFK_BUND_ID and BUNDLE_SOFT.PFK_SOFT_ID=? ORDER BY ORDR1

SOFTCONFVERSION

CHAR

null

PreparedSELECT NAME, FK_SOFT_ID FROM TYPE WHERE PK_TYPE_ID = ?1

TYPEID

CHAR

null

PreparedSELECT FK_SOFT_ID, FK_PARN_ID FROM SOFT_CONF ORDER BY FK_SOFT_IDNo variables. PreparedSELECT FK_SOFT_ID FROM TYPE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80)))1

LABEL

CHAR

null

StandardDELETE FROM BUNDLENo variables. PreparedSelect PK_TYPE_ID, NAME, FK_SOFT_ID From TYPE ORDER BY FK_SOFT_ID,NAMENo variables. PreparedSELECT COUNT(PK_BUND_ID) FROM BUNDLE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80))) AND VERS = ?2

BUNDLENAME	VARCHAR	null	null	null	0
BUNDLEVERSION	VARCHAR	null	null	null	0

PreparedSELECT COUNT(PK_TYPE_ID) FROM TYPE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80)))1

LABEL

VARCHAR

null

PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80))) ORDER BY VERS1

BUNDLENAME

VARCHAR

null

PreparedSelect MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID From CONSOLE where PK_CONL_ID = ?1

CONSOLEID

CHAR

null

PreparedSelect PK_SOFT_ID, FK_PARN_ID From SOFT_CONFNo variables. PreparedSelect PK_SOFT_ID, FK_PARN_ID From SOFT_CONF WHERE FK_PARN_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedUPDATE SOFT_CONF SET FK_PARN_ID = ? WHERE PK_SOFT_ID in ?2

DEPENDANT	CHAR	null	null	null	0
SOFTCONFVERSION	VARCHAR	null	null	null	0

StandardALTER SEQUENCE OAUQN_CONSOLE_F RESTART WITH 2000No variables. StandardDELETE FROM BUNDLE_SOFTNo variables. PreparedINSERT INTO TYPE (PK_TYPE_ID,NAME,FK_SOFT_ID) VALUES (?,?,?)3

TYPEID	CHAR	null	null	null
LABEL	CHAR	null	null	null
SOFTCONFVERSION	CHAR	null	null	null

PreparedSELECT PK_CONL_ID, MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID FROM CONSOLE WHERE FK_TYPE_ID = ?1

TYPEID

CHAR

null

PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE, BUNDLE_SOFT WHERE PK_BUND_ID=PFK_BUND_ID AND UPPER(PFK_SOFT_ID) = UPPER(CAST(? AS VARCHAR(80))) ORDER BY UPPER(NAME),VERS1

SOFTCONFVERSION

CHAR

null

PreparedSELECT COUNT(PK_CONL_ID) FROM CONSOLE WHERE UPPER(MAC) = UPPER(CAST(? AS VARCHAR(80)))1

CONSOLEMAC

VARCHAR

null

PreparedUPDATE CONSOLE SET FK_SOFT_ID = ? where CONSOLE.PK_CONL_ID = ?2

SOFTCONFVERSION	CHAR	null	null	null	0
CONSOLEID	CHAR	null	null	null	0

PreparedUPDATE SOFT_CONF SET PK_SOFT_ID = ? , FK_PARN_ID = ?, UPDT_DATE = CURRENT DATE WHERE PK_SOFT_ID = ?3

NEWSOFTCONFVERSION	CHAR	null	null	null
DEPENDANT	CHAR	Y	null	null
SOFTCONFVERSION	CHAR	null	null	null

StandardDELETE FROM CONSOLENo variables. PreparedSelect PK_TYPE_ID, NAME, FK_SOFT_ID From TYPE WHERE FK_SOFT_ID = ? ORDER BY NAME,FK_SOFT_ID1

SOFTCONFVERSION

CHAR

null

PreparedUPDATE CONSOLE SET FK_SOFT_ID=null WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

StandardDELETE FROM SOFT_CONFNo variables. PreparedDELETE FROM EXT_SOFT_CONF WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedSELECT COUNT(UPPER(NAME)), UPPER(NAME) FROM BUNDLE WHERE PK_BUND_ID IN ? GROUP BY UPPER(NAME)1

IDBUNDLE

VARCHAR

null

PreparedSELECT PK_CONL_ID,MAC,PCI,MAC_PCI,FK_SOFT_ID,FK_TYPE_ID FROM CONSOLE WHERE FK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedDELETE FROM BUNDLE_SOFT WHERE PFK_SOFT_ID = ?1

SOFTCONFVERSION

CHAR

null

PreparedSELECT PK_TYPE_ID, FK_SOFT_ID FROM TYPE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80)))1

LABEL

CHAR

null

PreparedUPDATE TYPE SET NAME = ? , FK_SOFT_ID = ? WHERE PK_TYPE_ID = ?3

LABEL	CHAR	null	null	null
SOFTCONFVERSION	CHAR	null	null	null
TYPEID	CHAR	null	null	null

PreparedSelect PK_CONL_ID, MAC, PCI, MAC_PCI, FK_SOFT_ID, FK_TYPE_ID From CONSOLE ORDER BY FK_TYPE_ID,FK_SOFT_IDNo variables. PreparedSELECT PK_BUND_ID, NAME, VERS, CRC, CONT FROM BUNDLE WHERE UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80))) AND UPPER(VERS) = UPPER(CAST(? AS VARCHAR(80)))2

BUNDLENAME	CHAR	null	null	null	0
BUNDLEVERSION	CHAR	null	null	null	0

PreparedVALUES (NEXTVAL for OAUQN_TYPE_F)No variables. PreparedDELETE FROM CONSOLE WHERE PK_CONL_ID = ?1

CONSOLEID

CHAR

null

PreparedSELECT SOFT_CONF.PK_SOFT_ID, SOFT_CONF.FK_PARN_ID FROM SOFT_CONF,TYPE WHERE SOFT_CONF.PK_SOFT_ID=TYPE.FK_SOFT_ID AND UPPER(NAME) = UPPER(CAST(? AS VARCHAR(80)))1

LABEL

CHAR

null

PreparedUPDATE CONSOLE SET FK_TYPE_ID = ? WHERE PK_CONL_ID IN ?2

TYPEID	CHAR	null	null	null	0
CONSOLEID	CHAR	null	null	null	0