The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
0answers
763 views

Problem inserting data into a mysql table with column names having a space

I have a mysql table whose column name has space. I tried inserting the data into this column. I got an error I tried a sample code, which tests accessing the columns with a space and that returns ...
2
votes
0answers
215 views

Can Mathematica use a MySQL ODBC connector?

I have a MySQL database that I connect to using Mathematica and would like to distribute my Mathematica code to others. We already have ODBC DSNs setup on peoples machines using the MySQL ODBC ...
1
vote
0answers
49 views

How can I connect database oracle with Mathematica

I try to connect to an Oracle database with Mathematica but I get this error: DBC::classnotfound: oracle.jdbc.driver.OracleDriver" My code: ...
1
vote
0answers
77 views

Using Mathematica to connect to Cloudera Impala

I am trying to connect to Cloudera Impala via Mathematica, but so far I have not been able to do so. Has anyone ever done it? I have been able to connect to it via R using the JDBC or ODBC interface ...
1
vote
0answers
75 views

Importing SQL view vs table

I am trying to import a SQL view not a table in Mathematica. The command: SQLSelect[conn, "DataByYear"] This will correctly bring in the table. However using the ...
1
vote
0answers
131 views

I can create an H2 database with the H2 Console, but I can't find the database with MMA

I can create an H2(Server) database using the tool that H2 provides, but although i can create a memory based H2 database with the Database Explorer, when I try to create a connection to the ...
1
vote
0answers
119 views

Datastream to Mathematica

I currently use data from Thomson Reuters Datastream. With an add-in in Excel, the data can be requested. Because I need to use the data in Mathematica, and I need to update the data frequently: Is it ...
0
votes
0answers
43 views

how to use a tree as a key to construct a table of key values

I have an interesting problem that I was able to summarize in the form of trees, sets, and key value pairs. I have the following sets of keys and values \begin{equation} \begin{aligned} k_0 &= ...
0
votes
0answers
69 views

Mathematica SQL command that counts records in table

Is there a DatabaseLink command other than SQLExecute that can be used to count the total records in a database table?
0
votes
0answers
67 views

Improve performance of processing transactions in a large file

I want to work with a table which has 296,705 transactionslines and 172,147 transactions. ...