I want to connect up to a database server in my .NET app and execute a database command that produces a series of database statistics. The problem is that it doesn't return the stats in a structured format, it returns it in plain text (like a df -k command in UNIX) I can capture the output and parse it, but I was wondering if there's a...
I work for a community college in North Carolina. Our most central repository of data is a software system called Datatel, aka Colleague (why it has two names, I don't know). In our case the underlying data store is IBM Unidata. I develop with .net technologies. Does anyone have any idea about consuming data from Datatel/Colleague in a...
I am doing some research about how to access data in a UniData database from .NET code. From what I have found, I can use UniObjects for .NET and U2.NET. I have also found this information, which I think is possible by using U2.NET, but I'm not quite sure. I am also unsure as to the cost of these products, and if they are free, how to ...
I hate IBM's site. It is extremely hard to find anything on there let alone try to find it twice! I'm looking for the UniObjects for .NET. I did find the below files and have installed them (can't find them now on IBM's website) however when I go to install the database add-ins for Visual Studio (v9.7) it says the IBM Data Server Provid...
I'm new to the world of UniObjects as I've been in .NET land since it debuted. After building a simple app to return the select list of a UniCommand statement I noticed that there are some major differences in how UniData and how UniObjects parses the UniCommand statments. From what I've found it looks like it is differences in the flavo...
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? ...
Unfortunately I have to do some interaction with IBM's UniData database system. I am doing this from c# code with UniObjects for .net. I am building an ASP.NET search page that has a single search box. The problem I am having is that the criteria is case sensitive. How can I do a case insensitive search with UniQuery? I could return ev...
Can anyone provide a function to sanitize input for a UniData query? Or provide a list of things to remove? ...
How do you secure a UniData session using UniObjects for .net? The documentation is severely lacking. The UniObjects for Java documentation has a whole chapter on SSL. EDIT The UniObjects .net documentation says this about the UniSession.EncryptionType property: public int EncryptionType {get; set} This property gets or sets ...
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...
Are we "doing it wrong"? A colleague and I are messing around with an ASP.NET page to act as a "portal" to view the results from a diagnostic program on a UniData server. Although we do the odd-job of ASP/ASP.NET at work, it is not our primary language. To access this server, we have to use UniObjects, which is an API for authenticatin...
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? ...
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'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. ...
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...
We are doing a feasibility on what we're going to propose as a solution to a client who wants to migrate to a .NET based solution. Part of the data resides in UniData. What is required can be achieve using the following tool: http://www.welland.com/export.html The above product ETLs data from UniData to SQL Server. As a first step, we...
I am new to Java and I am attempting to use JDBC to connect to an UniVerse database. I'm using Sun Java 6 JDK to using NetBeans to build the project. My simple test below builds however it gives the errors below: > run: driver loaded Exception in thread "main" java.lang.ExceptionInInitializerError Connecting... at com.ibm.u2.jdb...