Questions tagged [u2]

U2 refers to the family of products that revolve around two MultiValue Databases called UniData and UniVerse. U2 includes connectivity tools, development tools and a 4GL development environment.

U2 refers to the family of products that revolve around the two MultiValue DBMS called UniData and UniVerse. U2 includes connectivity tools, development tools and a 4GL application development environment.

U2 was purchased from IBM in 2009 by Rocket Software and is now branded as Rocket U2

Related Tags

UniData
UniVerse
UniObjects
UniQuery
U2 Toolkit for .NET

119 questions
3
votes
5 answers

UniVerse RetrieVe how do I query a file for all of its columns' values?

Kind of a follow up to my self-answered question about finding the column names. In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't, how do you…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
3
votes
1 answer

How can I handle JSON strings in UniData?

I am receiving JSON strings from a web service. Is there any JSON parsers for UniData? I am on version 7.2.
3
votes
4 answers

Learning to query UniData

We have an IBM UniData server. I just installed UniObject .net. It looks like you just issue unidata queries through the .net classes. Where can I learn the query language/syntax and to work with UniData in general? What books, sites, or videos do…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
3
votes
2 answers

How do I set the timezone for UniObjects?

I am connecting to an AIX 5.3 box from Win7Pro using Uniobjects for Java. When the udcs user logs in, /etc/profile is executed. It appears that /etc/environment is not sourced. If a rpc method (using aix user 'sbr') calls a Unidata subroutine that…
slestak
  • 153
  • 1
  • 8
2
votes
3 answers

Universe OCONV argument for zero-padding

I'm looking for some argument (ARG) such that this code: A = 5 B = OCONV(A,'ARG5') PRINT B will print to the screen 00005 Anybody know something which will do this for me?
Charles
  • 355
  • 1
  • 2
  • 12
2
votes
2 answers

How to get the smallest date value using SELECT on TCL from a file?

Is there a way that I can get the smallest date value without SORT and DESC, through SELECT only?
aisha
  • 87
  • 7
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
3 answers

Call UniVerse Command from Shell

I have a UniVerse (Rocket U2) system, and want to be able to call certain UniVerse/TCL commands from a shell script. However whenever I run the uv binary it seems to stop the execution of the rest of the shell script. For Example if I…
Jon
  • 1,820
  • 2
  • 19
  • 43
2
votes
0 answers

Trying to decrypt data sent from U2 subroutine in PHP

I am being sent encrypted test data from a U2 system to see if it can be handled and utilised to increase security. The SUBROUTINE generating the encrypted test data in U2 is: RESULT='' ALGORITHM="rc2-cbc" ; * 128 bit rc2…
php-b-grader
  • 3,191
  • 11
  • 42
  • 53
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
3 answers

U2 UniVerse: update a multivalue field

I have a DICT that is set as a multivalue. When opening TCL, and doing an UPDATE DICT.FILE SET Blah = 'Y' statement, I get the following error: Correlatives are illegal for UPDATE, column "Blah" How can I update a specific attribute in a multivalue…
vinco83
  • 467
  • 1
  • 4
  • 16
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
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
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…