• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

WSAD Databases/Cloudscape

 
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

Graham
 
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
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic