[U2] Sort Columns in GUI Screen

I have a screen, it reads in one record that has some MV fields. On the main screen my first 4 fields can not be sorted. (1,2,3,4) However, on a tabbed screen I have another set of 4 MV fields (15,16,17,18 in the same record) that lets me sort my fields. I would like to be able to sort the MV

Re: [U2] Sort Columns in GUI Screen

Yes, I was wondering if that was a factor or not. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Sort-Columns-in-GUI-Screen-tp42926p42928.html Sent from the U2 - Users mailing list archive at

Re: [U2] Sort Columns in GUI Screen

Ok thanks. Been a while since I did SB and can't remember the right terminology in order to look up things. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Rivert back delete screen

The Screen is stored in the Dictionary of the file you set it up in. X will be screen name. The names will be; X X.GUI X.TXT You need all three parts. If you have a backup of that DICT you should still have it. You may need to remake/regenerate the PD.I for it. Hope that helps. - I

Re: [U2] Left Outer Join Question

I tried the simplest way and still could not get it to work. SF-MORTSELECT OLDMAS TO 1 5247 record(s) selected to SELECT list #1. SF-MORTSELECT TRWMONTHEND TO 2 5229 record(s) selected to SELECT list #2. SF-MORTMERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. SF-MORTMERGE.LIST 1

Re: [U2] Left Outer Join Question

It looks like the same thing. 4 lines long. : 0001: V : 0002: MERGE.LIST : 0003: I : 0004: GKSX Bottom at line 4. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Left Outer Join Question

Using NSELECT works as long as I don't do a complicated statement with it. NSELECT OLDMAS WITH CO = SF AND WITH TRWSTATUS AND WITH ACTIONCODE NE 99 ... Unknown word WITH on command line. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Left Outer Join Question

For all my testing I've been doing from TCL. Looks like I may need to do this in a PROC and not execute them in Unibasic code. Still this information maybe useful for the next time when I need to do it this way. - I used to be an Optimist until I knocked over the glass. -- View this

Re: [U2] Left Outer Join Question

If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Left Outer Join Question

Ok, I see. If I just keep doing a Select I can keep trimming down the active select list as long as the keys are the same. (And I use the right logic. What I want to keep vs what I don't want.) Sorry, I got caught up in lists and the like. - I used to be an Optimist until I knocked

Re: [U2] Left Outer Join Question

Which was what I was looking for. Thanks. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42791.html Sent from the U2 - Users mailing list archive at Nabble.com.

Re: [U2] Left Outer Join Question

Yes, that's what I meant. I was hoping to take out selected items in Y from X. I was trying to use it in another way to control it more. I realize now I can do that with the active select list using multiple selects as long as I use the right logic to filter out what I want vs. what I don't

[U2] Left Outer Join Question

I have 2 files. File 2 is a black list of records (keys) I want to exclude in and active select list of File 1. I've been looking into this for a little while and am not sure what I'm doing wrong. Docs are not very helpful with any examples on the how to do with this. I know of ways to deal

Re: [U2] Left Outer Join Question

Thanks for all the options. Been going over the Universe SQL Reference Doc's but they didn't give me enough detail. I think, a long time ago I have used NSELECT before. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Left Outer Join Question

I've found that you can keep on going too as long as the keys are the same. :SELECT FILE1 xxx items selected. NSELECT FILE 2 yyy items selected. NSELECT FILE 3 zzz items selected. Turns out I may need to do it this way. Cool. - I used to be an Optimist until I knocked over the

Re: [U2] Left Outer Join Question

I must be doing something wrong. When I try this I get; SELECT FILE1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Left Outer Join Question

I'm on Universe for this. I will try your options next time I'm on the system. Thanks for all the help. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42767.html

[U2] Using a ( at the end of a Select statement

Working with Universe Select statements I found one with (RSD at the end of it. I need to do the same select, but I want to confirm if I the (RSD is needed or not. I've been looking for any ref to this with no luck so I thought I ask you folks. Thanks for any help on this. - I used to

Re: [U2] Using a ( at the end of a Select statement

It's possible the system I'm on started out in the 70's. I do use (P with select for outputting to a printer. So I thought maybe there were other control items. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Using a ( at the end of a Select statement

I did forget one thing. The select in question was in an SB process. EXEC 'S:SELECT ACHPAY.TXT WITH CO = ':@PARMS(3)2:' (RSD' - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] Using a ( at the end of a Select statement

Funny I made an PD.S not long ago. Just didn't associate the SB process code with a PD.S. It's been years since I've done a raw select in an SB process. I guess I've been coding to long in Unibasic. Thanks Dave. - I used to be an Optimist until I knocked over the glass. -- View this

Re: [U2] A Descriptors and its Subroutine Issue

Wow lots of good stuff here. I will look into all of this. I used what I did ONLY because I was mimicking another A type record because I didn't know exactly how to use it. Thanks - I used to be an Optimist until I knocked over the glass. -- View this message in context:

[U2] A Descriptors and its Subroutine Issue

I'm not use to making these. I based what I was doing on another A type which also called a Subroutine. My A Type record; SB.SVCED DICT ADFILA RNS.CB.MAS 10 lines long. : 0001: A : 0002: 0 : 0003: Reason Not To Be Sent : 0004: M : 0005: : 0006: : 0007: : 0008:

[U2] How can I Insert a Page Break in a Printer Spooler?

I have a proc building several SORT reports and they are all going into a Spooler. (For later and special processing.) I have added a different kind of report (via code), but I need to have a page break before and after it. Is this possible? PCL codes don't work. When dumped to PDF they just

Re: [U2] How can I Insert a Page Break in a Printer Spooler?

I've been coding for years and don’t think I ever used PAGE before. Or it’s more like I've never needed to, or use it for a long time and well, you know how that is. ;) I've just got such an unusual situation I've been fighting for a while and this might just be the last thing I needed. Thanks!!

[U2] I Type Fields in Universe

It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again,

Re: [U2] I Type Fields in Universe

I used ED. If I change the code/compile code and the I type then use the field its still runs the way it did before I changed it. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] I Type Fields in Universe

I believe we are local, we have several accounts on the system. Maybe that's the issue? I'm running in one account and pointing to the code in another to test it. (Using Catalog) - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] I Type Fields in Universe

When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

Re: [U2] I Type Fields in Universe

Tried that. Only deleting attributes from the I type and recompiling works. It works fine when I do everything in the same account. (Code recompile is all I need.) It's just an issue because I'm testing in one account and have cataloged to my code in another using a Q pointer when I CATALOG.

Re: [U2] I Type Fields in Universe

John, Thanks for the info and help. From: Israel, John R. [via U2 (UniVerse UniData)] [mailto:ml-node+s1073795n41343...@n5.nabble.com] Sent: Tuesday, July 23, 2013 1:56 PM To: randyleesmith Subject: Re: I Type Fields in Universe It sounds to me like in the account that works

[U2] LIST reports and Fields that Do reads

Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the

Re: [U2] LIST reports and Fields that Do reads

In this case it is a SUBR call. Ok, thanks I'm a little older school and speed was always an issue I had to be aware of. Thanks for all the quick feedback. - I used to be an Optimist until I knocked over the glass. -- View this message in context:

[U2] SORT reports line length, change right margin?

It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was

Re: [U2] SORT reports line length, change right margin?

I've tried to get the ok for moving items over, but it effected the headers too. I guess the customer didn't go for it. (I have a Customer Rep I work with.) The SORT did not like making PCL changes. It just ignored them. I'm sure its because of the default settings on the system. You can set

Re: [U2] SORT reports line length, change right margin?

You all have given me a lot to work with. Thank you. I forgot to mentioned that the report I'm changing is part of a number of other similar reports. They all need to be together in the same printer spool. They are printed together as one big report. Since I don't know, or remember, much about

Re: [U2] SORT reports line length, change right margin?

There is a SP-ASSIGN OHS At the start of the Proc And a SP-ASSIGN At the end. All the report are meant to be held together. I really did miss this, even if you don't get the answer you wanted to your question, you sometimes get some great insight to the U2 environment. Knowledge that can

Re: [U2] UML mapping tool for MV (UniVerse)

There is MITS. (Assuming its still out there. Been a while since I've been in the U2-verse.) When I worked at Zaner-Bloser we looked at getting it as a 3D data mining tool for marketing. The thing that stopped us was the time it would take to build the data cubes. We estimated it would take over