title: DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool
body: <p>I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using a variable that I declare.</p>
  
  <p>For example, in the SQL Server world I would easily do this in the SQL Server Management Studio query window like so:</p>
  
  <pre><code>DECLARE @VariableName varchar(50);
  SET @VariableName = 'blah blah';
  
  select * from TableName where Column = @VariableName;
  </code></pre>
  
  <p>How can I do something similar in the IBM System I Navigator tool?</p>