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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.