Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. etan1999

    MQ in COBOL/DB2 program

    I don't know why when my batch COBOL/DB2 program abends, the previously processed MQ messages (using MQGET) are still on the queue even if I issued a EXEC SQL COMMIT END-EXEC. The database changes have taken effect but all messages stay in the queue. Is there another way of issuing some kind...
  2. etan1999

    DB2 Timestamp Value

    Hi. I have a table with a column defined as TIMESTAMP. Is it possible to insert a value into this column, using a variable PIC X(26) containing a value in DB2 format "YYYY-MM-DD-HH.MM.SS.ssssss" ? Thanks.
  3. etan1999

    Db2 Indexing

    T. Blom, Thanks for the immediate response. Yes, there are 3 indices defined for this table but none include this date field. We are working with our clients to see if they would be flexible enough to do a search based on other columns too.
  4. etan1999

    Db2 Indexing

    Hi all. My application is having timeout problem due to the length of time to execute a DB2 Select statement. It is going against a table, averaging about 18 million records with 22 columns. This sql statement has one WHERE condition, a date field which is NOT part of any index. I have asked...

Part and Inventory Search

Back
Top