ICES Marine Data
DATSU
 
DATSU > List of operations > Specification of the format > Details of the check
 

   
Details of a check:
   
Record: D1
Check Description: Metier Level 6 is not valid, please check if the code is valid
Error type: error

RecordSQL ExpressionSQL Type
D1FROM RD1 LEFT OUTER JOIN (SELECT tblCodeID, Code FROM RECO.dbo.tblCode WHERE (tblCodeTypeID = 1647)) AS C ON replace(replace(RD1.MetierL6,'Bigger','>'),'Smaller','<') = C.Code WHERE (C.tblCodeID IS NULL) and RD1.MetierL6 is not nullFree SQL

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 · info@ices.dk
Disclaimer © ICES - All Rights Reserved