dbo.QBM_PNonlinear_DeleteUntouched

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:24.497 · modified 2026-04-14T23:14:36.450 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
No parameters.

Referenced objects

SchemaObjectColumn/minorClass
QBM_PExecuteSQLWithRetry_LLPOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_VNonlinearDeleteCandidatesOBJECT_OR_COLUMN
QBM_YCursorBufferTYPE
dboQBM_FGISessionErrorRethrowOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1 create   procedure QBM_PNonlinear_DeleteUntouched as begin  declare @TableName varchar(30) declare @DebugSwitch int = 0 declare @Pattern nvarchar
2(max) = '
3delete /* algorithmisch notwendig */ @TableName@
4--select Xtouched, XObjectKey
5	 from @TableName@
6	where XTouched = ''O''
7
8' declare @SQLCmd
9 nvarchar(max) declare @Tablenames QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int SET XACT_ABORT OFF BEGIN TRY insert into @Tablenames
10(Ident1) select distinct v.TableName from QBM_VNonlinearDeleteCandidates v select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex
11 <= @ElementCount begin select top 1 @TableName = bu.Ident1 from @Tablenames bu where bu.ElementIndex = @ElementIndex select @SQLCmd = REPLACE(@Pattern
12, '@TableName@', @TableName) if @DebugSwitch > 0 begin print @sqlcmd end exec QBM_PExecuteSQLWithRetry_LLP @SQLStatement = @SQLCmd , @LockTimeout_ms = 
13default , @MaxWaitTimeForLock_s = 4.0 , @ProcIDForJournal = default , @HandleErrorSilent = 0 select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
14 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 
15

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:14:36.450

has TRY/CATCH error handling

Summary: calls QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBM_VNonlinearDeleteCandidates

Declared parameters

No declared parameters in sys.parameters for this object, or metadata was not available.

DML targets

INSERT into

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @TableName @DebugSwitch @Pattern @SQLCmd @Tablenames @ElementCount @ElementIndex @ROWCOUNT @sqlcmd @SQLStatement @LockTimeout_ms @MaxWaitTimeForLock_s @ProcIDForJournal @HandleErrorSilent @Rethrow

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.