• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1812
  • Last Modified:

Declaring variables

I normally use MSSQL and am not as familiar with DB2.  In MSSQL, I can declare and set variables like this:

DECLARE @begdate DECIMAL(8,0)
DECLARE @enddate DECIMAL(8,0)

SET @begdate = '20060101'
SET @enddate = '20060626'

How would I do the same thing in DB2?

I am trying to run an SQL statement against an i5 database using iSeries Navigator.

Thanks.

Derrick
0
dnsvh
Asked:
dnsvh
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi  Derrick,

You can't create DB2 variables in most SQL client interfaces.  You'll have to code a Stored Procedure or Function to do that.

But the syntax is similar:

  DELARE NAME VARCHAR(24);


Kent
0
 
dnsvhAuthor Commented:
Thanks, Kent.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now