Excel SQL: which functions can I use?

[krausr79]

I do all my SQL statements using excel VBA. I search for help with syntax and statements online, but more often than not I try to use some sweet-sounding SQL function and it comes back with:

sql0204: DATEADD in *LIBL type *N not found

Where dateadd was the latest nifty function I'm trying to use. Is there some way I can use this function? Or is there somewhere I can find an exhaustive list of available Excel VBA sql functions?

I'm also posting this question at:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=179379

[krausr79]

Answers from the other forum:


Excel doesn't actually "support" SQL, nor does VBA. They
offer a programming interface that lets you connect to SQL databases, and you
get access to whatever functions/features that SQL product
supports.

Regarding DATEADD and the error message you're getting, it
looks like you're accessing an AS/400 - DB2 database, which doesn't support that
function.

SQLTeam is a Microsoft SQL Server website, so we really can't
help with DB2, but dbForums can: http://www.dbforums.com/db2/1637371-help-there-dateadd-function-db2.html


Now that points me in the right direction! The search term as400 helped me find a couple manuals:
http://publib.boulder.ibm.com/html/a...2/rbafzmst.pdf
http://publib.boulder.ibm.com/infoce...2/rbafzmst.pdf
Not completely sure which one is exactly right for me, but these should provide a rich source of possible things to try and a place to look up potential functions that don't seem to be working,