Help | Site Map

Forums
- Programming Languages
  
  C / C++ Java .NET Visual Basic Python
- Web Development
  
  PHP Ruby / Rails Perl ASP Coldfusion Javascript / Ajax Flash / Actionscript XML HTML / CSS
- Database
  
  MySQL Oracle SQL Server PostgreSQL Access DB2
- System Administration
  
  Apache IIS Networking Linux / Unix / BSD Windows
- More
  
  Software Development Mobile Development Misc Questions
Howtos
- Browse all Howtos and articles here
Jobs
- Browse All Jobs
- Post Job Listing

Bytes > Forums - Questions and Answers > DB2 Forum

DB2 Forum

DB2 relational database management system (IBM) - ask questions about DB2 administration and development, tuning, clustering, queries, security, API, views, joins, XML, schemas, tables, triggers, SQL and more.

Views: 5,177

Announcement: Only Q & A Threads Here

July 10th, 2008 msquared (Administrator)

Please read me first

Post Reply? | Posted by: docdiesel | Last post by docdiesel, 181 days ago

Hi everybody, of course you all have read the posting guide lines, but I'd like to kindly ask you to keep a few things in mind: Use code tags for... more »

sticky

Dynamic SQL

Post Reply? | Posted by: Sirsuram | Last post by Sirsuram, Today

Hi , I am facing problme with my code. it is not displaying the results of SELECT statement MOVE 'SELECT AAA, BBB FROM sample - ' WHERE... more »

SQL0440 error on delete statement

3 Replies | Posted by: 28days | Last post by 28days, Today

HI, The following SQL statement returns an error SQL0440, complaining about routine '=' not found delete from XXX.YYYYY where YYYY_key = ... more »

SQL30081N error while connecting to a DB2 ver. 7.2 Database

1 Reply | Posted by: toffees | Last post by ganeshmn25, Yesterday

Hi, I am having some problems getting an application server to connect to the database server. Both servers run on Windows 2000 Server. DB2 version... more »

Verify attribute content

1 Reply | Posted by: lordfrodo | Last post by spider007, Yesterday

Im trying to get the DBMS to make sure that my update / inserts only contains valid chars A´-> Z and numbers 0-9 - is that possible ? Brgds Claus more »

SQL query help

Post Reply? | Posted by: ibmdb2user | Last post by ibmdb2user, Yesterday

Hello all, I have a table and need to update the FINAL_FFE column based on the following. FINAL_FFE is FFE divided by count of ASSIGN_ID's in the... more »

Import SPF via Script

1 Reply | Posted by: jbonbright | Last post by benwinnipeg, Yesterday

Hi folks; my first post. I'm a total DB2 newbie who works as a Packager. I've created a package that installs DB2 (old version which I can find out... more »

Max Lehgth Of A Row In Db2

2 Replies | Posted by: 238963 | Last post by ganeshmn25, 3 days ago

HI anyone plz say what is the maximum length of a row in a db2 table..... more »

Db2 loading from Tab delimited Txt file

4 Replies | Posted by: ananthaisin | Last post by spider007, 4 days ago

Hi all, I am pretty much new to DB2 platform and i have one query... I have to import data of about 7 million rows into a Db2 table. i am using... more »

Date function help subtracting dates

Post Reply? | Posted by: ananthaisin | Last post by ananthaisin, 5 days ago

I am having the below oracle statement TO_DATE(to_char(last_day(add_months(sysdate-1,-1))+1,'dd-mon-YYYY'),'dd-mon-YYYY')-ACT_DATE to update a... more »

Sybase to DB2 Migration

Post Reply? | Posted by: donnadimeo | Last post by donnadimeo, 5 days ago

We are migrating a 300gb Sybase DB to DB2. How much can we expect the DB to grow (if at all) as a result of the migration? Give me a number on the... more »

DB2 Stored Procedure Refresh

Post Reply? | Posted by: Piedra | Last post by Piedra, 5 days ago

Hi, I'm new to this site. I would like to refresh the DB2 WLM using JCL. How do I do that ? #VARY WLM,APPLENV=WLMDEVL,REFRESH Currently I use... more »

DB2 Stored Procedure Refresh

1 Reply | Posted by: Piedra | Last post by Piedra, 5 days ago

Hi, I'm new to this site. I would like to refresh the DB2 WLM using JCL. How do I do that ? Currently I use the following command in IOF command... more »

DB2 backup Valid or Corrupted

3 Replies | Posted by: ganeshmn25 | Last post by spider007, 6 days ago

Hi all , I would like to know is there any command available in DB2 V 8.1 UDB in windows platform to check wheather the backup image in... more »

Max Length Of Varchar

2 Replies | Posted by: 238963 | Last post by spider007, 6 days ago

Please anyone let me know what is the maximum length of varchar datatype in db2 tat can we use more »

Embedded SQL returning uncatchable error - Procedure/Trigger

Post Reply? | Posted by: NotepadZ | Last post by NotepadZ, 6 days ago

I am getting a frustrating error when i try to insert into the table the trigger i created is on. Any insight would be appreciated Error: db2 =>... more »

DB2 UDB Objects Dependent on UDF

Post Reply? | Posted by: satyajit911 | Last post by satyajit911, 7 days ago

Hi, Can anyone please provide me information on how we can check which database objects(views, indexes, etc.) are dependent on a UDF. I want to... more »

Db2

2 Replies | Posted by: paida | Last post by ganeshmn25, 7 days ago

Hi everyone.I am a beginner using DB2 i would want to know what the task center doed and how it is related to tools catalog.Thank you more »

Having problem restoring incremental backup

1 Reply | Posted by: lhemski | Last post by ganeshmn25, 7 days ago

Guys, im using dB2 Version 9. I perform all the re-configuration of database parameter for incremental backup. I perform initial full backup and... more »

Database release level

Post Reply? | Posted by: ganeshmn25 | Last post by ganeshmn25, 7 days ago

Hi all , I need to know what is the difference between Database release level=a.00 and Database release level=b.00 Regards more »

SUM function with conditions (>) or (<)

2 Replies | Posted by: seraieis | Last post by ganeshmn25, 7 days ago

Hello everyone! I've run into a little snag with SQL (which I am still very new at). What I'm trying to do it run a query again medical claim... more »

How to Write this SQL Statement?

Post Reply? | Posted by: rohitkishoregupta | Last post by rohitkishoregupta, 7 days ago

Hi, Table A Col1 Col2 Col3 Col4 Table B Col5 Both tables are not linked to each other. more »

DB2 Web Tools - Error code 101

Post Reply? | Posted by: ganeshmn25 | Last post by ganeshmn25, 8 days ago

Hi all, I tried to configure DB2 webaccess tool with tomcat-4.1.30 I followed all the procedures that given in manual . While accessing... more »

ErrorCode

1 Reply | Posted by: PrateetiBhattacharya | Last post by r035198x, 9 days ago

Hi all, I am getting an exception like Exception occurred during Timestamp conversion. See attached Throwable for details. ERRORCODE=-4220,... more »

SQL 103 - "Numeric literal invalid" on SELECT *, but not SELECT a,b,c

3 Replies | Posted by: tdickerson | Last post by docdiesel, 9 days ago

Hi, I'm encountering a strange error after an upgrade has been run on a test site. Attempting to SELECT * FROM table or even just entering SELECT * ... more »

Error in Stored Procedure(DB21034E)Expected tokens may include:"FROM".SQLSTATE=42601

3 Replies | Posted by: saravananmc | Last post by kalyan14, 10 days ago

Hi All, I am new to Stored Procedures, Cursors. I am getting an error "DB21034E The command was processed as an SQL statement because it was invalid... more »

. . .

Top DB2 Forum Contributors