Re: [U2] [OT] Sql Query

2012-11-07 Thread Wols Lists
On 07/11/12 16:31, Bill Brutzman wrote: > While the given link is key... a bit of frustration that I have had with SQL > is that... often I have data in more than two tables... following the first > select list... there could be data in six or more tables. > > The joins that I have tried seem to

Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...

2012-11-07 Thread Wols Lists
COUNTNAME > CONVIDX -r ACCOUNTNAME > UPDATEVOC -oca ACCOUNTNAME > Martin > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wol

Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...

2012-11-07 Thread Wols Lists
And to add even further to the mix ... bear in mind my advice is about operating systems not U2, and my knowledge is UV not UD ... Are you SURE it's not needed if the source is Linux? Or do you actually mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is the endian-ness of the

Re: [U2] Another job ad written by people who have no clue

2012-11-05 Thread Wols Lists
On 05/11/12 12:36, Charlie Noah wrote: > I do pretty well with a QWERTY keyboard, since I've been using one all > my life, starting with an old Underwood typewriter. I don't think I want > to try to learn the Dvorak keyboard at this point. I have enough > frustrations in my life. :-) Thanks for the

Re: [U2] Another job ad written by people who have no clue

2012-11-03 Thread Wols Lists
On 02/11/12 16:31, Charlie Noah wrote: > Left handed only, when I used to be right handed? Try and get a left-handed-dvorjak keyboard layout. If you're on windows you should be able to find a key mapping somewhere. It'll then take some getting used to :-) but it should make life easier. I swear by

Re: [U2] Another job ad written by people who have no clue

2012-11-02 Thread Wols Lists
On 02/11/12 02:49, Bill Haskett wrote: > Kind of reminds me of my phone. It's gotten so many functions, that > barely work, now I can't even make a simple phone call. So I ditched my > Android and went to a pay-as-you-go simple phone. Now I can receive and > make calls without any problems. Who

Re: [U2] SB+ question

2012-10-22 Thread Wols Lists
On 23/10/12 00:46, Lunt, Bruce wrote: > All suggestions are greatly appreciated. Are the related fields ASSOCiated? That's an INFOism, however, so SB+ might not recognise that. Whenever I've done anything like that, ASSOCiated fields are supposed to move in lock-step. Cheers, Wol ___

Re: [U2] Selection Suggestions for using UV instead of SQL

2012-10-18 Thread Wols Lists
s I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wol

Re: [U2] Selection Suggestions for using UV instead of SQL

2012-10-18 Thread Wols Lists
rs, Wol > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Wednesday, October 17, 2012 11:38 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Selection Suggestions for using

Re: [U2] Selection Suggestions for using UV instead of SQL

2012-10-17 Thread Wols Lists
On 17/10/12 14:59, George Gallen wrote: > Ok. > > I have file1 - "people" that has @ID of PID > I have file2 - "registration" that has @ID of PID+EID+RID (EID = event id, > RID = registration id) > > I want to select people who are not in the registration file with an EID of > "1". > > With

Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper

2012-10-15 Thread Wols Lists
On 15/10/12 19:41, Wjhonson wrote: > Does anyone know what exactly the Chap Up and Chap Down do, as far as the > underlying system settings? CHAnge Priority. Which is a Pr1mos command. As Symeon says, "nice" is the unix equivalent, I'm not sure what the Windows equivalent is. So whatever the un

Re: [U2] User timeout question

2012-10-12 Thread Wols Lists
On 12/10/12 02:28, nancy wrote: > How does autologout work in SB ? (windows/universe) > How does ON.EXIT work? If ON.EXIT exists, then it is called by UV as part of the normal logout process. For example, what I used it for was to turn the default stack saving mechanism off. Then I used ON.EXIT t

Re: [U2] Consuming Web Services

2012-10-04 Thread Wols Lists
On 04/10/12 09:43, Symeon Breen wrote: > Ok so perhaps there is this and that. My point is a database like SQL server > is architected in a very different manner to U2 But that's why U2 is superior :-) - it is the actual central > sqlserver.exe process that does the majority of the work, it acc

Re: [U2] [u2] Parallel processing in Universe

2012-10-02 Thread Wols Lists
rs-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Tuesday, October 02, 2012 4:20 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [u2] Parallel processing in Universe > > On 02/10/12 03:49, Ross Ferris wrote: >> If the file

Re: [U2] [u2] Parallel processing in Universe

2012-10-02 Thread Wols Lists
On 02/10/12 03:49, Ross Ferris wrote: > If the file were big enough, and already had part files, then I believe that > you could have a phantom process each of the individual parts. Failing that, > get an SSD relatively cheap, and will give your processing a reasonable > kick along!! > Jus

Re: [U2] [u2] Parallel processing in Universe

2012-10-02 Thread Wols Lists
On 01/10/12 22:47, Robert Houben wrote: > Create an index on a dict pointing at the first character of the key, and > have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9) > Actually, this is a very BAD way of chopping up a file into five even chunks. I'm not sure of the stats, but on any

Re: [U2] STARTUP file issue with UV11.1 PE version (Linux)

2012-10-02 Thread Wols Lists
On 02/10/12 08:23, Hona, David wrote: > The installation instructions of Rocket is quite good and does indeed mention > the need to use "cpio" on UNIX servers. See "Quick Installation" and > "Step-by-step Instructions" (of NEWINSTALL.PDF)... > > However, the instructions from Rocket could be imp

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Wols Lists
On 24/09/12 18:54, Kevin King wrote: > Good thought on the index, but alas, no index on the file. We could > probably add one, but then how do we control the order of the records being > retrieved from the list? (The order is important to our process.) You'll have to check, but IME with UV the i

Re: [U2] UniData, LOCATE and strings with mixture of negative and positive numbes

2012-09-24 Thread Wols Lists
On 24/09/12 22:38, Tony Gravagno wrote: > If U2 does not support ARS/DRS, for standardization and portability I > highly recommend these platforms adopt the same convention in addition > to the documented but platform-specific UDT.OPTIONS. I've never come across the S option in UV, but then I've n

Re: [U2] Variable Interpolation

2012-09-18 Thread Wols Lists
On 17/09/12 23:31, Dawn Wolthuis wrote: > Maybe you were accepted after 10 days? --dawn The computer is an idiot, It knows not how or when. In fact, the only thing it knows Is one plus one is ten! Cheers, Wol > > Typed on a mobile keyboard > > On Sep 17, 2012, at 9:52 AM, George Gallen wrote:

Re: [U2] Inverting/Pivoting a table

2012-09-10 Thread Wols Lists
On 10/09/12 14:39, Dave Laansma wrote: > I get flat files that I'd like to 'flip' to accommodate the multi-value > database. For example, given this table: > I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... > >

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Wols Lists
nted there is no way for PI to read the account name and find out what account it is. Cheers, Wol > > On 9/7/2012 10:54 AM, Wols Lists wrote: >> On 07/09/12 03:19, Charles Stevenson wrote: >>> A newbie stumped me: Why are "Q-Pointers" "Q" pointers ? >

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Wols Lists
On 07/09/12 21:44, Mecki Foerthmann wrote: > I have no Idea what you are talking about. > What is wrong with LOCATE A IN B SETTING C ? Except you've just given me a statement, and I was talking about the function :-) The syntax is something like LOCATE(A,B,1;C) although as I said, I might have

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Wols Lists
On 07/09/12 18:28, Mecki Foerthmann wrote: > I guess it always depends on where you come from and what you know. > I would say the account philosophy is much cleaner than having duplicate > file pointers. > And of course we have accounts in U2 too - it is the working directory. > I have to admit I

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Wols Lists
On 07/09/12 03:19, Charles Stevenson wrote: > A newbie stumped me: Why are "Q-Pointers" "Q" pointers ? > > The "Q" lingo comes from the dawning days of Pick. > Why was the letter "Q" chosen? > > "A"ttribute makes sense. > "S"ynonym makes sense. > "PQ" for Prestored Query makes sen

Re: [U2] Scrub HangUp Fixed

2012-09-03 Thread Wols Lists
On 01/09/12 15:08, Allen Egerton wrote: > This isn't Rocket's user group, it's OURS. It's existed through several > product owners, (where product == UniData/Universe). Actually, as regards the mailing list, iirc it predates the user group by a fair few years ... And to start with, it had nothin

Re: [U2] [ud] Sub-second delay?

2012-08-30 Thread Wols Lists
On 30/08/12 08:55, dennis bartlett wrote: > Well, then you would remember CHAP (where you create a processing > priority). One could flag some processes to work as foreground and others, > where finish time was not of great concern, to background. One then set > CRON items to CHAP up processes over

Re: [U2] Scrub Hangs Up

2012-08-28 Thread Wols Lists
On 29/08/12 00:36, Bill Brutzman wrote: > Rich > > Thanks for writing... > > 1. I believe that HS.SCRUB just creates SQL data types in like fields <7> and > <8> of the dictionary file. > 2. Yes It should be COPY FROM DICT INVOICE TO DICT INVOICE_TEST ALL... This > now works... I tried it but.

Re: [U2] Scrub Hangs Up

2012-08-28 Thread Wols Lists
On 28/08/12 23:39, Bill Brutzman wrote: > More help is needed... > > 1. >copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST > Unable to open "DICT D_INVOICE" file. > > 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to > copy... unable to open q-pointer. > Hmmm S

Re: [U2] Scrub Hangs Up

2012-08-28 Thread Wols Lists
On 28/08/12 22:57, Bill Brutzman wrote: > Wol may have nailed yet another one... All of our other files just have an > "F" in line one. > >> ED VOC INVOICE > 3 lines long. > 0001: F INVOICE FILE But this is valid syntax - F-space means a file and anything after that is a comment. This shouldn't

Re: [U2] Scrub Hangs Up

2012-08-28 Thread Wols Lists
On 28/08/12 21:16, Bill Brutzman wrote: > When I do a > >> LOGTO HS.ADMIN >> HS.ADMIN > 5. Run HS.SCRUB on a File/Table.. [F]ix > > Most of the files here work ok. > > This one (important) data file INVOICE... it starts an... Analyzing: *and > then just sits there. > > I looked at the dic

Re: [U2] CPU Charge Units

2012-08-24 Thread Wols Lists
On 24/08/12 14:54, Wjhonson wrote: > > > > For some reason either Universe on Windows does this, or are particular users > are doing something where a large number of processes are left "running dead" > on the Windows server. That is, the process *claims* to be a telnet process, > but it's

Re: [U2] Virtualizing a Universe server of 100+ users

2012-08-21 Thread Wols Lists
On 21/08/12 17:20, Robert wrote: > There's an example of how the path is formed in the help file. > > ORION!/u1/filename > > This example is shown if you type HELP BASIC SYSTEM() . > > Another example: > > OPEN "ORION!/u1/user/file" TO FU.ORIONFILE > > You can type HELP BASIC TIMEOUT to see th

Re: [U2] CSV to Array

2012-08-16 Thread Wols Lists
On 15/08/12 23:24, David Wolverton wrote: > I've done this in the past by doing this: > > SWAP DQUOTE WITH @AM > > Now, in theory, every EVEN attribute is a 'quoted' string - don't touch the > commas > Every ODD attribute is a 'non-quoted' string... > > Double check me here in case I've lost

Re: [U2] MATREAD vs MATPARSE

2012-07-30 Thread Wols Lists
On 30/07/12 16:57, Larry Hiscock wrote: > You don't need to do the matbuild/write, you could simply do a MATWRITE > MATRECORD TO F.FILE,KEY Plus, do you know how many attributes you are going to access when updating? If you know before you read it the highest number attribute you are going to acc

Re: [U2] insert data

2012-07-30 Thread Wols Lists
On 30/07/12 00:58, unidata7 wrote: > I'm trying to learn UniData and keep coming across 3rd party tools ie > RocketSoftware. Can this be done without using a 3rd party tool? I don't > know how to insert data to begin. Does the data need to be formatted in a > certain way? Firstly, Rocket does not

Re: [U2] Running a command in a different account

2012-07-28 Thread Wols Lists
On 27/07/12 16:42, bpa...@serta.com wrote: > Greetings! > > > > We have a program that runs in one account, but under certain conditions it > is becoming necessary for that program to execute a command in another > account, and then continue on its merry way doing other things. One fairly > si

Re: [U2] Printing

2012-07-28 Thread Wols Lists
On 28/07/12 07:10, Robert wrote: > I have a question in regards to my brand new installs of the Personal > Editions (evaluation copies) of both UNIDATA and UNIVERSE. > > I just downloaded and installed these versions: > > UNIVERSE PE 11.1.9 > UNIDATA PE 7.3.0 > > I am unable to print anything to

Re: [U2] Array Types

2012-07-28 Thread Wols Lists
On 27/07/12 17:41, Charlie Noah wrote: > Hi John, > > I had to jump in here, if for no other reason than to let people know > I'm still alive and kicking. :-) > > When you said "One thing you CAN'T do is insert a value." I hope you > meant attribute. Actually, you CAN insert attributes. No probl

Re: [U2] uniobjects running as?

2012-07-24 Thread Wols Lists
f your program calls su, it's a pretty safe bet you don't know what you're doing and you're going to get quite a surprise! Cheers, Wol > > > -Original Message- > From: Wols Lists > To: u2-users > Sent: Tue, Jul 24, 2012 2:18 pm > Subject: Re: [U2] u

Re: [U2] uniobjects running as?

2012-07-24 Thread Wols Lists
that user's environment. If I don't, it runs with the original environment. That's why so many things written by inexperienced users and run from cron keep breaking ... Cheers, Wol > > > > -Original Message- > From: Wols Lists > To: u2-users > Sen

Re: [U2] uniobjects running as?

2012-07-24 Thread Wols Lists
On 24/07/12 18:57, Wjhonson wrote: > Why would it not use the env settings of the user you log in as in uniobjects? > Why don't you try to log in as that user yourself and check the settings Why wouldn't it use the env settings? Because if it's on nix, and starts as root then changes user, it need

Re: [U2] MySQL query qestion....

2012-07-19 Thread Wols Lists
My SQL-fu isn't up to much, but my reaction was along the lines of SELECT *, LAST_UPDATED=GET_PROCEDURE() FROM TABLE WHERE LAST_UPDATE > LAST_UPDATED; An optimiser may be able to optimise this for you, depending how complicated GET_PROCEDURE() is. If it's just a select from yet another table, the

Re: [U2] trimming a list (a test of your ability)

2012-07-13 Thread Wols Lists
On 12/07/12 16:15, Dave Laansma wrote: > I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares' > about pointers, it still has to get to the end of the 'string' one way > or another. Except that a string, as far as I am aware, uses the "pascal method" I think it's called - namely

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Wols Lists
On 05/07/12 23:58, Rick Nuckolls wrote: > Oops, I would of thought that if a file had, say 100,000 bytes, @ 70 percent > full, there would be 30,000 bytes "empty" or dead. Are you suggesting the > there would be 70,000 bytes of data and 42,000 bytes of dead space? Do you mean 100,000 bytes of di

Re: [U2] RESIZE - dynamic files

2012-07-05 Thread Wols Lists
On 05/07/12 14:49, Chris Austin wrote: > > Disk space is not a factor, as we are a smaller shop and disk space comes > cheap. However, one thing I did notice is when I increased the modulus to a > very large > number which then increased my disk space to about 3-4x of my record data, my > SELEC

Re: [U2] RESIZE - dynamic files

2012-07-05 Thread Wols Lists
On 05/07/12 16:12, Martin Phillips wrote: > A file without overflow is not necessarily the best solution. Winding the > split load down to 70% means that at least 30% of the file > is dead space. The implication of this is that the file is larger and will > take more disk reads to process sequent

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-04 Thread Wols Lists
On 03/07/12 21:19, Ed Clark wrote: > Hmm, I never knew that EVAL needed to write to the dict on universe. Is that > try on unidata as well? It was certainly the case on Prime. I always thought it was security more than anything else. Not particularly effective necessarily, but if you've locked

Re: [U2] RESIZE - dynamic files

2012-07-04 Thread Wols Lists
On 04/07/12 17:44, Charles Stevenson wrote: >>SMAT -d (or ANALYZE.SHM -d) see uv/bin/smat[.exe] > uv/bin/analyze.shm[.exe] > > Dynamic Files: > Slot # Inode Device Ref Count Htype Split Merge Curmod Basemod > Largerec Filesp Selects Nextsplit > 0 1285128087 2093077925

Re: [U2] RESIZE - dynamic files

2012-07-04 Thread Wols Lists
On 04/07/12 19:59, Rick Nuckolls wrote: > I believe PiOpen used a directory with two files in it ‘&$0’ and ‘&$1’ > corresponding to DATA.30 and OVER.30. If the numbers went up from there, I > think that they corresponded to alternate keys, ie ‘&$2’ and ‘&$3’ > represented DATA.30 and OVER.30 fo

Re: [U2] RESIZE - dynamic files

2012-07-04 Thread Wols Lists
On 04/07/12 11:26, Brian Leach wrote: >> All the other groups effectively get 1 added to their number > Not exactly. > > Sorry to those who already know this, but maybe it's time to go over linear > hashing in theory .. > > Linear hashing was a system devised by Litwin and originally only for > i

Re: [U2] Problem running script from crontab

2012-06-28 Thread Wols Lists
On 28/06/12 19:03, charles_shaf...@ntn-bower.com wrote: > This is interesting. There are files being created in the _PH_ directory > for each run (they are 10 minutes) apart. But they are empty. This means > that something failed right off the bat right? Looks like it. Run the PHANTOM command

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread Wols Lists
On 28/06/12 18:30, David A. Green wrote: > Sure, > > Let's say you have a file "B" that has a customer number in the data and not > the key. > > And you want to build a link from file "A" that also has a customer number > in the data. > > You would build an index on file "B" for customer number.

Re: [U2] Regarding: use of I - Descriptor

2012-06-25 Thread Wols Lists
On 25/06/12 17:47, Oaks, Harold wrote: > Hi Satya: > > An I-descriptor is the same as an I-type (or a V-type). > > It's like a little program in the DICT (dictionary) of a file. It can > do very complex things, but quite often is used for very simple things, > but those simple things can be quit

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Wols Lists
On 22/06/12 20:13, Bill Haskett wrote: > George: > > Unfortunately, I'm on Windows. I do full backups each day, but the 15Gb > backup files shut down the dbms for about 30 minutes each night. We're > not a 24/7 shop by any means, but we do span a number of time zones, so > our window for backups

Re: [U2] UV Unix File Recovery

2012-06-21 Thread Wols Lists
On 21/06/12 16:53, George Gallen wrote: > We use rdiff-backup for onsite backups, it creates a mirror and keeps > differential for > Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network b

Re: [U2] UV Unix File Recovery

2012-06-21 Thread Wols Lists
On 21/06/12 15:59, Bill Brutzman wrote: > Wol: > > Thanks. One trouble with using FileZilla is having to remember to check that > pesky option for ASCII vs binary. > > It appears I need a new and improved backup and recovery scheme. I like the > Linux box idea. > > --Bill > I've thought a l

Re: [U2] UV Unix File Recovery

2012-06-20 Thread Wols Lists
On 20/06/12 22:28, Bill Brutzman wrote: > I am having trouble trying to restore a year-end file to a new file name. > > The file is saved to my Windows7 PC... The UniVerse host is running on hp-ux. How did you save it to the PC? > > I tried to FileZilla FTP the file back using binary enconding.

Re: [U2] FW: Multivalue Question

2012-06-08 Thread Wols Lists
On 07/06/12 17:29, Al DeWitt wrote: > Unidata 7.1.20 Pick Flavor > > > > I am going to end up with a situation where I will have a multivalue > field that contains 5500 +/- values. Each value will be 5-characters > long. > > > > I'm concerned that this will issues with the following statem

Re: [U2] Why did this compile??

2012-06-08 Thread Wols Lists
On 07/06/12 21:24, Tony Gravagno wrote: > When I was working at Pick Systems I found that anything can be passed > into format masks from BASIC, OCONV, or an F-correlative. If it > doesn't blow up some code deep down in the parser then it's just > ignored. I think the theory is that if someone know

Re: [U2] Do indexes record mv pos ?

2012-06-06 Thread Wols Lists
On 06/06/12 20:02, Wjhonson wrote: > > Index shows key A12345 twice because it exists twice in the multi-valued > field which is being indexed. > > So traditionally I would like to see A12345_3^A12345_7 > > or something like that which would indicate it exists in position 3 and in > position 7

Re: [U2] Universe/Unidata in the Cloud

2012-06-06 Thread Wols Lists
On 04/06/12 18:27, Wjhonson wrote: > > That was a jury award. > It's common knowledge that juries can be swayed to grant millions of dollars > to bloated greedy record labels, or people who got cancer after smoking three > packs a day for 20 years. > > To which I'll add, McD's had had SEVERAL

Re: [U2] Learning about file sizing

2012-06-06 Thread Wols Lists
On 05/06/12 18:33, Dave Laansma wrote: > Can anyone point me to a good document that will give me guidelines for > 'proper' file sizing of dynamic files in particular? > Which database? Please note that as regards their underlying implementation UniVerse and UniData are *very* different. At user

Re: [U2] Excel Worksheets

2012-06-02 Thread Wols Lists
On 01/06/12 20:57, Colin Alfke wrote: > Or save yourself the trouble http://www. remove this > nebula-rnd.com/products/xlite.htm - There isn't anything in the CSV > "standard" that would create a new sheet and I haven't run across anything > that Excel uses. > > hth > Colin > AOL. If you try and

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wols Lists
On 01/06/12 15:33, Israel, John R. wrote: > If you are using dynamic arrays, switch to dimensioned arrays. You will be > amazed at the performance increase. > > John > And going by what you've said, what I would do - MAKE SURE THIS IS DOCUMENTED IN THE CODE - is undersize the array with a DIM A

Re: [U2] File Sizing using concurrent option AND FAREWELL

2012-05-23 Thread Wols Lists
On 23/05/12 20:14, David L. Wasylenko wrote: > "A" company??? > I wish I had the list to market into... work for life :-) Not if they've all gone bankrupt ... :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.

Re: [U2] Trim trailing attributes off records

2012-05-18 Thread Wols Lists
On 16/05/12 19:09, Wjhonson wrote: > > You missed the last sub-part where the *size* of the array actually affects > your below. > In Information flavor > IF the DIM is smaller than the record, it will write all the trailing > attributes back out > > However, IF the DIM is larger than the recor

Re: [U2] Trim trailing attributes off records

2012-05-18 Thread Wols Lists
On 16/05/12 19:10, Wjhonson wrote: > > Reality flavor must use the *stuff it all into the end* logic. > Don't have any Reality flavor accounts here. > > I wonder if when you MATWRITE it, if it will truncate the trailing attributes? > Read up on the different types of arrays. Pick does NOT have

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
ion your array to hold every element of the record *without* overflow, it'll work fine. I bet the MATWRITE tests if (0) is empty, and if it's got overflow in it ... Cheers, Wol > > > > > > > > > -Original Message- > From: Wols Lists > To:

Re: [U2] Trim trailing attributes off records

2012-05-15 Thread Wols Lists
On 11/05/12 17:36, Wjhonson wrote: > > I thought that too. > Tried that one. > What it actually does is store all the trailing attributes in the "header" > and then append them back to the record when it writes it out. > Universe 10.3 > What flavour? That ALWAYS worked for me on PI. Let's say y

Re: [U2] Printing to a windows printer from a Linux server on Universe

2012-05-15 Thread Wols Lists
On 10/05/12 22:02, Tim Stokes wrote: > I am using a samba share. > > > /usr/bin/smbclient '\\\' -U > -c 'translate;print -'>/root/Printers/ > > This is working on several windows printers to linux, and on a Windows 7 > professional edition. But on a windows 7 home edition the jobs run through

Re: [U2] Serial to Ethernet device from Mettler Scale to Unidata/Universe

2012-05-06 Thread Wols Lists
On 04/05/12 15:21, Robert Porter wrote: > There are lots of reasons... > How far is the device?We span an 11 floor set of buildings where the UV > box is, plus 3 dozens other buildings across a radius of upwards of 100 > miles. With serial the farther you go, the slower you have to set it.

Re: [U2] The CONTINUE statement

2012-04-28 Thread Wols Lists
On 28/04/12 04:22, Laura Hirsh wrote: > You are so right. Thank you John! As I've mentioned before, I've succeeded in using a goto in C! And when my colleague told me off, and said I should remove it, I just turned round and said "if you want it removed, remove it yourself". He never did ... :-)

Re: [U2] BDT what's the big deal?

2012-04-26 Thread Wols Lists
On 25/04/12 20:28, Doug Averch wrote: > The reason for both of those errors is BDT is not using the real compiler > for error checking. Those Rocket software engineers used ANTLR parse > generator to go through the UniBasic code. In my opinion a fatal flaw. > That's interesting ... what do you th

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Wols Lists
Except that CONVERT will take a from list and a to list. Much as Wil winds me up,he is spot on here. I often use that trick when validating input - if say I only want numbers I will do something like INPUT INPUTVAR JUNK = CONVERT( "01234567890", "", INPUTVAR) CONVERT JUNK TO "" IN INPUTVAR It re

Re: [U2] Huge Dynamic Unidata file

2012-04-25 Thread Wols Lists
On 25/04/12 15:46, John Jenkins wrote: > We've recently added a new UniData tuneable to udtconfig "UDT_SPLIT_POLICY" > which can help conserve space when an overflowed dynamic file splits. The > total size of the contents are not necessarily the same as the physical file > size. Always worth ch

[U2] DOS /c and the &HOLD& file

2012-04-13 Thread Wols Lists
Just a quickie - I'm trying to run a command and pass a pathname to the &HOLD& file DOS /c 'pcl6 -sOutputFile="&HOLD&\PO.pdf" "&HOLD&\PO.pcl"' I can't work out how to get dos to handle the & properly - everything seems to work perfectly until I put an & into the command. Seeing as it's a print fi

Re: [U2] COMMON Size MisMatch

2012-04-13 Thread Wols Lists
On 13/04/12 15:56, David A. Green wrote: > That's why you would specify. > > Example: > > COMMON /SYSSTUFF/ SYSSTUFF(100) > > COMMON /MYSTUFF/ MYSTUFF.REC(100) -CLEAR.ON.LOGTO > > Then only the MYSTUFF gets cleared. This is the kind of logic that I have > to end up writing over and over again

Re: [U2] New U2 BDT

2012-03-13 Thread Wols Lists
On 12/03/12 21:58, Symeon Breen wrote: > Tut linux desktop - ahh that's popular ;) > Gentoo ... the "assemble it yourself" version. But it teaches me a fair bit about system administration - especially every time an upgrade breaks something :-) Not helped by the fact my hardware is slightly

Re: [U2] New U2 BDT

2012-03-12 Thread Wols Lists
On 12/03/12 21:38, Symeon Breen wrote: > Well said Tony - But I just wish they chose something other than eclipse as > the base. Just about every programmer I know (java,.net,web,php etc) has > eclipse installed yet not one of them uses it as their main ide. Things like > VS, netbeans, inteliJ make

Re: [U2] U2-Users Digest, Vol 35, Issue 3

2012-03-11 Thread Wols Lists
On 11/03/12 16:03, Allteq - Tech Support wrote: > Hello, > > My name is Ken and I'm new here. If I have any questions do I post > them here or other site? Also, does anyone know where I can get help with > the following: > > Manfact II (wIntegrate v3.0.01) w/ UniVerse DBMS (v9.5.1.1, sam

Re: [U2] New U2 BDT

2012-03-11 Thread Wols Lists
On 11/03/12 11:57, Wjhonson wrote: > For U2 developers, what specific tool does Eclipse allow me to use, other > than BDT in general? > If the sole purpose is to allow the use of BDT for either Windows or Linux I > see a vanishingly small market for such an ability. Eclipse is a developer frame

Re: [U2] Calling U2UG Members

2012-03-09 Thread Wols Lists
On 09/03/12 17:12, Daniel McGrath wrote: > Hi Brian/U2UG, > > Now that I work for Rocket, I'm not sure if I should still vote. Thoughts? When we set up the U2UG, that was one of the things we discussed. And seeing as you are eligible to stand in the elections, it would be a bit of a poor show if

Re: [U2] mvToolbox

2012-02-16 Thread Wols Lists
On 16/02/12 23:09, Tony Gravagno wrote: > To Doug, you imply that GUI=productive which is as invalid as > telnet=unproductive. I also hoped that you would have restrained > your competitive instincts in just this one case. You don't need > to stomp on other products to promote your own. You'll n

Re: [U2] Building an Excel File

2012-02-11 Thread Wols Lists
n't have row*s* to process. > As always, there are exceptions to any thing. Yes. In this case it's the FM that is the problem ... > > John Israel > Cheers, Wol > Sent from my iPhone > > On Feb 11, 2012, at 6:22 AM, "Wols Lists" wrote: > >> On 09/

Re: [U2] SB+ editing question

2012-02-11 Thread Wols Lists
On 10/02/12 01:02, Lunt, Bruce wrote: > If you mean: ] that doesn't seem to work. Probably depends on your emulator - in my new job (yes I've got a new job!) they use Hostaccess, and } works just fine :-) It sticks a } in the file that really is a @VM. If all else fails, you can hopefully define

Re: [U2] Building an Excel File

2012-02-11 Thread Wols Lists
On 09/02/12 16:47, Charlie Noah wrote: > I'm exporting from Excel and importing into jBASE. DCOUNTing on the > header line is an excellent idea. I'll give that a try. Since I'm using > a convert routine, if that fixes the problem, it will be fixed for any > spreadsheet I import. > > It may very we

Re: [U2] Building an Excel File

2012-02-11 Thread Wols Lists
On 09/02/12 16:55, Charlie Noah wrote: > Hi Josh, > > I'd be happy to share my routines with you, if they would be of any use. > I have a program I use to load a csv file, and a subroutine which > converts back and forth between csv, dynamic and fixed width, either a > line at a time or an entire

Re: [U2] Building an Excel File

2012-02-11 Thread Wols Lists
On 09/02/12 17:03, Israel, John R. wrote: > I always read in the file and convert known "problem characters" to null then > process the file row by row. Except if you do that *here* you won't be able to convert it row by row ... you'll have all the data in just one row !!! Cheers, Wol > > -

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Wols Lists
On 07/02/12 23:46, Kevin King wrote: > An include is fine for declarations, but not for executable code due to the > fact that individual lines in the include cannot be debugged (on Unidata). > Declarations like EQUates and common blocks are best uses for includes. > The need to break apart big r

Re: [U2] Building an Excel File

2012-02-06 Thread Wols Lists
On 06/02/12 21:44, George Gallen wrote: > I haven't checked, but are there any perl modules that can convert an XML > file to an .xls file >This would require unix, but not any user intervention. You can get Perl for Windows. Done by ActiveState, I think MS has taken them over so it's even a

Re: [U2] Passing by Value

2012-01-27 Thread Wols Lists
On 26/01/12 21:26, Mecki Foerthmann wrote: What does -X do? Sorry if this has already been answered, but I guess it's what I know as XREF. It creates a listing of all the variables used, including the lines on which they are used. I'd probably compile it with -Z2, run the program in debu

Re: [U2] Init script for Universe on RHEL 5 or 6?

2012-01-04 Thread Wols Lists
On 04/01/12 21:44, John Hester wrote: Problem is, the UV install puts a complete copy of the script in the runlevel directories making it impossible to be managed with chkconfig. I think this is because there is both a startup and shutdown copy of uv.rc that differ from each other. That doesn'

Re: [U2] Init script for Universe on RHEL 5 or 6?

2012-01-04 Thread Wols Lists
On 04/01/12 21:06, John Thompson wrote: So has anyone ever seen or written an init script for Universe on RHEL 5 or 6. I know some things changed with 6, but, it still seems to have some compatibility. Surely that should be added automatically for you by the install? When I say init script I

Re: [U2] AV feedback (was) Corrupted compiled code

2011-12-24 Thread Wols Lists
On 23/12/11 17:58, John Jenkins wrote: I've seen some significant problems with Nod32 AV as well so I avoid it. (There's a TechTip). I've not really played with it (when I did it didn't have "on access" checking, though I think that's recently been added), but what about ClamAV? It's a "Free"

Re: [U2] [UD] Corrupted compiled code

2011-12-21 Thread Wols Lists
On 21/12/11 20:59, Wally Terhune wrote: I was actually thinking of my personal memory about UniData problems reported these past 21 years. I got that. It just seemed a nice intro to what I thought was a possibility. But seeing as I was thinking of INFORMATION, I knew it was a long shot. Ch

Re: [U2] [UD] Corrupted compiled code

2011-12-21 Thread Wols Lists
On 21/12/11 17:38, Wally Terhune wrote: Though I have to agree with Bob Wyatt: "memory seems to get cheaper and less reliable as it ages" :-( I was thinking memory ... possibly bad? Does Unidata store its programs in shared memory? Could the memory have got corrupted and it takes a recompile

Re: [U2] RHEL 6.x and Universe Package Requirements

2011-12-20 Thread Wols Lists
On 20/12/11 14:17, John Thompson wrote: True. But if you don't use yum, yum doesn't update its database properly of what has been installed/updated and will sometimes complain on its next run. Plus yum seems to do a much better job of automatically installing the dependencies you need, without

Re: [U2] RHEL 6.x and Universe Package Requirements

2011-12-20 Thread Wols Lists
On 20/12/11 13:52, John Thompson wrote: Rocket has a little paper on this that my vendor sent me, BUT, it uses rpm, and rpm has been deprecated with RHEL 6. You now need to run everything through yum (the package manager). AUIU, all yum does is call rpm "under the hood". So yes, using yum *sh

Re: [U2] Solid State Drives (SSD) and Universe

2011-12-19 Thread Wols Lists
On 19/12/11 13:45, John Thompson wrote: 2) Be sure and buy enterpise SSD's. For example, an Intel 320 SSD is probably not an enterprise SSD. The quality of the firmware/drivers and flash memory is pretty key on these things, and the prices range from $200 all the way up to $4,000+ a piece. I'

<    1   2   3   4   >