I have a SQL file containing a few CREATE PROCEDURE/FUNCTION
statements.
This file is meant to be run against a database when installing a
software product, and again when updating the product.

This has been posted a few times but still I could not find a way to
connect to our database.  We run DB2 Express on WIN2K server with XP
clients.  I can ping inside network and to the Internet from the
server, so TCP/IP is ok.  The DB2COMM=TCPIP is set also.

Right now we have DB2 on Z/OS, collecting information on putting DB2 on
Linux zseries. So that our company can save money on Z/OS cpu cycles(or
MIPS).
On our mainframe we have OMEGAMON,CICS,RACF,TSO and PLATINUM tools are

Can someone point me to good documentation on 'WITH clause" ? (I
couldn't get much
out of Queries section from SQL Reference manual).
We are getting better performance when we explicity use global temp

The information center writes:
"Encryption Algorithm: The internal encryption algorithm used is RC2
block cipher with padding, the 128-bit secret key is derived from the
password using a MD2 message digest.

I'm using DB2 9 Developer Workbench, Debug icon is dim (deactivated), I
tried all help tools how to setup, but failed..
Am I missing any installations? or is there any special setting?
Thanks for help

I have a table of populations of cities (identified by country, state,
cities) on particular dates.  How do I transpose the date values in my
rows to a date value column that lists populations for that date.  In
other words go from this:

i heard that db2 ignores indexes when using any column function on the
column which has index on it. but i have seen db2 using indexes even
when using column function.
what is the criteria of db2 about picking index or not picking index

Let's have a data of type DECIMAL(6, 2) and with value 0.01.
How can I convert this one into a "pretty" CHAR?
I've tried
VALUES(CHAR(DECIMAL(0.01, 6, 2)))

Has anyone come upon this problem?  My DB2/LUW 9.1 database seems to be
both "started and not started".  Check out the following:
C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

Dear mainframers,
                  I'm sorry to bother you in this group but I'm
totally new to this mainframe world but I have a question that I
believe you are the best people to answer.

I cant seem to find a list of possible exit codes from db2. I know I've
seen somewhere that 4 means error, and 0 is ok. Experimenting a bit
further I get 1 and 2 as warnings (but I dont know the difference). Are
there more, and what do they mean?

I am trying to insert into a temporary table but only the first n
number of rows.  I thought I could use the combination of insert into
and fect first row command ,but it won't work.  Does anyone know why?
Any other suggestions other than writing a loop?  This is in a db2 sql

Noticed the command "#Sync 10"
What does that do - is it a form of a commit?

Please help...
To make it simple, I have a simple test C program which calls my
semphore library functions only.  (It doesn't call any db2 function at
all).  And the following is the test program: