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
1 answer

Rocket UniData/UniVerse: ODBC Unable to allocate sufficient memory

Whenever I tried using pyodbc to connect to a Rocket UniData/UniVerse data I kept running into the error: pyodbc.Error: ('00000', '[00000] [Rocket U2][U2ODBC][0302810]Unable to allocate sufficient memory! (0) (SQLDriverConnect); [00000] [Rocket…
2
votes
1 answer

pvlib-python forecast using GFS model server error - variable not contained in requested dataset

I'm new here and beginner Python user so go easy on me. I used to successfully forecast GHI and ambient temperature using pvlib-python forecasting module with GFS model using get_data() method for more than two years without problems but a week ago…
2
votes
2 answers

UniVerse database | catalog command line parsing error

I am new to Universe-database trying to publish my SUBROUTINE compiled at universe-database version (11.1 and 10.1.5) successfully at windows and Linux. Publishing SUBROUTINE command CATALOG filename HELLO I am using universe 11.1 at windows and…
ranjit
  • 51
  • 1
  • 9
2
votes
3 answers

In UniQuery, how do you get the count of unique values found while doing a BREAK.ON

I know I can get the counts for how many individual entries are in each unique groups of records with the following. LIST CUSTOMER BREAK-ON CITY TOTAL EVAL "1" COL.HDG "Customer Count" TOTAL CUR_BALANCE BY CITY And I end up with something like…
Script Wolf
  • 106
  • 2
  • 12
2
votes
2 answers

How can pvlib-python retreive a year-long archived weather forecasts from the global model (GFS)?

I have seen how easy pvlib-python can obtain weather forecasts, as it is presented in this link: https://pvlib-python.readthedocs.io/en/latest/forecasts.html In this link, the example is just for illustration, the retrieved weather data seem to be…
mhdella
  • 189
  • 1
  • 8
2
votes
1 answer

Return multiple records from subroutine and parse into datatable [Unidata][U2.NET]

I am working with Unidata, and ADO.NET using the U2 .NET Provider. This may be a shot in the dark as there are not many resources for Unidata and .NET these days. Currently I can only return a single MV record 153926þIþ and parse it using…
trevster344
  • 491
  • 2
  • 14
2
votes
2 answers

Unidata - Extract Count of strings from MultiValued fields

I'm a bit of a newbie when it comes to Unidata. My problem is this; I have lots of records with 20 fields. I want to extract a TOTAL count of the different values used in 1 of those fields; the field in question is multi-valued, so the data looks…
Jack McCauley
  • 43
  • 1
  • 9
2
votes
1 answer

UniFile ReadNamedFields

I'm currently using IBM's UniObjects and I trying to retrieve multiple fields from a UniFile at once to increase efficiency. UniFile uFile = uSession.CreateUniFile("fileName"); uFile.RecordID = inputID; string[] fieldNames = {"I_Field_1",…
jasonbryan
  • 115
  • 1
  • 11
2
votes
1 answer

Rocket Universe & Unidata File

This is just for clarification, know exactly what a qpointer is but today in a meeting the concept of a dpointer was raised. Anyone know what a "D" pointer refers to? Never ever heard this term before.
ScaryMinds
  • 335
  • 3
  • 11
2
votes
1 answer

Unidata database export - how to add headings using TO DELIM

In Unidata, when dumping a query to a delimited file, e.g. list MYFILE '1000' ATB1 ATB2 ATB3 TO DELIM "|" /tmp/extract.txt Are there any UDT.OPTIONS that control if a heading row is written or not? The only workaround currently involves some really…
Ian McGowan
  • 3,461
  • 3
  • 18
  • 23
2
votes
0 answers

Custom UniData server

I am looking at the following documentation in hopes of understanding uniData. The problem that I am experiencing is that I am unable to make a "simulated real-like version" of a backend server inorder to test my unidata queries. Here is what I have…
angryip
  • 2,140
  • 5
  • 33
  • 67
2
votes
1 answer

UniData - record count of all files / tables

Looking for a shortcut here. I am pretty adept with SQL database engines and ERPs. I should clarify... I mean databases like MS SQL, MySQL, postresql, etc. One of the things that I like to do when I am working on a new project is to get a feel for…
MrGoodfix
  • 317
  • 2
  • 14
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) ?
2
votes
0 answers

Unable to update unidata from .NET

I've been attempting for the last couple of days to update unidata using sample code as a basis using .NET without success. I can read the database successfully and view the raw data within visual studio. The error reported back is a out of range…
rfc
  • 21
  • 2
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…
1
2
3
8 9