Re: [U2] LIST reports and Fields that Do reads
In UniData we also make sure the file is opened to a COMMON variable. Makes a huge performance difference vs doing the OPEN on every call to the subroutine. YMMV Sent from my iPhone. Please forgive brevity as well as any auto-corrected or fat finger spelling errors! On Jul 19, 2013, at 1:29 PM, randyleesmith randyleesm...@roadrunner.com wrote: 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: http://u2-universe-unidata.1073795.n5.nabble.com/LIST-reports-and-Fields-that-Do-reads-tp41304p41308.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData PreStore to change the KEY of a record?
OK - a program was always a choice -- just wanted to ensure I had not missed a 'simple feature' of AE along the way -- again - 90 records -- I have to alter a single attribute and change the key ... was hoping I could do one 'compound' prestore! No such luck! Thanks all... at least I know I have 'maxed out' the usage of PreStores!! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, May 29, 2013 2:25 AM To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData PreStore to change the KEY of a record?
I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData PreStore to change the KEY of a record?
But how would I 'swap out' the bad piece? For example - -the key is currently bad.1234 and I want it to be good.1234 How would I perform that 'replace' on the ID for the record? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Tuesday, May 28, 2013 1:04 PM To: 'U2 Users List' Subject: Re: [U2] UniData PreStore to change the KEY of a record? Sure, you should be able to write the record with the new key and then delete the existing record. The trouble comes in making sure another record doesn't already exist with the new key. Hth Colin -Original Message- From: David Wolverton Sent: Tuesday, May 28, 2013 11:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] srs4uv.com status [Was: Corrupted object in global catalog]
Question on the Source Code Recovery -- is the logic such that it could be 'open sourced' or GPL'd? Or is there another way to do the source recovery? That is, were the mechanics sold to Rocket Software Professional Services? If not, could they be sold to another company is someone wanted to keep the product active? While I don't have a need now, I like to think there is a place to go for 'the unthinkable' if it happened! Just wondering!! I don't know the circumstances that led to withdrawing this service -- I would think it would rarely be needed, but when it was, would be invaluable. Seems a loss if it's now got to be re-written from scratch!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gyle Iverson Sent: Thursday, January 03, 2013 7:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] srs4uv.com status [Was: Corrupted object in global catalog] Thanks for your comments David. I left http://srs4uv.com/ on-line for now. The hosting expires 2012/02/21 and the domain expires 2012/02/28. I added a Donate button to the main page in case people want to keep the site around and the links to it from breaking. Otherwise, the site vanishes next month. Gyle ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wally Terhune
Well he can ALWAYS continue in the User Group as an enthusiast! I mean, he can only play golf, fish, ski, etc etc for so many hours in a day, right?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, December 14, 2012 4:02 AM To: 'U2 Users List' Subject: Re: [U2] Wally Terhune Wally You *can't* retire! What will all the UniData crowd do without you? Thanks for all your help, guidance (and patience) over the years. It's been a privilege to meet you and I wish you a long and happy retirement. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, December 13, 2012 10:04 PM To: U2 Users List Subject: [U2] Wally Terhune Congratulations on your upcoming retirement. Thanks for all the support you have given us over the years for us Unidata guys. Your breadth of knowledge will surely be missed. Enjoy retirement, -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
HA! I had to go look up SMILE for GIRLS -- what a GREAT acronym! They were really were creative (and yes, maybe a bit sexist...) in their naming! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, November 01, 2012 12:02 PM To: 'U2 Users List' Subject: Re: [U2] Another job ad written by people who have no clue Show me a single person in the world who has all of : Universe, Unidata, D3, Jbase, Revelation AND RPL and I will show you a liar Better keep my mouth shut, then, hadn't I ? grin. Mind you I'm surprised they didn't add SMILE for GIRLS... Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
System Marketing Inc. Language Extender for Generalized (Global?) Information Retrieval Language System -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Thursday, November 01, 2012 1:01 PM To: U2 Users List Subject: Re: [U2] Another job ad written by people who have no clue So what does SMILE stand for ? Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, November 01, 2012 1:38 PM To: 'U2 Users List' Subject: Re: [U2] Another job ad written by people who have no clue HA! I had to go look up SMILE for GIRLS -- what a GREAT acronym! They were really were creative (and yes, maybe a bit sexist...) in their naming! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, November 01, 2012 12:02 PM To: 'U2 Users List' Subject: Re: [U2] Another job ad written by people who have no clue Show me a single person in the world who has all of : Universe, Unidata, D3, Jbase, Revelation AND RPL and I will show you a liar Better keep my mouth shut, then, hadn't I ? grin. Mind you I'm surprised they didn't add SMILE for GIRLS... Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.3.x on intel
Is there a need for it? The UniVerse transition to 64 bit was **SO** painful that I suspect as long as the 32 bit binaries are performing, they have little reason to WANT to endure that torture... Personally, if they DID ship a 64 bit version tomorrow, I'd wait for everyone else to install it first. ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Thursday, November 01, 2012 5:24 PM To: U2 Users List Subject: [U2] Unidata 7.3.x on intel For Unidata 7.2.x and earlier, Rocket does not have 64-bit builds for intel (Windows, RedHat). To be clear - you can install on 64-bit machines (we have), but the unidata binaries are 32 bit. Does anyone know if this is the same for 7.3? It's not a huge issue for us, more curiosity. -- Jeff Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
In my example, I would grab 'whatever' records were hashed in the to 'group' -- while it's not perfect since there are 'overflow' - was just trying to think of a way to break a file into pieces that would otherwise process much like a BASIC select - just grab the 'group' and go I can see it's probably not possible, but the topic got me thinking about 'what if'... (And we're UniData - so I have to apply that filter to most everything I read on the list anyway G) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Taylor Sent: Monday, October 01, 2012 6:10 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe Or, let's suppose you wanted to process repetitive segments of one very large record using the same logic in a separate phantom process for each segment, how large a record can be read and processed in Universe? Dave So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
AH - would not even have to 'delete' as long as the 'locks' are held long enough -- meaning if you know you will have 20 phantoms, each phantom would keep a list of 'keys locked' and once it hits 21 (or 40 if you want insurance LOL) in the list, would unlock earliest lock -- that way there is no way any other phantom could process anything twice... As each phantom runs, if it hits a locked record, it would move to the next item in the list. Great idea! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 02, 2012 10:52 AM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe What if you created a duplicate file, did a SELECT and saved the list (non-sorted). Each of the phantoms would do a getlist and loop through using readlist/readu and if the record were already locked, skip it until it reads An unlocked record (and locks it). Delete the record when finished. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, October 02, 2012 11:43 AM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe In my example, I would grab 'whatever' records were hashed in the to 'group' -- while it's not perfect since there are 'overflow' - was just trying to think of a way to break a file into pieces that would otherwise process much like a BASIC select - just grab the 'group' and go I can see it's probably not possible, but the topic got me thinking about 'what if'... (And we're UniData - so I have to apply that filter to most everything I read on the list anyway G) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Taylor Sent: Monday, October 01, 2012 6:10 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe Or, let's suppose you wanted to process repetitive segments of one very large record using the same logic in a separate phantom process for each segment, how large a record can be read and processed in Universe? Dave So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
Great point!! I think we can agree that 'spinning media latency' is the enemy and having phantoms increasing the 'head dance' can make things worse, not better! Many problems go away or become trivial as the spinning media trails to the sunset. I've advised customers that just moving 'code files' to a tiny SSD would likely increase overall system performance on Windows boxes. Just waiting until the price for Enterprise SSDs makes them a no-brainer... Until then, even small SSDs will help! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, October 02, 2012 12:05 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe You've highlighted one problem here. By having multiple processes accessing the disk in different locations, you destroy cache optimization and seek times. More phantoms = less performance. This assumes I/O is a bigger concern than CPU, which is generally the case. More phantoms = more communication, which also adds another overhead that reduces performance. Introducing more phantoms than CPU cores, you increase the amount of context switching, which ones again hurts your cache usage as well as adding bigger overheads on the CPU again. In short, except for very specific cases, increasing 'concurrency' through phantoms on a single machine is generally ill-advised, resulting in longer processing times, higher average system loads and worse yet, greater system complexity (and hence ways for things to break). As mentioned earlier, more system-level architectural changes (such as multiple machines, or at least, files storage on different disks/spindles for each process) are required if you want benefit from this sort of work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, October 01, 2012 4:47 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe OK - I was trying to create a 'smoother use' of the disk and 'read ahead' -- this example the disk would be chattering from the heads moving all over the place. I was trying to find a way to make this process more 'orderly' -- is there one? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, October 01, 2012 4:48 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 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) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun
Re: [U2] [u2] Parallel processing in Universe
Which was my question -- was there a way to 'jump to' a group or 'BASIC SELECT' with a'starting/ending' group -- so that again, 10001 moduo, one phantom does 'groups' 1-2000, next phantom does 'groups' 2001-4000 etc... But can't see that it's really possible without jumping through hoops that make it unattractive at best! At least on UniData! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 02, 2012 12:55 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe OK. I See what your saying...I'll buy that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 02, 2012 1:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] Parallel processing in Universe The point of the caching concern is related to the read ahead, and you will still get some benefit from this, if your five phantoms are reading their *portion* of the file in order, which they should. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Oct 2, 2012 10:39 am Subject: Re: [U2] [u2] Parallel processing in Universe If 5 phantoms were running, and read in order but from 5 different starting points, the records would Essentially still be processed in a random order, if you were to layout the record ID's as they get Processed. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 02, 2012 1:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] Parallel processing in Universe The idea of the phantoms would be to read the file in order, not randomly, just inorder from five different starting points. So you should still get the benefit of some caching. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
OK - I was trying to create a 'smoother use' of the disk and 'read ahead' -- this example the disk would be chattering from the heads moving all over the place. I was trying to find a way to make this process more 'orderly' -- is there one? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, October 01, 2012 4:48 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 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) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
I've found that TO 8 does not work...
HOWEVER...
LISTNO = 8
TO LISTNO
Works fine... always meant to ask Rocket why I have that issue, but just
worked around it as shown.
DW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Monday, September 24, 2012 11:49 AM
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the
master process, and let your SUBR virtual field default to list 0 {zero}?
The other option could be to do a READLIST within the SUBR function and
reset the list when RETURNing, but this could be onerous in terms of
processing speed.
HTH
-Baker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 11:43 AM
To: U2 Users List
Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata? I could have
sworn I've done this before, but for some reason it's not working at all as
I recall.
I have this SUBR(..) type field in file A that selects records from file B
to calculate an aggregate. This works fine when listing file A and showing
the field. However, if there's an active select list when file A is listed
with this field, the select statement in my SUBR(..) is consuming the active
select list 0 and returning incorrect results.
My subroutine is $BASICTYPE U and is selecting records using the lower
case select and selecting to active list #3. It then processes from list
#3 and returns its result. I've tried using the RTNLIST and PASSLIST
options on the EXECUTE statements and I get a Misuse of Reserved Word
'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE
with no compilation errors but also no improvement on the problem. I've
even tried MDPERFORM but I get the misuse errors with the RTNLIST and
PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an
error on MDPERFORM but I can't READNEXT from a numbered select without the
$BASICTYPE U.
How should I structure this SUBR(..) so that it does not consume list 0 when
selecting to list 3?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
This communication, its contents and any file attachments transmitted with
it are intended solely for the addressee(s) and may contain confidential
proprietary information.
Access by any other party without the express written permission of the
sender is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy,
distribute or use the contents, attachments or information in any way.
Please destroy it and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
And I think it's more on the 'READNEXT' and the 'FROM' that I've seen the
issue, by the way...
Any place in BASIC (not the ECL-level stuff) seems to not like the 'actual
numeric' -- but a variable works fine.
YMMV -- just something I've seen.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton
Sent: Monday, September 24, 2012 11:53 AM
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
I've found that TO 8 does not work...
HOWEVER...
LISTNO = 8
TO LISTNO
Works fine... always meant to ask Rocket why I have that issue, but just
worked around it as shown.
DW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Monday, September 24, 2012 11:49 AM
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the
master process, and let your SUBR virtual field default to list 0 {zero}?
The other option could be to do a READLIST within the SUBR function and
reset the list when RETURNing, but this could be onerous in terms of
processing speed.
HTH
-Baker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 11:43 AM
To: U2 Users List
Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata? I could have
sworn I've done this before, but for some reason it's not working at all as
I recall.
I have this SUBR(..) type field in file A that selects records from file B
to calculate an aggregate. This works fine when listing file A and showing
the field. However, if there's an active select list when file A is listed
with this field, the select statement in my SUBR(..) is consuming the active
select list 0 and returning incorrect results.
My subroutine is $BASICTYPE U and is selecting records using the lower
case select and selecting to active list #3. It then processes from list
#3 and returns its result. I've tried using the RTNLIST and PASSLIST
options on the EXECUTE statements and I get a Misuse of Reserved Word
'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE
with no compilation errors but also no improvement on the problem. I've
even tried MDPERFORM but I get the misuse errors with the RTNLIST and
PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an
error on MDPERFORM but I can't READNEXT from a numbered select without the
$BASICTYPE U.
How should I structure this SUBR(..) so that it does not consume list 0 when
selecting to list 3?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
This communication, its contents and any file attachments transmitted with
it are intended solely for the addressee(s) and may contain confidential
proprietary information.
Access by any other party without the express written permission of the
sender is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy,
distribute or use the contents, attachments or information in any way.
Please destroy it and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
AH! Probably explains why we would have to set WIP.LIST in your example -- we use BASICTYPE P everywhere. Never thought about it being BASICTYPE-based, but makes perfect sense. Thanks Trevor! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Trevor Fulton Sent: Monday, September 24, 2012 12:44 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists BASICTYPE M and P allows for named Select Lists, so you can EXECUTE SENTENCE RTNLIST WIP.LIST CAPTURING JUNK LOOP READNEXT WIP.ID FROM WIP.LIST ELSE EXIT CALL SUB1 REPEAT So in SUB1 you can do another EXECUTE to another Named list. Trevor. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 24 September 2012 17:43 To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== mzYSmfEz!grmb2Vr9yuNyLUcPPmbfFPdrr1lqOECv!Swg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows] (SECURITY=UNCLASSIFIED)
Worse, I know that on UniData, the IP address 'reported' back to the server is simply the first address from the IPCONFIG -- even if that address is non-routable to the server! Very annoying issue I've submitted to Rocket (actually, it was IBM at the time!) ... Not yet fixed to my knowledge. David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, September 06, 2012 10:08 PM To: U2 Users List Subject: Re: [U2] [Windows] (SECURITY=UNCLASSIFIED) Great input, Tony. But be warned WJ, if your client PCs are external to your network, then Private Addressing and NAT may make this whole exercise nugatory. For example, if your host network / server is on your 10.x.y.z (or 192.168.a.b) and your remote client is on his 10.x.y.y (or 192.168.a.c), then you may end up resolving the name for the remote client as being whatever has 10.x.y.y (or 192.168.a.c) assigned on its local network. IPv4 addresses are legitimately non-unique. Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of Tony Gravagno Sent: Friday, 7 September 2012 1:48 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Windows] Here are a number of ways to link a telnet client into UV back to its respective hostname. There's some redundancy here as not all commands work everywhere. [snip] I'm sure none of that was helpful to WJ who will say no, that's not it at all, what I really want is... but I trust it will benefit someone else. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub HangUp Fixed
Did someone submit this as a bug that HS.SCRUB should probably do something 'more friendly' than just hang if there is a dictionary error? Just wondering -- every now and then we just accept as 'fact' something that really should be reported a bug to Rocket! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, August 30, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Scrub HangUp Fixed David: 0. Thanks so much for writing. 1. Yes... same problem on the same file... now fixed. 2. I have read both the Rocket ODBC and JDBC documentation exhaustively... and found these manuals to be rather excellent. 3. I have also had trouble with getting the Rocket JDBC driver to work with Adobe's new release of ColdFusion 10. It is like I have to again write a little Java program to troubleshoot the connection string thing. We may be forced to upgrade our version of UV. 4. Much as I would like to attend all the Rocket UV courses... I find these courses to be pricey and involve serious days and travel. 5. I would like to see Rocket move the courses to Lynda.com or do something similar to Lynda. 6. I am delighted to learn about the seminar... I registered for it. I am surprised that I did not learn about it except through this back door. 7. This list being something of a forum... as I understand it... posts on newbie, intermediate, and advanced questions are all welcome. If the question is directly answerable via an official Rocket manual... then the originator risks suffering the punishment of embarrassment from the respondent who... from some point of view... is following in the traditions of the late William F. Buckley, Jr. 8. The speed of the u2ug forum responses in of course invaluable. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, August 29, 2012 8:32 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html Same problem/solution? I kindly suggest that you go on a Rocket UV course to help work out how to get the best from UV. Plus the UV ODBC documentation is quite detailed on the use of HS.SCRUB. So I assume you're followed it's correct used - before you posted this request for help. BTW check this out Rocket U2 Webinar coming soon: http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 29 August 2012 6:16 AM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up 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 dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub HangUp Fixed
Ahahahahahahahahaha!! No!! Stop!! You're killing me!! But seriously... For the good of humanity, it's the duty of every person on the list to raise stinks to Rocket on stupid system behavior like this It's probably not that hard to fix and will avoid the NEXT person from having to live the trauma. And then we can get back to reminiscing about RQM - the true reason for the list;-) Just sayin' -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, August 30, 2012 10:36 AM To: U2 Users List Subject: Re: [U2] Scrub HangUp Fixed In my little world of fantasy (BillsVille)... both Rocket and US Homeland Security are actively monitoring this list. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 30, 2012 11:32 AM Subject: Re: [U2] Scrub HangUp Fixed Did someone submit this as a bug that HS.SCRUB should probably do something 'more friendly' than just hang if there is a dictionary error? Just wondering -- every now and then we just accept as 'fact' something that really should be reported a bug to Rocket! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub HangUp Fixed
LOL!! In my book ... opening a case = raising a stink g Bad choice of words though, eh?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, August 30, 2012 11:36 AM To: U2 Users List Subject: Re: [U2] Scrub HangUp Fixed Rather than raising a stink, it would be best to just open a support case... Without personal knowledge of UV, I haven't been paying much attention to this thread. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 30, 2012 10:13 AM To: 'U2 Users List' Subject: Re: [U2] Scrub HangUp Fixed Ahahahahahahahahaha!! No!! Stop!! You're killing me!! But seriously... For the good of humanity, it's the duty of every person on the list to raise stinks to Rocket on stupid system behavior like this It's probably not that hard to fix and will avoid the NEXT person from having to live the trauma. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub HangUp Fixed
Just remember -- this is a USER's Group -- not a Rocket Support Forum. So no one from Rocket is required or expected to be here. This is not a 'support channel' for Rocket at all. And that was my point, Rocket is not lurking here and noticing things they can make better or change, and we sometimes just take the fix we get from our fellow users and move forward without thought of 'wow, that really should not have done that - I should log a case' ... The Engineers don't know what to fix without feedback from users. Hence my 'raise a stink' comment (Okay, Okay ... log a case in Rocket-speak. g) I for one say THANK YOU WALLY -- I appreciate your time and concern for all us User-Folk I love it when you lurk and pop up with tidbits... But that's just me! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, August 30, 2012 4:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub HangUp Fixed There is no one at Rocket whose role is to be the liaison to the community. That issue has been brought up before. I find it to be a remarkable attitude on their part. But so far they haven't asked my opinion. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 30, 2012 8:36 am Subject: Re: [U2] Scrub HangUp Fixed In my little world of fantasy (BillsVille)... both Rocket and US Homeland Security are actively monitoring this list. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 30, 2012 11:32 AM Subject: Re: [U2] Scrub HangUp Fixed Did someone submit this as a bug that HS.SCRUB should probably do something 'more friendly' than just hang if there is a dictionary error? Just wondering -- every now and then we just accept as 'fact' something that really should be reported a bug to Rocket! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PI/UV: Decompiler
Was there a reason it was dropped? Just wondering ... While I've never needed one, I can think of a few close calls at client sites where they lost custom source code! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lee Leitner Sent: Tuesday, August 28, 2012 12:01 PM To: U2 Users List Subject: Re: [U2] PI/UV: Decompiler Folks, Infocus had a Unidata decompiler (Xtrico) which we stopped development and licensing on a number of years ago. I am not aware of any others under development. Cheers, Lee On Tue, 28 Aug 2012, Tom Whitmore wrote: I know there was a decompiler available. I don't remember if Lee Leitner (Infocus) or Fitzgerald and Long were the resellers for this tool. I'll try to dig up information on this but it would be great if Lee, Peggy or Jeff could put their two cents in on this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, August 28, 2012 8:18 AM To: U2 Users List Subject: Re: [U2] PI/UV: Decompiler I don't know of any UniData UniBasic object code decompiler utilities. Certainly none ever created by the UniData engineering team. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Sent: Monday, August 27, 2012 8:37 PM To: U2 Users List Subject: Re: [U2] PI/UV: Decompiler Does anyone know how to find out more information about 'IBM's compiler'? (see http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg10843.html ) Does anyone know where to locate a decompiler (or decompiler service) for UNIBASIC (UNIDATA BASIC)? Does anyone know how to access the 'free decompiler that Universe provides'? *Why would I pay to use the SRS for my PI/open recovery when I can use the free decompiler that UniVerse provides?* http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the% 20SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20f ree%20decompiler%20that%20UniVerse%20provides? (see http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the%2 0SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20fr ee%20decompiler%20that%20UniVerse%20provides? ) (or just see http://www.srs4uv.com/faq.htm and look for *Why would I pay to use the SRS for my PI/open recovery when I can use the free decompiler that UniVerse provides?* http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the% 20SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20f ree%20decompiler%20that%20UniVerse%20provides?) Robert Norman . ROBERT NORMAN AND ASSOCIATES Address: 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 Phone : 951/541-1668 Email :i...@keyway.net Website:http://users.keyway.net/~ice/ [Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC] -Original Message- RE: [U2] PI/UV: Decompiler Gyle Iverson Thu, 18 Aug 2005 18:37:56 -0700 AD When you need to recover the BASIC source code for PI/open or UniVerse systems, your ultimate source is found at www.srs4uv.com. The srs4uv team has helped companies, government agencies and learning institutions around the globe with their source recoveries for over 22 years. Many srs4uv customers tried IBM's PI/open decompiler beforehand and seem amazed at how easy the recovered programs are to read and maintain. /AD While the PI/open decompiler provided by IBM was a technically accurate utility, the maintainability of their recovered source code leaves much to be desired. IBM's decompiler failed to perform logical structure recovery, the most important quality, as this impacts the long-term maintainability of the programs. (There are other deficiencies with IBM's decompiler, such as, maintainable common member naming, reversing equated variable expressions, and recovering programs with certain internal-use statements. Please contact me directly for additional information on these PI/open recovery issues.) The logical structure for LOOP-REPEAT, FOR-NEXT and CASE statements, like IF-THEN-ELSE statements, are translated by a BASIC compiler into conditional and unconditional branch instructions. IBM's PI/open decompiler took the lazy-mans approach to decompiling, returning conditional branches as IF-THEN statements and unconditional branches as GOTO statements. As you might imagine, IBM's results look like a pile of spaghetti code. The srs4uv decompilers analyze the branch patterns to recover all of the high-level logical structures, making
Re: [U2] CSV to Array
You can't have 3/4 Bolts in the data stream -- that would not work. So that means the embedded has to be 'escaped' - usually by a \.. So you'd have 3/4\ Bolts or the like ... right? In that case, you'd want to 'swap' out the \ for some other 'hold character' first -- like DQOUTE And Then swap out the 'remaining' '' out as listed. I did forget that! At the very end, you 're-swap' DQUOTE for '' DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, August 16, 2012 2:26 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CSV to Array The moment you start working in the engineering or manufacturing industry where it is not uncommon to have double quotes embedded in a field (i.e 5 1/4 Steel Bar) your code will bite you. On 15/08/2012 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 it... but this should work ... seems this would be faster as well on larger records. Only thing you'd have to test for -- if the first character is a doublequote, we will have a blank first attribute and should not -- but that could be tested in the END ELSE section (IF XXX = 1 THEN IF DATASTRING[1,1] = 1 THEN CONTINUE) DATASTRING = 'A,B,C,D,E,F,G,H,I,J,K,L NEWSTRING = SWAP '' WITH @AM IN DATASTRING AMCNT = DCOUNT(DATASTRING,@AM) FOR XXX = 1 TO AMCNT IF MOD(AMCNT,2) = 0 THEN NEWSTRING := @AM: DATASTRINGXXX END ELSE DATAROW = NEWSTRINGXXX SWAP ',' WITH @AM IN DATAROW NEWSTRING := @AM:DATAROW NEWSTRING-1 = DATAROW END NEXT XXX -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 15, 2012 4:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] CSV to Array Rex Gozar uploaded this code, and someone (perhaps him) corrected it, but there's a redundancy here. I'm trying to fix it, in my own version, mostly perhaps I *hate* the CONTINUE, but the logic is a bit convoluted eh? Anyone spot the redundancy ? EQU COMMA TO ',' EQU DQ TO '' BUFFER = TEXT BUFPTR = 0 CPTR = 0 QUOTESW = @FALSE LOOP CPTR += 1 C = BUFFER[CPTR,1] WHILE (C NE ) DO IF (DQ EQ C) THEN IF (QUOTESW) AND (DQ:DQ EQ BUFFER[CPTR,2]) THEN CPTR += 1 END ELSE QUOTESW = NOT(QUOTESW) CONTINUE END END IF (COMMA EQ C) AND NOT(QUOTESW) THEN C = @FM END BUFPTR += 1 BUFFER[BUFPTR,1] = C REPEAT RECORD = BUFFER[1,BUFPTR] RETURN END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CSV to Array
And I missed the whole 'Escaping Double Quotes' thread -- so this is already covered... Skip this post!! ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 16, 2012 5:42 PM To: 'U2 Users List' Subject: Re: [U2] CSV to Array You can't have 3/4 Bolts in the data stream -- that would not work. So that means the embedded has to be 'escaped' - usually by a \.. So you'd have 3/4\ Bolts or the like ... right? In that case, you'd want to 'swap' out the \ for some other 'hold character' first -- like DQOUTE And Then swap out the 'remaining' '' out as listed. I did forget that! At the very end, you 're-swap' DQUOTE for '' DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, August 16, 2012 2:26 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CSV to Array The moment you start working in the engineering or manufacturing industry where it is not uncommon to have double quotes embedded in a field (i.e 5 1/4 Steel Bar) your code will bite you. On 15/08/2012 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 it... but this should work ... seems this would be faster as well on larger records. Only thing you'd have to test for -- if the first character is a doublequote, we will have a blank first attribute and should not -- but that could be tested in the END ELSE section (IF XXX = 1 THEN IF DATASTRING[1,1] = 1 THEN CONTINUE) DATASTRING = 'A,B,C,D,E,F,G,H,I,J,K,L NEWSTRING = SWAP '' WITH @AM IN DATASTRING AMCNT = DCOUNT(DATASTRING,@AM) FOR XXX = 1 TO AMCNT IF MOD(AMCNT,2) = 0 THEN NEWSTRING := @AM: DATASTRINGXXX END ELSE DATAROW = NEWSTRINGXXX SWAP ',' WITH @AM IN DATAROW NEWSTRING := @AM:DATAROW NEWSTRING-1 = DATAROW END NEXT XXX -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 15, 2012 4:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] CSV to Array Rex Gozar uploaded this code, and someone (perhaps him) corrected it, but there's a redundancy here. I'm trying to fix it, in my own version, mostly perhaps I *hate* the CONTINUE, but the logic is a bit convoluted eh? Anyone spot the redundancy ? EQU COMMA TO ',' EQU DQ TO '' BUFFER = TEXT BUFPTR = 0 CPTR = 0 QUOTESW = @FALSE LOOP CPTR += 1 C = BUFFER[CPTR,1] WHILE (C NE ) DO IF (DQ EQ C) THEN IF (QUOTESW) AND (DQ:DQ EQ BUFFER[CPTR,2]) THEN CPTR += 1 END ELSE QUOTESW = NOT(QUOTESW) CONTINUE END END IF (COMMA EQ C) AND NOT(QUOTESW) THEN C = @FM END BUFPTR += 1 BUFFER[BUFPTR,1] = C REPEAT RECORD = BUFFER[1,BUFPTR] RETURN END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CSV to Array
Oh that is interesting ... will have to give that a run! Thanks Wol! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, August 16, 2012 7:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CSV to Array 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 it... but this should work ... seems this would be faster as well on larger records. Only thing you'd have to test for -- if the first character is a doublequote, we will have a blank first attribute and should not -- but that could be tested in the END ELSE section (IF XXX = 1 THEN IF DATASTRING[1,1] = 1 THEN CONTINUE) Given that you're parsing on a delimiter, actually the best tool here is probably MATPARSE! You need two dimensions, however. Something like DIM ARRAY(100,2) MATPARSE STRING USING ',' Until I actually played with it, I didn't realise it put text into column 1, and delimiters into column 2. Which makes it easy to ding through. If say you have a comma followed by two double quotes, it will put the comma in column 2, a blank in column 1, and then both double quotes in the next element in column 2. I was actually parsing a maths statement, but it was so easy ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CSV to Array
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 it... but this should work ... seems this would be faster as well on larger records. Only thing you'd have to test for -- if the first character is a doublequote, we will have a blank first attribute and should not -- but that could be tested in the END ELSE section (IF XXX = 1 THEN IF DATASTRING[1,1] = 1 THEN CONTINUE) DATASTRING = 'A,B,C,D,E,F,G,H,I,J,K,L NEWSTRING = SWAP '' WITH @AM IN DATASTRING AMCNT = DCOUNT(DATASTRING,@AM) FOR XXX = 1 TO AMCNT IF MOD(AMCNT,2) = 0 THEN NEWSTRING := @AM: DATASTRINGXXX END ELSE DATAROW = NEWSTRINGXXX SWAP ',' WITH @AM IN DATAROW NEWSTRING := @AM:DATAROW NEWSTRING-1 = DATAROW END NEXT XXX -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 15, 2012 4:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] CSV to Array Rex Gozar uploaded this code, and someone (perhaps him) corrected it, but there's a redundancy here. I'm trying to fix it, in my own version, mostly perhaps I *hate* the CONTINUE, but the logic is a bit convoluted eh? Anyone spot the redundancy ? EQU COMMA TO ',' EQU DQ TO '' BUFFER = TEXT BUFPTR = 0 CPTR = 0 QUOTESW = @FALSE LOOP CPTR += 1 C = BUFFER[CPTR,1] WHILE (C NE ) DO IF (DQ EQ C) THEN IF (QUOTESW) AND (DQ:DQ EQ BUFFER[CPTR,2]) THEN CPTR += 1 END ELSE QUOTESW = NOT(QUOTESW) CONTINUE END END IF (COMMA EQ C) AND NOT(QUOTESW) THEN C = @FM END BUFPTR += 1 BUFFER[BUFPTR,1] = C REPEAT RECORD = BUFFER[1,BUFPTR] RETURN END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dbpause/dbresume or stopud/startud
Has the issue on Windows been resolved? Our customers reported that UniData maintained 'open files' at a dbpause, which still made the backup difficult with a dbpause. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, August 08, 2012 5:27 PM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud RFS with TP has been available in UniData for 15-20 years too. I understand your issues. I'm just saying you do have the ability in UniData to generate a consistent backup (physical and logical) using dbpause. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 3:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud That's the rub isn't it? We have a few thousand programs written over 30 years, and only a limited staff, and users always want more. Users don't see the need to go back and *fix* code that's working, and/or are not willing to pay you to do it. It's a cost-benefit issue. For a site that doesn't *have* to be 24-7 but can be say 22-7, it's safer to shutdown, then backup. You can't always control every piece of code someone has written. -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 2:18 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud If you have put transaction processing semantics in your code you will have logical consistency with dbpause. For RFS enabled systems, dbpause forces a checkpoint. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud You get an extra benefit from stopud and startud in that your database will be consistent. dbpause does not enforce consistency Personally I would never suggest using dbpause to take a snapshot because of that issue. You're never guarenteed that you have a clean consistent copy. -Original Message- From: John Jenkins u2g...@btinternet.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 6:02 am Subject: Re: [U2] dbpause/dbresume or stopud/startud dbpause and dbresume allow any background processes (e.g. PHANTOM or WebDE (Redback)) to continue running. You do not have to have a restart procedure. Additionally, as long as your backup methodology is brief - a SAN snap or a mirrored drive split - then anyone using Telnet, UniObjects or ODBC not even notice and can continue uninterrupted. Stopping UniData menas terminating those sessions I'd look at what is blocking your dbpause - there is a Tech Tip in the U2 knowledgebase.- search on dbpause - you should find SFMA-13082. Regards JayJay -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of thomas.bo...@firstgroup.com Sent: 26 July 2012 10:34 To: u2-users@listserver.u2ug.org Subject: [U2] dbpause/dbresume or stopud/startud Importance: High U2users, Will I get the same benefits by using stopud and startud as oppose to dbpause and dbresume? The reason for my question is that my server is running unidata 7.2 but 50% of the time cannot resume and stays in dbpause state long after backup? Regards, Thomas Boadu | IS Systems Manager ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dbpause/dbresume or stopud/startud
WELL... in theory UniData has SOME control -- I mean, on Windows, there could be a dbpause 'flag' that tells UniData to close all the open file handles on dbpause and reopen them on dbresume. That would fix the issue! ;-) DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, August 09, 2012 9:38 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud Dbpause doesn't close files. It blocks updates by UniData processes to UniData files. This is via a flag in shared memory that all UniData processes access. We have no control as to how operating systems manage file system files. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 09, 2012 7:35 AM To: 'U2 Users List' Subject: Re: [U2] dbpause/dbresume or stopud/startud Has the issue on Windows been resolved? Our customers reported that UniData maintained 'open files' at a dbpause, which still made the backup difficult with a dbpause. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, August 08, 2012 5:27 PM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud RFS with TP has been available in UniData for 15-20 years too. I understand your issues. I'm just saying you do have the ability in UniData to generate a consistent backup (physical and logical) using dbpause. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 3:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud That's the rub isn't it? We have a few thousand programs written over 30 years, and only a limited staff, and users always want more. Users don't see the need to go back and *fix* code that's working, and/or are not willing to pay you to do it. It's a cost-benefit issue. For a site that doesn't *have* to be 24-7 but can be say 22-7, it's safer to shutdown, then backup. You can't always control every piece of code someone has written. -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 2:18 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud If you have put transaction processing semantics in your code you will have logical consistency with dbpause. For RFS enabled systems, dbpause forces a checkpoint. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud You get an extra benefit from stopud and startud in that your database will be consistent. dbpause does not enforce consistency Personally I would never suggest using dbpause to take a snapshot because of that issue. You're never guarenteed that you have a clean consistent copy. -Original Message- From: John Jenkins u2g...@btinternet.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 6:02 am Subject: Re: [U2] dbpause/dbresume or stopud/startud dbpause and dbresume allow any background processes (e.g. PHANTOM or WebDE (Redback)) to continue running. You do not have to have a restart procedure. Additionally, as long as your backup methodology is brief - a SAN snap or a mirrored drive split - then anyone using Telnet, UniObjects or ODBC not even notice and can continue uninterrupted. Stopping UniData menas terminating those sessions I'd look at what is blocking your dbpause - there is a Tech Tip in the U2 knowledgebase.- search on dbpause - you should find SFMA-13082. Regards JayJay -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of thomas.bo...@firstgroup.com Sent: 26 July 2012 10:34 To: u2-users@listserver.u2ug.org Subject: [U2] dbpause/dbresume or stopud/startud Importance: High U2users, Will I get the same benefits by using stopud and startud as oppose to dbpause and dbresume
Re: [U2] dbpause/dbresume or stopud/startud
It's dependent on the software in use -- we have customers who want to use what they've always used as backup software, and many of the products they have been using will not back up 'open' files. So they end up skipping our primary datafile files!! Yikes!! I'm sure things will improve as the Windows Server versions keep marching forward -- just one of those things -- We have 'what we have seen work' and just suggest that when it happens. Many customers just do a 'stopud' at night to pull backups -- then startud when done -- all part of their backup script. Just too bad the dbpause does not have an option to 'release open files' . I think the problem is the backup software sees any 'open file' as a potential 'in motion' and does not bother with it since there is no way it can be 'consistent'. 'dbpause' handles this 'logically' but Windows still sees and reports the file as 'open'. Again, not a huge deal - just always keeping the ear to the ground if it gets 'better'. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, August 09, 2012 10:06 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud David: I'm sure I don't have a complete understanding of your situation. I use dbpause all the time and run backups using Windows backup utilities. I don't think they have a problem backing up locked files because of the volume Shadow Copy functionality built into Windows (of course the service needs to be running). Our backups have been running on a number of machines over the last seven or eight years. Am I missing something? Bill - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 6:35 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Has the issue on Windows been resolved? Our customers reported that UniData maintained 'open files' at a dbpause, which still made the backup difficult with a dbpause. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, August 08, 2012 5:27 PM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud RFS with TP has been available in UniData for 15-20 years too. I understand your issues. I'm just saying you do have the ability in UniData to generate a consistent backup (physical and logical) using dbpause. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 3:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud That's the rub isn't it? We have a few thousand programs written over 30 years, and only a limited staff, and users always want more. Users don't see the need to go back and *fix* code that's working, and/or are not willing to pay you to do it. It's a cost-benefit issue. For a site that doesn't *have* to be 24-7 but can be say 22-7, it's safer to shutdown, then backup. You can't always control every piece of code someone has written. -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 2:18 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud If you have put transaction processing semantics in your code you will have logical consistency with dbpause. For RFS enabled systems, dbpause forces a checkpoint. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud You get an extra benefit from stopud and startud in that your database will be consistent. dbpause does not enforce consistency Personally I would never suggest using dbpause to take a snapshot because of that issue. You're never guarenteed that you have a clean consistent copy. -Original Message- From: John Jenkins u2g...@btinternet.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 6:02 am Subject: Re: [U2] dbpause/dbresume or stopud/startud dbpause and dbresume allow any background processes (e.g. PHANTOM or WebDE (Redback)) to
Re: [U2] dbpause/dbresume or stopud/startud
Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, August 09, 2012 10:06 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud David: I'm sure I don't have a complete understanding of your situation. I use dbpause all the time and run backups using Windows backup utilities. I don't think they have a problem backing up locked files because of the volume Shadow Copy functionality built into Windows (of course the service needs to be running). Our backups have been running on a number of machines over the last seven or eight years. Am I missing something? Bill - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 6:35 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Has the issue on Windows been resolved? Our customers reported that UniData maintained 'open files' at a dbpause, which still made the backup difficult with a dbpause. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, August 08, 2012 5:27 PM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud RFS with TP has been available in UniData for 15-20 years too. I understand your issues. I'm just saying you do have the ability in UniData to generate a consistent backup (physical and logical) using dbpause. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 3:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud That's the rub isn't it? We have a few thousand programs written over 30 years, and only a limited staff, and users always want more. Users don't see the need to go back and *fix* code that's working, and/or are not willing to pay you to do it. It's a cost-benefit issue. For a site that doesn't *have* to be 24-7 but can be say 22-7, it's safer to shutdown, then backup. You can't always control every piece of code someone has written. -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 2:18 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud If you have put transaction processing semantics in your code you will have logical consistency with dbpause. For RFS enabled systems, dbpause forces a checkpoint. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] dbpause/dbresume or stopud/startud You get an extra benefit from stopud and startud in that your database will be consistent. dbpause does not enforce consistency Personally I would never suggest using dbpause to take a snapshot because of that issue. You're never guarenteed that you have a clean consistent copy. -Original Message- From: John Jenkins u2g...@btinternet.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 8, 2012 6:02 am Subject: Re: [U2] dbpause/dbresume or stopud/startud dbpause and dbresume allow any background processes (e.g. PHANTOM or WebDE (Redback)) to continue running. You do not have to have a restart procedure. Additionally, as long as your backup methodology is brief - a SAN snap or a mirrored drive split - then anyone using Telnet, UniObjects or ODBC not even notice and can continue uninterrupted. Stopping UniData menas terminating those sessions I'd look at what is blocking your dbpause - there is a Tech Tip in the U2 knowledgebase.- search on dbpause - you should find SFMA-13082. Regards JayJay -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of thomas.bo...@firstgroup.com Sent: 26 July 2012 10:34 To: u2-users@listserver.u2ug.org Subject: [U2] dbpause/dbresume or stopud/startud Importance: High U2users, Will I get the same benefits
Re: [U2] dbpause/dbresume or stopud/startud
Oh Geez -- I forgot all open files were managed in private memory! That moves it all the way to the 'never can happen' setup! Thanks Wally for the slap-up-side-of-the-head! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, August 09, 2012 11:28 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud I would not envision having every active UniData process on the system close all of their files when a dbpause command is run. Each process has it's own file handles in its private memory. Processes not actively updating files would need to be signaled that dbpause is requested and then run through their file table and issue close commands at the OS level - then let the dbpause process know they are done. Also - a UniBasic process that issues a WRITE command and detects dbpause is active will just wait until dbresume. If the process were to close their files, it would have to 'jump out' of the WRITE, cycle thru closing all files, and then resume context of the WRITE statement. All of this seems overly intensive and possibly not easily architected. Just providing some background (and my bias). Regards, Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 09, 2012 9:06 AM To: 'U2 Users List' Subject: Re: [U2] dbpause/dbresume or stopud/startud WELL... in theory UniData has SOME control -- I mean, on Windows, there could be a dbpause 'flag' that tells UniData to close all the open file handles on dbpause and reopen them on dbresume. That would fix the issue! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Using XML Mapping in U2
I have a XSD file from a vendor -- mapped it to our data file -- XML is squirting out via XMAP commands in BASIC... Everything seems hunky-dory... But it was not working with the vendor's routines -- just found that the 'xsd' has xsd:sequence at the start of the 'group' - and the mapping generated by the XML/DB Tool does not seem to have noticed that in the XSD. All the mapping is 'sorted' by alpha. How do I get the 'map' to respect the sequence request?? Or is this a 'hand edit' job after the main process is complete? And if I edit the .map file -- will it survive being opened/saved in the XML/DB Tool? Just wondering how prevalent 'sequencing' is -- I've done a dozen maps -- first one where the 'order' of the XML mattered. Thanks - David Wolverton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Multivalue Question
Or since UniData does keep AM pointers, you could do this - then the @SVM become @VM -- and if there is sub-valued data, in some ways this is EASIER than tracking what item 'REMOVE' is handling. SEARCHITEM = RAISE(RECORD31) CNT = DCOUNT(SEARCHITEM,@AM) FOR PTR = 1 TO CNT ELEMENT = SEARCHITEMPTR NEXT PTR -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Thursday, June 07, 2012 11:45 AM To: 'U2 Users List' Subject: Re: [U2] FW: Multivalue Question X = RECORD31 isn't your issue. This is your issue: CNT = DCOUNT(MVDATA, @VM) FOR PTR=1 TO CNT SNGDATA = MVDATA1, PTR ... NEXT PTR Use instead: MORE.FLAG = (MVDATA # ) LOOP WHILE MORE.FLAG DO SNGDATA = REMOVE(MVDATA, MORE.FLAG) ... REPEAT Of course other factors can help your decision on how to store your data. 1. Does it need to be sorted? 2. How do you need to retrieve it? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, June 07, 2012 9:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] FW: Multivalue Question 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 statement: X = RECORD31 I've tried searching the manuals and can't find a good answer. Appreciate your input. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe/Unidata in the Cloud
They do have an ASP license -- it's an annual license fee instead of the 'permanent' fee. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, June 02, 2012 6:04 PM To: U2 Users List Subject: Re: [U2] Universe/Unidata in the Cloud Just so I'm clear... what exactly would be different about such a license? Seems to me the typical licensing terms would work just fine, as long as you have enough seats to handle the traffic. I would, however, be concerned about opening up the telnet port on a cloud architecture. On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.netwrote: Does Rocket license Universe or Unidata for use in the cloud? Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_ba dge Twitter http://www.twitter.com/fusionwareint FaceBook http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integra tion-Corp/115116258510923 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trim trailing attributes off records
Why even do it? The 50 bytes of storage are worth the effort? Usually, I prefer to have attibutes 'all the way' to the full definition of a file -- makes it easier to 'prestore' when needed! It's a pain when you need to 'prestore' data into attribute 200, but the record stops at 185 because those other fields were blank! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, May 10, 2012 5:21 PM To: U2 Users List Subject: Re: [U2] Trim trailing attributes off records I would write a little uniBasic program... to cleanse, purify, and rehydrate... testing it first in a sandbox. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, May 10, 2012 6:13 PM Subject: [U2] Trim trailing attributes off records Given that you have a file with thousands of records, each with dozens of trailing attributes which are empty. How can you pick up the file and drop it back down with all those empties trimmed off? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Training [was RE: Fwd: Command that turns off default command stacker]
You'll have to start at www.rocketsoftware.com and look for U2 -- look under the Resources and under Technical Docs area. Your request is fairly 'wide and deep' - you'll want to look at all the manuals from Rocket to decide what you need. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Monday, May 07, 2012 12:23 PM To: U2 Users List Subject: [U2] Fwd: Command that turns off default command stacker -- Forwarded message -- From: satya satya satyapal...@gmail.com Date: Mon, May 7, 2012 at 10:49 PM Subject: Re: [U2] Command that turns off default command stacker To: U2 Users List u2-users@listserver.u2ug.org Hi to every one, I am heart fully Thank to one and all for sharing important information including with me may i know the some logic of the pick basic 7.3 version can u guys forward some material based on unidata please Thank you, Satya On Mon, May 7, 2012 at 10:22 PM, George Gallen ggal...@wyanokegroup.comwrote: Idk, What happens on the second entry into Finish? If there wasn't a gosub to start with? Will it just error out, or just drop out of the program? I haven't tried it, just my 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 07, 2012 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that turns off default command stacker Finish... return to finish Isn't this an infinite loop? FINISH: RETURN TO FINISH END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *satya king** software professional* -- *satya king** software professional* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: Sb+ Documentation
Same place! Just look for SB+ instead of UniData -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Tuesday, May 08, 2012 11:30 AM To: U2 Users List Subject: [U2] Regarding: Sb+ Documentation -- Forwarded message -- From: satya satya satyapal...@gmail.com Date: Tue, May 8, 2012 at 12:27 PM Subject: Re: [U2] Command that turns off default command stacker To: U2 Users List u2-users@listserver.u2ug.org Hi Symeon, Thank you for providing link for valuable documentation. Were can i get Sb+ Documentation Thank you, Satya On Tue, May 8, 2012 at 11:10 AM, Symeon Breen syme...@gmail.com wrote: Try http://www.rocketsoftware.com/u2 and take a look around. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 08 May 2012 15:16 To: U2 Users List Subject: Re: [U2] Command that turns off default command stacker Hi Symeon Can you give the detail information about the difference between Unidata Universe Thank you, Satya. On Tue, May 8, 2012 at 5:18 PM, Symeon Breen syme...@gmail.com wrote: Hi Satya Firstly please start a new conversation if you want, rather than replying to something on a different topic. As far as information, your unidata installation media should contain a clients cd that has all the documentation and development tools you will need. If you require further training, I am sure the VAR you bought the database from will be only too happy to help. Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 07 May 2012 18:19 To: U2 Users List Subject: Re: [U2] Command that turns off default command stacker Hi to every one, I am heart fully Thank to one and all for sharing important information including with me may i know the some logic of the pick basic 7.3 version can u guys forward some material based on unidata please Thank you, Satya On Mon, May 7, 2012 at 10:22 PM, George Gallen ggal...@wyanokegroup.comwrote: Idk, What happens on the second entry into Finish? If there wasn't a gosub to start with? Will it just error out, or just drop out of the program? I haven't tried it, just my 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 07, 2012 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that turns off default command stacker Finish... return to finish Isn't this an infinite loop? FINISH: RETURN TO FINISH END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4983 - Release Date: 05/07/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *satya king** software professional* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4984 - Release Date: 05/07/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CALLC Question...
And the answer was -- I ASSumed UDT.OPTIONS 88 was on since we have other 'C' code running. Now, if I had executed THAT other c code, and then tested this code, it would have worked! But it was not 'on' from Login -- D'Oh! The weird part is that the C program DOES get called and all variables pass in to it, but it falls over on the 'return' FROM the c program. The documentation says that if UDT.OPTIONS 88 is not set to on the CALLC would 'fail' -- I assumed it meant on the CALL/front side. My bad! So the fix was simple ... Documented here just in case it ever comes up elsewhere -- -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, March 22, 2012 7:07 PM To: 'U2 Users List' Subject: [U2] CALLC Question... I've never had this particular issue, and the debugging for CALLC is ... u... sketchy... I call a function using CALLC -- from the logs, I can tell that everything is perfect on the subroutine -- everything I pass in does what it should. However, on exit the UniData (on Windows, 7.2.2) session ALWAYS DIES. The data is not being changed in the 'passed parameters' - so it should be 'good' and the function is defined Int funcname(parameters) And the Function is set to exit with return 0; The first field in the E pointer is INT, and all the others a CHAR_PTR -- all the parameters are 'inbound' and not changing - and even if they did change, the are CHAR_PTR strings -- should be no big deal... and I can see that the C function is working -- and getting every passed parameter. It is JUST on the 'return 0;' that it fails. Is there a way to 'know' what is causing this? It's just too freaky since everything that 'went out' fine should 'come back' exactly as it left. But I can't think of a way to 'watch' this interface or 'catch' what is going wrong. Thoughts?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CALLC Question...
And just narrowed down -- DEFINITELY - it's something to do with INT return ... I made the process a VOID process... moved the data into the 'passed parameters' - and (dunno why) it is working now... Will spend some more time finding what is causing this little 'mismatch' ... appears that on return, whatever is being returned as an int from the C program, UnIData does not like in it's INT bucket... weird. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, March 22, 2012 7:07 PM To: 'U2 Users List' Subject: [U2] CALLC Question... I've never had this particular issue, and the debugging for CALLC is ... u... sketchy... I call a function using CALLC -- from the logs, I can tell that everything is perfect on the subroutine -- everything I pass in does what it should. However, on exit the UniData (on Windows, 7.2.2) session ALWAYS DIES. The data is not being changed in the 'passed parameters' - so it should be 'good' and the function is defined Int funcname(parameters) And the Function is set to exit with return 0; The first field in the E pointer is INT, and all the others a CHAR_PTR -- all the parameters are 'inbound' and not changing - and even if they did change, the are CHAR_PTR strings -- should be no big deal... and I can see that the C function is working -- and getting every passed parameter. It is JUST on the 'return 0;' that it fails. Is there a way to 'know' what is causing this? It's just too freaky since everything that 'went out' fine should 'come back' exactly as it left. But I can't think of a way to 'watch' this interface or 'catch' what is going wrong. Thoughts?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ screen question
FAR from torture Once you get productive on SB+, you can churn out screens that are consistent and easy to use by end-user clients faster than just about any other product. I'd recommend SB+ to anyone starting a new project. The fact it's moved fairly seamlessly from Character to GUI and soon to .NET without users really having to make ANY changes to their code (that were not to their benefit to do, anyway!) -- Most ANY other product has required a 'refactor' or 're-do' to change even rarely used code screens... Heck, I have seen code file screens that we have not had to touch since 1997 -- how crazy is that?? I just can't picture another product with that kind of 'staying power'. Just my .02 -- but what other product has been in constant use since the 1980s but still looks half-way commercial today?? DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, March 13, 2012 1:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SB+ screen question I like these SB+ questions. It lets the rest of us non sb plusers peer into the torture chamber. -Original Message- From: Lunt, Bruce bl...@shaklee.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Mar 13, 2012 11:14 am Subject: Re: [U2] SB+ screen question Hi Bob (and all other's who have been following this issue): I have found the problem. I did try creating a brand new screen and it was till failing, so I started changing settings, one at a time. I finally hanged the right one: I had the Write Record (Y/N) set to Y. I changed it o N and all is well. It makes sense since I was using a work record and in he Process After Screen Accept slot I called a program to update the main ile from the changes in the work record. So there is no reason to have the creen write the record. Sorry for taking up everyone's bandwidth. :-) Bruce -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob ent: Tuesday, March 13, 2012 9:14 AM o: U2 Users List ubject: Re: [U2] SB+ screen question i Bruce, Make a brand new screen with just the four WORK fields. If the problem ersists in the new screen then the problem is how you're loading the data nd calling the screen. If the problem does not appear in the new screen hen start adding bit by bit, saving and testing in small steps until you ither start seeing the problem again, or you get the screen completely uilt. It's got to be an assumption you're making somewhere along the line hat coming up from behind and biting you. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce ent: Monday, March 12, 2012 5:14 PM o: 'U2 Users List' ubject: Re: [U2] SB+ screen question Interestingly, it still fails after I remove the process from the field. here is nothing in any field definition to control the logic flow. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob ent: Monday, March 12, 2012 3:35 PM o: U2 Users List ubject: Re: [U2] SB+ screen question o theoretically, the one process is what's causing the skipping action of he Earned Date field. To test that theory, take it off completely. This hould let the cursor move between the LI# and Earned Date field, line by ine, each time, regardless if you change any of the values or not. After ou prove that it is, in fact, this process that's causing the issue then 'd say our next step is to look at what's happening inside the process. Is t a PROC or a BP program? Maybe we should take this off-list instead of flooding everyone's inboxes. 'm far from an expert in this but I'm willing to explore possibilities with ou. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce ent: Monday, March 12, 2012 3:20 PM o: 'U2 Users List' ubject: Re: [U2] SB+ screen question Yes they are MV fields. There is nothing on the LI# or Award fields. The equencing is left to right with no extra processing and they are just @WORK ariables. I tried to move the process from Process After entrty slot to the Validation lot and it behaves a little better but it still skips from line 1 to 2 and o on without stopping at the Earned Date field. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob ent: Monday, March 12, 2012 2:15 PM o: U2 Users List ubject: Re: [U2] SB+ screen question o are these MV fields or SV fields? Also, you only have a process-after on he Earned Date? Nothing on the LI# or Award fields? I'm also assuming your equence of prompting in the screen is straight forward, left to right for hese 4 prompts, and you have no extra processes on
Re: [U2] New U2 BDT
You should at least raise a case to Rocket about this -- they fix problems
based on issues from customers --But to my knowledge, they NEVER address
'forum based' issues as they don't have an 'eCase number'! g
Once you've raised the case and gotten an eCase number, post that
information so that other similarly situated can ALSO log a case and refer
to YOUR eCase -- the more people that have the same issue, the sooner and
more likely it gets addressed. People trying, giving up and then skulking
back into darkness has the side effect of leaving the issue broken with
Rocket possibly not aware of the impact of the break-- Unreported issues do
not help raise the quality level...
I've never felt that U2 ignored issues that rendered the product 'unusable'
- those are usually pretty high up the list -- especially a high-profile
tool like BDT -- they've been trumpeting that thing. NOW -- they may
'document' the shortcoming -- but at that point, it becomes the 'omission of
a feature -- not a bug' Heheh
SO, for the good of humanity (at least, the U2 subset of humanity) -- log
this as an issue before you move back to WED -- and everyone else similarly
situated, do the same.
(off box... back to work)
DW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Friday, March 09, 2012 11:59 PM
To: U2 Users List
Subject: Re: [U2] New U2 BDT
Thanks Doug.
Just another product that forces me to dance to their tune rather than
letting me work in the most efficient manner that 20 years of experience has
taught me. Yes, they're much smarter and better than me.
But then, my daughter informs me just how stupid I am on a daily basis! :-)
So, I guess WED is my editor of choice. After all the crap I'm forced to
download and install, one would think simple editing functions would work.
I guess not. [sigh]
Bill
- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/9/2012 6:11 PM
*Subject:* Re: [U2] New U2 BDT
Hi Bill:
BDT uses UOJ for connection which does not support environmental
variables.
You would have to shell out to get them and convert the files
manually. I looked in the manuals and did not find an alternative.
BDT does not have a keep alive. The default for a UOJ session is an hour.
If you do not do anything in that hour you have to reconnect again.
BDT's advance settings do not allow you to change the default even
though UOJ supports changing this parameter.
Regards,
Doug
www.u2logic.com
On Fri, Mar 9, 2012 at 4:14 PM, Bill Haskettwphask...@advantos.net
wrote:
I installed the new U2 BDT (Basic Developer's Toolkit) and attempted
to use it. In the U2 resource tab (after I created a server
connection) one gets a list of accounts. Drilling in one gets a list
of files. These include links ('Q'-files). When I click on one of
the program links I get the message:
Could not get contents of directory
E:\UDAccounts\Dev\@ABO_SYS\**BP on server devserver. Error message:
Unable to find the directory.
Ok, the file link I'm accessing looks like:
7 Dev (0)- AE VOC ABOBP
Top of ABOBP in VOC, 3 lines, 28 characters.
*--: P
001: LD
002: @ABO_SYS\BP
003: @ABO_SYS\D_BP
Bottom.
...so it appears the tool is appending the file path onto the VOC
information. Unfortunately, in UD on Windows we use environment
variables, so the reference @ABO_SYS is a defined environment
variable path. It appears, therefore, that one cannot reference programs
and data from links.
Secondly, there doesn't seem to be any timeout manager (or
keepalive
setting) because my RPC times-out because I've set it to do so.
I guess this alone makes use of this tool problematic for me. Can
anyone inform me that I'm mistaken and simply have to make a few
settings to overcome these basic impediments? I guess I just have to go
back to WED.
:-(
Thanks,
--
Bill Haskett
__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listser
ver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client PE download
Yes -- that's what I was thinking also Steve -- he's right -- but wrong too!! If you have to upgrade your SERVER side to use the new client, it means you have to have BOTH old and new SBClient on your PC if you support both old and new customers. He's 'right' in that 6.x will run in the 'old GUI' mode -- but he's 'wrong' in the way you and I were thinking -- the new SBClient is not 'retro-aware' like all previous versions were, probably due to the new licensing scheme where you ALWAYS get SBClient with SB+ - it's no longer an 'add on' ... DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 11:04 AM To: U2 Users List Subject: Re: [U2] SB Client PE download In response with to David and Steve Yes, you will have to upgrade SB+ to 6 as well. The statement that SBClient v6 does not run with SB+ is wrong; SB+ is still the server portion of SB/XA. Yes, there is a requirement to upgrade more than just your client. My previous statement still stands. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, March 07, 2012 9:51 AM To: U2 Users List Subject: Re: [U2] SB Client PE download Dan - With all due respect, I have to beg to differ with you. I have SBClient 6.03 installed and attempting to connect to anything other than SB/XA gives me an error: SBClient 6.0 or later is compatible only with SB/XA 6.0 or later. If there is a work around to get it to work, I would love to know it so I don't have to have multiple copies of SBClient. Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 8:39 AM To: U2 Users List Subject: Re: [U2] SB Client PE download I can denied. Both the New SB/XA clients and SBClient connect to SB+ on the Server. You should be able to migrate v5 applications to v6 without have to use the new rich clients provided with SB/XA (although, I highly recommend you look into it!) Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: Wednesday, March 07, 2012 9:35 AM To: 'U2 Users List' Subject: Re: [U2] SB Client PE download Thanks Dan, I'll check it out. Colin said that the version in SB/XA only works with SB/XA. Could you please confirm or deny? :) Thanks all! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 11:24 AM To: U2 Users List Subject: Re: [U2] SB Client PE download Hi Laura! SBClient is now included free as part of SB/XA. So you can download the latest SB/XA PE and you will have access to SBClient v6. Just so you know, we recently released SB/XA 6.1.2 and should have the v6.1.2 personal edition out shortly. Regards, Dan McGrath U2 Product Manager | Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: Wednesday, March 07, 2012 8:52 AM To: 'U2 Users List' Subject: [U2] SB Client PE download Hi all! I think that there used to be a download of SBClient PE, but I can't seem to find it now. Seems that most things are for SB/XA. Any ideas? Thanks! Laura ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client PE download
At this point, I think you'd have to license it from Rocket -- you can't get a PE version now. :-( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: Wednesday, March 07, 2012 12:04 PM To: 'U2 Users List' Subject: Re: [U2] SB Client PE download Well, thanks everyone. Hmmm, I was hoping to get the 'old' version because I have no control over the host side version and whether a particular site upgrades or not. At this point, most haven't upgraded. So, anyone have any ideas about where I can get an 'old' version of SB Client? Thanks again! Laura -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, March 07, 2012 12:10 PM To: 'U2 Users List' Subject: Re: [U2] SB Client PE download Yes -- that's what I was thinking also Steve -- he's right -- but wrong too!! If you have to upgrade your SERVER side to use the new client, it means you have to have BOTH old and new SBClient on your PC if you support both old and new customers. He's 'right' in that 6.x will run in the 'old GUI' mode -- but he's 'wrong' in the way you and I were thinking -- the new SBClient is not 'retro-aware' like all previous versions were, probably due to the new licensing scheme where you ALWAYS get SBClient with SB+ - it's no longer an 'add on' ... DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 11:04 AM To: U2 Users List Subject: Re: [U2] SB Client PE download In response with to David and Steve Yes, you will have to upgrade SB+ to 6 as well. The statement that SBClient v6 does not run with SB+ is wrong; SB+ is still the server portion of SB/XA. Yes, there is a requirement to upgrade more than just your client. My previous statement still stands. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, March 07, 2012 9:51 AM To: U2 Users List Subject: Re: [U2] SB Client PE download Dan - With all due respect, I have to beg to differ with you. I have SBClient 6.03 installed and attempting to connect to anything other than SB/XA gives me an error: SBClient 6.0 or later is compatible only with SB/XA 6.0 or later. If there is a work around to get it to work, I would love to know it so I don't have to have multiple copies of SBClient. Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 8:39 AM To: U2 Users List Subject: Re: [U2] SB Client PE download I can denied. Both the New SB/XA clients and SBClient connect to SB+ on the Server. You should be able to migrate v5 applications to v6 without have to use the new rich clients provided with SB/XA (although, I highly recommend you look into it!) Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: Wednesday, March 07, 2012 9:35 AM To: 'U2 Users List' Subject: Re: [U2] SB Client PE download Thanks Dan, I'll check it out. Colin said that the version in SB/XA only works with SB/XA. Could you please confirm or deny? :) Thanks all! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, March 07, 2012 11:24 AM To: U2 Users List Subject: Re: [U2] SB Client PE download Hi Laura! SBClient is now included free as part of SB/XA. So you can download the latest SB/XA PE and you will have access to SBClient v6. Just so you know, we recently released SB/XA 6.1.2 and should have the v6.1.2 personal edition out shortly. Regards, Dan McGrath U2 Product Manager | Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: Wednesday, March 07, 2012 8:52 AM To: 'U2 Users List' Subject: [U2] SB Client PE download Hi all! I think that there used to be a download of SBClient PE, but I can't seem to find it now. Seems that most things are for SB/XA. Any ideas? Thanks! Laura ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
Re: [U2] Hello
In that case, where every file is named FILE in your programs, but you want to make sure FILE is opened against CUSTOMER, I would guess you would do this: IF (FILEINFO(FILE, 0) = 0) THEN OPEN 'CUSTOMER' TO FILE ELSE END END ELSE IF FILEINFO(FILE,17) # CUSTOMER THEN CLOSE FILE OPEN 'CUSTOMER' TO FILE ELSE END END END David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, March 05, 2012 11:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Hello I don't think this will work. In your example John, you need to know the file variable assigned to the file. So IF (FILEINFO(CUSTOMER,0)=0) THEN OPEN CUSTOMER TO CUSTOMER ELSE... But you can't use FILEINFO to check CUSTOMER, only to check CUSTOMER. So you can't tell if a file is opened already and to what file variable. You can only tell if a certain file variable is opened. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Mar 5, 2012 7:56 am Subject: Re: [U2] Hello I assume you have some way of knowing what files you want. Do something like: IF (FILEINFO(yourfilename, 0) = 0) THEN OPEN yourfilename ... ND John -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Dave Laansma ent: Monday, March 05, 2012 10:38 AM o: U2 Users List ubject: Re: [U2] Hello Okay, I've got a pretty simple question ... How do I get a list of all files that are currently OPEN so I know whether I eed to open a given file again? Sincerely, avid Laansma T Manager ubbard Supply Co. irect: 810-342-7143 ffice: 810-234-8681 ax: 810-234-6142 ww.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug ent: Monday, March 05, 2012 10:32 AM o: U2 Users List ubject: [U2] Hello Is the list alive ? Haven't seen anything for a week. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File [AD-FREE]
Thanks Don! This is quite nice -- and well documented! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, February 08, 2012 9:15 PM To: 'U2 Users List' Subject: Re: [U2] Building an Excel File [AD-FREE] [AD] Completely free http://www.southeast-florida.com/ud/UD2EXCEL_CREATE_V2.zip Contains: - Perl Script to create XLS binary (97-2003) - Unidata Programs including a demo program - Limited Documentation Some features - Headers - Columns Headings - Sorting - SubTotaling and Outlining - Justification (Left / Right / Center) - Footers [/AD] This was written by me about 7 years. It's free, so please keep your comments about the horrible code to yourself. =) Additional Software need: PERL 5.8+ - PPM Module Spreadsheet::Write 2.20+ - PPM Module GetOpt::Long 2.3.7+ I will gladly answer questions offline at u2-usersrem...@thissoutheast-florida.com. Regards, Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, February 07, 2012 10:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File Wil, while the OP asked about reading Excel on an iPhone, the title of the thread is Building an Excel File. That prompted suggestions for how to create Excel, including use CSV. Yes, all spreadsheet clients including Excel will open a CSV file. But that led to my assertion that CSV is not Excel and that CSV is not acceptable when people want Excel, though that is a common belief amongst MV developers because most end-users will just take what you give them ... and then they'll quietly start looking for people who will give them what they really want, Excel. This is a digression that you are welcome not to follow. About your statements - I'm intimately familiar with internals of Excel (Office in general), XML, CSV, and related document standards, and I have no idea what kind of middleware you're talking about below. CSV has no information about formatting, it's pure data. It's therefore impossible for any utility to do anything but autosize the columns, and that's trivial. As I said above, if all you're doing is opening the file, sure, that should work, but the result is hardly Excel outside of being text in columns and rows. You can't just simply 'change the Excel files into csv files'. Your statement doesn't survive the first attempt. Excel will warn you that it's going to lose detail if you do that. Again, CSV is not Excel. It doesn't provide borders, colors, images, cell references, merged cells, fonts, type styles, multiple sheets, named sheets, named ranges, file properties, page formatting, print pagination, fixed col/row settings, custom col/row sizes, or data typing. And while you can provide formulas in CSV, you'll lose them if you save Excel as CSV. [AD] And _that_ is the reason I created NebulaXLite, to allow programmers to do all of that from BASIC, on any OS, any DBMS, and with no underlying libraries. It's real workbooks for Excel, Open Office, and Google docs - when everyone else is ready to provide a delimited text file. T From: Wjhonson I think somewhere this jumped the track. No one is saying that CSV is Excel Rather the OP wanted a way to read an Excel file on the Iphone. Can the Iphone natively read Excel files? I know that it can natively read csv files, because we're doing it. It puts the csv file into a neat table with a border, with columns and rows all autosized and pretty with no effort whatsoever. So the solution could be simply to change the Excel files into csv files and voila you have no problem anymore for the Iphone. This doesn't address the issue of whether existing Excel files, or Excel files you receive from others can be handled. It only addresses the issue of reading Tables (of some kind) on the Iphone. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File [AD]
Honestly -- back to my prior statement -- why is Rocket just not licensing the logic and shipping it like DataVu?? I suspect it would be used WAY more!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Thursday, February 09, 2012 3:16 PM To: U2 Users List Subject: Re: [U2] Building an Excel File [AD] Sorry to come in a bit late here. I have worked through a couple of versions of NebulaXLite and must say I am very impressed, with both the astounding results and the thoughtful improvements Tony has made to this breakthrough tool. If you have a requirement to clone an existing spreadsheet, but with data from U2, you need to get this tool. It will pay for itself day one and spare you a lot of grunt work. On Mon, Feb 6, 2012 at 2:56 PM, Tony Gravagno 3xk547...@sneakemail.comwrote: [AD] NebulaXLite creates rich XML workbooks (multiple sheets) which can be opened by Google Docs and Open Office, in addition of course to Excel. The XML isn't Excel-specific, it conforms to open standards, and Excel happens to open those files as well. remove.pleaseNebula-RnD.com/products/xlite.htm When I got my Android, I didn't look for Excel for Android, I just viewed docs as Google spreadsheets. Your BlackBerry and iPhone users would probably do well to do the same. NebulaXLite is free for all developers and only a one-time $200 purchase price for end-users with completely free support. Many people here use NebulaXLite over Universe and Unidata, and I hope a few of our clients will comment on their experience. Some months ago I also announced NebulaXPlus which exports XLite documents to a local Windows box to convert to a real Excel ..xls file. This allows even more complex documents to be created - yes, without user intervention. NebulaXPlus is now in beta. Thanks for you time. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about From: Israel, John R. We are running UniData on a UNIX platform. We create tab-delimited txt files (and tab delimited txt files with xls extensions) all the time that users open with Excel. Many of these jobs are run in the middle of the night or in a trigger program. In all cases, there is no direct user interaction building these files. We also have some XML files that are coded so that Excel opens them with formatting, colors, filters, etc. Unfortunately, our BB users and iPhone users can not open these files up in a meaningful way. Is there a way to build a TRUE Excel file without any user intervention from UniData or UNIX? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File
Can you license this logic to Rocket? Seems like getting the 'check box' for the database would serve them well, and would be a drop in the bucket for them to throw dollars at you that would be FAR more than you would likely get licensing it one-off yourself. Just a thought. Rocket should be 'buying' this kind of stuff and putting it under the hood. Horizontal stuff it just seems that no one ever 'seeks out' - we all end up building it. Which is craziness and hurts Rocket more than anyone! Just my thought on a late afternoon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, February 07, 2012 3:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File From: Bob Rasmussen It would be conceivable, though not necessarily profitable, to have an Excel add-in that would pull data out of Pick via a network-based object call. Conceivable? How about Done. Phil Gerber has referred people to NebulaXChange as the replacement for CrowFlite. http://nebula-rnd.com/blog/tech/2009/03/xchange-intro1.html (Not bothering with nospam anymore...) If nothing else, just look at the screenshots. That blog links back to another 2007 blog which has code showing how to connect from Excel to any MV platform via a web service. The takeaway here is that anyone here can have a solution for Excel-to-U2 today, for free. (NebulaXChange for U2 can connect with UO.NET, mv.NET, telnet, or SSH.) Not necessarily profitable? Righteo! Not in this market. Once again, people will go for years longing for something that already exists, the underlying theme being it must be free. The mentality of free (not related to open source) or at least the insistence that for some reason Pick tools need to be cheap, has seriously done a lot to kill innovation. It has destroyed the motivation for developers like me to create solutions which address common needs. NebulaXChange never went production because of kickback on a couple hundred dollar price tag. I might rethink that. It might seem weird to say this, but XChange is software that just deserves to be used. Frustration with this market obvious? :) T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Import XML data [not-secure]
I wonder how much longer those IBM articles will exist... Are those 'moved' to the Rocket DevZone? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, January 27, 2012 8:36 AM To: U2 Users List Subject: Re: [U2] UniVerse Import XML data [not-secure] I'll admit to my xml ignorance. However, as to not leave you hanging, there were a few articles on IBM developer works about this stuff in addition to the standard U2 manuals. https://www.ibm.com/developerworks/wikis/display/u2tech/XML+for+IBM+U2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] A Thursday Quandry...
UniData. I have an external subroutine we call thousands of times within a program (does G/L Account assembly from all the 'pieces' of data). Our logic was that making it an 'included' subroutine within the program would make it perform faster, and I think that was a good call. Now it sort of bites during debug, as UniData does not 'explode' the code at compile, so that if you're doing interactive debugging, you get the 'same line number' each time as you step through that included code - so there's no way to know where it's at in the subroutine (and therefore, no good clue how many lines you can do Enn to step through.) It's not often that I need this, but I'm doing it now and am not believing there is not a 'better way'... Is there a way to make an Included Subroutine 'insert itself' at compile time - as if that code were REALLY in the program?? How have others dealt with this? David W. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniVerse on Windows
I have a customer who is setting up a brand new user in UV on Windows -- this is a running machine, has been for years -- but the first new employee is a long while. This new user, when they get the Telnet log on and put in their user name/password is NOT being asked for the path to account they want to go into. They are being 'dumped' into the UV account. And then they cannot 'log to' anywhere else. The customer swears this new user is built just like all others -- a Domain User with 'User Rights' on the UV Server. Rocket tech support has said the is fix is that users HAVE to have Admin rights in order to be prompted for the 'UniVerse account' Something seems wrong with that answer. I mean, I am guessing it will fix the issue, but I hate passing out Admin rights when the real answer is probably something else. So -- What else might be the cause here?? (I am WAY more UD than UV, so any idea will likely be something I have NOT tried yet!) Thanks - David W. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects and Record Locking
Post back the cause and fix if you can - I know I'd be interested! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, January 09, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] Uniobjects and Record Locking Done! :-) Thanks, Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/8/2012 7:17 PM *Subject:* Re: [U2] Uniobjects and Record Locking Just open a support case and email the test case... thanks Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, January 08, 2012 7:46 PM To: U2 Users List Subject: Re: [U2] Uniobjects and Record Locking Wally: I can even re-create this (amazing isn't it?). :-) I'm here all day tomorrow after 10:30am PST. I can call you, if you'd like. Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users Listu2-users@listserver.u2ug.org *Date:* 1/8/2012 1:06 PM *Subject:* Re: [U2] Uniobjects and Record Locking UniData record locks are tied to a file variable. So if a file is opened in named common, a lock could persist after a subroutine exits. Of course, it would show up in LIST.READU... The behavior Bill describes doesn't make sense to me. Would love to see a small test case demonstrating what he describes. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, January 08, 2012 12:48 PM To: U2 Users List Subject: Re: [U2] Uniobjects and Record Locking John: As a note, we've been programming in web paradigms for many years, and we mostly understand the difference between non-persistent web connections and persistent telnet connections. None of our activities does anything except gather data and submit to UO for almost instantaneous results, whereupon the results is returned to the web. These are all momentary connections and no LOCKING occurs except within the context of a momentary update. So, the user calls the web server, a UO connection is either reused or created to connect to the dbms, a subroutine is run and ends (which, of course, should release all locks within the subroutine (unless doing something like a WRITEU which we never do - we're old-school in that regard), the the web call is closed and data returned by the UO connection is returned to the user in another web page, and the web connection is closed. I think what's important to note is a LIST.READU ALL shows the lock when AE has the record edited and the BASIC LOCKED clause is taken on a momentary UO connection. When AE exits the record LIST.READU ALL no longer shows any record locks but the BASIC LOCKED clause on a subsequent UO connection is still taken as though the record is locked only if the UO connection where the lock occured is reused. If a new UO connection is used (due to timeouts or manually killing the original UO connection) the BASIC LOCKED clause is __NOT__ taken. Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData Update Triggers
During an Update Trigger, I'd like to alter the 'Current Record' as passed into the trigger so the 'effective written' record is different with changes I want to make, but it appears the change is not allowed. I have some logic that would be easy to add into a trigger to modify a few fields that otherwise I get to hunt through every relevant 'write' in BASIC -- worse, I will miss the ability to do this field update if the records is AE edited. Is just a 'too bad, so sad' thing? I am guessing I could write a whole bunch of 'phantom' that monitors a log record, and have the trigger record the needed data into the 'log' and have the phantom 'update' the record in a second pass, but that seemed extreme, and possibly a problem if the record received several sequential changes. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Update Triggers
Ah!! By 'not allowed' I meant that it was not using my record change -- but I was using EXECSTAT = 1 as well! I missed the EXECSTAT = 2 ... I only had 0 (fail) and 1 (write) as valid choices -- I missed the 2. Let me try my code with a 2 and see -- that's likely my whole issue ... Thanks Jeff! -Original Message- From: Jeff Butera [mailto:jbut...@hampshire.edu] Sent: Sunday, October 09, 2011 10:41 PM To: u2-users@listserver.u2ug.org; dwolv...@flash.net Subject: Re: [U2] UniData Update Triggers On 10/09/2011 08:46 PM, David Wolverton wrote: During an Update Trigger, I'd like to alter the 'Current Record' as passed into the trigger so the 'effective written' record is different with changes I want to make, but it appears the change is not allowed. I'm not sure I understand not allowed - are you getting an errors? I have some logic that would be easy to add into a trigger to modify a few fields that otherwise I get to hunt through every relevant 'write' in BASIC -- worse, I will miss the ability to do this field update if the records is AE edited. That's the whole point of EXECSTAT: 0 = don't write the record 1 = write record as passed in, ignoring any changes made in trigger 2 = write record as edited by trigger This example will overwrite field 1: SUBROUTINE MY_TRIGGER_SUB(X.EXECSTAT,X.DICT,X.FILE,X.ID,X.REC) X.EXECSTAT=2 X.REC1 = 'Happily overwriting fields in this record' RETURN I use this for stored computed columns and other things that sound similar to what you want. Here's a real example that sets a slew of default values anytime a record is written: SUBROUTINE H08.T.H08.JA.SEARCH(X.EXECSTAT,X.DICT,X.FILE,X.ID,X.REC) X.EXECSTAT=2 IF X.DICT = '' THEN * record changed who/date/time X.REC5 =UPCASE(@LOGNAME) X.REC3 =DATE() X.REC4 =TIME() IF X.REC17 = THEN * record added who/date/time X.REC17 =X.REC5 X.REC1 =X.REC3 X.REC2 =X.REC4 END * Default values... * Next Question=1 IF X.REC25 = '' THEN X.REC25 = 1 END * Num apps IF X.REC46 = '' THEN X.REC46 = 0 END * Status=Search Creation IF X.REC10 = '' THEN X.REC10 = 'SC' X.REC11 = DATE() END * Accept Resumes=NO IF X.REC20 = '' THEN X.REC20 = 'N' END * Cull method=view all apps IF X.REC23 = '' THEN X.REC23 = 'A' END END RETURN -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FAST (File Analysis and Sizing Tool)
What about this... Could you just store a MultiValue of the 'approx size' of each record? Then you would 'add one' to the correct MV as you process the record counts. At the end of the run, you'd have a list where you could essentially start a loop to 'work to the center' So you'd have a MV of buckets as 512]1024]2048]4096]8192]16384]32768[etc in whatever break was most reasonable -- perhaps it would be 100]200]300]400]500]600]700 etc... Each record would '+1' to the correct size bucket - so a record that is 310 would drop into the '400' bucket (300, =400) or one that is 4000 would be in 4096 (2048 =4096) -- the number and size for the buckets would be what would be 'meaningful' to the process. At the end, you'd have an array of counts based on the 'size' MV it dropped into that would resemble 20]400]22600]52000]16000]250]1]]]1 Or the like... from there, you could get to 'median' pretty quickly I think with one pass at it. And while not the EXACT a byte count (meaning the 52000 'bucket' clearly has the 'median' which would be somewhere between 300 and 400 bytes or 2048 to 4096 - depending on how you did your 'buckets'. This would likely be 'close enough' for the 'horseshoes' game of file sizing as long as you did the buckets in narrow-ish/meaningful breaks. (And maybe you'd do a DIM'd Array over MV to make incrementing the counters faster -- but you get the idea.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald Sent: Thursday, October 06, 2011 12:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FAST (File Analysis and Sizing Tool) Thanks all for weighing in on FAST and file sizing. Charles, I AM listening and I hear your interesting suggestions about trending. Most of the improvements to FAST over the years have come directly from user experiences and requests. No promises but we will brainstorm this with a view to seeing how it might fit. Of course, it really isn't as easy as saying Sure, we'll put that right into the next release! I can see some issues arising -- once trend analysis is turned on, does the naive user just allow FAST to resize based on the trends? If so, how do we account for false trends; for instance, if the trending period is short and encompasses a recent purge the analysis might indicate a shrinking file where a longer analysis period might reveal exponential growth with infrequent purges. Anyway, my point is that we would have to try to identify the gotchas and make the analysis intelligent and controllable. During our brainstorming I'd like to contact you and pick your brain a bit. I'd also like to pose a technical question. As Cameron, Tom and others pointed out, the standard U2 tools aren't the best; they can recommend bad types and are thrown off by file aberrations. (By the way, Doug, this is why Mr. XLrG8r's bullet point 6. I run analysis with the U2 database native commands. really is a liability and not a feature.) Anyway, file analysis gets interesting when there are abnormally large records or vastly non-homogeneous records in a file. Sizing for the average is sort of like worseification in investing. We are looking at ways of being smarter in these situations. There are a couple measures that might be helpful - skewness and kurtosis, both of which measure the degree and direction to which a population deviates from a normal distribution. A simple measure of skewness can be derived from comparisons of the mean (the average) and median (the middle value). This brings up my question - What is the best way to find the median? Say that you have an arbitrary number of records; how do you find the median record size? The easy answer is to sort the size values and then pick the middle. However, suppose you have a billion records - storing the billion size values provides some challenges! Is there a way to find median with a single pass and without having to provide storage for ALL the values? I'd be interested in anyone's ideals about finding median and about measures of skewness in general. Thanks! Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com j...@fitzlong.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniVerse 10.3 with Domain Controller Failure
The domain controller failed. The Backup took over. Universe 10.3 appears to hang on login - just dead. UniData on the same site (on another server) hangs for a moment and 'complains', but completes the login and runs correctly - so it appears that it 'finds' the backup controller. What's the story with UniVerse? One other piece: There are TWO BDCs, the UniVerse box appears to look at one (as do other machines) while the UniData box looks at another (as do other machines there) -- UniData and UniVerse are the ONLY applications throwing issues right now -- all other items (SQL Server, Great Plains, etc) seem to be humming along. Thoughts appreciated! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse 10.3 with Domain Controller Failure
If I log into the actual server after logging in as a LOCAL user, the UV Shell starts up. If I log into the actual server after logging in as a DOMAIN user, the UV Shell just hangs. This is after MANY reboots, so I know the UniVerse services are cleanly restarted. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, September 15, 2011 11:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Local login script on Universe is doing something funky. Try to connect using the Universe Shell application directly on the UV server in the computer room, not locally from your PC -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Sep 15, 2011 9:51 am Subject: [U2] UniVerse 10.3 with Domain Controller Failure The domain controller failed. The Backup took over. Universe 10.3 appears to hang on login - just dead. UniData on the same site (on another server) hangs for a moment and complains', but completes the login and runs correctly - so it appears that t 'finds' the backup controller. What's the story with UniVerse? One other piece: There are TWO BDCs, the UniVerse box appears to look at ne (as do other machines) while the UniData box looks at another (as do ther machines there) -- UniData and UniVerse are the ONLY applications hrowing issues right now -- all other items (SQL Server, Great Plains, etc) eem to be humming along. Thoughts appreciated! __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse 10.3 with Domain Controller Failure
See, I would suspect something like this as well, but the %LOGONSERVER% is 'up', and Great Plains running on the same server as the UniVerse server is working A-OK. (I hate the fact they have 3 different databases on this machine, but it is illustrative that it's 'only UniVerse' as both the Great Plains and the Oracle databases are running without a glitch since the failover, so I'm looking at what I can do to 'fix' Universe.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Thursday, September 15, 2011 12:11 PM To: U2 Users List Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure This is a wild guess... So my disclaimer is, Try at your own risk Part of my hatred for Windows Active Directory resides with this very issue, but, I digress... I have seen servers and workstations not talk to the backup domain controller before, especially after a primary domain controller failure. SO, IF, the Primary Domain Controller has failed... and the Backup is now controlling things, and the primary is still not up and running... You might be able to do the following to fix your login issue: 1) Remove the UV server from the domain completely 2) Reboot 3) Re-join the UV server to the domain 4) Reboot 5) Check whatever UV uses (which I have no knowledge of) to login to the domain and make sure its not a hardcoded hostname pointer kind of thing to the domain controller that is not online. Like I said. A wild guess, but, I've seen it work with other servers and workstations when a Primary Domain Controller would fail and the backup would pick up. Don't ask me why... I'm not a MCSE guy. On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton dwolv...@flash.net wrote: If I log into the actual server after logging in as a LOCAL user, the UV Shell starts up. If I log into the actual server after logging in as a DOMAIN user, the UV Shell just hangs. This is after MANY reboots, so I know the UniVerse services are cleanly restarted. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, September 15, 2011 11:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Local login script on Universe is doing something funky. Try to connect using the Universe Shell application directly on the UV server in the computer room, not locally from your PC -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Sep 15, 2011 9:51 am Subject: [U2] UniVerse 10.3 with Domain Controller Failure The domain controller failed. The Backup took over. Universe 10.3 appears to hang on login - just dead. UniData on the same site (on another server) hangs for a moment and complains', but completes the login and runs correctly - so it appears that t 'finds' the backup controller. What's the story with UniVerse? One other piece: There are TWO BDCs, the UniVerse box appears to look at ne (as do other machines) while the UniData box looks at another (as do ther machines there) -- UniData and UniVerse are the ONLY applications hrowing issues right now -- all other items (SQL Server, Great Plains, etc) eem to be humming along. Thoughts appreciated! __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse 10.3 with Domain Controller Failure
Correct -- the screen opens and what you would normally see next is the UniVerse 'banner' - the cursor just blinks... Nothing. But the 'shell screen' is 'open' and 'trying' to connect. And for DNS -- if the other applications were 'dead' as well on the machine, again, I'd suspect something 'outside' -- But it's sounding more like a Rocket support call than anything, so may have to ask the vendor to see what they say. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, September 15, 2011 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure What exactly do you mean by the statement that uvshell hangs Do you mean it opens the uvshell application but will not give you any message at all? so its just a blank gray screen? Or do you mean it won't even open the application window? If you can run uvshell as a local user, can you LISTU to see if the default background processes are running? I mean the uvdlock, the phantom processer, the console, etc -Original Message- From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 15, 2011 10:19 am Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Perhaps the Domain Controller that failed also had DNS running on it? Perhaps its a DNS issue... you say one Unidata server takes a while and inally logs in... Another shot in the dark. On Thu, Sep 15, 2011 at 1:15 PM, David Wolverton dwolv...@flash.net wrote: See, I would suspect something like this as well, but the %LOGONSERVER% is 'up', and Great Plains running on the same server as the UniVerse server is working A-OK. (I hate the fact they have 3 different databases on this machine, but it is illustrative that it's 'only UniVerse' as both the Great Plains and the Oracle databases are running without a glitch since the failover, so I'm looking at what I can do to 'fix' Universe.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Thursday, September 15, 2011 12:11 PM To: U2 Users List Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure This is a wild guess... So my disclaimer is, Try at your own risk Part of my hatred for Windows Active Directory resides with this very issue, but, I digress... I have seen servers and workstations not talk to the backup domain controller before, especially after a primary domain controller failure. SO, IF, the Primary Domain Controller has failed... and the Backup is now controlling things, and the primary is still not up and running... You might be able to do the following to fix your login issue: 1) Remove the UV server from the domain completely 2) Reboot 3) Re-join the UV server to the domain 4) Reboot 5) Check whatever UV uses (which I have no knowledge of) to login to the domain and make sure its not a hardcoded hostname pointer kind of thing to the domain controller that is not online. Like I said. A wild guess, but, I've seen it work with other servers and workstations when a Primary Domain Controller would fail and the backup would pick up. Don't ask me why... I'm not a MCSE guy. On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton dwolv...@flash.net wrote: If I log into the actual server after logging in as a LOCAL user, the UV Shell starts up. If I log into the actual server after logging in as a DOMAIN user, the UV Shell just hangs. This is after MANY reboots, so I know the UniVerse services are cleanly restarted. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, September 15, 2011 11:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Local login script on Universe is doing something funky. Try to connect using the Universe Shell application directly on the UV server in the computer room, not locally from your PC -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Sep 15, 2011 9:51 am Subject: [U2] UniVerse 10.3 with Domain Controller Failure The domain controller failed. The Backup took over. Universe 10.3 appears to hang on login - just dead. UniData on the same site (on another server) hangs for a moment and complains', but completes the login and runs correctly - so it appears that t 'finds' the backup controller. What's the story with UniVerse? One other piece: There are TWO BDCs, the UniVerse box appears to look at ne (as do other machines) while the UniData box looks at another (as do ther machines there) -- UniData and UniVerse are the ONLY applications hrowing issues
Re: [U2] UniVerse 10.3 with Domain Controller Failure
Yes - I guess that is the case -- they are not on 11.1, and just got word that's where it's got fixed. The only choice under this release per the case is to cease the domain controller. I think they meant 'seize' the controller. [And I just notices that 'seize' violates the I before E rule, by the way!] So the client is going to do the 'seize' tomorrow. And then we'll load 11.1 when it's more convenient! Thanks for the thoughts here - at least I know we did everything we could and that it was actually a Rocket issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, September 15, 2011 3:30 PM To: U2 Users List Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure And I meant to add... If the PDC emulator was on the other DC (which I would assume it is) and you can't restore it you will have to seize the fsmo role. It's pretty simple, but it's also a last resort type of a deal. Instructions are here: http://technet.microsoft.com/en-us/library/cc785114%28WS.10%29.aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, September 15, 2011 3:21 PM To: U2 Users List Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Does this version of Universe pre-date the PDC emulator fix? If not you will not be able to login to UniVerse if the database cannot access the server with the PDC Emulator FSMO role. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, September 15, 2011 1:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure If you can get to TCL as a local user and cannot as a domain user, then I would suggest a permissions setting is wrong. Your domain user can't open some file that Universe is trying to open. For example uvtemp or something, who knows. The local user would most likely own all the files. But go to TCL and make sure what users are logged in. For example nine hundred sessions trying to lock the uv.accounts file. -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Sep 15, 2011 11:03 am Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure Correct -- the screen opens and what you would normally see next is the niVerse 'banner' - the cursor just blinks... Nothing. But the 'shell screen' is 'open' and 'trying' to connect. And for DNS -- if the other applications were 'dead' as well on the machine, gain, I'd suspect something 'outside' -- But it's sounding more like a ocket support call than anything, so may have to ask the vendor to see what hey say. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Thursday, September 15, 2011 12:29 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure hat exactly do you mean by the statement that uvshell hangs o you mean it opens the uvshell application but will not give you any essage at all? so its just a blank gray screen? r do you mean it won't even open the application window? If you can run uvshell as a local user, can you LISTU to see if the default ackground processes are running? mean the uvdlock, the phantom processer, the console, etc Original Message- rom: John Thompson jthompson...@gmail.com o: U2 Users List u2-users@listserver.u2ug.org ent: Thu, Sep 15, 2011 10:19 am ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure erhaps the Domain Controller that failed also had DNS running on it? erhaps its a DNS issue... you say one Unidata server takes a while and nally logs in... nother shot in the dark. n Thu, Sep 15, 2011 at 1:15 PM, David Wolverton dwolv...@flash.net wrote: See, I would suspect something like this as well, but the %LOGONSERVER% is 'up', and Great Plains running on the same server as the UniVerse server is working A-OK. (I hate the fact they have 3 different databases on this machine, but it is illustrative that it's 'only UniVerse' as both the Great Plains and the Oracle databases are running without a glitch since the failover, so I'm looking at what I can do to 'fix' Universe.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Thursday, September 15, 2011 12:11 PM To: U2 Users List Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure This is a wild guess... So my disclaimer is, Try at your own risk Part of my hatred for Windows Active Directory resides with this very issue, but, I digress... I have seen servers and workstations not talk to the backup domain controller before
Re: [U2] DataVu Query [ad]
I think this was another Rocket acquisition that was 're-engineered' so it could talk to U2. Hence the reason it's using SQL. I could be wrong... but I don't think I am! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 1:42 PM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Bill, I think you are correct. I was hoping and praying for straight UoJ connection to data, not shoehorned SQL. Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record Locks - How long should they last for? (Opinion)
WELL - optimistic lock testing is WAY more than 2 lines of code! You have to have a 'structure' to 'store' the original data image in, then on the write, check that image against a current version (that you DID hard lock) and if the same, write, if not fail. If you can do that in 2 lines of code, you're a better programmer than I am! LOL! But Tony's point was that you either have to 'code' for each kind of write to have one routine work from both standard locks or optimistic locks. That would add dozens of lines of code to each routine. Perhaps a more interesting example might be -- what if your business model would make it more efficient to move one of the files 'off world' to a SQL store on another machine?? If you 'called' a subroutine to do your reads and writes, those could actually handle that 'File A is now an SQL file while File B is still UniData' and handle that 'migration issue' with no changes to any business logic. When your program made a 'call' to read Key XYZ from File A, at one time it was a 'direct read' while now it's SQL query for that data to another machine -- the only program that changes is your 'READ' and 'WRITE' program being able to intercept and mangle the data such that the 'business logic' program just gets the MV record structure it was asking to retrieve. Just sort of a nifty idea. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, July 14, 2011 7:28 AM To: 'U2 Users List' Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) Because it is just 2 lines of code anyway so why bother -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 13 July 2011 23:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) After all of these years, why o why haven't the MV DBMS vendors created a READUO mechanism which allows us to optimistically lock records in exactly the way that George, Rex, and a hundred other app developers have indicated over the last 15 years? Design tip: For all new development, abstract your file IO and all OS access into separate functions, Includes, and/or subroutines, away from the business code. This way you can change your datastore interaction without messing with your application logic, and you can re-use the routines for a lot of different work. The application needs to be aware of whether you're moving forward with a pessimistic or optimistic lock, but your app code shouldn't have to manage those mechanisms. T From: George Gallen ... instead of the checksum token method, I was going to write the record to a holding file with an ID that was a combination of file/record/transaction token And do a comparison using the saved item to see if record changed, but only if the record lock had expired - I still wanted to keep the locks since the system could be used by local users as well, which is easier using the READU locally to test for locking. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1516/3762 - Release Date: 07/13/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uv v ud
SO... what does Rocket say when you ask for Support on UO? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, May 04, 2011 1:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv v ud Since I'm mentioned here... As Bill's vendor and support provider for mv.NET I feel bad when underlying technologies fail. Metaphorically speaking, the auto mechanic can't fix potholes, only help to improve the shock absorbers to make the bumps less painful. As Bill's friend, we frequently discuss the issues of multi-tier development and I get as frustrated as he does. With UO.NET, exceptions are sometimes thrown which log errors with no detail. The exception is not passed up to the client. The net result is that something has failed, we don't know what it was, we don't have any way to control it, and we don't know if it has adversely affected our transaction processing. It looks like everything is OK, except for these mysterious logs. Symeon posted some great info here many months ago about setting tracking info for UO.NET in web.config. I passed that to Bill a while back but haven't heard back. In line with Bill's comments, error tracking like this is just another tier of time consuming aggravation. The burden of debugging issues like this is shared amongst many people, including those who don't know and should not have to know about the underlying technologies. When UO/UO.NET works, it's great. But frankly, over the long term, UO/UO.NET has been a chronic source of low-level pain, and it's Extremely difficult to get anyone to help diagnose or remedy related issues. Developers and end-users are left to scratch their heads for months wondering how to diagnose the black box. It would really be nice for Rocket to step up with a UO Trauma Center to quickly diagnose and resolve chronic, nagging communications issues. As Bill's mv.NET vendor I can't continue to spend hours trying to debug UO potholes - I have no code and can't interpret logs. Bill shouldn't have to do that either. The people with the code should be supporting that component. Regards, T From: Bill Haskett An interesting side note is debugging. When technologists suggest we use a black-box technology approach, all this does is create massive investigation problems in a layered environment; which most are today. For not-easily-reproducible problems, logging exacerbates the problem because now where we're looking for a needle problem located somewhere in these large haystack logs. :-) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
I would agree -- if there is an active select list, then you would get some seriously unexpected behavior doing another select unless you 'pushed' that new select to a different 'List ID' than the default '0' list -- just ensure it's a ListID that you KNOW would never be used anywhere else. Back to the 'ideal' - the index is the 'best answer' as it will be faster AND it would avoid the entire 'select' in the first place. The downside of the index may be the in the use of this code -- if every records ends up with a status of DONE, you probably would hate to index that 'status' field since it would be a VERY large index for the DONE set of keys... DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, April 21, 2011 10:10 AM To: 'U2 Users List' Subject: Re: [U2] Very Weird Trigger Behavior Just a thought would be to change your select to use the non-default active select list. For example, instead of: CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:'' try CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:' TO 2' If you are running in PICK flavor, change the SELECT to select to force it to run in native UniData flavor. I am not sure how this will work with the SYSTEM(11) command, but even if that does not work, there are other ways to test if anything was returned. Note that if you DO need to loop through this, you may need to change code to read from active select 2 (not the default). You might also want to do a CLEARSELECT (or CLEARSELECT 2). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Thursday, April 21, 2011 11:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Weird Trigger Behavior Hi, all. I'm new to this forum, but have been programming multivalue database apps for years. I ran across something here that really has me puzzled. I wonder if anyone has seen something like this and might be able to shed a bit of light as to what's happening. I'm running Unidata 6.0 on hpux. I have a trigger set up to run before deletions take place on a file called CODE_DEFS. The file just contains code numbers (ID) and their meaning/description. There's another file, TRADES, that contains a field, TRADE_CODE, that should have a many-to-one relationship with IDs in CODE_DEFS. That is, the content of TRADE_CODE should match a record ID in CODE_DEFS. Before a record is deleted from CODE_DEFS, I want to ensure its ID does not appear in any record in TRADES. That's where the trigger comes in. The trigger is passed the ID of the record to be deleted. This is done via parameter variable CODE_DEF_ID. The trigger program, CHECK_TRADES, has the following logic: --- . . . CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:'' EXECUTE CMD IF SYSTEM(11) THEN * there's a select list, so the code is still in use in TRADES. * Return 0 in EXECUTE_STATUS to disallow the deletion. EXECUTE_STATUS=0 END . . . --- The problem is when I try to delete a record from CODE_DEFS, using a TCL DELETE command, I get the following error message. '' is not a record in TRADES Of course, there are two problems with the error message. Not only has it lost the ID of the record to be deleted, it has also lost the name of the file. Notice that it is looking in the TRADES file instead of CODE_DEFS. I believe what's happening is when it EXECUTEs the CMD, the internal variables for ID and filename are being reset. To support this hunch, I changed the trigger routine so that CMD=DATE, causing it to execute the TCL DATE command. Here's the error message from that: '' is not a record in CODE_DEFS And if I make CMD=COUNT CUST, which makes the trigger deal with a completely unrelated file, I get this error message: '' is not a record in @7X% So, it appears that any EXECUTE is going to lose the ID, and if CMD deals with any file, the filename is reset also. I really need to have it perform the intended check before deletion. Any ideas? -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31450305.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Not knowing when the trigger were being called, even the COUNT would be 'dinged' if there is an active SELECT list. That would be a problem! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Thursday, April 21, 2011 11:57 AM To: U2 Users List Subject: Re: [U2] Very Weird Trigger Behavior On 4/21/2011 11:03 AM, jonathanm wrote: Hi, all. I'm new to this forum, but have been programming multivalue database snip I really need to have it perform the intended check before deletion. Any ideas? Your execute of the SELECT will potentially result in an active select list that doesn't appear to be intentionally used. Since you don't want the ids, you just want to know if there are any, I'd do something like: CMD - 'COUNT TRADES WITH TRADE_CODE = ': CODE_DEF_ID: '' EXECUTE CMD CAPTURING CMD.CAP RETURNING CNT.SELECTED IF (CNT.SELECTED GT 0) THEN EXECUTE_STATUS = 0 END ELSE EXECUTE_STATUS = END I also don't know what you're doing with EXECUTE_STATUS, but if it's not set by the caller, it needs to be set here, otherwise its value is undetermined, (and in most cases will be set to null). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Leaving Locks in UOJ
I'm thinking that it's got to be a bug SOMEWHERE if Universe Unix and Universe Windows behave differently. Sounds like a case for Rocket! ... Doug said... We noticed a problem with locks being left when we delete our temporary programs using UniObjects for Java on the new code we are using for XLr8Editor continuous compile. We used the standard setDefaultReleaseStrategy(). This should release the record when it was written or deleted, but some of our users found they were not being released. We are using the current version of UOJ and this happens in Unidata Windows, Universe Unix and not Universe Windows. We have since coded around the problem, of course. However, my question is this: Are we looking a bug or do we not understand the strategy? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-Threading Universe Socket traffic
And remember, at the more recent UniData/UniVerse, this use of sockets will require a 'real' seat license -- it will make a 'phantom' (free) into an iPhantom (licensed) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, March 07, 2011 3:17 AM To: 'U2 Users List' Subject: Re: [U2] Multi-Threading Universe Socket traffic Ok the python solution mentioned is one way - however this multi threading you requiree is not a multi threading requirement - you are consuming a socket service, and not accepting connections, - we do this kind of thing all the time using phantoms. Lets say your batch of transactions is in a file, as you process each one set a flag saying it is done, or delete the record or something, then yourprogram can select the file, loop through the records and if the flag is set or the record does not exist it just skips onto the next one. You can then start 10 processes running all doing the same thing and they will work through the file. Or you could have process 1 doing all the ones beginning with a 1, 2 for 2 and so on. You may want a controlling program that runs up, counts the records on the file/in the batch and from that determined how many phantoms to run up. It then runs up the phantoms and then stops. Rgds Symeon. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: 05 March 2011 16:55 To: u2-users@listserver.u2ug.org Subject: [U2] Multi-Threading Universe Socket traffic On Universe 10.1.14 over AIX 5.3, we currently communicate Credit Card transactions via sockets (ISO-8583) using the following logic (works fine): OPEN.ERR=openSocket(THIS.IP,THIS.PORT,TCP.MODE,TIMEOUT,THIS.HANDLE) INFO.ERR=getSocketInformation(THIS.HANDLE,PEER.FLAG,SOCKETINFO) WRITE.ERR=writeSocket(THIS.HANDLE,SEND.MSG,TIMEOUT,TCP.MODE,SEND.SIZE) READ.ERR=readSocket(THIS.HANDLE,RECV.MSG,RECV.LEN,TIMEOUT,TCP.MODE,RECV.SIZE ) I am looking into using some sort of multi-threading logic to allow increased volume in shorter timeframes. For example, we now send batches of up to 3,000 cards via a ftps mechanism that responds normally within 3-5 minutes. We want to benchmark doing this via the sockets instead. The Subroutine that does this Socket comm takes about 0.7 secs per trx, so a 3,000 card batch would take over 30 minutes single-threaded (unacceptable). Probably 80% of that 0.7 secs is transforming the data to send and then transforming the response back to process. I hearthat my BASIC applicaton program can utilize PHANTOM processes (unfamiliar territory) to launch multiple requests but I am not sure how to throw multiple trxs over the wall and make sure to put te correct responses back together with the appropriate request. Can anyone point me to some good documentation and/or example code for doing this? -- View this message in context: http://old.nabble.com/Multi-Threading-Universe-Socket-traffic-tp31076011p310 76011.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1435/3482 - Release Date: 03/04/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 'U2 Market Place' {Unclassified}
If you look at the 'about' as I recall it shows Jay LaBonte as the 'man
behind the curtain' (or did when I looked a while back). He's been in the
U2 space for a while...
DW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter
Sent: Monday, March 07, 2011 2:35 PM
To: U2 Users List
Subject: Re: [U2] 'U2 Market Place' {Unclassified}
Don't know anything about u2marketplace.com -- looks to be brand new with
basically empty forums, etc. but serverphase.com is a hosting company. They
are legit, but I suspect their only connection is they are being paid to
host u2marketplace...
Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the
solicitor-client or other applicable privileges), or constitute non-public
information. Any use of this information by anyone other than the intended
recipient is prohibited. If you have received this transmission in error,
please immediately reply to the sender and delete this information from your
system. Use, dissemination, distribution, or reproduction of this
transmission by unintended recipients is not authorized and may be unlawful.
HENDERSON MIKE, MR michael.hender...@nzdf.mil.nz 3/7/2011 2:20 PM
Folks,
I have recently started getting email from
postmas...@u2marketplace.com about the 'U2 Market Place'. It also
features Return-Path: u2...@mercury.serverphase.com.
Whilst it looks like it might be kosher, I'm a little intrigued as to
where they got my email address from. The address they use indicates
it's not been harvested from an email I sent, but that it may have been
scraped from a signature block.
I guess I could do a little whois work on u2marketplace.com and
serverphase.com, and maybe a traceroute on mercury.serverphase.com,
but asking here is definitely easier!
So: advice, please: is this a genuine bona fide organisation I might be
interested in, or yet another but reasonably sophisticated attempt to
separate me from my digital identity and possibly my hard-earned cash?
Thanks
Mike
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV PE Linux
Well, I can tell you from an UniData document error on the web site - that web group is SLOW AS MOLASSES at things -- my guess, Rocket's acquisitions mode keeps them in a constant state! g If you have an urgent need, find an alternate way to 'get' the PE download. You could wait a while for the web group to act (sort of counterintuitive, I know...) DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, March 04, 2011 2:49 AM To: 'U2 Users List' Subject: Re: [U2] UV PE Linux All I'm told it is on the way - apparently it's been in the queue for getting onto the Rocket website for a couple of weeks now. Just like the other UniVerse 11 stuff :( It exists - really - I was able to get a private download direct from Rocket to test out a specific issue that I needed to sort before implementing on a live system. It appears the problem is not at the Rocket *U2* end but with whatever division runs their website. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
Well -- I usually code so the 'first clause' is my 'expected outcome' -- that is, if the PARMS(7)102,CM is TYPICALLY 'not empty' -- so I would do # THEN myself as well.. I do it as much to express the code as the 'typical path'. I also perceive (although have never tested!) the THEN clause as being the 'lower cost' clause to execute. Don't know why I think that or have a reason for thinking that -- I guess because of 'reading' the code, THEN is always the next line without having to 'skip ahead'. So I'm curious why it would that be a bad idea to say ' # THEN'? Is there actually any extra 'overhead'? Or is this a 'preference' issue? Myself, I actually think of it as being 'better documented' explaining how I think the average transaction should progress (usually taking the THEN statements.) Wondering why that is a 'bad thing'??? David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Wednesday, March 02, 2011 12:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is this worth rewriting? In a message dated IF PARMS(7)102,CM#'' THEN CUMO(M)=CUMO(M)+PARMS(7)102,CM ELSE CUMO(M)=CUMO(M)+PARMS(12)134,CM END Just as a follow up, IF Not Not, is very bad style. And parsing long and then short is as well. This part should have been done as IF PARMS(7)102,CM='' THEN CUMO(M) += PARMS(12)134,CM ELSE CUMO(M) += PARMS(7)102,CM END Infinitely more legible. W Fire that programmer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
The += I completely agree with. No arguments on that point at all. But #or = ... that's the exact same amount of code! ;-) And this example seems to point that ONE or the other is needed. That is, you could not change their code IF PARMS(7)102,CM # '' THEN CUMO(M)=CUMO(M)+PARMS(7)102,CM END ELSE CUMO(M)=CUMO(M)+PARMS(12)134,CM END To be a SHORTER: IF PARMS(7)102,CM THEN CUMO(M)=CUMO(M)+PARMS(12)134,CM END ELSE CUMO(M)=CUMO(M)+PARMS(7)102,CM END As what if PARMS(7)102,CM = 0? 0 would 'fail' the 2nd test, but is 'not blank'. So you cannot 'shorten' the clause at all. It either has to be = or # in this case (not knowing anything about the data). My point was that someone said you should NEVER say '# THEN' And I will not dispute this logic could be done with CASE statements - but again, that was not the point I'm trying to delve into more deeply. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 02, 2011 12:40 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? On 3/2/2011 1:34 PM, David Wolverton wrote: So I'm curious why it would that be a bad idea to say ' # THEN'? Is there actually any extra 'overhead'? Or is this a 'preference' issue? Myself, I actually think of it as being 'better documented' explaining how I think the average transaction should progress (usually taking the THEN statements.) Wondering why that is a 'bad thing'??? David W.s IMO, less code is better code as long as it doesn't involve magic. I will always use += and drop the #''. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
By jove, you're right! In this example, you COULD shorten the clause and it would work! I missed that!! But back to the 'issue' I was raising, although in this example it's moot - the generic statement was that 'IF ... # ... THEN' is 'bad style' ?? I still have missed why that should be considered 'wrong' or 'bad'. If it's purely style, then that's OK too and discussion over! Different horses for different courses! But when someone tells me something is 'bad', I want to know the reasons why so I can advance my understanding. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 02, 2011 1:09 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? On 3/2/2011 2:05 PM, David Wolverton wrote: As what if PARMS(7)102,CM = 0? 0 would 'fail' the 2nd test, but is 'not blank'. So you cannot 'shorten' the clause at all. It either has to be = or # in this case (not knowing anything about the data). Adding a zero into the sum is basically a NOOP. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Clear Message Initiative - Logging Errors to a U2 File
In UniData we can get that from a SYSTEM(49) I think. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, February 09, 2011 5:37 PM To: U2 Users List Subject: Re: [U2] Clear Message Initiative - Logging Errors to a U2 File Is there a way to capture the name of the program, sub, and current line of UniBasic code? For example, the user at the Dock tries to ship out a quantity of of parts more than are in the inventory bin location. The UniBasic program calls a sub to splash an error message to the user's screen, and then log the user, date, time and message to the ERROR.LOG file. How can we capture what program he is running? How do we capture the UniBasic code line number. For this scenario, I cannot see how a table of standard error codes would apply. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
Would make sense -- I would guess you have 2 disk reads to 'find' the Global Catalog - once test for the 'direct' entry in the VOC, and then the read to the Global? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, February 08, 2011 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command On 08/02/11 00:31, Dan McGrath wrote: From my testing with the aforementioned project, directly cataloguing in the VOC results in noticeably faster calling than code that is catalogued globally. I don't have time at work at the moment do the tests again, I might try after I finish the day. That seems very odd to me, but global cataloguing probably came from PI, and was optimised to work fast on Primos (if you ran PI, you had special microcode in the CPU :-) I know Primes had blinding fast dynamic linking - okay their clocks are very slow by today's standards, but tick for tick they can knock x86 into a cocked hat. Changing topics within the thread, I much prefer Prime's condition handling (inherited from PL/1) to C++'s try/catch. But that's probably because it's not an OO type concept ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
I have been using 'DIRECT' for so long I did forget about the 'LOCAL'!! 3 it is... wow. No wonder things run faster on SSD drives, huh? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Tuesday, February 08, 2011 3:39 PM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command 3. Once for the VOC, once for the Local Catalog and once for the Global Catalog. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, 9 February 2011 7:52 AM To: 'U2 Users List' Subject: Re: [U2] Does UV have a BLOCK command Would make sense -- I would guess you have 2 disk reads to 'find' the Global Catalog - once test for the 'direct' entry in the VOC, and then the read to the Global? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, February 08, 2011 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command On 08/02/11 00:31, Dan McGrath wrote: From my testing with the aforementioned project, directly cataloguing in the VOC results in noticeably faster calling than code that is catalogued globally. I don't have time at work at the moment do the tests again, I might try after I finish the day. That seems very odd to me, but global cataloguing probably came from PI, and was optimised to work fast on Primos (if you ran PI, you had special microcode in the CPU :-) I know Primes had blinding fast dynamic linking - okay their clocks are very slow by today's standards, but tick for tick they can knock x86 into a cocked hat. Changing topics within the thread, I much prefer Prime's condition handling (inherited from PL/1) to C++'s try/catch. But that's probably because it's not an OO type concept ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
@George - you're probably right -- I found the doc on that link was dated Feb / Mar of 2010 -- that was well into Rocket-realm, but perhaps they just 'wrote up' the logic IBM used to make the change. And yes -- it appears the any 'socket' sets iPhantoms. The problem is that the logic does not address specifically the uses that could be 'abused' - but rather ALL uses. @Jeff / Symeon - That I can see, you don't 'consume' a 'purchased' seat running a phantom UNTIL you do a anything 'socket' - even if that Socket Use has the same use as a 'disk read'. As for use of cURL, WGet, etc - these are examples of the issue as I see it. Those are still an option to do exactly what we could do BEFORE this rule went into play, and we can still do those even now without a license 'ding'. To me, that's the core of this issue: the change didn't 'fix' anything except to create a barrier to adopting the Rocket-provided toolsets since CallHTTP can no longer work in a Phantom without 'expense' to the customer. I mean, they spent the time and money to develop CallHTTP, but now I can never use it again -- and sounds like a great number of people never used it or already 'jumped ship' as well. And are still doing EXACTLY what the change was designed to prevent! So what good was the 'effort' and 'hassle' for the change?? Did they really pick up additional revenue?? Or just make people find 'non-U2' solutions?? So - As I see it, there was a logic error in the decision made by IBM, continued by Rocket. I (probably crazily) hope that they will revisit the issue for CallHTTP. But from comments posted here, appears no one else is impacted by the Phantom license change. I am guessing people either just silently re-wrote their code to 'skip over' CallHTTP rather than complain, or had never adopted CallHTTP in the first place (used cURL/wGet before CallHTTP existed and never moved.) - So I will just work around it as everyone else did since it is not a 'group issue' worth pushing. Now, if they ever hamper the ability to run cURL/wGet, I guessing there will be the massive outcry that didn't happen over this issue! LOL! Have to get started -- Sadly, no one is going to pay me to fix this. And I write enough issues on my own without someone else creating issues for me! So... Goodbye CallHTTP -- Heo cURL! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
Thanks for the feedback folks. The reason I was doing this query was to review the 'reason' for the recent license changes that make CallHTTP 'consume' a seat if it is used within a 'phantom' process. I didn't say WHY I was interested get 'genuine' usage comments. Like many of you, I use CallHTTP to get a piece of data from a remote machine (in my case, a UniVerse server is validating a code from a UniData machine). But with a recent update to UniVerse, we started having weird 'failures' -- turns out it failed when all the 'seats' on the UniVerse machine were in use, and the Phantom attempted a CallHTTP lookup. Blam! Dead phantom! I read all the uses people posted, and unless I was mistaken, no one was seriously using CallHTTP for the purpose of serving multiple 'logical users'. It appears everyone is using CallHTTP as a way to gather a piece of data that could have just as easily been in a file on the local disk drive if the machine you have could have limitless resources. In my use, and apparently most of yours, to call CallHTTP 'interactive' would be the same as calling a disk read 'interactive'. Here is the link for the 'business case' for making CallHTTP 'eat a seat' when used in a Phantom. I wanted to see if the logic made sense for the CallHTTP feature. My point to Rocket will be that someone could make a phantom into a 'multi-user' server by using READ/WRITEs from Text Files -- yet those are 'allowed' -- so trying to 'lock down' the server against a POSSIBLE misuse of the license terms by removing needed features seems counterproductive. UNLESS, that is, you're going to lock down EVERY POSSIBLE way to misuse the system - Meaning, phantoms should not be able to READ or WRITE at all. Heck, phantoms should not even EXIST since their existence could lead to license misuse! https://u2tc.rocketsoftware.com/rsp-portal/rsp/solutionDetail.asp?id=0002370 1?sterm=iphantomexact=searchAction=doSolutionSearch.aspcatFilter=02n4 000TqmnoType= Am I out on a limb here saying that CallHTTP should probably not cause a Phantom to go iPhantom? I mean, Rocket can do whatever the heck they want, it's their sandbox after all and we really have no choice but to suck it up... But is the logic they employed flawed as I think it is? Or am I just a loon? (H.. really, the two questions are not mutually exclusive I guess... But you get the point... ) I'm interested in comments on the topic, if any. DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UUID [was Data in Dict]
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 27 January 2011 10:46 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, 27 January 2011 10:07 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Most OSs have a call available for generating a UUID (Universally Unique ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted generation standards these are almost guaranteed (!) to be unique (the probability of a clash is extremely small) across all computers. In UV you could use GCI to create a UV verb to invoke the OS call. Or just create a VOC item which you can execute and capture. There are usually options which affect the format of the output. For AIX the VOC item might look like this: UUID 0001 V 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM For Linux use: /usr/bin/uuidgen For Windows (not installed by default): guidgen HTH -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, 27 January 2011 01:55 To: 'U2 Users List' Subject: Re: [U2] Data in Dict I'm curious what your logic is to generate the Unique ID -- can you share that without giving away a trade secret?? It's too bad it's not a database function call in UniData/UniVerse - we can do that in D3/Pick - it's a derivation of system Date/Time with AlphaSequencing if more than 1 hit in a given clock cycle - but it would only be unique on the 'machine' since another system could generate the same ID. So I am interested in the idea of generating a TRULY unique ID. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, January 25, 2011 7:24 PM To: U2 Users List Subject: Re: [U2] Data in Dict In some cases I am becoming a fan of UUIDs for db table keys. A UUID type one uses the mac address of the host along with the current time as salt so you don't have to worry about key collisions between accounts (I.e. TEST and PROD). Generating the next key is fast because there is no readu, update, write. They should hash pretty well since they are long and random. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1BAEgE3GKH/7zQqhc0y0YR7mTW04Avx4o/ 3.053 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail
[U2] What do you do with CallHTTP?
What uses have you found for CallHTTP for in your applications? Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Thanks for your thoughts! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Data in Dict
I'm curious what your logic is to generate the Unique ID -- can you share
that without giving away a trade secret??
It's too bad it's not a database function call in UniData/UniVerse - we can
do that in D3/Pick - it's a derivation of system Date/Time with
AlphaSequencing if more than 1 hit in a given clock cycle - but it would
only be unique on the 'machine' since another system could generate the same
ID. So I am interested in the idea of generating a TRULY unique ID.
DW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Tuesday, January 25, 2011 7:24 PM
To: U2 Users List
Subject: Re: [U2] Data in Dict
In some cases I am becoming a fan of UUIDs for db table keys. A UUID
type one uses the mac address of the host along with the current time
as salt so you don't have to worry about key collisions between
accounts (I.e. TEST and PROD). Generating the next key is fast because
there is no readu, update, write. They should hash pretty well since
they are long and random.
On 1/25/11, Bill Haskett wphask...@advantos.net wrote:
Jeff:
I have a single file named (CTRLNOS) with the item ID equal to the file
name using the sequence#. Field#1 is the last seq# used while field# 2
is the maximum seq# allowed before the seq# is reset to 0. Each item
has documentation in it to describe what it's for and any unusual pieces
of data allowed (e.g. maximum length of data allowed in a text box).
The get-next-sequence code looks like:
READ{U} SEQREC FROM SEQFILE, FILENAME ELSE
SEQREC = 0:@AM:9:@AM:@AM:@AM
SEQREC := ** Item created on :TIMEDATE():.
END
SEQ = SEQREC1 + 0
MAX.SEQ = SEQREC2 + 0
OSW = 0
LOOP
SEQ += 1
IF SEQ MAX.SEQ THEN
IF NOT(OSW) THEN OSW = 1 ; SEQ = 1
END
READV{U} DoesExist FROM FILENAME.FV, SEQ, 0 ELSE DoesExist = 0
UNTIL NOT(DoesExist) DO REPEAT
If a file goes bad then I know which item to fiddle with. Just a thought.
Bill
Jeff Schasny said the following on 1/25/2011 8:37 AM:
My preference is to have a data file specifically for next key records
with the item id being the filename and field 1 being the next
available key. As far as restoring it should it become corrupted a
fairly simple Uvbasic program which is fed a list of filenames,
selects each file BY.DSND @ID,
readnext,
add 1 to the first key,
write that as the next key for the file,
next filename
should be able to restore your next key file in a couple minutes if
not less.
George Gallen wrote:
The one down side I can think of to not keeping 'next' values in the
DICT and in a separate file, is if you have to restore the file, you
will also have to restore the NEXT-FILE as well. It's not one neat
package.
But I have to admit, when I was setting up a MySQL structure and
needed to implement a 'next' value, I went with a separate file and
each row had two values, key and value, where the key was the filename
and the value being the next value, and used this one file for all my
'next' placeholders, instead of writing it to the DICT, I used the
filename as the key.
Although, keeping all your nexts in one basket could be a problem if
that file ever was corrupted, it would be difficult to reset them
all to the correct values. Other than that, seems a bit of overhead
to have a separate next file for each file you want to keep one on
to avoid losing all your keys with one file issue.
What other methods are people using to track next ID?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, January 24, 2011 7:55 PM
To: U2 Users List
Subject: Re: [U2] Data in Dict
Kate:
It seems to me that this is very tidy! :-)
Bill
---
-
Kate Stanton said the following on 1/24/2011 1:27 PM:
Hi David,
The reason we use dictionaries for data entry, reports, queries and
forms is so we can use the same dictionary item for all activities,
thus using the dictionary as designed with a little more.
So, if part ID is changed at a site to be 6 numbers, then changing
the
dict item in a file once means the same change applies to all other
activities.
We think this is very tidy, and the unused portion of dictionaries
have been used like this for a long, long time (over 30 years to our
knowledge).
Cheers, Kate
Kate Stanton
Walstan Systems Ltd,
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: +64 9 360 5310 mobile: + 64 21 400 486 fax: + 64 9 367 0750
Email: k...@walstan.com
On 25 January 2011 03:53, David A. Greendgr...@dagconsulting.com
wrote:
All this talk about using the Dictionary item to store extra data
has
prompted this post.
I realize in the past when the limit to the number of
Re: [U2] INPUTIF statement in Universe {Unclassified}
UniData 7.1.9 --- Using list filename field-a field-b TO DELIM | c:\Test.txt Works and generates a Pipe Delimited text file... (I have to use 'lowercase LIST' so that it does work due to ECLTYPE, but that's OK) BUT -- I need the resulting file to be tab-delimited - the 'consumer' for the file is a stupid old program and cannot accept XML. It can only eat tab, or comma delimited files. And since some of the data CONTAINS commas, the TAB seems to be the better choice. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to create tab-delimited LIST output
Does that syntax work on your UniData?!? I just barfs up trying that syntax
on mine. If it does work, let me know your version.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Tuesday, November 02, 2010 12:33 PM
To: U2 Users List
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
BUT -- I need the resulting file to be tab-delimited - the 'consumer'
for
the file is a stupid old program and cannot accept XML. It can only eat
tab,
or comma delimited files. And since some of the data CONTAINS commas,
the
TAB seems to be the better choice.
How about list filename field-a field-b TO DELIM CHAR(9) c:\Test.txt
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INPUTIF statement in Universe {Unclassified}
WELL -- I guess I could go the 3rd Party Product route -- but come on!
EVERY database product can do what I'm asking. It's not rocket science or
anything! (pun unintended!) I could just write BASIC code if I wanted - I'm
trying to find what I'm thinking should already be 'inside' of UniData. If
the answer is 'it is not there' then I will be forced to ask if someone from
Rocket can address 'why not'??
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Tuesday, November 02, 2010 1:25 PM
To: U2 Users List
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
Cedarville Download
David Wolverton wrote:
UniData 7.1.9 --- Using
list filename field-a field-b TO DELIM | c:\Test.txt
Works and generates a Pipe Delimited text file... (I have to use
'lowercase LIST' so that it does work due to ECLTYPE, but that's OK)
BUT -- I need the resulting file to be tab-delimited - the 'consumer' for
the file is a stupid old program and cannot accept XML. It can only eat
tab,
or comma delimited files. And since some of the data CONTAINS commas, the
TAB seems to be the better choice.
Using TO DELIM ^009 will not work that I can see. And I think in this
day
and age, having to write a program to generate this simple of a file seems
a
bit over the top!!
The other choice - building a dictionary called tab -- but I need to
extract about 40 fields for this issue, so I was hoping to NOT have to
build
a 'hard coded' dictionary that was itself just a CHAR(9) so that my
command
line does not have 'tab' as every other word and get near the 'max length'
along the way! That is, I didn't think I should have to do this:
list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt
I mean, tab delimited file. How routine is that?? Why would I have to
build
a 'fake dictionary' to handle that? Am I missing something?
How do others deal with this issue? Or is the 'fake dictionary' the
'state
of the art' methodology today??
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Tab Delimitted LIST Output...
WELL - found that this worked for me also - from REAL ECL only. And it
looked hideous typing (wrapped the code around to the start.) I found that
this method would NOT work from the TCL shell provided in SB+, as the tab
entry caused the 'shell command line' to close up as if you were pressing
'enter'.
OK - good deal that this works. And it's intuitive except that it's not
pretty, nor is it 'usable' from within SB+.
So I have a work-around!! Hopefully the new 'command line' interface that is
coming out Real Soon Now works more like SQL does will have the ability to
handle this more 'neatly' than this as well.
Thanks Larry! I should have read the oldest response first!!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Tuesday, November 02, 2010 1:18 PM
To: 'U2 Users List'
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
I just tested ... TO DELIM ... (i.e. press the tab key in between the
quotes) and it worked for me.
UD 6.1.12
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton
Sent: Tuesday, November 02, 2010 10:59 AM
To: 'U2 Users List'
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
UniData 7.1.9 --- Using
list filename field-a field-b TO DELIM | c:\Test.txt
Works and generates a Pipe Delimited text file... (I have to use
'lowercase LIST' so that it does work due to ECLTYPE, but that's OK)
BUT -- I need the resulting file to be tab-delimited - the 'consumer' for
the file is a stupid old program and cannot accept XML. It can only eat tab,
or comma delimited files. And since some of the data CONTAINS commas, the
TAB seems to be the better choice.
Using TO DELIM ^009 will not work that I can see. And I think in this day
and age, having to write a program to generate this simple of a file seems a
bit over the top!!
The other choice - building a dictionary called tab -- but I need to
extract about 40 fields for this issue, so I was hoping to NOT have to build
a 'hard coded' dictionary that was itself just a CHAR(9) so that my command
line does not have 'tab' as every other word and get near the 'max length'
along the way! That is, I didn't think I should have to do this:
list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt
I mean, tab delimited file. How routine is that?? Why would I have to build
a 'fake dictionary' to handle that? Am I missing something?
How do others deal with this issue? Or is the 'fake dictionary' the 'state
of the art' methodology today??
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Using LIST to generate a delimited file.
Yes -- this does work --
It also turns out it DOES work using the 'tab' key, but looks bad, but that
it will not work from an SB+ '/TCL shell'.
I'm sort of hoping the new features (which includes a 'database viewer' I
hear) will make this kind of thing better for us going into SQL-land
settings! Generating a tab-delimited file is something a novice SQL users
can do - it's point and shoot for the most part. I'm hoping our
interpretation is as nice!
David W.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Tuesday, November 02, 2010 4:37 PM
To: U2 Users List
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
2 line program works:
STMT = 'LIST CUSTOMER NAME TO DELIM ' :CHAR(9): ' wwtestjunk'
EXECUTE STMT
Also - if you are using dictionary items with conversion codes and want the
data in the output file to have the conversion code applied, don't forget to
first run the ECL command:
UDT.OPTIONS 91 ON
Wally Terhune
U2 Support Architect
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton
Sent: Tuesday, November 02, 2010 3:24 PM
To: 'U2 Users List'
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
WELL -- I guess I could go the 3rd Party Product route -- but come on!
EVERY database product can do what I'm asking. It's not rocket science or
anything! (pun unintended!) I could just write BASIC code if I wanted - I'm
trying to find what I'm thinking should already be 'inside' of UniData. If
the answer is 'it is not there' then I will be forced to ask if someone from
Rocket can address 'why not'??
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building XML using the UV XDOM API functions
It was definitely 'mapped' into our world. There are steps in the API that logically would never be used 'standalone', but as the underlying process broke the functions out as the underlying API did -- for example -- the PrepareXML must be followed by OpenXML -- why show that to us developers?!? We should have received a PrepareAndOpen function call instead. I mean, I will never do a PrepareXML that is not immediately followed by an OpenXML. It was a literal implementation of the underlying requirements without any thought to the 'target user'. Anyway, that kind of design ugliness was what said 'checkbox item' over 'well thought out' or 'implemented for real users' to me. I voiced this the first time I went through the process -- my point was that all parts of the systems handles that kind of 'allocation of memory' without it having to be explicitly executed. The XML add-on is the most C like stuff ever presented to us to use in BASIC! g So I'm in the camp that I like that it is built in to UniData, but it really was a cheesy (and maybe even inconsiderate) job on the design and implementation That was my take anyway! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, October 26, 2010 6:36 PM To: U2 Users List Subject: Re: [U2] Building XML using the UV XDOM API functions Compared to something like lxml it seems rather clumsy and unmaintained. On 10/26/10, Gregor Scott gregor.sc...@pentanasolutions.com wrote: I actually like the XML handling built into UV. I have always been a believer in using the intrinsic facilities of the database where possible to maximise the performance of the process being automated. The XDOM API is a good example of this, and is a good fit for our requirements. My biggest issue is with the poor state of the documentation. It does not allow me to easily obtain a good level of competency, which I think is needed to feel like I can be productive with a tool, and to feel that the tool is worth using. Once I got past the documentation and did a lot of testing, and raising cases with Rocket Software (the guys here in Australia should now know their XDOM backwards!), I have a much clearer understanding of what is possible and what the limitations are. Which is why I created the blog and started adding entries for various aspects of the XDOM that were not obvious from the documentation. I just hope it helps others get a handle on the XDOM API a bit quicker than I did. It might also allow others to better evaluate the XDOM API as a valid toolset, rather than discount it out of hand due to FUD, or marketing pressures. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 26 October 2010 3:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building XML using the UV XDOM API functions Gregor, your comments serve as a testimonial to support my position against using many of these vendor-supplied toolkits. Some of them are OK, but many not. People insist on the DBMS vendors building stuff for them, but then we get the mess that you've described. For this reason I continue to recommend at least consideration for integration with tools that are outside of the DBMS. DBMS vendors should be focusing on making superior databases, not XML, web services, or a lot of this other fluff. People in the open source and commercial markets spend a great deal of time focused on these things, and because of this, their offerings are often much better. So take a look around and weigh other offerings against the built-in functionality. It would be nice to see people here comparing more toolkits - it might save others from feeling like they're stuck with whatever is provided by the DBMS vendors. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1AYrw4K3L1/76hLrBplQLdEzGQ20K2ljp/0 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list
Re: [U2] Licensing
I think that is correct -- you have to 'buy' device licensing additionally if you have 'Server' licenses. In that case, you can 'pick' how many device seats you want to add on per IP address - 10 is not the only answer - we have sites with 3 or 5 since it was an 'add on' cost against the Server license. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, October 21, 2010 10:44 PM To: U2 Users List Subject: Re: [U2] Licensing I thought Enterprise licences included device licences, Server didn't ...? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 2:34 PM To: 'U2 Users List' Subject: Re: [U2] Licensing As I understand, some of it depends on whether you have WorkGroup, Server, or Enterprise. You can have X count of device licenses allowed per IP address, with 10 I think being the maximum (10 is the 'standard count' for WorkGroup level licenses as well I think - it's 'built in' to WorkGroup licenses.) For server you 'choose' you Device License 'count'. And your example is correct - only thing to note is that if one machine has 12 connections and you have '10' as you Device License count, I think you'd end up being dinged 3 seats (1 for the first 10, then 1 for every seat used past 10). That's why if you are 'choosing' your device license count (as you would on the server licensing) you want to choose wisely! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Marcos Sent: Thursday, October 21, 2010 10:22 PM To: U2 Users List Subject: Re: [U2] Licensing Not sure if I read DW's message correctly, but we have device licensing here and it works as follows; 1 device license means from 1 IP/device you can login to a maximum 10 uv sessions (thus only using 1 license) So 10 device licenses (10 individual IP's) equates to maximum number of 100 sessions . And can you mix your licenses on one machine?? Regards, Jeff Marcos -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 6:38 AM To: 'U2 Users List' Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing You have to BUY device licensing for this to be true... If you device license 3 devices - and connect 4 sessions from one IP, you will end up using TWO seats - one for the first 3 sessions, and then 1 for every session thereafter. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, October 21, 2010 2:32 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing On Thu, 21 Oct 2010, charles_shaf...@ntn-bower.com wrote: I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. Note that (unless something changed recently) your licensing actually is based on number of users, not sessions. If you have a terminal emulator that can handle this, properly configured, one user on one machine with 5 open sessions will consume only one license. Our Anzio emulators can do this. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 271 7600 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained
Re: [U2] Licensing
No - device licenses are across ALL seats -- hence the reason our server customer chose fewer than 10! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, October 22, 2010 8:36 AM To: U2 Users List Subject: Re: [U2] Licensing I think that is correct -- you have to 'buy' device licensing additionally if you have 'Server' licenses. In that case, you can 'pick' how many device seats you want to add on per IP address - 10 is not the only answer - we have sites with 3 or 5 since it was an 'add on' cost against the Server license. If you have say 100 licenses, can you buy 10 device licenses and assign them to particular users? Or is it necessary to buy 100 licenses? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Licensing
But that device license limit is PER SESSION... So you buy 3. Power user uses 4 -- Power user eats TWO real licenses. One for the '3' device licensed, then one for each thereafter. Even if every other user is just using one seat. SO -- if you had 300 seats, and only 2 or 3 users needed 2 or 3 sessions, it may be CHEAPER to just buy more seats on a server license than to waste device licensing on all... It's all math! BUT -- where we installed it, it seems that most users immediately used them -- they ALL needed (wanted?) more connections, but were locked out. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, October 22, 2010 9:20 AM To: U2 Users List Subject: Re: [U2] Licensing No - device licenses are across ALL seats -- hence the reason our server customer chose fewer than 10! So for example, if you have a few users that use several sessions then it would be more cost effective to buy for example 3 seats. Most users would only use 1, but the power users would use maybe 2 licensesfor 6 separate sessions. You have to balance wasted sessions against the users who would use multiple licenses. Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Licensing
Based on the IP -- so 6 connections (Sessions) from a single IP that is 3-device licensed will indeed use 4 'licenses' (seats) - 1 for the first 3, then one for each over 3. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, October 22, 2010 9:50 AM To: U2 Users List Subject: Re: [U2] Licensing But that device license limit is PER SESSION... So you buy 3. Power user uses 4 -- Power user eats TWO real licenses. One for the '3' device licensed, then one for each thereafter. Even if every other user is just using one seat. SO -- if you had 300 seats, and only 2 or 3 users needed 2 or 3 sessions, it may be CHEAPER to just buy more seats on a server license than to waste device licensing on all... It's all math! BUT -- where we installed it, it seems that most users immediately used them -- they ALL needed (wanted?) more connections, but were locked out. DW I guess I am a little unsure of the terminology. In terms of the licensing agreement, what is a SESSION? Is it the same as a login? Assuming device licenses with a limit of 3 connections, can you login twice and get all 6 connections? Or is it based on the IP address and 6 sessions will use 4 licenses? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Licensing
NOTE that WorkGroup and Enterprise have DeviceLicensing BAKED IN -- but that you can AUTHORIZE these (at least on UniData) with ZERO Device Licenses, and it will do so, with a tiny message at the bottom of the screen that you are 'authorizing below your limits' -- we had sites that never had DeviceLicensing 'on' even though they were 'licensed' to use it for this reason! Just an FYI -- something I asked IBM (this was a long time ago!) to make more 'bold' in the auth process (haven't had reason to test/review if they ever made a change there!) DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, October 22, 2010 11:23 AM To: U2 Users List Subject: Re: [U2] Licensing A session is a open telnet / uniobjects session. OPEN is the key word (as in active open in use) :-) It's just like you have now, but a single MAC / IP address is allowed multiple sessions up to X to combine into 1 license. I think Enterprise edition already has the 10 device. It would be nice for Rocket to chime in here, and clarify in black and white... I agree. It seems like a small point, but it could affect cost substantially. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Licensing
As I understand, some of it depends on whether you have WorkGroup, Server, or Enterprise. You can have X count of device licenses allowed per IP address, with 10 I think being the maximum (10 is the 'standard count' for WorkGroup level licenses as well I think - it's 'built in' to WorkGroup licenses.) For server you 'choose' you Device License 'count'. And your example is correct - only thing to note is that if one machine has 12 connections and you have '10' as you Device License count, I think you'd end up being dinged 3 seats (1 for the first 10, then 1 for every seat used past 10). That's why if you are 'choosing' your device license count (as you would on the server licensing) you want to choose wisely! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Marcos Sent: Thursday, October 21, 2010 10:22 PM To: U2 Users List Subject: Re: [U2] Licensing Not sure if I read DW's message correctly, but we have device licensing here and it works as follows; 1 device license means from 1 IP/device you can login to a maximum 10 uv sessions (thus only using 1 license) So 10 device licenses (10 individual IP's) equates to maximum number of 100 sessions . And can you mix your licenses on one machine?? Regards, Jeff Marcos -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 6:38 AM To: 'U2 Users List' Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing You have to BUY device licensing for this to be true... If you device license 3 devices - and connect 4 sessions from one IP, you will end up using TWO seats - one for the first 3 sessions, and then 1 for every session thereafter. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, October 21, 2010 2:32 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing On Thu, 21 Oct 2010, charles_shaf...@ntn-bower.com wrote: I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. Note that (unless something changed recently) your licensing actually is based on number of users, not sessions. If you have a terminal emulator that can handle this, properly configured, one user on one machine with 5 open sessions will consume only one license. Our Anzio emulators can do this. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 271 7600 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
This has been our issue in the past -- unless you look at that data with a HexEditor, it's not obvious. If you use the UniData AE Editor (now included with UniVerse) you can type a ^ (Shift 6 - Caret) and see non-printable characters. Once you know the culprit, you fix the source data and the index heals itself. David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Brown Sent: Friday, October 01, 2010 6:02 AM To: U2 Users List Subject: Re: [U2] UV index with duplicate nodes Look for a space or non printing character in the data. That would make it look the same but actually be unique. - Original Message - From: Richard Lewis rbl...@gmail.com To: U2-Users@listserver.u2ug.org Sent: Thursday, September 30, 2010 8:47 PM Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
File Opens ARE a major killer -- even today -- we found that just building a 'named common' block used just in a SubRoutine called from dictionaries helped SELECTs and SORTs and LISTs to perform MAGNITUDES better (We're UniData, so YMMV)... We test the 'FILEINFO' for the handle that is carried in NamedCommon, and if FILEINFO for the named common was not filled in, we did the open. Note that you also need to store the 'current path' data as well in the NamedCommon, and check that as well since the NamedCommon persists through 'LOGTOs' -- if you have a LIVE and a TEST account, and you run in LIVE first, the named common will still 'be there' if you simply LOGTO the TEST account - so always test that the account/path used to open a file is the same on 're-use' of the file handle. But I'm here to say - of all things, cache your file handles. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, August 05, 2010 10:23 AM To: U2 Users List Subject: Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key On 05/08/10 00:24, Aramaies wrote: Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? What are you doing in your i-type? Optimisation of your code can make quite a difference. The more data that your i-type needs, that you can feed in via arguments rather than (re)read from file, that's saving reads. If you need to open files, cache them in named common because that USED to be a MAJOR performance killer (much less so nowadays I believe, but still...) Look at your code. The reference to an alternate key makes me suspect you are suffering open/read penalties that you can hopefully optimise away to a large extent. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.9 and .Net DLL
Ultimately we are calling a routine as a 'service' passing the XML and receiving back the 'answer' XML - this logic will allow abstraction off the 'core database' machine since the service call can point to any machine -- if they would complete all GeoCode actions with an EI XML interface, we'd be able to be C free... They are a bit slow getting this done -- the whole EI started as a 'skunkworks' project that ended up being marketable, but the GeoCode stuff is another group. On the tax side, the hardest thing was 'mapping' all the fields to a 'file' so the XML translations could just be handled by UniData -- lots of data in the 'EI request'! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, July 21, 2010 6:27 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL DW, Yes, I currently use the Vertex EI interface with the .NET application I'm working on. So do you know just link directly (add voc entry) with the vptrei.dll (enhanced integration) directly in Unidata? And yes, the XML is pretty sweet. Robert, Thanks for the heads-up about regasm. Tony, I did a quick google, but got a bit of search overload. I've written plenty of web services so that's not a huge huddle. I'll take a look at your articles for some refreshers on BASIC and WS. Thank you all for your ideas and helpful advice. Don Verhagen u2-usersrem...@thissoutheast-florida.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, July 21, 2010 12:31 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL Vertex's new code for passing XML is pretty sweet -- it's a different interface, but worth checking out. It's called their 'Enhanced Interface' version. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Tuesday, July 20, 2010 9:21 PM To: 'U2 Users List' Subject: [U2] Unidata 7.1.9 and .Net DLL Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 POINTER 5 CHAR_PTR 6 CHAR_PTR 7 CHAR_PTR 8 CHAR_PTR 9 INT I was hoping to update the VertexDriver.DLL (Currently COM/_cdecl) to a .Net dll. I really hate writing c code. David Wolverton, you out there? I know you have some experience writing c - Vertex utils. I may just end up writing a webservice to handle this and have Unidata call the webservice. Just want to check before I start writing this. Thanks for any assistance. Donald Verhagen u2-usersrem...@thissoutheast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.9 and .Net DLL
Vertex's new code for passing XML is pretty sweet -- it's a different interface, but worth checking out. It's called their 'Enhanced Interface' version. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Tuesday, July 20, 2010 9:21 PM To: 'U2 Users List' Subject: [U2] Unidata 7.1.9 and .Net DLL Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 POINTER 5 CHAR_PTR 6 CHAR_PTR 7 CHAR_PTR 8 CHAR_PTR 9 INT I was hoping to update the VertexDriver.DLL (Currently COM/_cdecl) to a .Net dll. I really hate writing c code. David Wolverton, you out there? I know you have some experience writing c - Vertex utils. I may just end up writing a webservice to handle this and have Unidata call the webservice. Just want to check before I start writing this. Thanks for any assistance. Donald Verhagen u2-usersrem...@thissoutheast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010)
Honestly... if he fixes this or unsubscribes I'll lose half the humor and joy of my work life You guys rock DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Martin Sent: Friday, June 25, 2010 3:42 PM To: U2 Users List Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010) Out of office slam Why does he torment always Hayden Bishop Die -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Conley Sent: Friday, June 25, 2010 3:25 PM To: U2 Users List Subject: Re: [U2] AUTO: Haydon Bishop is out ofthe office.(returning 26/06/2010) Please resubmit this in Haiku form. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Boyles Sent: Friday, June 25, 2010 2:41 PM To: U2 Users List Subject: Re: [U2] AUTO: Haydon Bishop is out of the office.(returning 26/06/2010) Haydon Bishop is out of the office today Haydon is traveling today We don't know where he is But he has gone away Is he working on the road? Vacation to the beach perhaps? But he left us with stinky load Haydon let's his computer harass us. It keeps sending spam our way. And we hope Haydon gets hit by a bus! - Bob Boyles, Controller O 214-631-5650 F 214-333-2035 - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, June 25, 2010 2:36 PM To: U2 Users List Subject: Re: [U2] AUTO: Haydon Bishop is out of the office.(returning 26/06/2010) I'm tempted to start a Haydon Bishop is out of the office fan page on Facebook fft2...@aol.com wrote: I thought we'd solved this problem. Can an educator please do a personal visit with Haydon Bishop and assist him in compliance procedures? Thanks Will Comrade Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] import data to excel sheet...
I've used the NebulaXlite -- it's good -- has a learning curve - but once you get the rhythm it makes getting a 'pretty' spreadsheet put together not that tough. I have a customer that uses it weekly to produce what was a problem as a CSV file just because of the 'perception' that it should look 'pretty'. The data is just as 'right' as ever, but now has more credibility! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, April 13, 2010 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... That program actually seems perfect for what I'm looking to do Bill. Do you guys use this at your work? Is it a decent product? -Chris Date: Tue, 13 Apr 2010 09:11:25 -0700 From: wphask...@advantos.net To: U2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... Chris: You may want to simplify your life and pick up NebulaXLite. http://nebula-rnd.com/products/xlite.htm HTH, Bill Chris Austin said the following on 4/13/2010 7:48 AM: I was curious if there is an easy way to add font formatting to the .CSV files I have been creating from UniVerse. Right now we just write to a sequential file and call it name.csv and just use comma's to separate the data. We then use a carriage return CHAR(13) to return to the next line in the spreadsheet. If I wanted to make a word appear as blue or in bold, how are you guys doing this? Thanks. -Chris Date: Mon, 12 Apr 2010 11:47:20 -0700 From: jacque...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... Hi Jaweed, If you already produced a number of files with the CHAR(13) as the end of line separator, you probably still handle them with excel, if you change the file extension from .csv to .txt and when you are in Excel import wizard, specify that the origin of the file is Macintosh.Since the Mac uses CHAR(13) as an EOL separator, the import should work. - Original Message From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, April 12, 2010 12:01:03 PM Subject: Re: [U2] import data to excel sheet... Hi Jaweed, I haven't looked too closely at your code, but I did notice on thing that I would consider the most likely candidate: CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I think CHAR(10) should do it. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] import data to excel sheet... Can anyone tell me what is wrong with the following code for importing data from txt file to an excel sheet, when its launch Excel it giving some error message, but when I open the downloaded file from my disc, all the data is in one line with some especial Chars. Any help will be appreciated. 034: ** 035: * OPEN FILES * 036: ** 037: ERRMSG = '' 038: OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!' 040: END 041: IF ERRMSG THEN 042: GOSUB 91000 043: RETURN 044: END *--: P 045: ** 046: * INITIALIZE * 047: ** 048: PAGE.FEED = CHAR(12) 049: LINE.FEED = CHAR(13) 050: ;* 051: ;* Read the text file to convert 052: ;* 053: READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE 054: ERRMSG = ITEM : TEXT.REC.NAME : DOES NOT EXIST IN : TEXT.FILE.NA ME 055: GOSUB 91000 056: RETURN 057: END 058: ;* 059: ;* Set default values (none are used now) 060: ;* 061: VALUE = DEFAULT 062: LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN 063: VALUE = FORMATSTR2,PTR 064: END 065: ;* 066: ;* Remove the first line if it contains a PAGE.FEED *--: P 067: ;* 068: LOOP WHILE TEXT.REC1 = PAGE.FEED DO 069: TEXT.REC = DELETE(TEXT.REC,1) 070: REPEAT 071: IF TEXT.REC1[1,1] = PAGE.FEED THEN 072: TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)] 073: END 074: ;* 075: ;* Find the header for each page 076: ;* 077: SLK.REC = '' 078: SLK.ROWS = 0 079: SLK.HEADER.LINES = 0 080: IF TEXT.REC1[1,10] = RUN D - T: THEN 081: SLK.REC-1 = F;SD;R3 082: SLK.REC-1 = F;SD;R4 083: SLK.REC-1 = C;Y1;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';; '))) 084: SLK.REC-1 = C;Y2;X1;K :
