Hi, I'm sure this is down to my misunderstanding something but could someone help me out.
I'm trying to use Cloudscape as a DB in WSAD and have the following questions.
I wrote the table creation SQL then selected 'Run against Local' and this quite happily created the table definitions in my project.
I then wrote SQL statements to populate these tables. If I select 'Run against Local' for this code it bombs out saying
IWAS0024E Invalid parser root object 'INSERT INTO MYTABLE' whatever that means!
I then tried exporting to a server from WSAD and the population SQL runs fine!!!
My understanding is that 'local' is a local DB to WSAD and exporting to a server runs the DB remotely. I noticed (after much trawling on the internet) that when I set up the connection to the server you have to specify create=true on the DB location to create the Cloudscape DB in the 1st place. Do I need to do something to create the 'local' database 1st or is it actually there implicitly on creating the table definitions?
As usual the documnentation is a bit lacking on the infocenter!!
Does anyone have any links that could help??
Thanks to anyone who replies
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop