Stack Overflow
Stack Overflow

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

Connection using uniobject.NET connection to unidata account does not work and transaction fails

I am using Uniobject.Net for connection to unidata account. Connection is successful but while using the transaction processing it fails during transaction commit. It says "No Transaction is in progress" in the client side message. We used user with…
Sandy
  • 1
  • 1
0
votes
1 answer

Change default RUNPY directory in UniVerse

I have UniVerse 11.3.1, and have been taking advantage of Rocket's u2py module to run python code. Overall, this has been great. When calling python code from PICK I usually do PyCallFunction. However I have a number of scripts I run directly from…
Jon
  • 1,820
  • 2
  • 19
  • 43
0
votes
1 answer

Does UniData only allow one command or query per connection at a time?

Does UniData (Rocket U2) only allow one query or command to run at a time per connection? I know each connection has a process or two (udapi_server/slave/etc. I believe), and we pool connections via UniObjects connection pooling. I know there have…
Tony B
  • 159
  • 6
0
votes
2 answers

How to alias a column in Unidata query with U2 provider

In SQL Server, I can create a column alias like so: select id as NewID from sometable How can I accomplish this in the U2 provider? I've tried: select id NewID --returns Column0 select id as NewID --returns Column0 select id "NewID" --returns…
Jeff
  • 908
  • 2
  • 9
  • 23
0
votes
1 answer

UniSubroutine Exception

I am getting following UniSubroutineException on following line of code while executing the Call() of UniSubroutine. try { if ((txtEmail.Text != "") && (txtPass.Text != "")) { if (txtPass.Text ==…
Vaibhav Vanawala
  • 3
  • 3
0
votes
2 answers

What is the most DRY way to get data out of my database?

I have to write an ASP.NET application that connects to our legacy IBM Universe Database and we are using a product called mv.net which allows us to connect, read, write, select, run server side programs, etc. I want as little code repetition as…
Mike Roosa
  • 4,752
  • 11
  • 40
  • 52
0
votes
1 answer

Filtering on a derived column in UniOLEDB

I am working on a piece of SQL for a IBM U2 Rocket database. It's not a flavour of db platform I'm familiar with. I do not have direct access to this database: I can only access it by composing statements in the calling code and testing it from…
Bob Tway
  • 9,301
  • 17
  • 80
  • 162
0
votes
3 answers

How do you do a LOCATE in Unidata with BASICTYPE 'U' for @AM's?

I typically use BASICTYPE 'P' at our shop but had an occasion to use 'U' for a project and noticed that I could not do a locate on a dynamic array that is delimited by Attribute Marks. Referencing the docs, it plainly states that in type U, not…
slestak
  • 153
  • 1
  • 8
0
votes
0 answers

Get field location U2 Unidata

It is very rare to find any help for U2 Unidata/Universe database and searches online are not much of a help. So I am trying to make dynamic field change (based on input): OPEN FILE.NAME TO WORKING.FILE ELSE STOP READV FIELD_VAR FROM…
zuboje
  • 696
  • 3
  • 11
  • 28
0
votes
2 answers

Use Array as datasource for a web service

I am very new to web services I am trying to create a web service hopefulle REST if possible to Receive an array from a subroutine(U2 sub but that doesn't matter right now) and create like a list in sharepoint using that web service as an external…
Damian
  • 1
  • 3
0
votes
2 answers

PICK/BASIC, FlashBASIC, and C Interoperability

I stumbled across some interesting documentation regarding PICK programming: http://www.d3ref.com/?token=flash.basic It says FlashBASIC is a compiled, instead of interpreted, version of PICK programs that are interoperable with PICK. This is great.…
Jon
  • 1,820
  • 2
  • 19
  • 43
0
votes
1 answer

UniObjects - Write vs WriteField Difference?

Can someone please explain the difference in the following: string RecordID = "123456"; string AttribNum = "120"; UniFile myUniFile = myUniSession.CreateUniFile("myFileName"); UniDynArray uda = myUniFile.Read(RecordID); uda.Replace(AttribNum, "New…
Jeff Brady
  • 1,454
  • 7
  • 35
  • 56
0
votes
2 answers

What is the most efficient way to copy UniDataSet to SQL Server?

I have a U2/UniVerse database, and need to copy the data in one table into a SQL Server table. The table in question has approx 600,000 rows and just under 200 columns. I didn't create the table, and can't change it. For other tables, I'm looping…
Jeff Brady
  • 1,454
  • 7
  • 35
  • 56
0
votes
1 answer

Rocket Universe Data load

I'm trying to do a dataload into a Rocket Universe database. In going through the SQL Admin documentation, they give the following example, but very little in the way of describing what is going on with the config file. Can anyone shed a little…
shawno
  • 343
  • 1
  • 3
  • 17
0
votes
1 answer

run SQL script using Rocket Universe from AIX command line (uvsh)

Hopefully this is a simple question. I want to write a shell script that calls a SQL script to do some queries in a Rocket UNIVERSE database. I am doing this from the Server command line (the same machine where the database resides). In SQLSERVER…
shawno
  • 343
  • 1
  • 3
  • 17
1 2 3 4 5 6
7
8