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
0
votes
3 answers

Single query gives more result than same query UNION another?

I'm not sure if I misunterstood a basic thing or if I have a problem with how my database interprets the query... Running universe When I run SELECT POIDSBRUT, PRIXBRUTU, FAMILLENU, TPSMOU, TPSMOUPLANIF, QTE1PLANIFMOU, OF5 FROM GPSOF WHERE…
xNeyte
  • 612
  • 4
  • 18
0
votes
0 answers

sendmail issue from uniVerse phantom generated script

Not quite sure what is happening here. If I run my script from a Universe basic program no problems under a user login, email is sent and received. However if I run it as a background process I get the following error Saved message in…
ScaryMinds
  • 335
  • 3
  • 11
0
votes
0 answers

Rocket universe2 stop console messages in vb.net console application

I have a vb.net console application that uses a Rocket Universe 2 database as a DSN. I can connect to the database and query it, but the console always displays progress messages for each fetch. Querying from my local Sql Server does not cause any…
Jerry Mollis
  • 21
  • 5
0
votes
2 answers

Rocket Universe basic suppressing output to screen

Via universe basic how do I suppress output to the screen, vaguely remember from PICK R83 days it's an execute statement? Please note don't want to output to any other device.
ScaryMinds
  • 335
  • 3
  • 11
0
votes
1 answer

BOE Universe @prompt with null value

I need to have a null value in a prompt for in my BOE Universe. How do I do this? @Prompt('Special Claims Indicator','A','Special Claims Analytics\Special Claim Type Code',MULTI,CONSTRAINED,,{' '}) When I change my prompt value of ' ' to null or…
staples
  • 424
  • 2
  • 8
  • 24
0
votes
3 answers

Universe 9+ system, UniObjects (not for .NET) - How to convert examples from VB 6 to C#

I am working with a multi-value database that is currently using IBM U2 (now Rocket Software)'s UniObjects software to connect to a Universe 9.+ system. This is not UniObjects for .NET as put out by Rocket Software for Universe 10+ and 11+ systems.…
J. Riccardo
  • 1
  • 1
0
votes
1 answer

U2 Universe Update Multi value field errror

I am using the Universe U2.net toolkit to update the record in universe database. We have so far no issue with update to non multi value field with the following code Open_Again: Try db_connectionU2 = openConnU2() …
user3651809
  • 11
  • 2
0
votes
1 answer

Move UniVerse data into SQL Server 2014 using u2 Toolkit

I am attempting to migrate a UniVerse database into SQL Server 2014. I have downloaded and installed the U2 toolkit for .net from Rocket software. The U2 provider is displayed in the dropdown list and I have entered all the required info in the…
Rod
  • 3
  • 3
0
votes
3 answers

Pattern Matching BASIC programming Language and Universe Database

I need to identify following patterns in string. - "2N':'2N':'2N" - "2N'-'2N'-'2N" - "2N'/'2N'/'2N" - "2N'/'2N'-'2N" AND SO ON..... basically i want this pattern if written in Simple language 2 NUMBERS [: / -] 2 NUMBERS [: / -] 2 NUMBERS So is…
Nitin Rathod
  • 159
  • 2
  • 15
0
votes
2 answers

Is there any documentation on configuring Rocket U2 database for transaction processing?

I am trying to implement transactioning in an application which uses a Rocket U2 Universe database (formerly IBM Universe). There is fairly good documentation on the use of UniObjects, specifically the UniSession.CreateUniTransaction method, and…
Peter
  • 1,292
  • 4
  • 15
  • 33
0
votes
2 answers

Change the default date format while exporting the resultset data using OpenCSV

I am trying to export the data into CSV using OpenCSV. The Database is Universe Db and the CSV generates fine with "$" as the separator. However, when we tried to load the same CSV data into an IBM DB2 database it is failing because of an…
Nilesh Wattamwar
  • 1
  • 1
  • 1
0
votes
1 answer

Date dimension for parallel dates

I have a schema to show sales amount by customer and by date. A requirement is to be able to show the sales amount for each customer for the same date the previous quarter (so 21/08/2015 - 21/05/2015). I have added a ParallelQuarterDate column in my…
user3552829
  • 103
  • 1
  • 4
  • 13
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
3 answers

universe U2.net SELECT wildcard

When i use SQL to query MS access or MS SQL. I can have the following sql to retrieve data SELECT ORDER_NO,NAME FROM ORDER WHERE LEFT(ORDER_NO,6)='123456' to retrieve the record with order number start with '123456' But LEFT is not working in the…
user2764136
  • 1
  • 1
0
votes
2 answers

UniVerse - SQL LIST: View List of All Database Tables

I am trying to obtain a list of all the DB Tables that will give me visibility on what tables I may need to JOIN for running SQL scripts. For example, in TCL when I run "LIST.DICT" it returns "Name of File:" for input. I then enter "PRODUCT" and it…
tomc0920
  • 21
  • 5
1 2 3
…
11 12