Questions tagged [universe]

UniVerse is an extended relational data server with easy-to-understand data modeling that uses XML-like data structures to allow developers to quickly create embedded solutions. UniVerse delivers a high-performance, highly scalable, easy-to-use database offering for rapid deployment and rapid return on investment.

166 questions
1
vote
1 answer

Big query nested json strings to arrays then new tables

Bigquery Database I've got a webhook that's pushing to my big query table. The problem is it has lots of nested json strings which are brought in as strings. I ultimately want to make each column with these json strings into their own tables but…
John
  • 11
  • 3
1
vote
1 answer

Slow Connect via Open / OpenAsync .Net Provider Unidata

I am consistently seeing a 3+ second delay when opening a connection to a Unidata server via OpenAsync and the ADO.NET provider by Rocket. What can I do to diagnose this delay?
trevster344
  • 491
  • 2
  • 14
1
vote
1 answer

Improper data type return when creating API request in Rocket Universe

We encounter this error message “improper data type” at production but in UAT environment is working fine. It also hang at submitRequest.Please advise. Below is our coding 0001: TEXT="" ; RHANDLE = "" 0002: DL="|" 0003:…
Ong Ming Soon
  • 1,041
  • 1
  • 10
  • 22
1
vote
1 answer

How to SELECT for Value Mark Characters in TCL?

I am doing a SELECT in TCL for UniVerse. I want to see if there are any value marks in a given field. Is there way to represent a value mark character in my TCL SELECT? I know there are reserved variables in PICK, such as value mark @VM,…
Jon
  • 1,820
  • 2
  • 19
  • 43
1
vote
1 answer

I Descriptor Length

In UniVerse, I am trying to convert a ZIP+4 to just a 5 character ZIP. I have set the output length for my new field to 5 and it displays the ZIP in 5 characters, but I still have an issue when trying to filter by certain criteria (Example: ZIP =…
Jacob
  • 151
  • 1
  • 8
1
vote
1 answer

Why would a UV BASIC (compile) command hang?

An empty item is created in the .O file, but the BASIC command never returns to the > prompt. There is 5-month-old object, so the BASIC command has worked in the past. Windows Server 2016 Datacenter running on a VM RELLEVEL 001 X 002 11.2.5 003…
Ross Morrissey
  • 141
  • 1
  • 4
1
vote
1 answer

What is the fastest way to GET a list of records from Universe DB file using C#.NET?

I want to perform a SELECT query which would make a hit to the Universe DB once only and get the list of records quickly and efficiently which would then be added to a List. I have tried to use U2DataAdapter as well as U2DataReader but not sure…
usafder
  • 791
  • 5
  • 17
1
vote
1 answer

Rocket Universe string delete a character question

This one has me wondering if I may be missing a function or something. Have a string, example TZ118-AH01 I simply want to remove the second character and was wondering if there was a simple way of doing this, cannot use CONVERT as the second…
ScaryMinds
  • 335
  • 3
  • 11
1
vote
1 answer

Inline prompting in a virtual attribute?

I am trying to calculate what the balance of an invoice was at a certain period where BAL = Invoice.AMT - sum(adj.amts). The adjustments amounts (adj.amts) are MV and have associated dates. Therefore, I want to be able to have pass data via…
1
vote
1 answer

Why does Uodotnet with Connection Pooling timeout?

We're trying to get connection pooling working with uodotnet and currently failing miserably. When we turn connection pooling off everything works as expected, but when we turn it on we often get timeouts or errors with one of the following trace…
Jackson Pope
  • 14,520
  • 6
  • 56
  • 80
1
vote
1 answer

Data Encryption from UNIVERSE/U2/PICK

I am extracting some data from a UNIVERSE system and want to encrypt it for transfer via email. I am no UNIVERSE expert so am using bits and pieces we have found from around the internet and it "looks" like it is working BUT I just can't seem to…
php-b-grader
  • 3,191
  • 11
  • 42
  • 53
1
vote
1 answer

Rocket Universe Dictionary passing VM attribute value to subroutine

Okay this might get a tad complex or not. Have a file with a multivalues in attribute 4 I want to write another dictionary item that loops through the multivalue list, calls a subroutine and returns calculated values for each item in attribute…
ScaryMinds
  • 335
  • 3
  • 11
1
vote
1 answer

wIntegrate add text to dbgrid column headers

Well the documentation is non-existent on this one, which would seem a pretty straight forward things to want to do. Am trying to add column header text to row 0 and it simply is not playing ball. * Load up the Column REC = "Cell 0,1":VM:"Cell…
ScaryMinds
  • 335
  • 3
  • 11
1
vote
1 answer

UniVerse uonet looping on a record in C#

Have the following code for(int i = 1; i <= iCnt; i++) { clbRegion.Items.Add(ctrl_record.Extract(i, i, 0), false); } clbRegion = CheckListBox The code is successfully working out the record has four fields, but only displays the value of…
ScaryMinds
  • 335
  • 3
  • 11
1
vote
1 answer

How to execute TCL commands of Rocket Universe through Ansible?

I wanna execute 3-4 commands of Universe(which is in Linux) by executing some program through Ansible in Windows. I was having a look at UniObjects but couldn't find it how to add it in C# console app and not sure if it is free of cost. The aim is…
usafder
  • 791
  • 5
  • 17