title: Declare a variable in DB2 SQL
body: <p>Does anyone know how to run the following SQL Server code in DB2?  </p>
  
  <p>I am converting SQL Server scripts so that they will run on a DB2 system and am having some problems wrapping my head around the use of variables in DB2.</p>
  
  <p><strong>T-SQL code</strong></p>
  
  <p>This is obviously not the actual code but works well as an example.</p>
  
  <pre><code>DECLARE @INPUT_VALUE INT
  SET INPUT_VALUE = 4756
  
  SELECT *
  FROM TABLE1
  WHERE TABLE1.COLUMN1 = @INPUT_VALUE
  </code></pre>