Questions tagged [unidata]

UniData is an extended relational database and integrated development environment. It is part of the MultiValue Database family. It features its own query language called UniQuery and programming language called UniBasic.

UniData is an extended relational database and integrated development environment. It is part of the MultiValue Database family. It features its own query language called UniQuery and programming language called UniBasic.

UniData was originally developed by the Unidata Corporation for embedding in vertical software applications, but after several acquisitions, including by IBM, it is now owned and developed by Rocket Software.

References

UniData V7.3.x Manuals
U2 Developer Zone
Code examples on github
U2 Users Group

127 questions
1
vote
1 answer

Compile Error: UniData LSELECT

I've found the LSELECT program on the rocket software website but I'm having issues compiling it. Has anyone had success with it? Here are the errors: :BASIC BS LSELECT Compiling Unibasic: BS/LSELECT in mode 'm'. main program: syntax error at or…
PhilipZU2
  • 21
  • 4
1
vote
2 answers

How to pass current date from one UniQuery paragraph to another

How can I pass the current date from one PA to another in UniQuery? A colleague taught me the trick of having the date written by cron to a file and using a inline prompt to read it with <>, but that adds extra parts that can…
Script Wolf
  • 106
  • 2
  • 12
1
vote
2 answers

Show UniData SELECT results that are not record keys

I'm looking over some UniData fields for distinct values but I'm hoping to find a simpler way of doing it. The values aren't keys to anything so right now I'm selecting the records I'm interested in and selecting the data I need with SAVING UNIQUE.…
Script Wolf
  • 106
  • 2
  • 12
1
vote
1 answer

Unidata File Manipulation with C#

I have a windows server with Unidata running. I need to write a C# program that will manipulate a file and save out. The way I currently have to do it involves going into udt. I have tried looking at just manipulating the file itself, but doubt it…
cdburns123
  • 13
  • 3
1
vote
0 answers

How many properties can you have in Rocket Soft U2 Web Designer Object/Class

Could someone tell me what is the maximum # of properties for an Object or Class in U2 Web Designer? I can't seem to find that in the documentation.
1
vote
1 answer

MySQL procedure to load data from staging table to other tables. Need to split up multivalue field in the process

I'm trying to export data from a multivalue database (Unidata) into MySQL. Lets say my source data was a person's ID number, their first name and all the states they've lived in. The states field is a multi value field and I'm exporting them so that…
David
  • 193
  • 2
  • 3
  • 10
1
vote
2 answers

UniData List all avaiable subroutines / All parameters

I am trying to wrap some UniData Subroutines to SOAP Web Service. I'm planning to use C# and UODOTNET library (IBM U2 Data Management Interface for .NET). Also I'm looking to create an engine to read all the available Subroutines from data server…
Barsham
  • 749
  • 8
  • 30
1
vote
1 answer

UCI connections to non universe databases is not allowed

I need to access unidata database from a server. I tried using vbscript. Set conn = CreateObject("ADODB.Connection") conn.Open"Provider=IBM.UniOLEDB.1;Data Source=myunidatadatasourcename;User…
neetz
  • 140
  • 4
  • 11
1
vote
3 answers

Why do I get an ArrayIndexOutOfBoundsException in my JDBC connection?

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…
Norm
  • 659
  • 3
  • 10
  • 20
1
vote
1 answer

How data is structured in Tables in unidata

I am Extracting dictionary info and data(flat files) for the unidata tables through a java program where i used 'table name' for getting both the things, now we are having other project where the Unidata db is divided into multiple…
syed99
  • 332
  • 1
  • 5
  • 20
1
vote
2 answers

Data from UniData to SQL Server 2005/above through SSIS

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…
wadooma
  • 13
  • 5
1
vote
1 answer

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…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
1
vote
2 answers

How do I find what extended character code is entered

I'm trying to see what's being stored in a record for the extended character è using ED editor in TCL, when I did the ^ arrow, it showed as ^!!!! invalid character. I even tried to use UNISEQ on the character but it returing null. Does anyone…
1
vote
1 answer

How to close a submitRequest function in U2/Universe

I searched everywhere in U2 Universe manual but I don't see any example of how to close the connection after calling a submitRequest function. Does anyone knows?
1
vote
1 answer

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…
Dan McGrath
  • 41,220
  • 11
  • 99
  • 130
1 2 3
8 9