1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT CASE nmr.ligne
WHEN 1 THEN 'help view ' || TRIM(tbl.DatabaseName) || '.' || TRIM(tbl.TableName) || ' ;'
WHEN 2 THEN ''
WHEN 3 THEN '.if errorcode = 3807 then insert into DB_RECETTE.LHU values('''
|| TRIM(tbl.DatabaseName) || ''', '''|| TRIM(tbl.TableName) || ''', ''Existe pas'');'
WHEN 4 THEN '.if errorcode <> 0 then .goto SQL_ERREUR;'
WHEN 5 THEN ''
END
FROM db_datamart.lhu_g AS tbl
CROSS JOIN
( SELECT 1 AS ligne
UNION SELECT 2
UNION SELECT 3
UNION SELECT 4
UNION SELECT 5
) AS nmr
WHERE tbl.lot = '3'
ORDER BY tbl.DatabaseName
, tbl.TableName
, nmr.ligne
; |
Partager