I have a table which has about 7 columns and the first row of all the collums is NULL.. when i do a select statement something like

Select * from tablename order by col0 NULLS FIRST..

It says the NULLS clause is not supported.

If i use simply

Select * from tablename order by col0 ..

By default the Null row is displayed at the last but i created it in the first row.. ...

AM using the JDBC interface metho getProcedures() to get the stored procedures from the Database... Since this is common interface method am trying out with two different set of databases namely MySQL, DB2 and Oracle too.. For oracle and MySQL the getProcedures() returns the stored procedures as well as the Functions.. But for DB2 it returns only the stored procedures not the functions...

What changes should i do so that the interface...

Thanks.. it solved the problem

CREATE PROCEDURE PART6(IN a FLOAT, IN b FLOAT, OUT retval FLOAT)
BEGIN
retval = a * b
END

The above procedure creation statement throws error saying

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "retval" was found following "retval FLOAT)...