SQL-037: clsImgsys
This statement updates an existing IMGSYS row. UPDTTS is set to Oracle sysdate. AfterUpdate verifies exactly one row affected.
Classification
| Field |
Value |
| SQL ID |
SQL-037 |
| Operation type |
Update |
| Execution method |
Inline SQL |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
Text** |
| Business object |
clsImgsys |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:Batid |
Input |
[not specified]** |
15 |
Batch identifier. |
:Delcd |
Input |
[not specified]** |
5 |
Delete code. |
:Idxfl |
Input |
[not specified]** |
1 |
Indexed flag. |
:Ifnds |
Input |
[not specified]** |
N/A |
Image find date start. |
:Ifnid |
Input |
[not specified]** |
N/A |
Image find ID. |
:Npages |
Input |
[not specified]** |
N/A |
Number of pages. |
:Slevel |
Input |
[not specified]** |
N/A |
Security level. |
:Updrid |
Input |
[not specified]** |
30 |
Last updater user ID. |
:Towid |
Input |
[not specified]** |
N/A |
TOWID (WHERE clause). |
Tables
| Table |
Access |
Columns used |
| IMGSYS |
UPDATE |
BATID, DELCD, IDXFL, IFNDS, IFNID, NPAGES, SLEVEL, UPDRID, UPDTTS (WHERE: TOWID) |
Sample SQL
Update IMGSYS
Set
BATID = :Batid,
DELCD = :Delcd,
IDXFL = :Idxfl,
IFNDS = :Ifnds,
IFNID = :Ifnid,
NPAGES = :Npages,
SLEVEL = :Slevel,
UPDRID = :Updrid,
UPDTTS = sysdate
Where TOWID = :TowId
Operations and processes
Note: Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources
Business\SAIF.Business.Imaging\clsImgsys.vb