SAP Knowledge Base Article - Preview

1872011 - DDLGEN 15.7 creates lwp for every sql statement in the java code - ASE

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

SAP Adaptive Server Enterprise 15.7

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.