Questions tagged [universe]

1

votes
0

answer
9

Views

python 'environments have crashed'

I'm just getting started with using universe in python to learn how to make a game bot. I'm using a demo code to start with. However I get the same error after I run the code on PyCharm. import gym import universe env = gym.make('flashgames.DuskDrive-v0') env.configure(remotes='vnc://localhost:5900+...
Daniel dos Santos
1

votes
1

answer
72

Views

Getting a select list from an alternate index with selectMatchingAK return a “The RPC failed” error

I'm trying to use an alternate index to get records id from a file using uniobject and java. UniFile uFile = uSession.open('EC_WORK_ORDER_REQUEST_STATUS'); UniSelectList uSelect = uSession.selectList(0); uSelect.selectMatchingAK(uFile, 'EC_WORK_ORDER_REQUEST_ID', '12547'); But I'm getting the fo...
DavRob60
1

votes
1

answer
31

Views

Rocket Universe Dictionary passing VM attribute value to subroutine

Okay this might get a tad complex or not. Have a file with a multivalues in attribute 4 I want to write another dictionary item that loops through the multivalue list, calls a subroutine and returns calculated values for each item in attribute 4. somthing like a]b]c]d]e New attribute @RECORD;SUBR('S...
ScaryMinds
1

votes
1

answer
912

Views

Why does Uodotnet with Connection Pooling timeout?

We're trying to get connection pooling working with uodotnet and currently failing miserably. When we turn connection pooling off everything works as expected, but when we turn it on we often get timeouts or errors with one of the following trace outputs: 2011-03-28T15:09:28 System.Exception: Non-ne...
Jackson Pope
1

votes
2

answer
471

Views

How do you do multiple transactions in one I-Descriptor?

Currently I have an IDescriptor that pulls Sales from another FILE for Period 1,2,3. I want to be able to pull Costs from Period 1,2,3 and subtract the totals to get a profit. The Current I-Descriptor Statement is: TRANS(SAS1,ITEM,4,'X');@[email protected][email protected] 4 = Sales 3 = Cost @1 = Period 1 @1 = Period 2 @1 = P...
Jacob
1

votes
1

answer
461

Views

UniVerse records containing special characters skewing output

I'm reading data from a file in UniVerse, and some of the records contain special character(s) that are causing line breaks. Is there a way to strip these out? Some are ASCII 255 but there are some others as well. I'm pretty new to UniVerse. I'm using C# and the U2 Toolkit for .NET. Here's my code:...
Jeff Brady
1

votes
2

answer
399

Views

Why the OCONV() with the 'MCT' code change the original string?

I've a string with some Spanish characters and when I use the U2's OCONV() function with the code 'MCT', it changes the Spanish Character to something else. Does anyone know? STRING: T r L=16 `CITáN, MOR 32000' TEST.MCT: 5: STR2 = OCONV(STR,'MCT') :: S TEST.MCT: 6: CRT STR2 :: S Cit?9: Mor 320...
user1387287
1

votes
1

answer
102

Views

Returning multiple record IDs with an I-Descriptor

Is it possible to create an I-descriptor that returns multiple record keys when the only the first part of the key is known? For example I have Quote Header record in the QTH file and need to reference all of the Quote Detail records in the QTD file. A QTH record has an ID of '1159' so I know that a...
Conrad Eggan
1

votes
1

answer
464

Views

How to close a submitRequest function in U2/Universe

I searched everywhere in U2 Universe manual but I don't see any example of how to close the connection after calling a submitRequest function. Does anyone knows?
user3464522
1

votes
1

answer
147

Views

Better cleanup after protocolLogging() on UniVerse?

I have a Basic program that is used to send email via a web service. I want to leverage the protocolLogging() function to catch any issues that sometimes arise when interacting with a web service. However, I don't want to be flooded with all the success logs (right now I'm generating one log file ev...
wags
1

votes
1

answer
157

Views

Is it possible to audit dictionary changes on UniVerse?

A while ago, International Spectrum posted a great article that outlined the process of auditing changes in a file through the use of an indexing subroutine. This works well for record changes and I have been thinking that it would be especially useful if I could track changes to dictionaries in a f...
wags
1

votes
3

answer
293

Views

Create Subroutine in Universe

I have problems in identifying the error of UniObject during execute UniCommands. I saw the answer in UniObjects for Java: How to get response String when error occurred in UniCommand.exec() But I don't know how to create subroutine in Universe? I saw this method CreateUniSubroutine but it only has...
Yin Sang Lam
1

votes
2

answer
199

Views

How to record speed of UniVerse verbs such as SELECT and SORT?

I remember seeing an article somewhere that outlined a clever way to wrap a UniVerse verb, like SELECT, in a custom basic program in order to record some metrics such as elapsed time. The easy answer is to share that link, if you are familiar with that article. Otherwise, I appreciate any sample co...
wags
1

votes
1

answer
116

Views

Universe basic convert a select list to an array?

I have one major select list in a program EXECUTE 'SELECT PRODUCTS WITH DEL.DATE
ScaryMinds
1

votes
1

answer
24

Views

UniVerse uonet looping on a record in C#

Have the following code for(int i = 1; i
ScaryMinds
1

votes
1

answer
16

Views

wIntegrate add text to dbgrid column headers

Well the documentation is non-existent on this one, which would seem a pretty straight forward things to want to do. Am trying to add column header text to row 0 and it simply is not playing ball. * Load up the Column REC = 'Cell 0,1':VM:'Cell 0,2' REC = 'Deal#':VM:'Deal' CALL WIN.DBSETPRP(DLGNAME,...
ScaryMinds
1

votes
1

answer
0

Views

Data Encryption from UNIVERSE/U2/PICK

I am extracting some data from a UNIVERSE system and want to encrypt it for transfer via email. I am no UNIVERSE expert so am using bits and pieces we have found from around the internet and it 'looks' like it is working BUT I just can't seem to decrypt the data. Below is the script I have used base...
php-b-grader
1

votes
2

answer
0

Views

Multi-valued Database (UniVerse) — SM (MV) vs SM (VS) and ASSOC()

I have a question taken from pg 16 of IBM's Nested Relational Database White Paper, I'm confused why in the below CREATE command they use MV/MS/MS rather than MV/MV/MS, when both ORDER_#, and PART_# are one-to-many relationships.. I don't understand what value, vs sub-value means in non-1nf database...
Evan Carroll
1

votes
1

answer
0

Views

UniObjects for .NET - Reading and Writing UniVerse Files

Our organization is using UniObjects for .NET but the CD seems to have gone missing. I need to figure out how to read and write to and from files in Universe. Please note the program is written in VB.NET Dim uniSession As UniSession Private DATABASE_IDENTIFIER As String = 'uvcs' uniSession = UniObje...
Spacehamster
1

votes
1

answer
0

Views

I Descriptor Length

In UniVerse, I am trying to convert a ZIP+4 to just a 5 character ZIP. I have set the output length for my new field to 5 and it displays the ZIP in 5 characters, but I still have an issue when trying to filter by certain criteria (Example: ZIP = 36301). This query would not pull ZIPs with a PLUS4....
Jacob
1

votes
2

answer
685

Views

Javadocs for Uniobjects for Java

I just started working with Rocket UniObjects and am looking for some Javadocs. Currently I am using the Rocket Documentation, but I'm not a fan. I've looked, but had no luck. Has any one seen any?
Guy
1

votes
1

answer
639

Views

“Improper data type” with query in Rocket UNIVERSE database

I am trying to do a simple LIST from the UV command line: LIST PSUB TSN.COMMENT I get the following: LIST PSUB TSN.COMMENT 07:37:39am 22 Mar 2014 PAGE 1 @ID..................................... TSN.......... **Program 'DICT.GET.LEDGER.DET.VALUE': Line 9, Improper data type.** Looking further, I...
shawno
1

votes
3

answer
211

Views

Universe Basic Dynamic Array Relative Operation

Universe dynamic array relative operation (using -1) works in a strange way. Operation below does not add new element in position as I expected instead adds '1,1,5' to DYNAMIC.ARRAY. DYNAMIC.ARRAY = ' ' DYNAMIC.ARRAY = '1,1,5' ; *Adds to 1,1,1 not 1,1,5 when DYNAMIC.ARRAY contains only whi...
Baha
1

votes
2

answer
94

Views

How do I find what extended character code is entered

I'm trying to see what's being stored in a record for the extended character è using ED editor in TCL, when I did the ^ arrow, it showed as ^!!!! invalid character. I even tried to use UNISEQ on the character but it returing null. Does anyone have any ideas? I'm using Universe under Unix AIX. 0...
user3464522
1

votes
1

answer
193

Views

Universe execute a Linux command from within a Basic program

Am attempting to execute an ls -al from within a Universe basic program and it isn't working as expected. EXECUTE 'sh' EXECUTE 'ls -al | grep FILELIST' The program is shelling out to Linux, but then stops prior to execution of the ls command. Anyone have any ideas of how to get around this one?
ScaryMinds
1

votes
2

answer
68

Views

Somehow send command line commands on windows externally and get back the response

Problem: Need to convert local html (with local images etc) to pdf from an AIX box running Universe 11.2.5 with System Builder Current solution: FTP over html file to a Windows server which converts in batches and sends the e-mail to the destination Proposed Solution: Do everything on the AIX box, f...
James H
1

votes
3

answer
1.7k

Views

Why do I get an ArrayIndexOutOfBoundsException in my JDBC connection?

I am new to Java and I am attempting to use JDBC to connect to an UniVerse database. I'm using Sun Java 6 JDK to using NetBeans to build the project. My simple test below builds however it gives the errors below: > run: driver loaded Exception in thread 'main' java.lang.ExceptionInInitializerError C...
Norm
1

votes
1

answer
580

Views

U2 Toolkit for .NET - Entity Framework Sample “EntityFramework_CodeFirst” not working

When we try to run 'EntityFramework_CodeFirst' and 'EntityFramework_CodeFirst2' samples, we get the following error: Unable to determine the provider name for connection of type 'U2.Data.Client.U2Connection'
Rajan Kumar
2

votes
1

answer
116

Views

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
2

votes
4

answer
3.6k

Views

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 LIST), and @select (behavoir definition of * with very S...
Evan Carroll
3

votes
5

answer
6.8k

Views

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 query a table for all of its columns' values? So I can...
Evan Carroll
22

votes
2

answer
676

Views

Trying to build PHP PDO extension for Rocket U2

I wonder if anyone can help me with a problem that is making me pull what's left of my hair out... I am currently working on a project that requires me to talk to a Unidata database. PHP has no native driver to access this type of database, however, after some Googling, I found the following: https:...
kaigoh
2

votes
3

answer
2k

Views

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 MR2$) and dates (almost all are D2/) is extremely slow...
Los Frijoles
3

votes
3

answer
2k

Views

What is the best way to handle authentication in ASP.NET MVC with a Universe database?

We use an IBM database known as Universe that holds all of our user id's, passwords, and profile information in a table called USERINFO. Can I use the Membership Provider to connect to this database and authenticate the user? The database access is actually through a web service since we don't ha...
Mike Roosa
4

votes
2

answer
313

Views

what's the difference between MATREAD and READ?

I need to understand the difference between MATREAD and READ? and please provide a simple example on where and how to use one.
TMAN-MAN
3

votes
1

answer
514

Views

Scalar functions with UniVerse ODBC driver

I am using the UniVerse ODBC driver to pull data from our transactional system to SQL Server 2008. The ODBC driver is installed on Windows Server 2003 and it works fine. I am trying to find some help on the syntax for writing the scalar functions such as CONVERT. As I went through the manual, I fou...
rvphx
2

votes
2

answer
744

Views

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 UniDynArray is that, I would like to pass a dynamic arr...
cwkueh
2

votes
2

answer
626

Views

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 correctly. lets say files on subfolder A1 are supposed to b...
TMAN-MAN
2

votes
3

answer
278

Views

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
3

votes
2

answer
4.6k

Views

How can I get schema information about a UniData/UniVerse database?

I have some (limited) experience with UniData and UniVerse databases and now wanting to work with them via the .NET framework. It appears that the way to work with them now is via Rocket Software's U2 Toolkit for .NET. Since I will be accessing databases whose schemas I won't know a priori, I need...
ksigmund

View additional questions