- users-list - monetdb.org

[MonetDB-users] how we get the timestamp value 10 minutes before from current_timestamp
by pawan123 28 Sep '07

28 Sep '07

how we get the timestamp value 10 minutes before from current_timestamp -- View this message in context: http://www.nabble.com/how-we-get-the-timestamp-value-10-minutes-before-from… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] how to run TPC-H benchmark on MonetDB
by xxiao 27 Sep '07

27 Sep '07

hi, I am a beginner of MonetDB. I want to run TPC-H benchmark on MonetDB. I found there are SQL queries and related files under monetdb source folder <monetdb-source>/sql/src/benchmark/tpch. I ran the script 'run.all'. But that gave me many errors and did not succeed. Can anyone describe briefly the steps I need to carry out in order to run TPC-H benchmark? Any documentations I can refer to is highly appreciated. Thank you. -- View this message in context: http://www.nabble.com/how-… [View More]

4 5

[MonetDB-users] minus 10 minutes from current_timestamp
by pawan123 27 Sep '07

27 Sep '07

how we minus 10 minutes from current_timestamp. because i have to fetch all the records from a table 10 minutes before currenttimestamp. so pls tell me how we deternine 10 min before timestamp value. Thanks pawan -- View this message in context: http://www.nabble.com/minus-10-minutes-from-current_timestamp-tf4526685.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] I want to select records from MonetDB
by pawan123 25 Sep '07

25 Sep '07

I want to select records from a table on the basis of date in MonetDB and then insert all these selected records in a table i.e. present in oracle using C or Pro*C. can any one help me in writing the code. Thanks in advance. Pawan -- View this message in context: http://www.nabble.com/I-want-to-select-records-from-MonetDB-tf4514715.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Database tool
by Venks 25 Sep '07

25 Sep '07

Hi, What's the good database tool that I can use to connect to MonetDB, run queries and browse the objects? I used to use DBVisualizer earlier and now both 5.1.1 and 6.0.x version are giving errors. I installed the latest version of the MonetDB couple of weeks ago and I think the changes in the new version of MonetDB (JDBC) are causing these issues. Thanks, -Venks

3 2

[MonetDB-users] building client on Windows
by Sander Kruseman 24 Sep '07

24 Sep '07

Hi, I want to construct a Monet client app in C on Windows but find very sparse info on this. I took notice of the fact that Windows is apparently not exactly Monet's main target platform. Still, I tried using nmake on the client sources but ran into errors involving missing (or incorrectly placed) files (see below). Do I really have to go through the complete 'Experts > Windows Installation', i.e. building MonetDB server itself? regards, Sander ...\clients-1.18.2\src\mapilib>… [View More]

2 1

[MonetDB-users] Cannot manipulate XML Document
by Timothy Marc 24 Sep '07

24 Sep '07

Hello all, I've downloaded MonetDB XQuery for evaluating the XQuery Update Facility. I've shredderd a document and can perform xqueries from MapiClient successfully. But, when i try to update a document, the process fails with error message: !ERROR updating read-only document. May i have to specify some flags or something else??? Thx Timothy

2 1

[MonetDB-users] can we create cache group in MonetDB
by pawan123 24 Sep '07

24 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan -- View this message in context: http://www.nabble.com/can-we-create-cache-group-in-MonetDB-tf4492681.html#a… Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] can we create cache group in MonetDB
by Pawan Kumar Gupta 21 Sep '07

21 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan

1 0

[MonetDB-users] Persistent Stored Modules and a SQL issue
by Venks 18 Sep '07

18 Sep '07

Two questions. 1. Can I execute a dynamic DDL statement using PSM? 2. I am trying to create a script where I would like to DROP A TABLE before re-creating it. If I include the DROP TABLE in the script, MonetDB throws an error and STOPs execution if the table is not found. This is rather painful as I would like MonetDB to continue with the next SQL command. For. e.g DROP TABLE table1 ; CREATE TABLE table1 .... If I include the above 2 commands in one script, then the above scripts stops … [View More]

2 3