title: How to write stored procedure in DB2
body: <p>Please Help me in to write the stored procedure in Db2.</p>
  
  <pre><code>CREATE PROCEDURE assedt
  BEGIN 
  
   SELECT ASSETNUM FROM ASSET
  END 
  </code></pre>
  
  <p>I tried the above code it is throwing an error like below:</p>
  
  <blockquote>
    <p>Error report -
    DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=SELECT ASSETNUM;ROCEDURE p1
    BEGIN </p>
    
    <p>;, DRIVER=4.12.55</p>
  </blockquote>