ROUTINE_NAME,
ROUTINE_TYPE,
LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),”)) LOC
FROM INFORMATION_SCHEMA.ROUTINES
COMPUTE SUM(LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),”)))
COMPUTE avg(LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),”)))
DB2_ADVANCED_LOG_SPACE_MGMT
sqldatacompare /Database1:WidgetDev /Database2:WidgetLive
ComparisonKeys:Widgets:PK_Widgets
