We currently use a PAM for local authentication, but this does not help
with remote clients.
I am thinking of writing an OpenLDAP plug-in. Has anyone written a
userid and group plug-in against open LDAP? How has it performed?

A client gave a spreadsheet that has this column format:
.u29034c.ccridl.djkcjd
I need to parse out only the characters between the first two periods
in the column using only SQL.

Please,
I'm an Oracle user (ooohhh!!!  :-P ) but I have practices with DB/2.
My question it's very simple.
In Oracle I  write procedures with PL/SQL.

Do you know of any udb column functions resembling MS-Access "First" /
"Last"  functions?
Regards,
tuarek

I have a question related to backup and restore procedures; When
backing up and then restoring a DB2 database on another machine, does
the process copy all of user defined store procedures and functions
over to the target machine?

I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?

Hi to all NG
I write a *.sqc program. In this program I 'ld like to declare a struct in
the declare section, but during the precompile the system told me :
48   SQL0008N  The token "[" found in a host variable  declaration is not

I'm fairly new to DB2 Stored Procedures so not sure how best to go about this.
I need to generate a csv file that will contain data from approximately 9
different tables [I do not wish to have a single query for this] -
approxinmately 150 columns. This will be accessed via a servlet ...

I am getting duplicate rows back from a select distinct statement of the
form:
SELECT DISTINCT 'jhough', '000111', t0.bhid
  FROM (SELECT lots of good stuff) t0

I am testing a database application.  It works fine when only one user
uses the application, however, when there are concurrent users, I saw
rollbacks in event log.
Can experts in this group tell me what is going on?

Using AS400 DB2, AquaData Studio SQL editor
I am new to DB2 coming from a SQL Server background. How do I get
something like the following to work?
BEGIN

I have a DMS tablespace named D_0001 which has 3 containers and hosts a
single partitioned table. I would like to reduce only the size of the
first container (p1data/tbspace/D_0001). Hence I used the command
alter tablespace D_0001 reduce (FILE '/p1data/tbspace/D_0001' 100)

I am running explain plans on different SQLs and need some help reading
the output. Is there a document that will help me understand this? Any
help will be appreciated.
Thanks

I have a UDFs defined in a C source file. I also have a Microsoft Visual
Studio 2005.
Can someone please tell me how to compile this C source with Microsoft's
compiler into a DLL? I'd prefer the command line options :)

I have a large (perhaps small) table (foo)  of 48 Million rows  and I
have a temp table which I load with keys (2 to 3 Mil).  I use the temp
table to extract and aggregate some columns from foo (basically by a
transaction date) that I then insert into a summary table.  Now foo