---
title: "SQL-013: clsXPrintControl.RetrieveSQL"
summary: Retrieves a single print-control batch header by primary key.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Services.Printing.Remote
reference_type: package
---

# SQL-013: clsXPrintControl.RetrieveSQL

Retrieves a single `XPRINT_CONTROL` row by its primary key (`XPRINT_CONTROL_SEQ_NUM`). This is the live retrieve path for `clsXPrintControl.GetXPrintControl(inSeqNum)`. The returned row populates all batch-header properties: directory name, duplex code, processed date, IDM path name, XML file name, and MD5 hash.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-013 |
| **Operation type** | Read (Retrieve) |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsXPrintControl` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:XPrintControlSeqNum` | Input | Decimal | — | Primary key lookup |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [XPRINT_CONTROL](../database-tables.md#xprint_control) | SELECT | `DIRECTORY_NAME`, `DUPLEX_CODE`, `PROCESSED_DATE`, `XPRINT_CONTROL_SEQ_NUM`, `IDM_PATH_NAME`, `XML_FILE_NAME`, `MD5_HASH_VALUE` |

## Sample SQL

```sql
Select
    XPRINT_CONTROL.DIRECTORY_NAME           as DirectoryName,
    XPRINT_CONTROL.DUPLEX_CODE              as DuplexCode,
    XPRINT_CONTROL.PROCESSED_DATE           as ProcessedDate,
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM   as XPrintControlSeqNum,
    XPRINT_CONTROL.IDM_PATH_NAME            as IDMPathName,
    XPRINT_CONTROL.XML_FILE_NAME            as XMLFileName,
    XPRINT_CONTROL.MD5_HASH_VALUE           as MD5HashValue
From
    XPRINT_CONTROL
Where
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM = :XPrintControlSeqNum
```

## Operations and processes
- [Print-control batch header lifecycle](../operations/print-control-batch-header-lifecycle.md)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.

## Sources
- `Services\SAIF.Services.Printing.Remote\clsXPrintControl.vb`