DatabaseLink SQL Operations
DATABASELINK SYMBOL

WriteDataSource

WriteDataSource[name]
writes a new HSQL data source name.

WriteDataSource[name, database]
writes a new data source to database.

DetailsDetails

  • To use WriteDataSource, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Description"""textual description of the data source
    "URL"AutomaticURL to use in the JDBC setting
    "Username"Automaticusername for the connection
    "Password"Automaticpassword for the connection
    "Properties"{}properties to set for this connection
    "Location"Userwhere to install the data source
    "RelativePath"Automaticwhether file-based databases have a relative path
    "UseConnectionPool"Automaticwhether a connection pool should be used
    "ReadOnly"Automaticwhether the connection should be read only

ExamplesExamplesopen allclose all

Basic Examples (2)Basic Examples (2)

In[1]:=
Click for copyable input

Create a new data source named that will use the HSQL database:

In[2]:=
Click for copyable input
Out[2]=
In[1]:=
Click for copyable input

Create a new data source that includes the and and is available to all users:

In[2]:=
Click for copyable input
Out[2]=
Top
Send Feedback
Mathematica 9 is now available!

400+ new features, including the new Wolfram Predictive Interface, social network analysis, enterprise CDF deployment, and more »

Try Now
Buy/Upgrade
New to Mathematica? Find your learning path »
Have a question? Ask support »