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 SkipVought 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. allanhicks

    Select record with nearest value

    I have a table with fields FA & FD where FA is a key field and FD is a date. I want to know how to select, via sql, one record for each available key where the date is closest to but not more than a specified date. eg if the table looked like: FA, FD 1, 01/01/2000 1, 30/03/2001 1, 21/09/2001...
  2. allanhicks

    DB2 Host Variables in Visual Basic

    Hi, I am trying to perform SQL queries on DB2 tables that return a single row result, eg SELECT PRODUCT_NAME INTO :PNAME FROM PRODUCT_FILE WHERE PRODUCT_NAME = 'XXXX-XXX' Where :PNAME is a 'host variable' as defined in the DB2 SQL guide. For example, in COBOL is could be defined as follows...
  3. allanhicks

    DB2 Host Variables in Visual Basic

    Hi, Can anyone tell me if it is possible to use DB2 host variables in Visual Basic. I have searched the documentation but can only find examples for C++ & COBOL. If it is possible could you provide a code sample on how to utilise them. I have asked this in the DB2 forum but have received no...
  4. allanhicks

    DB@ host varaibles in Visual Basic

    Hi, Can anyone tell me if it is possible to use DB2 host variables in Visual Basic. I have searched the documentation but can only find examples for C++ & COBOL. If it is possible could you provide a code sample on how to utilise them. Thanks, Allan Hicks

Part and Inventory Search

Back
Top