but you do need literals to introduce simple constants into Prepared
statements.

It is funny.  I did quite a long search, but came up with no
definitive table.

I have done a first cut at a table of function. They need to be
fleshed out with details mostly about 0- or 1-basedness.

see http://mindprod.com/jgloss/jbdc.htm#FUNCTIONS

SQL92 doesn't have a specific literal for long, or int for that
matter. Integers and decimals are covered by 'exact numeric literal':

 digits [ . [ digits ] ]  | . digits

There is no specified limit on the number of digits.

Alternatively, you can use prepared statements (as suggested) or:

 {fn convert('10',SQL_BIGINT)}

Other suggestions for the Literals section:

+ SQL92 only specifies using single quotes for delimiting string, with
two single quotes to indicate embedded quotes. Double-quotes are
reserved for quoting names. This is not true for all SQL DBMS vendors,
though.

+ Timestamp literals have an optional fraction for seconds - [.f...].

Suggestions for the Functions section:

+ The 3rd argument for LOCATE is optional.

+ TIMESTAMPADD and TIMESTAMPDIFF have a first argument (interval) that
the form - SQL_TSI_XXXX. Where XXXX is YEAR, DAY, SECOND, ... It
specifies the interval being used in the calculation.

+ The second argument for CONVERT is prefixed with SQL_.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)