CODEWITHSUNDEEP
sqlsyntax
Alex Yeung
Alex Yeung

Reputation: 2515

Where is Simba DB SQL Reference?

I have never used Simba DB before... however my boss needs me to do integration between Simba DB and our system.

I just want to see the syntax of Simba SQL. However I can get no result on internet.

I just want to know two syntax.

One. Type conversion statement

select convert(StartDate, varchar)) from MyTable

where StartDate is Date type. I want to convert to char or varchar. But I got

System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Simba][SimbaEngine ODBC Driver]The second parameter varchar for CONVERT is invalid.

Two. Inner sql statement

select * from (select * from MyTable)

This syntax is totally failed.

Please help...orz...

Alex

Upvotes: 0

Views: 2264

Answers (2)

oae
oae

Reputation: 1652

I struggled with this as well... Got following examples from a Simba contact:

select convert(DATE_COL1, SQL_VARCHAR) from Date
select convert('2011-04-01', SQL_TYPE_TIMESTAMP)
select convert('2011-04-01', SQL_TYPE_DATE)

Which i could apply successfully!

Upvotes: 0

Derek
Derek

Reputation: 23238

You can find documentation here: http://www.simba.com/odbc-sdk-documents.htm

Upvotes: 1

Related Questions