You need to generate the SQL statements from the Deploytool.
In the entity beans properties, theres a tab for that, I forgot which one (sorry I'm not using my development computer now)
You will need to run Cloudscape first, from the command line.
In the j2ee/bin directory, I think it was "cloudscape -start".
Then you'll have to tell the Deploytool the JDBC
connection settings. Once done, you can press the "Autogenerate button" and it will generate all the necessary SQL statements for Cloudscape.
Sorry that I can't explain in detail now. I hope you can figure it out.