SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Excel SQL: Which functions can I use?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

krausr79
Starting Member

18 Posts

Posted - 10/01/2012 :  09:34:55  Show Profile  Reply with Quote
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.mrexcel.com/forum/excel-questions/662196-excel-sql-functions-can-i-use.html#post3281975

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 10/01/2012 :  09:39:43  Show Profile  Visit robvolk's Homepage  Reply with Quote
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
Go to Top of Page

krausr79
Starting Member

18 Posts

Posted - 10/01/2012 :  10:31:56  Show Profile  Reply with Quote
Now that points me in the right direction! The search term as400 helped me find a couple manuals:

http://publib.boulder.ibm.com/html/as400/v4r4/ic2924/info/db2/rbafzmst.pdf

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/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,
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000