---
title: SAIF.Services.Printing.Remote SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Services.Printing.Remote
reference_type: package
---

# SAIF.Services.Printing.Remote SQL catalog

This page indexes all SQL statements in this library (22 live `IBusinessCriteria` properties + 1 supplemental property), grouped by CRUD type. Statements flagged ⚠️ contain live SQL text but are not wired to an executing `Before*` lifecycle method — they are dead/orphaned code.

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-services-printing-remote.md) | `clsXDeferredPrint.CreateSQL` — scalar sequence select ⚠️ dead/unwired | `COPIES_COUNT_NEXTVAL` (CodeGen2 artifact)* | `DUAL` | `clsXDeferredPrint` |
| [SQL-002](SQL-002-saif-services-printing-remote.md) | `clsXDeferredPrintCollection.CreateSQL` — scalar sequence select ⚠️ dead/unwired | `COPIES_COUNT_NEXTVAL` (CodeGen2 artifact)* | `DUAL` | `clsXDeferredPrintCollection` |
| [SQL-003](SQL-003-saif-services-printing-remote.md) | `clsXPrintControlCollection.CreateSQL` — scalar sequence select ⚠️ dead/unwired | `DIRECTORY_NAME_NEXTVAL` (CodeGen2 artifact)* | `DUAL` | `clsXPrintControlCollection` |

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-saif-services-printing-remote.md) | `clsXDeferredPrint.InsertSQL` — insert a deferred print item | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrint` |
| [SQL-005](SQL-005-saif-services-printing-remote.md) | `clsXDeferredPrintCollection.InsertSQL` ⚠️ dead/unwired | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrintCollection` |
| [SQL-006](SQL-006-saif-services-printing-remote.md) | `clsXDocument.InsertSQL` — insert a print job document | Inline | `XDOCUMENT` | `clsXDocument` |
| [SQL-007](SQL-007-saif-services-printing-remote.md) | `clsXPrintControl.InsertSQL` — insert a print-control batch header | Inline | `XPRINT_CONTROL` | `clsXPrintControl` |
| [SQL-008](SQL-008-saif-services-printing-remote.md) | `clsXPrintControlCollection.InsertSQL` ⚠️ dead/unwired | Inline | `XPRINT_CONTROL` | `clsXPrintControlCollection` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-009](SQL-009-saif-services-printing-remote.md) | `clsXDeferredPrint.RetrieveSQL` ⚠️ dead/unwired (hard `Throw`) | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrint` |
| [SQL-010](SQL-010-saif-services-printing-remote.md) | `clsXDeferredPrintCollection.RetrieveSQL` — dynamic WHERE/ORDER BY | Inline (dynamically assembled) | `XDEFERRED_PRINT` | `clsXDeferredPrintCollection` |
| [SQL-011](SQL-011-saif-services-printing-remote.md) | `clsXDocumentCollection.RetrieveSQL` — per-document retrieve with routing join (`ByDocSeq`) | Inline | `XDOCUMENT`, `XPRINTER_BIN`, `XPRINTER` | `clsXDocumentCollection` |
| [SQL-012](SQL-012-saif-services-printing-remote.md) | `clsXDocumentCollection.RetrievePrintSQL` — grouped retrieve (`ByPrintGroup`); supplemental non-interface property | Inline | `XDOCUMENT`, `XPRINTER_BIN`, `XPRINTER` | `clsXDocumentCollection` |
| [SQL-013](SQL-013-saif-services-printing-remote.md) | `clsXPrintControl.RetrieveSQL` — single batch header by PK | Inline | `XPRINT_CONTROL` | `clsXPrintControl` |
| [SQL-014](SQL-014-saif-services-printing-remote.md) | `clsXPrintControlCollection.RetrieveSQL` — pending/stale batches | Inline | `XPRINT_CONTROL` | `clsXPrintControlCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-015](SQL-015-saif-services-printing-remote.md) | `clsXDeferredPrint.UpdateSQL` — update a deferred print item by PK | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrint` |
| [SQL-016](SQL-016-saif-services-printing-remote.md) | `clsXDeferredPrintCollection.UpdateSQL` ⚠️ dead/unwired | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrintCollection` |
| [SQL-017](SQL-017-saif-services-printing-remote.md) | `clsXPrintControl.UpdateSQL` — update a print-control batch header by PK | Inline | `XPRINT_CONTROL` | `clsXPrintControl` |
| [SQL-018](SQL-018-saif-services-printing-remote.md) | `clsXPrintControlCollection.UpdateSQL` ⚠️ dead/unwired | Inline | `XPRINT_CONTROL` | `clsXPrintControlCollection` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-019](SQL-019-saif-services-printing-remote.md) | `clsXDeferredPrint.DeleteSQL` — delete a deferred print item by PK | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrint` |
| [SQL-020](SQL-020-saif-services-printing-remote.md) | `clsXDeferredPrintCollection.DeleteSQL` ⚠️ dead/unwired | Inline | `XDEFERRED_PRINT` | `clsXDeferredPrintCollection` |
| [SQL-021](SQL-021-saif-services-printing-remote.md) | `clsXDocumentCollection.DeleteSQL` — delete documents by batch PK ⚠️ no `BeforeDelete` override | Inline | `XDOCUMENT` | `clsXDocumentCollection` |
| [SQL-022](SQL-022-saif-services-printing-remote.md) | `clsXPrintControl.DeleteSQL` — delete a print-control batch by PK | Inline | `XPRINT_CONTROL` | `clsXPrintControl` |
| [SQL-023](SQL-023-saif-services-printing-remote.md) | `clsXPrintControlCollection.DeleteSQL` — delete a print-control batch by PK | Inline | `XPRINT_CONTROL` | `clsXPrintControlCollection` |

> **Note:** Statements marked with `*` were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `Services\SAIF.Services.Printing.Remote\clsXDeferredPrint.vb`
- `Services\SAIF.Services.Printing.Remote\clsXDeferredPrintCollection.vb`
- `Services\SAIF.Services.Printing.Remote\clsXDocument.vb`
- `Services\SAIF.Services.Printing.Remote\clsXDocumentCollection.vb`
- `Services\SAIF.Services.Printing.Remote\clsXPrintControl.vb`
- `Services\SAIF.Services.Printing.Remote\clsXPrintControlCollection.vb`