DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool
Posted
by KenB
on Stack Overflow
See other posts from Stack Overflow
or by KenB
Published on 2010-02-25T19:10:21Z
Indexed on
2010/03/28
3:23 UTC
Read the original article
Hit count: 447
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.
For example, in the SQL Server world I would easily do this in the SQL Server Management Studio query window like so:
DECLARE @VariableName varchar(50);
SET @VariableName = 'blah blah';
select * from TableName where Column = @VariableName;
How can I do something similar in the IBM System I Navigator tool?
© Stack Overflow or respective owner
