We use an IBM database known as Universe that holds all of our user id's, passwords, and profile information in a table called USERINFO. Can I use the Membership Provider to connect to this database and authenticate the user? The database access is actually through a web service since we don't have a direct connect to the database. ...
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 ...
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? ...
Can anyone provide a function to sanitize input for a UniData query? Or provide a list of things to remove? ...
Hi all, I am building an xml parser and constructor using the XDOM functions in UniVerse 10.1.0. Things are going fine until I get to use the XDOMAddChild function. I can add single elements fine using the handles but I get an error when adding a tree. The manuals indicate adding a tree is fine. XDOMAddChild function Syntax XDOMAddCh...
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'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 ...
I'm trying to begin a transaction however on calling the .Begin() method throws a NullReferenceException and the stacktrace shows that it is coming from IBMU2.UODOTNET.UniTransaction.ServerTransaction(Int32 aKey). Has anyone successfully used UniTransaction, if so is there something that i'm missing? // note: Session is already connec...
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 am creating a sequential file which requires a digital signature (MD5 hash). While I am creating the sequential file I am also creating a dynamic array with the same data. If I perform a MD5 hash on both the sequential file and dynamic array can I expect the result to be the same or different? ...
Our organization is using UniObjects for .NET but the CD seems to have gone missing. I need to figure out how to read and write to and from files in Universe. Please note the program is written in VB.NET Dim uniSession As UniSession Private DATABASE_IDENTIFIER As String = "uvcs" uniSession = UniObjects.OpenSession(_hostname, _username,...
When using the EXECUTE statement combined with the RETURNING clause, UniData returns any error codes encountered along with related data. Does anyone know a definitive list of these error codes? Unfortunately the manuals are lacking in this regard and I'm not feeling particularly psychic this morning. For example EXECUTE MyStatement R...
Does anyone have a quick example of how Associations, @NS and @NV work in UniData? I’m trying to work out associations in dictionary items but cannot get them to do anything. For example, in a record <1,1> = A <1,2> = B <2,1> = Apple <2,2> = Banana I created 3 dictionary items. LETTER and FRUIT, COMBO as follows LETTER: <1> = D <2...
I am working on inserting data into our UniData server from .net. I have successfully updated an existing record using UniQuery by using the Modify statement. And according to the documentation, I can insert new data this way also: "UniQuery also provides the MODIFY command, which enables you to enter or modify data in a UniData fil...
WHAT IS THE DIFFERENCE BETWEEN U2 SCRIPTS AND UNIVERSE BASIC CODE? ...
how can we change the blinking speed of letters in Accuterm ...
how can we migrate from u2 to sql server.tell me the sites where i can find the pdf on migration from u2 ...