running SQL scripts from CLP ?

[gmont66]

hi Gurus out there ... sorry for the newbie question.

I have an Oracle background, so I'm having some trouble trying to port some ideas to the DB2 environment. I'm sure you know all this off the top of your head, so I wonder if you could give me a little hand?

I basically need to write a simple SQL script, to be executed from within a ksh script (Unix - AIX), against a DB2 database. It would run like this:

Db2 connect to INSTANCE_NAME user XXXX using PPP
Db2 -tvf SCRIPT.SQL -z output.out

My questions are regarding what I can do in the SQL script and especially the syntax... For example, I need basic stuff like:

- declare variables
- declare a cursor and fetch rows from it
- run "select into variable" type of select
- execute some date formatting functions

Can I do all of this without being a stored procedure?

I understand that I could do all this in a Stored Procedure, but that would complicate things, I'd like to have a basic SQL script instead, because of time constraints.

Do you know if there's a manual out there with examples? Once I see the syntax, I'll figure it out.

If anyone could help me out in any way or just reply with basic examples, that would be fantastic!

Thanks,

Gmont