!!!DB2 データ有無をフラグに変換
[DB2][Database]{{category SQL}}

 SELECT A.CNT,
   CASE
    WHEN A.CNT > 0 THEN 1
    ELSE 0 END
 FROM (
  SELECT COUNT(FIELD01) CNT
    FROM TEST_TABLE
   WHERE FILED01 = '0000'
 ) A