SQL - Exemples Console SQL dans Hana Studio (1)

Exemple de Select : OK why not

set schema SAPANWR01;

select count(distinct "/BIC/ZMAT_PO") as "nombre" from "/BIC/PZMAT_PO" ;

Exemple d'update : C'EST LE MAL

set schema SAPANWR01;

update "/BIC/AZSPD_A0012"

set "CALWEEK" = '202218'

where "CALDAY" = '20220501'

and "/BIC/ZTRID" = '7-1000-1000-20220501142830-6-618';