Stack Overflow
Stack Overflow

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

Universe/U2/Pick ICONV()

In U2/Universe/Pick, there is a function ICONV("11/11/15","D") to convert an external date to an internal date but this will work in USA or with the date format mm/dd/yyyy only. How can I use this function for UK date format (dd/mm/yyyy) ?
user3464522
  • 71
  • 5
2
votes
3 answers

UniVerse SQL View All Tablenames

I am new to UniVerse. I am working with an existing Database. I would like to know how to View a List of all available TABLES in the database. Is there a simply syntax command to view all TABLES?
tomc0920
  • 21
  • 5
2
votes
2 answers

Is there a native way to convert to UTC time in UniVerse 11.2.4+?

The release notes for UniVerse version 11.2.4 mention local time zone configuration, but it is in the context of auditing. This is the quote: Local time zone configuration Prior to UniVerse 11.2.4, the date and time data stored in the audit log…
wags
  • 149
  • 12
2
votes
1 answer

Does anyone know how to add new user on rocket universe?

I have installed Rocket Universe database on my computer, however, I need a username and password to connect through JDBC. Do you know how I can add a new user? Thank you
Joe
  • 23
  • 3
2
votes
4 answers

How can I SELECT records using a select list made of foreign keys?

I have a table, DEBTOR, with a structure like this: and a second table, DEBTOR.INFO structured like this: I have a select list made of record IDs from the DEBTOR.INFO table. How can I select * from DEBTOR WHERE 53 IN (name of select list)? Is…
user3140622
  • 37
  • 6
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":…
user3464522
  • 71
  • 5
2
votes
4 answers

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…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
2
votes
1 answer

Slow connection speed while uploading data more than 1MB to IIS

I am using IIS as my web server. I am going to use this web server to receive data from a a http client on a Universe database. Whenever i send a Post request that has more than 1 MB then the data transfer speed is merely around 12 KB per second.…
Sabareesh Kkanan
  • 1,201
  • 1
  • 14
  • 22
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
1 answer

UniVerse XDOM Trouble with Default Namespaces

I'm trying to use the XDOM functions of UniVerse to parse an XML file, but I can't get it to correctly parse XML that uses a default namespace. It can correctly handle XML without namespaces, or with named namespaces, but if there is a default…
Nate Allen
  • 3,159
  • 1
  • 11
  • 11
2
votes
2 answers

Using UniDynArray on ASP.net MVC view page

Can anyone help me on how to use UniDynArray on ASP.net MVC3 (MS Visual Studio 2010) View Page? I managed to add reference (U2.Data.Client) to the project and I'm able to use it in the Controller, but not in View page. The reason to utilize the…
cwkueh
  • 23
  • 3
2
votes
1 answer

U2 Toolkit for .NET - RPC Failed, An established connection was aborted [errorcode=81009]

I am using the U2 Toolkit for .NET to access our Universe system from MS SSIS. This has been working great while running some investigation tests on several files returning less than 200k rows of data. On my latest run, using a new file where the…
user2121229
  • 21
  • 1
  • 2
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
3 answers

UniVerse native date format

I am in the process of optimizing some UniVerse data access code we have which uses UniObjects. After some experimentation, it seems that using a UniSession.OConv call to parse certain things such as decimal numbers (most we have a MR4 or MR2 or…
Los Frijoles
  • 4,771
  • 5
  • 30
  • 49
1
vote
3 answers

In UniVerse SQL. How to get the Maximum actual Data Len of a column

In UniVerse SQL. How to get the actual Max Len of a column. I'm debugging an SSIS package and having trouble in ADO.Net Source. UniVerse SQL script gets an error of "UniVerse/SQL: Row Length Exceeds Buffer Size". I tried adjusting the Buffer size…
FullMetalPanda
  • 46
  • 3
1 2
3
…
11 12