# 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

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)