DB2 Web Query – Active Report Show Unreadbale Data
I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this [...]

Answer Question   |  February 26, 2010  4:50 AM
DB2, DB2 query, DB2 Web Query

mainframe db2 – get current month and year
Please advise. My DB2 statement does not work. gl_date is a date field, format is ‘yyyy-mm-dd’. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date);

Answer Question   |  September 21, 2009  1:24 AM
DB2, DB2 query

i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that
i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that

Answer Question   |  July 27, 2009  5:35 PM
DB2 query

Compare a field from a file to a column from DB2
Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

Answer Question   |  May 18, 2009  10:33 AM
AS/400 database administration, DB2 query, DB2/400, Virtual Storage Access Method, VSAM

In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.
In DB2 when I’m giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you [...]

Answer Question   |  August 6, 2009  12:23 PM
DB2, DB2 query, SELECT statement