We have a traditional UV account. Data files in one directory, application programs & subroutines in another directory. Our latest projects is implementing JDBC and in order to fully access the subroutines from java, I belive I need to create a schema on the existing uv account. How can I do this? I tried logging in as uvadm and create ...
I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is that it is a bad idea to make use of multiple values in a single field. Traditionally if you wanted to allow for a record to have several values for a field you would create another two tables and link them with foreign ...
We have an IBM UniData server. I just installed UniObject .net. It looks like you just issue unidata queries through the .net classes. Where can I learn the query language/syntax and to work with UniData in general? What books, sites, or videos do you recommend? ...
Anyone have any interest in intergrating RDF and/or SPARQL with a PICK database? Has anyone tried this yet? I have some thoughts about what to try. One idea is to figure out how to create a file with a dictionary that defines some correlatives that allow data to be pulled from the file as RDF, as one or many of n-triple, turtle, n3 or XM...
I've recently come in contact with a proprietary descendant of UniVerse. Does anyone know where I can get a good tutorial or brush up on the syntactic quirks of its more popular parent? I can't figure out how to even get a table listing. Navigating my way around is difficult, and I don't see any man pages. UPDATED with the official Rock...
I have a question taken from pg 16 of IBM's Nested Relational Database White Paper, I'm confused why in the below CREATE command they use MV/MS/MS rather than MV/MV/MS, when both ORDER_#, and PART_# are one-to-many relationships.. I don't understand what value, vs sub-value means in non-1nf database design. I'd also like to know to know ...
I am a software developer with devlopment experience in C#, C++ .Net alongwith SQL Server 2005/08, Oracle and mysql. But somehow i dont get jBASE to work at Windows XP SP3 machine. My goal is setup user accounts, create database on a JBASE ainstallation, authenticate and backup/restore few table via a C++ program. And i dont need to do ...
I've got an issue where a table (file) is set up to return column foo on LIST table and SELECT * FROM table. I need to know the other possible columns in table. I'm pretty sure this was achieved by setting @ (behavoir definition of unqualified LIST), and @select (behavoir definition of * with very SELECT) but I don't know how to get the ...
Kind of a follow up to my self-answered question about finding the column names. In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't how do you query a table for all of its column's values? So I can get the total column listing (column ...
Does anyone here run the Basic Developer Toolkit with UniData 7.1? Even though the IDE was released with UniData 7.2, I was given the impression that it works fine with 7.1. However, when opening up "Database Files" in an account, every single DIR type file gives a loading error dialog and doesn't register any records in them. Are chan...
I'm looking for some free software to let me browse through the files/records in a Unidata server. I found a program several months ago, but have no idea what it was called or where I found it. ...