Forum: DB2

Hi, My company would like to implement column level encryption for columns storing client data for compliance purpose. Is there a way to implement...

I have just been informed by a work colleague that IBM is going to drop support for DDM files in the release after V7R1. As we use DDM files...

My former employ (I'm semi-retired) had a crisis after a V5R4M0 upgrade to V6R1M0...Some DB2 changes had "tightened" up some rules apparently and...

I have thousands of objects in my one library, i want to automaticaly segerate Programs, Reports & Inquiry Programs. Any one idea how to do pl. help...

Got a new project working to receive a XML from a vendor that needed to parse into 2 databases. I tried using the new feature (Annotation...

Does anyone have any example of using CTE with an UPDATE included?

Hi, 3 steps to acccess any database over jdbc from STRSQL, QMQRY and embedded SQL - install ArdGate its open Source and available at:...

We are replacing all our DDS Physical Files with Tables created using DDL (SQL Create Table statments). One of the requirements is that the new...

Looking for the latest news and technical education on IBM DB2 for i to ensure that you are fully leveraging the integrated database for IBM i®?...

DBinfo - the new free Database Editor for system i (iSeries-AS/400-i5) Check this new free product from KST Software. Link to download:...

I've printed out some source files using option 6 and then used Navigator to copy them to the IFS drive. By default these files are named...

Hello, We have over 100 LF's built over some JDE Files like F0911, F4211, F42119. Is there an easy way to figure out if these index's are being...

** This thread discusses the article: Navigate DB2 for i Through the SQL Server Galaxy ** ** This thread discusses the Content article: Navigate...

Does anyone know how to reset an identity column seed value of a DB2 SQL table/file, without recreating the table? Either to 0 or to a larger...

I am new to DB2 on an AS/400 V4R3. On mysql this works: SELECT 1 + 1 AS Number I've searched for DB2 table synthesis, DB2 Math. Anyways it...

I'm curious if there's any possible way, using DDS, to create a join logical file where data from two different files is required to join to a third...

I haven't worked on trigger programs in years and have a question. We have a (*UPDATE *BEFORE) trigger over a file. Trigger condition is *Always...

We have developed a J2EE, JBOSS application (on Linux O/S) with DB2 as backend database. As customer wanted a failover of database in real time and...

Re-posted since the posting to "Stumped" thread. I made a title difference from the post I replied to and sort of lost the hook to the thread...

Another twist on the last trick Joe mentioned...You can create the QTEMP table and populate it at the same with one SQL statement. Try the DECLARE...