My problem is a visual basic select what I like migrate to a stored
procedure, by example:
str="select * from t1 where"
str=str & IIf(a=0, t1.a>0 and t2.b<0, t1.a<0) & "and " & IIf(c=0,

I am an Electrical background engineer n now trying to switch to
software guy.
I know  basic knowledge of computers and now i am planning to take up
the DB2 700 exam.

I had a problem when I restore a db2 V7 EE Fixpack 5 on AIX 4.3.3 to
db2 V8 ESE Fixpack 3 on AIX 5.1.
Once I restored db2 db (PRD) to V8 and tried to connect to DB, I had
the following problem:

Anyone know if stinger will support multi-character column & record
delimiters in loads or imports?
I'm assuming that no documentation is yet available - at least I
haven't been able to find any (mostly due to the nifty website

I'm having trouble doing multiple counts with groups, ordering, and
joins.  Can someone help me out? Below is two table samples and what
I'm trying to get my output to be:
TABLEA

I am new to db2.  In sql, I was able to execute the following commands
succesufully:
Select A.Phone, B.*
From A, B