Symptom
- Problem in DDLGEN java code
- It creates every “single use” statement as a prepared statement which in turn creates a light weight procedure (lwp). It then executes the proc once then destroys it.
- Here is the monSysSQLText showing the problem.
Using ddlgen of 15.7 ESD#1, with SYBASE_JRE-6_0_6, on a ASE 15.7ESD#1 server
create proc dyn30013 as SELECT text FROM AUDIT.dbo.syscomments D,AUDIT.dbo.sysprocedures P WHERE D.id = 1894766303 AND P.id = D.id AND P.sequence = 0 AND P.status & 4096 = 4096
create proc dyn29887 as SELECT text FROM AUDIT.dbo.syscomments D,AUDIT.dbo.sysprocedures P WHERE D.id = 1350764365 AND P.id = D.id AND P.sequence = 0 AND P.status & 4096 = 4096
DYNAMIC_SQL dyn30051:
DYNAMIC_SQL dyn30013:
DYNAMIC_SQL dyn29887:
create proc dyn30051 as select isnull(lobcomp_lvl, 0) from AUDIT.dbo.syscolumns where id = 1958766531 and name = 'PositionDate'
DYNAMIC_SQL dyn30013:
DYNAMIC_SQL dyn29887:
DYNAMIC_SQL dyn30051:
DYNAMIC_SQL dyn30014:
DYNAMIC_SQL dyn30051:
create proc dyn30014 as SELECT status2 from AUDIT.dbo.syscolumns where id = 1830766075 and name = 'ModifiedBy' and lobcomp_lvl = null
DYNAMIC_SQL dyn30052:
DYNAMIC_SQL dyn30014:
create proc dyn30052 as SELECT text FROM AUDIT.dbo.syscomments D,AUDIT.dbo.sysprocedures P WHERE D.id = 2038766816 AND P.id = D.id AND P.sequence = 0 AND P.status & 4096 = 4096
DYNAMIC_SQL dyn30014:
DYNAMIC_SQL dyn30052:
DYNAMIC_SQL dyn30015:
DYNAMIC_SQL dyn30052:
create proc dyn30015 as select isnull(lobcomp_lvl, 0) from AUDIT.dbo.syscolumns where id = 1830766075 and name = 'ModifiedBy'
DYNAMIC_SQL dyn30053:
DYNAMIC_SQL dyn30015:
create proc dyn30053 as SELECT status2 from AUDIT.dbo.syscolumns where id = 1958766531 and name = 'SecurityNum' and lobcomp_lvl = null
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 ESD#1
- ddlgen of ASE 15.7 ESD#1 with SYBASE_JRE-6_0_6
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.