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
2
votes
2 answers

Unidata UniObjects for .NET - Write amendments back to unidata from modified table

I'm trying to write data back into a file on Unidata, after the contents have been adjusted in a datagridview. I've tried various option based around the code below, but with no luck. Within the foreach section I want to update my file. The file…
2
votes
1 answer

How do I use JSON with U2/Universe

U2/Universe JSON document have the following UDOSetProperty, how would one set the value if it has multiple values? For example if I have multiple emails. example: UDOSetProperty(udoHandle, "to", value) "to": [ { "email":…
2
votes
1 answer

Synchronize the data in MySQL with Unidata

I have two applications (AppA and AppB). AppA is coded in Java with unidata database and AppB is coded in PHP with MySQL database. I want AppB to display the information AppA has. I wonder if there is any way to bridge the communication of the…
Jia-Luo
  • 3,023
  • 5
  • 16
  • 17
2
votes
3 answers

Sanitize Input for UniData

Can anyone provide a function to sanitize input for a UniData query? Or provide a list of things to remove?
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
2
votes
2 answers

u2 or uniVerse code to iterate through folders,subfolders and files to check their permissions

I am new in uniVerse and I have to write a uniVerse program which will check permissions of folders,subfolders and files. for example we have a folder called A and subfolder A1 and files in A1. now have to check if their permissions are set…
TMAN-MAN
  • 141
  • 1
  • 2
  • 13
2
votes
2 answers

How to do a UniData Case Insensitive Search with Uniquery

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

How can I convert U2 Business Logic Subroutine’s multi-value data into .NET Objects such as DataSet/DataTable using U2 Toolkit for .NET?

I have the following subroutine. It takes INPUT as argument 1 and sends multi-value data OUTPUT as argument 2. SUBROUTINE MV_TO_DATASET_SELECT_SUBROUTINE(ARG_INPUT,ARG_OUTPUT) x = ARG_INPUT ARG_OUTPUT =…
Tyler Elma
  • 27
  • 3
2
votes
1 answer

Where to get UniObjects for .NET?

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…
thames
  • 5,833
  • 6
  • 38
  • 45
1
vote
1 answer

Multiple threads accessing UniData from UniObjects.NET throws UNI RPC error

We've been using UniObjects.NET without issue until we started using it with BizTalk which is a multithreaded product. The issue is the error below. This error only happens on the 2nd thread (and probably 3rd, 4th etc. threads). The 1st thread…
thames
  • 5,833
  • 6
  • 38
  • 45
1
vote
2 answers

UniData UniQuery - two WITH

Alright I have little to no knowledge of SQL language, and am wondering what are the possible reasons for the slowness of two WITH vs one WITH in unidata. Database has around ~1 million rows. Ie/ SELECT somewhere WITH Column1 = "str" AND WITH…
Phoenix
  • 23
  • 4
1
vote
2 answers

In a Paragraph can we use the results of a SELECT statement in another SELECT criteria?

Within a paragraph, is there a way to take the results of one SELECT statement and use them in another SELECT statement? For example, if I have the following SELECT statement: SELECT PROGRAM.REQ WITH CREDITS GT 0 AND CREDITS LT 15 SAVING UNIQUE…
Jeremy
  • 23
  • 4
1
vote
1 answer

How to return exit code in UniData?

Is there a way to return an exit code to the operating system in UniBasic or ECL ? For example I want to capture a user-programmable exit code that can be retrieved with Bash's $? variable. From what I see, the UniBasic STOP and ABORT commands only…
mvanle
  • 1,847
  • 23
  • 19
1
vote
2 answers

UniQuery - How to find the largest length of a field in a file

I'm trying to figure out how to find the largest length of records for a field in a file on a Unix-based Unidata database in a Manage2000 (M2k) MRP system. I currently have the "Using Uniquery" and "Uniquery Command Reference" both for v7.2 and the…
Ken Stulce
  • 23
  • 1
  • 5
1
vote
2 answers

Is there a way to check if a savedlist is empty in Unidata?

is there a way to check if a savedlist is empty in Unidata (and if so generate a new savedlist)? The pseudo code would essentially be: IF savedlist1 IS EMPTY SELECT PERSON SAMPLE 1 SAVE.LIST savedlist1 (if not empty, leave the original savedlist1 as…
Jeremy
  • 23
  • 4
1
vote
2 answers

Is there a UniData SQL equivalent to the UniQuery SAMPLE keyword?

I'm using UniData 6. Is there a UniData SQL equivalent to the UniQuery SAMPLE keyword? Using UniQuery, I've always been able to do: SELECT CUST BY NAME SAMPLE 1 and it would give me the record with the first alphabetical name. In UniData SQL,…
Jonathan M
  • 17,145
  • 9
  • 58
  • 91
1 2
3
8 9