u2

What is the best way to handle authentication in ASP.NET MVC with a Universe database?

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. ...

IBM U2 (UniVerse 10.2) - Create Schema - How

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 ...

Learning to query UniData

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? ...

Sanitize Input for UniData

Can anyone provide a function to sanitize input for a UniData query? Or provide a list of things to remove? ...

XDOM API in UniVerse

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...

Pick and RDF/SPARQL

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...

UniVerse learning materials

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...

Multi-valued Database (UniVerse) -- SM (MV) vs SM (VS) and ASSOC()

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 ...

How do I find the column listing in UniVerse with RetrieVe or SQL?

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 ...

UniVerse RetreiVe how do I query a file for all of its column's values?

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 ...

UniTransaction throwing NullReferenceException

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...

U2 Basic Developer Toolkit

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...

MD5 hashing of Sequential files and dynamic arrays in UniData

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? ...

UniObjects for .NET - Reading and Writing UniVerse Files

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,...

UniData EXECUTE's 'RETURNING' clause. List of error numbers?

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...

How do associations, @NS and @NV work in UniData Dictionaries?

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...

How To Insert Data into UniData using UniObjects for .NET

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...

question from universe-database

WHAT IS THE DIFFERENCE BETWEEN U2 SCRIPTS AND UNIVERSE BASIC CODE? ...

how to change the blinking speed in accuterm

how can we change the blinking speed of letters in Accuterm ...

migration from universe database

how can we migrate from u2 to sql server.tell me the sites where i can find the pdf on migration from u2 ...