1
  • Need some help with queries in DB2

    Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.Search the entire database that look for tables with a column called "Remarks"Search...

    ITKE344,855 pointsBadges:
  • 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 ?...

    Liverpoolfc20 pointsBadges:
  • 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);

    Rulala5 pointsBadges:
  • 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 in advance.

    UmaGandreddi80 pointsBadges:
  • 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

    Iluilu5 pointsBadges:
  • 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.

    BobBill10 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following