---
# System prepended metadata

title: QRCA Procedures

---

# QRCA Procedures

- QRCA_START_NEW Procedure checks

|Step |   Description         |  SQL Instructions             |ARC|
|-| ----------------- |:----------------------- |--|
|1|   Controllo parametri di input NOT NULL       | anno IS NULL OR periodo IS NULL OR codice_archivio IS NULL OR progr_file IS NULL| LOAD|
|2|Check  PROGRESSIVO_TRACCIATO valido|  SELECT PROGRESSIVO_TRACCIATO FROM SISME_FILE WHERE CODICE_ARCHIVIO= codice_archivio  AND PROGRESSIVO_FILE= progr_file AND ANNO_A IS NULL    | LOAD|
|3|    Recupero PROGRESSIVO_TRACCIATO e richiamo di QRCA_START      |    |  LOAD|

- QRCA_START Procedure diagram

```flow
st=>start: Start
e=>end
select1=>inputoutput: Select * :> /LxqODxcOSZqgZNpqbRfqVA[blank]
op1=>operation: Read Cursor
condCursor=>condition: Exists Cursor
condID=>condition: rec_fetched.column_id = 1 
storeF0=>subroutine: STORE FLAG 0: Numero record
totali del tracciato
selectNotNULL=>inputoutput: Select Not NULL :>[]
storeF1=>subroutine: FLAG 1: STORE NOT NULL
selectSISME=>inputoutput: Select SISME
opEcc=>operation: . . . 

st->select1->op1->condCursor
condCursor(yes,right)->condID
condCursor(no,left)->e
condID(yes,right)->storeF0->selectNotNULL
condID(no,left)->selectNotNULL
selectNotNULL->storeF1->selectSISME
selectSISME->opEcc(left)->e

sub1=>subroutine: My Subroutine
cond=>condition: Yes
or No?:>http://www.google.com
io=>inputoutput: catch something...
para=>parallel: parallel tasks
```
- Auto-generated Table of Content
[ToC]


- And MORE ➜ [HackMD Tutorials](https://hackmd.io/c/tutorials)
