Re: [U2] UniVerse Dictionary question
I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
I don't - but of course, I didn't actually write it :) Colin From: James.McGowan To: u2-users@listserver.u2ug.org Date: Fri, 7 Feb 2014 16:57:35 -0800 Subject: Re: [U2] UniVerse Dictionary question That's brilliant! Colin, would you mind if I steal that for www.pickwiki.com? Ian -Original Message- From: Colin Alfke Sent: Friday, February 07, 2014 2:14 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the 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
Re: [U2] [UD] Who's locking a record
That's what we used to use. It's a little more of a pain as you have to parse through the output to find the correct record - but it should give you need. It's simply list.readu output in an array. Hth Colin -Original Message- From: David A. Green Sent: Tuesday, January 28, 2014 2:19 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Who's locking a record Can you get what you need using GETREADU? David A. Green (480) 201-7953 DAG Consulting -Original Message- From: Bill Haskett Sent: Tuesday, January 28, 2014 1:18 PM To: U2 Mail List Subject: [U2] [UD] Who's locking a record In UniData, if you do a READU you can find out the User ID who has the record locked by using the STATUS() function; this returns the 'UID' value. Here's a list of users: 3 Dev (0)- lu Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 24 + 1 ) / 25 1 0 0 0 1 UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESS TIME DATE 1 2488 197612 AsiAdmin phantom pts/1 Console 10:42:32 Jan 15 2014 2 3920 197610 JohnSmith udt pts/2 192.168.1.52 08:15:33 Jan 28 2014 3180 197608 udcsuser udcspts/3 udcs 09:22:57 Jan 28 2014 4 3840 197608 udcsuser udcspts/4 udcs 09:23:08 Jan 28 2014 Now, if John Smith goes to read and lock a record that is locked by port#3, how can I figure out which port# actually has the record locked, since the UniData GETUSER() function only returns the UID, and that user, because it is a UniObjects user, is connected on more than one port#? I have a file managed at login that keeps track of the PORT#s and the associated users assigned by our application. I want our logging to report that a record lock by user so-and-so on port {n} is already in place. Thanks. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Pick 7.3 What is this?
http://www3.rocketsoftware.com/rocketd3/support/patches/d3rs.jsp -Original Message- From: Wjhonson Sent: Friday, January 10, 2014 10:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Pick 7.3 What is this? On someone's resume I see Pick 7.3. When I try to google for that, I get nothing useful. Is this from Raining Data ? It's a D3? Or is this an MvBase or something other thing. What is it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped on a WRITE failure
Did you check the udterrorlog? We saw similar issues (although we didn't have an on error clause) when running a scheduled process overnight and it conflicted with the backup. The backup would lock the file at the operating system level and UniData would error out at the write statement (we could see it in the _PH_ file). Good luck Colin -Original Message- From: Woodward, Bob Sent: Friday, August 16, 2013 11:09 AM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
Ummm, if the file doesn't exist then it's *supposed* to take the else clause, when I'm creating new files I use THEN and put the abort in there. When you borrowed this code did it have all of the validation? I don't have my error codes handy - but if you let it continue does it let you do the writeseq? Hth Colin -Original Message- From: Al DeWitt Sent: Monday, August 05, 2013 8:04 AM To: U2 Users List Subject: Re: [U2] OPENSEQ Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. -Original Message- From: Kevin King Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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?
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
Re: [U2] Selecting a special character in a SELECT (UV)
With UniData you can use GUIDE to find a character but I'm not sure of an easy way to find it with a select. Maybe by creating the select in basic (so you can put the actual character in the string) and executing it??? Hth Colin -Original Message- From: George Gallen Sent: Thursday, May 16, 2013 7:41 AM To: U2 Users Subject: [U2] Selecting a special character in a SELECT (UV) Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE ...^160... But that didn't work. Aside from writing a program to scan the file, is there a way from TCL? George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
That's what READLIST and WRITELIST are for. I've found writing the list as MY.LIST000 to be relatively safe, when you read you would have to check for MY.LIST000, then MY.LIST001, etc. Sathya - as Mecki said, if you're using the @ID of the file you can do a straight read to check if it's there. However, the select shouldn't be taking that long. Hth Colin -Original Message- From: Bill Haskett Sent: Wednesday, May 15, 2013 9:41 AM To: U2 Users List Subject: Re: [U2] select query.. George: In UniData, all SAVEDLISTS items have 000 (or 001, etc) appended to the end of it. Although one can normally do a SAVE.LIST MY.LIST and expect that the actual item ID in the SAVEDLISTS file to be MY.LIST000 this isn't always the case if the list is large. This makes managing a list directly in UD problematic. :-( HTH, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/15/2013 6:43 AM *Subject:* Re: [U2] select query.. I'm confused.. If your doing a select with @ID = you will only get 1 response each time, @ID is a primary key field. So as suggested just open the file, then do a read from That file with the given @ID. An alternative to a SAVE.LIST and GET.LIST could be to open SAVEDLISTS as file Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT loop to Traverse it. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Wednesday, May 15, 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exporting to Excel after upgrading to MS Excel 2007
I used the .txt extension (as the file is really a text file). The final DDE macro error is because when it opens the file it uses compatibility mode which uses a smaller sheet size than the newer version and the last step SBClient does is to copy the sheet to a new sheet with a different name. Excel returns an error on the copy because of the different sizes. I never looked far enough into it to determine if it would be easier to change how Excel opened the file or to modify the scripting commands SBClient sent. Hth Colin -Original Message- From: Lunt, Bruce Sent: Friday, April 19, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to Excel after upgrading to MS Excel 2007 Hi All, We are on HP9000 running Unidata 7.1 with SB+ using SB Client 5.3. We have been on MS Excel version 2000 and just upgraded to version 2007. Now the default extension for Excel sheets is: xlsx. When I run the transfer program - TU.TO.EXCEL - it now displays this error message before sending the data to Excel. The file you are trying to open,'SBCLIENT.XLS', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? I can answer Yes and the data will export to Excel. After the job finishes it displays this error: DDE Macro Error Continue I have modified the program that calls TU.TO.EXCEL to use the extension of 'xlsx' but it still gives me the same errors. Is there some other thing that I can do? Thanks for any help that you can provide. Regards, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exporting to Excel after upgrading to MS Excel 2007
This was fixed as of 5.4.2. It uses .TAB as the extension. Not sure what they did about the rename/move problem. -Original Message- From: Colin Alfke Sent: Friday, April 19, 2013 1:26 PM To: 'U2 Users List' Subject: Re: [U2] Exporting to Excel after upgrading to MS Excel 2007 I used the .txt extension (as the file is really a text file). The final DDE macro error is because when it opens the file it uses compatibility mode which uses a smaller sheet size than the newer version and the last step SBClient does is to copy the sheet to a new sheet with a different name. Excel returns an error on the copy because of the different sizes. I never looked far enough into it to determine if it would be easier to change how Excel opened the file or to modify the scripting commands SBClient sent. Hth Colin -Original Message- From: Lunt, Bruce Sent: Friday, April 19, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to Excel after upgrading to MS Excel 2007 Hi All, We are on HP9000 running Unidata 7.1 with SB+ using SB Client 5.3. We have been on MS Excel version 2000 and just upgraded to version 2007. Now the default extension for Excel sheets is: xlsx. When I run the transfer program - TU.TO.EXCEL - it now displays this error message before sending the data to Excel. The file you are trying to open,'SBCLIENT.XLS', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? I can answer Yes and the data will export to Excel. After the job finishes it displays this error: DDE Macro Error Continue I have modified the program that calls TU.TO.EXCEL to use the extension of 'xlsx' but it still gives me the same errors. Is there some other thing that I can do? Thanks for any help that you can provide. Regards, Bruce Lunt ___ 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 env var
Then I'm not going to say anything about the 16384 we used to set it to :) Colin -Original Message- From: Dave Davis Sent: Thursday, March 21, 2013 7:38 AM To: U2 Users List Subject: Re: [U2] unidata env var Uppercase has always worked for me. $VFIELDSIZE and $vfieldsize are distinct variables to the operating system, so I suspect you should stick with uppercase. 6000 - that's huge - what are you putting in these things? I've had to increase to 380 or so before. -Original Message- From: Jeffrey Butera Sent: Thursday, March 21, 2013 6:52 AM To: U2 Users List Subject: [U2] unidata env var We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. -- Jeffrey Butera, PhD ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Apparent Data Problem
It looks like the file variable is getting hammered. Is the VOC item OK? Are you using RCVR as a variable anyplace else? If you are re-opening the file you may need to close it first. Hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, March 21, 2013 4:57 PM To: 'U2 Users List' Subject: Re: [U2] Apparent Data Problem GS: I answered these questions in a subsequent post. I am opening the file ok... the record was whacked. I now merely validate the record ID before continuing in the program. --Bill -Original Message- From: Gregor Scott Sent: Thursday, March 21, 2013 6:53 PM To: U2 Users List Subject: Re: [U2] Apparent Data Problem Bill, If I read the error message correctly the problem is to do with opening the file not reading the record. Are you really opening the file for each record read? Are you sure you are in the account where the RCVR file exists - i.e. does the code cross-log at all? Regards, Gregor -Original Message- snip __ 3.19.13 10R19 072220 M10857300530 222 ** 16516þ16516þN10091þ1þ124þ745240þ0þ60100þ16515þ124.0þ300468300468þþ1þ 1240 3.20.13 10R19 07 N10091 300468 124 ** 16517þ16517þM10762þ1þ13173þ8891775þ0þ6750þ16511þ13173.0þ303253303253 3.21.13 10R11 072232 M1076230325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 3.21.13 10R11 072232 M10762 30325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC ___ 313: open 'RCVR' to fRcvrelse null 314: 315: read rRcvr from fRcvr, rcvrID else rRcvr = '' 316:AP.Invoice.ID = rRcvr20,1 crt '** ' : rRcvr crt 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Replacements for Old SB?
What about Osmosis? -Original Message- From: Tony Gravagno Sent: Tuesday, March 12, 2013 2:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Replacements for Old SB? I'm still running across sites that have 1990's versions of SystemBuilder on different DBMS platforms. What's the latest wisdom on either migrating away from SB to another cross-platform product, or the pain of migrating/upgrading to a current UV/SB+ ? I'm fully aware that DesignBais is very familiar looking to SB users but there are no good conversion tools to get to that product. I'm also aware of another product based in the UK that has excellent tools for migrating From SB, but I don't like where they migrate To. Thanks for your thoughts. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB 5.5
It used to be in the TUSTATE file - not sure if it's changed now or not. It should be buried somewhere in your user account - likely under application data Colin -Original Message- From: Israel, John R. Sent: Tuesday, March 12, 2013 12:53 PM To: U2 Users List Subject: [U2] SB 5.5 OK gurus, here's one for you: Using SB 5.5, I make changes to my settings (like background color) and then Save Configuration As... and give it a New Session Name under the Classic tab. I can now see this as one of the available configurations the next time I log in. Where the heck is this saved? I haven't found any files in the C:\SBClient folder that have today's date. Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Replacements for Old SB?
I'm guessing he meant the decision to stop supporting SB+ on top of D3. We had already migrated most of our customer base to U2 by that point so it didn't hurt us too badly, but even then it seemed like a cut off your nose to spite your face type of decision Colin -Original Message- From: Wjhonson Sent: Tuesday, March 12, 2013 3:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Replacements for Old SB? Not sure what you mean by saying that discontinuing support for SB would make people migrate to U2 ? System Builder and U2 have been married since the days of Ardent. Not all U2 sites use it, I would suggest no more than one third of all U2 sites have ever user System Builder. Maybe you meant that they wanted people to move to .NET and Uniobjects? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wally Terhune
Ditto - although I've never actually met you. Suddenly I'm glad that we're down to 1 last UniData customer Good luck and enjoy!!! Colin -Original Message- From: Brian Leach Sent: December 14, 2012 3: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: 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stripping line breaks from InfoTrieve output
When creating the file he would need to use WRITEBLK... :) The TO syntax will create an Aix file using the Aix linefeed char (10 or 13 - it's been a while). You will have to then have to join the lines together in the format required. It's whichever you find easiest - or is easier for the next guy to support Hth Colin -Original Message- From: Marc A Hilbert Sent: December 12, 2012 5:59 PM To: 'U2 Users List' Subject: Re: [U2] Stripping line breaks from InfoTrieve output Brad, I know nothing about infotrieve, but why can't you use OPENSEQ and then a READBLK loop? READBLK reads the next N bytes from a file, not caring if there are line delimiters of other strange characters. Regards, Marc -Mensaje original- De: bradley.sch...@usbank.com Enviado el: miércoles, 12 de diciembre de 2012 18:19 Para: U2 Users List Asunto: [U2] Stripping line breaks from InfoTrieve output I'm guessing it doesn't matter if this is UD or UV, but I have UD7.1 under AIX. We have a request to extract some data to what I call a tape file. The data is fixed length and there are no line breaks. Just one continuous stream of data. My thought is that this could be accomplished with an InfoTrieve using 'list TO' as in list AGREEMENT F1 F2 TO file.txt There is of course more to it than this, but if I can strip out whatever creates the line break, I think I can do what I need. So my question to the group is: what character(s) are create the new line when ouptutted from an InfoTrieve? Has anyone done this before? I'm thinking I'd used tr or sed to clean things up. Thanks Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
Not anything that has happened to me. It may have to do with the terminal emulation you are using. You could try reset defaults under Setup, Keyboard. I`ve also found changing the SBClient terminal type to ANSI and back can also fix some strange problems. Hth Colin -Original Message- From: Lunt, Bruce Sent: December 7, 2012 3:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012
The public downloads are available at: http://u2.rocketsoftware.com/resources/downloads but the NOV2012 version isn't listed yet. You should be able to get it from the u2bc site. Hth Colin -Original Message- From: Bill Haskett Sent: November 30, 2012 10:19 AM To: U2 Mail List Subject: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012 Trying to find the download link on the U2 site is like trying to find a needle in a haystack! Anyone have an idea specifically where to get these links (I did get the readme)? Thanks, Bill Original Message Subject:U2 Product Release: U2 DBTools vNOV2012 Date: Fri, 30 Nov 2012 09:42:14 -0700 From: u2as...@rs.com U2 DBTools vNOV2012 has been released, 11/29/2012 This release is available for the following versions of these operating systems: OS Platform OS Release(s) Windows x86 XP (SP2, SP3), 2003 (R2 SP2), VISTA (SP2), 2008 (R2 SP1), Windows 7 (SP1) For specific OS and platform support, please reference the database requirements. This product is available immediately via your U2 software provider or by logging into your U2BC account at https://u2tc.rocketsoftware.com. If you need assistance in ordering, please contact u...@rs.com. For any questions on product availability, please contact u2as...@rs.com. Additional Product Information can be reviewed through the Product Matrix at https://u2tc.rocketsoftware.com/matrix.asp Release Notes will be available shortly at: https://u2tc.rocketsoftware.com/downloads/readme/U2DBT-NOV2012.zip If you no longer wish to receive these emailings please amend your profile at https://u2tc.rocketsoftware.com/userprofile.asp ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: [MailServer Notification]Content Filtering Notification
Nope - but I haven't sent anything to the U2 list either... Hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: November 22, 2012 12:40 PM To: U2 Mail List Subject: [U2] Fwd: [MailServer Notification]Content Filtering Notification Anyone see anything like the below? I just received two emails at the same time as my post today. I wonder if this is a U2 group thing. The header information is below the message. Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV11.1.9 uvconfig issue
At UV11.1.9 the shared memory segment cannot be greater than 32 megabytes. When I tried to set the various values for approximately 800 users and have a huge record/group lock table I blew the limit. Suggest you try to pare down as much as possible the lock table if it is large. Colin Lucas Youi Pty Ltd fax +61 7 5443 8106 web youi.com.au youi abbr. you.insured verb. state of being where you save money by taking control of your insurance yourself. youi.com.au noun. place to reach state of being -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 22 November 2012 10:48 AM To: U2 Users List Subject: [U2] UV11.1.9 uvconfig issue I need guidance from those who have battled (and hopefully won!) the UV11 shared memory setup. I am configuring a RHEL6 server with UV11.1.9 to perform some load testing, and am getting an issue with uvregen processing the uvconfig settings. The error is: # uvregen Disk shared memory size of 44759272 exceeds maximum allowed size of 33554432 uvregen: error during regen, process aborted uvregen: error during regen, process aborted # The question is: What setting(s) in the uvconfig file (or in unix) control the maximum allowed size value of 33554432 (32768k, 32mb)? We are tuning for 1040 uv processes (with 10 device licenses per proc, and 2 connection pool licenses and possible 45% phantom process loading), so the following uvconfig settings are in place: NUSERS 15083 SHM_GNTBLS 32 SHM_GNPAGES 480 SHM_GPAGESZ 512 Thanks Gregor 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 This email message and any files attaching to it has been transmitted by Youi Pty Ltd and they are intended only for the addressee(s) and contain information which may be privileged, confidential and/or subject to copyright. If you are not the intended recipient, please destroy this e-mail immediately. For full terms and conditions of this e-mail communication please visit http://www.youi.com.au/terms-and-conditions/email-disclaimer .Youi Pty Ltd is committed to responsible environmental management in carrying out its operations. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV11.1.9 uvconfig issue
I would not consider those values as large. I did ask via our supplier in Australia ( Meier Business Systems) to lodge a case with Rocket to remove the limitation of 32MB particularly in view of our system having 512GB of main memory. Not sure if this will get a look in the upcoming release 11.1.10. Your current values give about 27,000 concurrent locks. Perhaps you can trim the width down and shorten the depth of GSEMNUM if your system doesn't need the possibility of as many locks being set. Colin Lucas desk +61 7 3166 4930 fax +61 7 5443 8106 web youi.com.au youi abbr. you.insured verb. state of being where you save money by taking control of your insurance yourself. youi.com.au noun. place to reach state of being -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 22 November 2012 11:03 AM To: U2 Users List Subject: Re: [U2] UV11.1.9 uvconfig issue Interesting - a fixed ceiling of 32mb. Would you consider the following to be a large lock table: GSEMNUM 193 GLTABSZ 150 RLTABSZ 150 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Lucas Sent: Thursday, 22 November 2012 11:53 AM To: U2 Users List Subject: Re: [U2] UV11.1.9 uvconfig issue At UV11.1.9 the shared memory segment cannot be greater than 32 megabytes. When I tried to set the various values for approximately 800 users and have a huge record/group lock table I blew the limit. Suggest you try to pare down as much as possible the lock table if it is large. Colin Lucas Youi Pty Ltd 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 This email message and any files attaching to it has been transmitted by Youi Pty Ltd and they are intended only for the addressee(s) and contain information which may be privileged, confidential and/or subject to copyright. If you are not the intended recipient, please destroy this e-mail immediately. For full terms and conditions of this e-mail communication please visit http://www.youi.com.au/terms-and-conditions/email-disclaimer .Youi Pty Ltd is committed to responsible environmental management in carrying out its operations. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV11.1.9 uvconfig issue
Glad to hear you have been successful with uvregen. Also thanks for the advice about 11.1.10 Regards, Colin Lucas desk +61 7 3166 4930 fax +61 7 5443 8106 web youi.com.au youi abbr. you.insured verb. state of being where you save money by taking control of your insurance yourself. youi.com.au noun. place to reach state of being -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 22 November 2012 12:51 PM To: U2 Users List Subject: Re: [U2] UV11.1.9 uvconfig issue I would not consider those values as large. I did ask via our supplier in Australia ( Meier Business Systems) to lodge a case with Rocket to remove the limitation of 32MB particularly in view of our system having 512GB of main memory. Not sure if this will get a look in the upcoming release 11.1.10. Just had feedback from Rocket Support that this issue should be addressed in 11.1.10, due November-30. In the mean time, adjusting the NUSERS setting (as a result of reducing our Phantom Loading%), and reducing our locking table has finally resulted in a successful uvregen! Thanks Colin 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 This email message and any files attaching to it has been transmitted by Youi Pty Ltd and they are intended only for the addressee(s) and contain information which may be privileged, confidential and/or subject to copyright. If you are not the intended recipient, please destroy this e-mail immediately. For full terms and conditions of this e-mail communication please visit http://www.youi.com.au/terms-and-conditions/email-disclaimer .Youi Pty Ltd is committed to responsible environmental management in carrying out its operations. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidebugger
It is/was a windows based (thick client) editor for UniData and UniVerse. It has a number of standard editor features like syntax highlighting etc. It is/was included on the clients package. It integrated with dynamic connect which allowed a telnet window in your editor screen. It could use direct disk access, ftp, or UniObjects connections to edit source code. Using UniObjects gave the benefit of locking any items you were editing as well allowing you to debug programs. It allows you to step through programs and watch variables. It's a little flakey when debugging but otherwise works well. I'm pretty sure it's been deprecated in favour of the new BDT editor. hth Colin -Original Message- From: Susan Joslyn Sent: October 26, 2012 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidebugger Hi U2 geniuses. Can anyone help me get the full picture of unidebugger? I thought it was part of wintegrate, but maybe not. I saw something indicating that it will be replaced by bdt - is that just on universe? What is unidebugger, how is it used and is it going away? TIA! Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
In my first programming class in high school (on apple IIe's) we liked to use G$ (with the $ pronounced as string) Colin -Original Message- From: Bill Haskett Sent: October 18, 2012 12:24 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Sort of a carry-over from VB when a string was given a variable name with a '$' in it, usually at the end, or the beginning. Habits die hard. :-) Bill ___ 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
Kevin; The problem is that the initial list is list 0 so that your execute select uses it - regardless of pass/rtnlist. Like David said you will have to save the list items before your select and then restore it to list 0 when done. Another alternative is to use the unibasic select - which loses any index gains and you have to process the file yourself. I don't use rtn/passlist so I'm not sure why they aren't compiling - but if you're using the TO 2 syntax you shouldn't need them and I don't think they'll help you anyway, but I would be surprised that the compiler would catch the double usage. I've used the initial techniques with existing select lists. How list 0 behaves while it's still building is an interesting test. I would like it to work - but am not really surprised that it doesn't. hth Colin -Original Message- From: Kevin King Sent: September 24, 2012 12:20 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists What I don't understand is why I can't seem to get PASSLIST and RTNLIST to work in BASIC. Seems that's exactly what these are intended to do but they give me nothing but compilation failures. [snip] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. ___ 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 think you would be more surprised that an executed select wasn't picking up an active select list :). I do recall getting burned by UniData's select handling while we were transitioning from D3. I had a Y2K program that would go though files and change a 2 digit year that was part of the key. D3 would drop the select where UniData wouldn't and it totally hammered a major file. eg in UniData you can go SELECT CUSTOMERS WITH...; DATE; LIST CUSTOMERS and only see the select list; however, D3 would drop the select list with the date command and the list would list all. In this case, you just don't want it to use the select list as you're trying to do something different. Usually, we have a little more control over where things start out - but it looks like you're trying to create a dictionary item that you intend to use all over the place. UniData has the REQUIRE.SELECT option for lists to make sure it only runs when there is an active select, but I can't think of anything that would ignore an active list. Compounding the question is how does the active select list work while in the middle of the actual select. Like I said, it would be nice that list 0 would contain everything up to that point, so you could save it, process something else, re-activate it and continue selecting. However, it's not hard to imagine someone optimizing the select process might not including this permutation in testing scenarios. The unibasic select works well for ignoring the active list, but necessitates processing the entire file. I think in most cases, we've already had a dense index in place that we can read instead of doing the nested select. hth Colin -Original Message- From: Kevin King Sent: September 24, 2012 3:03 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Thanks for the information. It is unusual that the subroutine works fine without a list but it consumes the active select list if there is one when the subroutine EXECUTES the select command. On Mon, Sep 24, 2012 at 2:11 PM, Colin Alfke alfke...@hotmail.com wrote: Kevin; The problem is that the initial list is list 0 so that your execute select uses it - regardless of pass/rtnlist. Like David said you will have to save the list items before your select and then restore it to list 0 when done. Another alternative is to use the unibasic select - which loses any index gains and you have to process the file yourself. I don't use rtn/passlist so I'm not sure why they aren't compiling - but if you're using the TO 2 syntax you shouldn't need them and I don't think they'll help you anyway, but I would be surprised that the compiler would catch the double usage. I've used the initial techniques with existing select lists. How list 0 behaves while it's still building is an interesting test. I would like it to work - but am not really surprised that it doesn't. hth Colin -Original Message- From: Kevin King Sent: September 24, 2012 12:20 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists What I don't understand is why I can't seem to get PASSLIST and RTNLIST to work in BASIC. Seems that's exactly what these are intended to do but they give me nothing but compilation failures. [snip] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. ___ 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] [UD] Determining number of users licensed
I've tracked the largest number of users logged in - but I didn't have to worry about the max. I had thought it was in the SYSTEM() somewhere - but a quick look through help didn't show it. You could try parsing it out of the @udtbin\smm.log file... It's in there for windows - not sure about HPUX though. good luck Colin -Original Message- From: dean.armbrus...@ferguson.com Sent: September 12, 2012 2:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Determining number of users licensed Is there a way to programmatically determine the number of licensed users allowed? SYSTEM(514) reports the number of non-phantom users currently logged in, which is essentially the number of licenses in use. I want to compare that against the number of users allowed in a monitoring program. I want to know if we're close to the limit before we run out. The number of licenses varies by server. Colleagues have suggested using grep on udtconfig for NUSERS, but that is not the same thing. Since we generally have 100-200 phantom processes, we sometimes configure to a size larger than the license limit to have room for those phantom processes. UniData 7.3.1 HPUX 11.31 Dean Armbruster ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
With the proper security settings you could also see it in the windows event log. Not sure about how to query the Universe telnet server, in UniData there are a number of commands that are actually executables that you can run from a command prompt - like listuser. hth Colin -Original Message- From: Jeff Schasny netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Sub-second delay?
I was just talking with a client this morning that was lamenting the fact that our proposed SQL solution would require 4 VM machines to run a comparable system to his current one on UniData that doesn't have as much processing power as my iphone. (It may also not have as much memory, and is possible that it has less disk space than the phone has RAM...) Colin -Original Message- From: Rutherford, Marc Sent: August 30, 2012 10:19 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? Ah yes, Microdata - my first Pick machine. We were running a 32 user ERP on 64K of main memory and a 30MB drive. Marc Rutherford ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
Perhaps. Anything that would have gone to the screen will go to the _PH_ record (note: if it's firing every 10 minutes you will want to automate a process to clean up the records). You could put some CRT's in your LOGIN/program process to track it better. From a previous note it looked like the crontab item wasn't going properly (you could also put output into your crontab script so you could see when it runs. It could also be as simple as surrounding the statement in quotes as per a previous suggestion - we do on Windows. Good luck Colin From: Charles_Shaffer Date: Thu, 28 Jun 2012 13:03:37 -0500 Subject: Re: [U2] Problem running script from crontab The phantom command will run your login paragraph. Is it setup to allow this process to go through? There should be something in the _PH_ file/folder for when the cron fired off. hth Colin This is interesting. There are files being created in the _PH_ directory for each run (they are 10 minutes) apart. But they are empty. This means that something failed right off the bat right? Charles Shaffer ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
The phantom command will run your login paragraph. Is it setup to allow this process to go through? There should be something in the _PH_ file/folder for when the cron fired off. hth Colin -Original Message- From: Charles_Shaffer Sent: June 28, 2012 10:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding : Usage of the SEL.CMD
It's likely simply a variable being used to run various commands. Is it being used after EXECUTE/PCPERFORM/UDTEXECUTE statements? If so, you'll need to look up the commands that are being loaded into the variable. hth Colin -Original Message- From: satya satya Hi Everyone, Can any Explain What is the use of SEL .CMD? In the program i have observed many times using this statement. but i didn't getting clarity on it. So Let, me know your valuable suggestions on this topic. Thank you, Satya. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Excel Worksheets
Or save yourself the trouble http://www. remove this nebula-rnd.com/products/xlite.htm - There isn't anything in the CSV standard that would create a new sheet and I haven't run across anything that Excel uses. hth Colin -Original Message- From: Israel, John R. I use xml for a few of our fancier reports. My technique is to built the Excel file the way I want it, save it as xls, then pick it apart. Again, it is a lot of work, but they are beautiful. Multiple worksheets, colors, formulas, pane freezing, etc. This might be the brute force method, but it works. John -Original Message- From: George Gallen If you don't mind switching from csv to xml, you define worksheets that way. Google excel and xml and worksheets It's a lot more work, but it works George -Original Message- From: Dave Davis That would be nice. I create separate CSV files and use macros to load each into a separate sheet. -Original Message- From: Jim Koca I am sending a CSV file to excel, and would like to divide it into separate worksheets. Is there a special value I can insert in the file which would cause the following data to create a separate work sheet ? Thanks, Jim Koca ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Dave; A couple more things: - do you have any other processes running at the same time? I found (long ago) that a couple of our big processes ran 5X faster consecutively than they did concurrently. - subroutine calls with file opens. I inherited a process that was running for 3 days and was 65% done. I put all of the file opens in common (well, the file variables) and re-ran in hours. You may want to re-think posting some of the code. There can be some efficiencies found in processing large dynamic arrays. You said it wasn't code you wrote - so try to take the criticism as constructive :) hth Colin -Original Message- From: Tom Whitmore Sent: May 1, 2012 5:50 AM To: U2 Users List Subject: Re: [U2] READU vs READ Hi, The question of READU vs READ when you are doing updates is moot. If you do a READ then a WRITE, UniVerse/UniData will perform the record lock. The only difference is with READ you are gambling that no one else is updating the record before you perform your WRITE. Performance, as others suggested, there are several things to do: Tune your files. If you are using dynamic files, make sure you have the MINIMUM.MODULUS set to reduce the shrink and merging If the records are lumpy redesign them so you have a header file and a detail file, with detail files being individual records for the associated values. Use LIST.INDEX with the STATISTICS option to see if you have huge index value, you may need to refine the index. Check your hardware, you may have a bottleneck due to slow disk, I/O pipe. Minimize the number of times you go through the associated values. Use READU with the LOCKED clause, if the record is locked, add logic to queue it up and try the records again once everything else is processed (WRITEs will hang on a lock if you don't have the LOCKED clause, just like a READU without the LOCKED clause. Good luck! Tom RATEX Business Solutions -Original Message- From: Symeon Breen Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: Dave Laansma Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EXIT ; EXIT inside a loop
Just note that this would execute the twisting little logic that I'm *assuming* the second exit was meant to avoid. I'm also assuming that somewhere in the logic either G or H is modified otherwise you should test them first and avoid the loops altogether. :) (niggly point - the use of exit makes your use of a2.done redundant). To answer the original question, I don't usually use exit, but I would expect the second one to be skipped as that is exactly what the first one is meant to do! hth Colin -Original Message- From: Lunt, Bruce Sent: April 19, 2012 2:50 PM To: 'U2 Users List' Subject: Re: [U2] EXIT ; EXIT inside a loop You could add logic to the For Next as in: A1.DONE = FALSE A2.DONE = FALSE FOR A1 = 1 TO X UNTIL A1.DONE FOR A2 = 1 TO Y UNTIL A2.DONE little twisted logic IF G = H THEN A1.DONE = TRUE; A2.DONE = TRUE; EXIT twisted little logic NEXT A2 twisting little logic NEXT A1 little twisting logic The question is, if G = H, will the two EXIT commands drop out of both loops, skipping BOTH twisted little logic and twisting little logic, and resume execution at little twisting logic ? PLOUGH Sincerely, David Laansma ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Account Permissions
It kind of looks like a missing write permission somewhere. I would try the VOC in MyAccount, see if you can write to the 'Q' pointer. Telnet is a little different. I tells customers that they need to setup the telnet user so that they are able to login at the console. Older versions of Windows had defaulted permissions on users that allowed this, the newer ones don't - although I haven't had to setup a 2008 box. It sounds like the user can telnet in though - just to another account. We were lazy when setting up our accounts. We simply have a group created with full permissions on the UD folder and then we put everything under it. A little funny considering our target market - but over 20 years I only had one security related incident. hth Colin -Original Message- From: Bill Haskett Sent: April 17, 2012 5:13 PM To: U2 Users List Subject: Re: [U2] UD - Account Permissions Colin: The funny thing is, this is a local user. The network doesn't use a domain (it's a server network). I'm a valid user and I can log onto any other dbms account. When I try to telnet into this one account I get: Unable to set current directory to E:\Advantos\MyAccount But, I log into another account, set a 'Q' pointer to MyAccount's (VOC) file, or any other file for that matter, and I can list the contents of any of the files. This tells me the permissions are fine. UniObjects has no trouble connecting to the account and neither does mv.NET using UO.Net (I'm using a user id that is a member of the UniDataUnique group). This particular user can't telnet in either. When I try to telnet in using my credentials, which happen to be the owner of everything under the dbms account's directory, it fails too. So, I guess I'll just put the permissions back to the way they were and forget about this, as telnet accesses something UO doesn't. :-( Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Account Permissions
Bill; There are a couple of windows permissions (log on locally, access this computer) that need to be enabled for the user for telnet user (at least as of 2003). hth Colin -Original Message- From: Bill Haskett Sent: April 17, 2012 10:27 AM To: U2 Mail List Subject: [U2] UD - Account Permissions I've been tinkering with the permissions on an account in UniData. We run Windows 2008 R2 and UD v7.1.12. I have one account where I removed all permissions, assigned me as the owner, then assigned me and a unique group (UniDataUnique) as having full control of the entire account directory. I propagated all permissions down into the directory. So, every object, within the account directory, gives full permissions to me and the group UniDataUnique. I assigned the group UniDataUnique to the DesignBais user (the user authorized to access the dbms via UniObjects). I cannot login via telnet. I can login via UniObjects through DesignBais. I can log into another dbms account, create a Q pointer to the voc of the restricted dbms account, and list the contents of the restricted VOC. I can't list the Q file if I'm anyone else. Is there something peculiar with telnet that I can't log into this account? Naturally, when I add the administrators group to the account's permissions I can login via telnet. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Can I automate Wintegrate BridgeCopy?
Can you not copy the index files as well (X_filename)? Otherwise, you could create script to create a dummy X_filename and running delete.index to simply remove the index (at this point you could also script the re-creation of the index if you would prefer). hth Colin -Original Message- From: Beverly Wilson Sent: April 17, 2012 9:11 AM To: U2 Users List Subject: Re: [U2] Can I automate Wintegrate BridgeCopy? Thanks, Jake. We're running Unidata on unix, and I'd considered an sftp transfer, but since the majority of the files are indexed, I didn't think that would work out for me. Appreciate your response. --bev At 4/13/2012 10:45 AM, you wrote: You can call uv.exe (on windows) from a cmd prompt and use it to run a command. Just create a simple batch file and add it to your OS scheduler -Original Message- From: Beverly Wilson Sent: Thursday, April 12, 2012 3:47 PM To: U2 Users List Subject: [U2] Can I automate Wintegrate BridgeCopy? Hi Folks, I've got several files I need to transfer between our live and test servers. Ideally, I would write a Unibasic program to take the list of filenames and feed them into the RunBridgeCopy command. However, I've been unable to determine how to do it, if it is even possible. I found WIN.INVOKE documented in the Wintegrate host commands manual, but that doesn't appear to allow for feeding in the variables I've assigned that hold RunBridgeCopy's options (SourceFile, TargetFile, etc.). I tried doing this with ViaDuct (One-step Copy) but that bluescreens my PC. Any suggestions on where I can read documentation on this, or can anyone tell me that it can't be done? Regards, --bev Beverly Wilson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring a U2 server?
UniAdmin has a fairly comprehensive monitoring system. You can look at it for inspiration (or show it as proof of concept, or just use it). I haven't checked XAdmin though. hth Colin -Original Message- From: Rutherford, Marc Sent: April 13, 2012 9:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Monitoring a U2 server? I have a request to help setup a monitoring process for Unidata on HP-UX. So far the outside tools have not been specified, but will most likely be MS Windows based. I am looking for any examples/documentation on what can be done to provide visibility into system status. Has anyone done something similar before? What Unidata and/or HP manuals should I look for? Marc Rutherford ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Export Telnet Registry Users (Win 2K3) and Import to Windows 2008 R2
I think there might be a technote on how to do this. I'm pretty sure Rocket has one and MS may as well... hth Colin -Original Message- From: Bill Haskett Sent: April 12, 2012 3:30 PM To: U2 Mail List Subject: [U2] UD - Export Telnet Registry Users (Win 2K3) and Import to Windows 2008 R2 On Windows 2K3 Server, UniData keeps telnet users as (a) registry entry(s) in: HKLM\SOFTWARE\IBM\UniData\7.1\UDTelnetD\users I can export this node to a .reg file on the desktop. I'd like to know how to import it into a Win 2K8 R2 machine; which goes into a different registry node: HKLM\SOFTWARE\Wow6432Node\IBM\UniData\7.2\UDTelnetD\users Has anybody exported from one node on a Win 2K3 machine to another node on a Win 2K8 R2 machine? I'm guessing all I have to do is edit the .reg file, change the registry paths, copy the file to the new server, then double-click it. Other than leaving the 2nd line blank, is there anything I should be looking out for? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] u2ug.net Website
Anyone else unable to connect to www.u2ug.net? I'm getting the following error: Server Error 401 - Unauthorized: Access is denied due to invalid credentials. You do not have permission to view this directory or page using the credentials that you supplied. www.u2ug.org redirects to http://109.104.64.69/cms/ which is unavailable. Thanks Colin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2ug.net Website
Can't get to Spectrum or u2ug.net? Brian's fixed the website - good job! I thought I convinced my boss a couple years back to send me next year - but then they sold the company to a SQL based competitor... -Original Message- From: John Thompson Sent: April 3, 2012 1:34 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website If you guys came to Spectrum, you would have less time to go on u2ug.net. I kid of course... I can't get to it either. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2ug.net Website
Yeah, I thought .org redirected to .net at one point. I did ask in the website forum about email (as it's still using .org). I tried to ask Laura Hirsch why the change was made but was having trouble with my email and I don't think the question ever got out. Brian, if it's supposed to redirect - it's not doing it now. Today's been a good day, but we have a snowfall warning so it may change Colin -Original Message- From: Bill Haskett Sent: April 3, 2012 3:55 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website Colin: The domain was changed from u2ug.org to u2ug.net. I think the .org was going to Brian's IP address and is the one that doesn't work. Not sure why they changed the domain. Sometimes we all have days like these. :-( Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to UPCASE in a Paragraph?
You may need an actual dictionary item rather than pulling something from the VOC -Original Message- From: George Gallen Sent: March 28, 2012 3:39 PM To: U2 Users List Subject: Re: [U2] How to UPCASE in a Paragraph? I have a records that match what I'm looking for..It's just not finding records matching the EVAL. It's working on some files, but not on others..something isn't right. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] odbc error Unable to get UCI configuration file from Registry
Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI config file editor I have options to Get Registry and Reset Registry under File. Perhaps that will help hth Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 10:29 AM To: .U2 List Subject: [U2] odbc error Unable to get UCI configuration file from Registry I'm running Universe clients 10.3 against a server running 10.3, and I've done something with my configuration that I can't resolve. When I attempt to test the connection within the Universe ODBC Data Source Setup, I consistently get this message: [IBM][UVODBC]90301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; Msg:[U2][SQL Client]Unable to get UCI configuration file from Registry.. I've de-installed the driver, cleaned the registry, re-installed the driver, removed all Universe client applications/tools, re-installed them, loop-repeat. I know it's not the software itself, because we're using the same tools here on similar laptops running the same OS, (windows-7 32bit), without issues. I've looked through the archives, looked through Experts-Exchange, and googled a number of times. Has anyone seen this before - and resolved it? Thank you. -- Allen Egerton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] odbc error Unable to get UCI configuration file from Registry
It was worth a shot - sometimes people miss the easy stuff because they're concentrating too hard on the complicated stuff. It's been close to 10 years since I've really looked at ODBC/OLE access to UD. I see it's as cryptic as it ever was. I seem to recall an old issue that required the UCI file to have a blank line at the end - but I'm pretty sure it had a different error. I remember it worked well once you had the right driver (I had one that would work with Access but not Excel?!?!?) and you pedantically followed all of the steps (even so far as casing on a windows box which is normally case insensitive). Good luck! Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 11:07 AM To: U2 Users List Subject: Re: [U2] odbc error Unable to get UCI configuration file from Registry Hi Colin, Sorry, I wish it was that simple. After I went through the exercise a couple of times, I got our tech support involved. He's done at least several dozen of these installs, (if not more), and he couldn't resolve it either. We've opened a ticket with Rocket, I figured I'd try here because if it's happening to me, it's probably happened to someone else here, and I might be able to get this resolved reasonably quickly. And of course, it's not that I need ODBC access in and of itself, but rather that I need it to test something I'm developing... Thanks. On 3/16/2012 12:53 PM, Colin Alfke wrote: Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI config file editor I have options to Get Registry and Reset Registry under File. Perhaps that will help hth Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 10:29 AM To: .U2 List Subject: [U2] odbc error Unable to get UCI configuration file from Registry I'm running Universe clients 10.3 against a server running 10.3, and I've done something with my configuration that I can't resolve. When I attempt to test the connection within the Universe ODBC Data Source Setup, I consistently get this message: [IBM][UVODBC]90301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; Msg:[U2][SQL Client]Unable to get UCI configuration file from Registry.. I've de-installed the driver, cleaned the registry, re-installed the driver, removed all Universe client applications/tools, re-installed them, loop-repeat. I know it's not the software itself, because we're using the same tools here on similar laptops running the same OS, (windows-7 32bit), without issues. I've looked through the archives, looked through Experts-Exchange, and googled a number of times. Has anyone seen this before - and resolved it? Thank you. -- Allen Egerton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client PE download
There is a version of SBClient in the SB/XA download although it's set to work with SB/XA and not SB+. hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: March 7, 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
Re: [U2] SB Client PE download
Sorry if I caused some confusion. I had thought Rocket was trying to get away from the SB+ naming conventions with SB/XA. When I said it won't work with SB+ I meant SB+ versions prior to the version in SB/XA. As Steve, David, and Dan have confirmed - SBClient 6 won't connect to prior versions of SB+. So if you're a VAR or consultant that needs to connect to various versions SBClient 6 isn't a good fit. Colin -Original Message- From: David Wolverton 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: Daniel McGrath 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: Steve Long 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 -Original Message- From: Daniel McGrath 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: Laura Hirsh 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: Daniel McGrath 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: Laura Hirsh 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
Re: [U2] SB Client PE download
I'm not sure if Dynamic Connect is still in the client download. It can work quite well - with some setting up of a new terminal type. It won't do GUI or any of the TU applications (file transfer, Excel Downloads, etc) but it works nicely as a terminal program. hth Colin -Original Message- From: Laura Hirsh 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: David Wolverton 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client PE download
Definitely price and perhaps inter-operability with SB+. I've used AccuTerm - just never to connect to SB+. P.S. What's with your e-mail client and dropping characters?!?!?!? -Original Message- From: Wjhonson So what's the advantage over AccuTerm ? -Original Message- From: Colin Alfke I'm not sure if Dynamic Connect is still in the client download. It can work uite well - with some setting up of a new terminal type. It won't do GUI or ny of the TU applications (file transfer, Excel Downloads, etc) but it orks nicely as a terminal program. hth olin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date Problem
Will's on the right track. @DATE (and @TIME) are set when the original program is executed. In most use cases @DATE is interchangeable with DATE() so most don't notice the difference. Although @DATE is available in dictionaries. It's likely that that one program can be traced back to a program running since then. Here is a really quick test: TEST.CALL.TIME CRT 'orig program' CRT '@TIME ':OCONV(@TIME,'MTS') CRT 'TIME() ':OCONV(TIME(),'MTS') CALL TEST.TIME CRT 'SLEEP 20 in orig program' SLEEP 20 CALL TEST.TIME CRT 'orig program' CRT '@TIME ':OCONV(@TIME,'MTS') CRT 'TIME() ':OCONV(TIME(),'MTS') TEST.TIME CRT '@TIME ':@TIME : :OCONV(@TIME,'MTS') CRT 'TIME() ':TIME(): :OCONV(TIME(),'MTS') CRT 'SLEEPING 10 SECONDS' SLEEP 10 CRT '@TIME ':@TIME : :OCONV(@TIME,'MTS') CRT 'TIME() ':TIME(): :OCONV(TIME(),'MTS') RETURN Output: :TEST.CALL.TIME orig program @TIME 13:25:23 TIME() 13:25:23 @TIME 48323 13:25:23 TIME() 48323 13:25:23 SLEEPING 10 SECONDS @TIME 48323 13:25:23 TIME() 48333 13:25:33 SLEEP 20 in orig program @TIME 48323 13:25:23 TIME() 48353 13:25:53 SLEEPING 10 SECONDS @TIME 48323 13:25:23 TIME() 48363 13:26:03 orig program @TIME 13:25:23 TIME() 13:26:03 You can see how the @TIME variable carries the same value throughout. @DATE works the same way. hth Colin Calgary, Canada -Original Message- From: Israel, John R. I have an INCLUDE that I use in ALL programs I touch. It simply does a bunch of assigning of variables so that I can use them as needed. One of these assignments is: TODAY = @DATE I have 1 program in 1 account that is consistently returning: 16066 (which is 12/26/11). This program is initiated via a Redback call but so are many many others. In the pgm that is failing, immediately after my INCLUDE, I just added code to write the following to disk: TODAY DATE() @DATE Both TODAY and @DATE ALWAYS return 16066 for this 1 program, but no others. The same program is working correctly in other accounts, and the value of TODAY is correct in EVERY other program I have ever used. Does anyone have a clue? I could replace @DATE with DATE() in my INCLUDE, but to do my due diligence, I should recompile EVERY program that uses the INCLUDE (and that is NOT going to happen). John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Missing Screen
The problem's obvious: you're working during your vacation!! Sorry, I don't know how PRC pushes the updates - but I'd start with /XP or /MP and go through the processes to make sure everything's calling what I expect (guessing that PRC didn't overwrite a current process that is setting things so it goes straight through). Good luck and Happy Holidays! Colin -Original Message- From: Israel, John R. I am dying here! We use PRC to push our SB stuff from TEST to PILOT and then from PILOT to LIVE. I wrote a new process in TEST that works perfectly. It looks for some txt files to import. If found, and you hit F2, it does some validation before importing. No problem. I used PRC to move this to PILOT, but when I run the process in PILOT, the screen never displays at all, and I start getting the SB.DISP messages as if I had hit F2. I have deleted the process and screens from PILOT and re-loaded - no effect. I have made changes to the process and the screen in TEST and re-loaded - no effect. I am not getting any errors, it just does not display the screen and immediately starts running the code as if the user had hit F2. I have been trying to get this to display the screen in PILOT for hours (on my vacation!), but have completely run out of ideas. Any thoughts? John Israel Senior ERP Developer ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Corrupted compiled code
I tried VCATALOG on a directly catalogued item and received the same error. The help does say it checks the global catalog file. I usually compare the time/date stamps on the original vs the compiled as we usually only compile immediately after saving the record. Colin -Original Message- From: Bill Haskett Thought I'd try the VCATALOG verb and got: :VCATALOG DTABP BUILD.HEADING BUILD.HEADING errno=2: No such file or directory Program 'BUILD.HEADING' does not verify. :AE VOC DTABP Top of DTABP in VOC, 3 lines, 28 characters. *--: P 001: LD 002: @ABO_SYS\BP 003: @ABO_SYS\D_BP Bottom. *--: EX Quit DTABP in file VOC unchanged. :LIST DTABP SAMPLING 5 LIST DTABP SAMPLING 5 12:06:01 Dec 22 2011 1 BP 123CONV.ASCII ACCT-INDEX ACCT.REINDEX ACH.CREATE ACH.PROCESS 5 records listed I read the documentation and don't know where I went wrong. I did make sure the problem occurred after I disconnected. I was using a UO connection and made sure the connection was killed, logged off, and tried again with the connection restarting each time I tried again. I also ran the Dell hardware tests and all results showed no problems. The weird thing about the checks, a few days ago, is one of our beta testing clients was running checks all day. It was just me that was having problems. Secondly, the other problem we were all having was limited to one dbms account. The same code ran just fine on all the other accounts. Last night I restored the application code account from a few days ago. A look at the date/time stamps for the _ object code shows nothing unusual. One program was recompiled during the last total recompilation on Aug 19, while another was recompiled on Oct 24. Thanks, Bill - Original Message - *From:* WTerhune You might try checking the source/object with VCATALOG after a problem occurs and before you recompile. What I'm hearing Bill say is that object code on disk has changed (apparently). As someone else suggested - check time/date of object also to see if this has changed after what you believe to be the last compilation. If a problem occurred, but did not re-occur after exiting and starting a new udt session - that feels like 'flaky memory' or some problem with udt.exe that has corrupted the memory for that process (think exception violation). If the only correction is to generate new object code (that presumably is not identical to what had been used), then you start thinking about disk or utilities that could touch files/objects on disk. Wally Terhune U2 Support Architect Rocket Software ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Corrupted compiled code
Ouch. I've never seen that. Did you check the time/date stamp on the compiled code? The only vaugely similar thing was data files getting corrupted. But that was only on writes and the problem was with some driver issues with the drive controller and network card. You may want to check with Rocket to see if there are any known issues - or create one Colin Date: Tue, 20 Dec 2011 19:40:19 -0800 From: wphaskett To: U2-users@listserver.u2ug.org Subject: [U2] [UD] Corrupted compiled code I've been using UD for a number of years. I'm currently using v7.2.7. Occasionally, the compiled code gets corrupted. I notice when a client calls and indicates something doesn't work. Today I couldn't create an A/P check. After a few hours I tracked down the following message: In E:\Abo\BP\BP\_APCHECK at line 60 can not use debugger for background job In E:\Abo\BP\BP\_M.APCHECK at line 343 Phantom run basic error, exit 4. Line 60 of APCHECK looks like: IF GUIMODE THEN SuppressCRT = 1 ELSE SuppressCRT = 0 I figured I'd left a DEBUG statement in APCHECK when I called M.APCHECK (which executes APCHECK from a phantom). I didn't! Everything looked good. I finally added a simple VOC debug-record-writev to theAPCHECK program , recompiled it and reran the process. All worked fine! I took out the debug code and everything works fine. So, recompiling was all it took because the object code was corrupted somehow. Yesterday, I spent 12 hours tracking down an intermittent browser crash for one of our clients and finally came to a BUILD.HEADING program I've been using since 1995. What happened was that SYSTEM(2) was returning the value 1024 instead of 80. So, when I created a three line heading and centered stuff on each line, instead of 30 (or so) spaces created on each side of the heading line I had about 450. When the heading info was added to the ECL command the line was too long and barfed when it was executed. No error message appeared anywhere so it was with a lot of effort I was able to track this down. Upon adding a writev-debug-line and recompiling, everything started working just fine. I removed the debug line and all is working well. Naturally I've recompiled everything and rebooted the server, but this is a major pain in the a$$! Does anyone know why code that's been used for months, and maybe years, would get corrupted like this? Everything is compiled with the '-Z2' option and all cataloging is local (DIRECT FORCE). Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extract first and last name from free-form name
Or you could use pre-packaged software to do it for you. I've used ParseRat http://www.guysoftware.com/parserat.htm for parsing report output and it worked really well - although the interface is getting extremely dated. Haven't tried it for names - but it would be way easier than reinventing the wheel Colin -Original Message- From: Bill Haskett As usual, one has to ask if the complexities involved in managing all potentialities ensures that the simplest, and by far the most usual, scenarios are at best difficult to implement. :-( Bill - Original Message - *From:* symeon You need to do a proper lexical analysis in order to work these out For example Input : Dean Foster Lex: title word Input: Dean Reginald McGraw Lex: title word word Then set rules to say a lex of title word is probable worked out as forename surname and a lex of title word word is probably title forename surname you can assign probabilities against these and build some self learning in. It is a whole massive topic. -Original Message- From: Mecki Foerthmann And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields in the input screen and keep them as separate attributes. You never get it 100% right. In your list take Dean or Prince for instance - they could be first names and not titles at all. A colleague of mine tried a last name upper to lower case conversion including Irish and Scottish names and out of Machine Co it made MacHine Co. And don't even ask what happened to last names starting with O.:-) On 14/12/2011 01:02, Charlie Noah wrote: Great start, but here is a longer list, although still nowhere near complete: Prefixes Code Description 1st Lt First Lieutenant Adm Admiral Atty Attorney Brother Brother (religious) Capt Captain ChiefChief Cmdr Commander Col Colonel Dean University Dean (includes Assistant and Associate) Dr Doctor (Medical or Educator) ElderElder (religious) Father Father (religious) Gen General Gov Governor Hon Honorable (Cabinet Officer, Commissioner, Congressman, Judge, etc.) Lt Col Lieutenant Colonel Maj Major MSgt Major/Master Sergeant Mr Mister Mrs Married Woman Ms Single or Married Woman Prince Prince Prof Professor (includes Assistant and Associate RabbiRabbi (religious) Rev Reverend (religious) Sister Sister (religious) Suffixes Code Description II The Second III The Third IV The Fourth VThe Fifth CPA Certified Public Accountant DDS Doctor of Dental Medicine Esq Esquire JD Jurist Doctor Jr Junior Jnr Junior (British) LLD Doctor of Laws MD Doctor of Medicine PhD Doctorate Ret Retired from Armed Forces RN Registered Nurse RPh Registered Pharmacist Sr Senior Snr Senior (British) DO Doctor of Osteopathy Perhaps others can add more to the list. Regards, Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds Info, Forum: http://www.TinyBearMarketing.com Store:http://Stores.TinyBearMarketing.com On 12-13-2011 5:12 PM, Wjhonson wrote: 0044: SUFFIXES = ,JR,SR,MD,III, 0045: S.NAME = DCOUNT(UM.NAME,' ') 0046: LAST.WORD.IN.NAME = FIELD(UM.NAME,' ',S.NAME) 0047: IF INDEX(SUFFIXES,,:LAST.WORD.IN.NAME:,,1) THEN 0048: LAST.NAME = FIELD(UM.NAME,' ',S.NAME-1) 0049: END ELSE 0050: LAST.NAME = LAST.WORD.IN.NAME 0051: END 0052: PREFIXES = ',DR,MR,MS,MISS,MRS,' 0053: FIRST.WORD.IN.NAME = FIELD(UM.NAME,' ',1) 0054: IF INDEX(PREFIXES,,:FIRST.WORD.IN.NAME:,,1) THEN 0055: FIRST.NAME = FIELD(UM.NAME,' ',2) 0056: END ELSE 0057: FIRST.NAME = FIRST.WORD.IN.NAME 0058: END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB print output question
Taken from the help output: This outputs the report in DIFF format (comma delimited) in the xxWORK file. Item ids are 'SBDIF.':port:'.':page and are used to transfer SB+ database records into DOS speadsheet programs. It's built into the SB+ Report writer. It's the Data Interchange Format. hth Colin -Original Message- From: Wjhonson What is a Diff ? What sort of output is that? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and SQL
Sorry, I'm a UD guy. Not sure when EDA was added to UV - but yes, it is powerful. No, you can't use syntax quite like that. You can use BCI - see the UniVerse BASIC SQL Client Interface Guide for syntax and examples. What it does is create an ODBC connection that you can use - much like below. Colin -Original Message- From: Wjhonson To be clear, I'm only trying to query the database at the moment. EDA looks pretty powerful, IF you upgrade. Can I execute a command in Universe like SELECT NAME, ADDRESS, ZIP FROM someexternaldatabase WHERE DATE = TODAY() ORDER BY DATE Can I do that in Universe 9.6 ? Or 10.2 ? And it will use the built-in SQL processor that comes with Universe ? Not to update the database, just to query from it? And if so, is there documentation on doing this query from an external database ? -Original Message- From: Colin Alfke Sure. They have EDA (originally a number of SQL type DB's but IBM reduced to B2 and now Rocket is adding them back) and BCI - an ODBC connection irectly from Basic. hth olin Alfke algary, Canada -Original Message- rom: Wjhonson see a lot of stuff on Universe accessing it's own files as SQL tables, and lso on how you can use OLE to access Universe tables using SQL. But can Universe, access SQL tables which are *not* in Universe? hey are just other SQL tables in other places around the network that sually is update by other non Pick software. Can Universe also access those tables? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] End of Month date routine
That's better. It wasn't the ';' in the last one that caused the problem - especially with a generic routine - it was the reliance on the date format being m/d/y (which Dave's original noted). Not sure why you're trying so hard to compress the lines. This routine will easily fit in pretty much any screen... I actually liked the 32 better. It just seemed to make a clearer connection to next month for me. -Original Message- From: Wjhonson I changed Marco's code slightly using Oconv to make it more clear what DD is doing and make it more generic I'm also adding 40 instead of 32 to make it clear that we don't care how much we are adding as long as it's between 32 and 57 To make it clear what this is doing, we are taking the internal date, and subtracting from that the day number on which we are running. This will *always* give you the last day of the previous month. Always. Then we add enough to jump us into the next month anywhere, doesn't matter at all. And then do the same trick again, which will *always* give you the last day of the month in which you are running This is a fantastic bit of magic. TODAY = DATE() ; LAST.MO.END = TODAY - OCONV(TODAY,'DD') A.DAY.NEXT.MO = LAST.MO.END + 40 END.OF.MO.DATE = A.DAY.NEXT.MO - OCONV(A.DAY.NEXT.MO,'DD') ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] End of Month date routine
Doesn't work for me :( Tried on UD 7.1.6 and UD 6.0.12. It works for December, but I changed it to March and it gave me January 3rd. UniData does have a nice function LAST_DAY(x) for using in virtual attributes to return the last day of the month for the date passed to it. hth Colin Calgary, Canada -Original Message- From: Wjhonson Thanks to everyone who responded This is with what I ended up MONTH = OCONV(DATE(),'DM') ; YEAR = OCONV(DATE(),'DY') IF MONTH = 12 THEN MONTH = 1 ; YEAR += 1 ELSE MONTH += 1 FIRST.OF.MONTH = ICONV(MONTH:/01/:YEAR,'D') END.OF.MONTH.DATE = FIRST.OF.MONTH-1 The only point of line 3 is for clarity so the next programmer doesn't stare at this for ten minutes going WTH? You could combine 3 and 4 into a single line END.OF.MONTH.DATE = ICONV(MONTH:'/01/':YEAR,'D')-1 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
It probably does this to keep it simple. If the pooled connection had to keep logging to different accounts for each of its connection it would have to keep track of where it was and which connection used which account. This would likely slow it down and open an attach vector that could be exploited. Not impossible to do - but may not be a good risk vs. return for Rocket. At least until we can get more vendors to host multi-customer based servers. Colin -Original Message- From: Bill Haskett That always seemed just /*wrong*/ to me! I could never figure out why a connection pool license would work this way. Sure puts a crimp on a number of potentialities. :-) Bill - Original Message - *From:* symeonb A pooling connection goes into 1 single account yes We have a special shared account for the pools with voc pointers to the real customer accounts . Part of the message passed to the backend is the customer so it opens the correct files etc. -Original Message- From: Bill Haskett Symeon: Your pooling connection is set up for a single dbms account, correct? You'd need a separate pooling license for each dbms account to access, correct? That is some dance you need to go through to do what, basically, the computer is supposed to do! Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I-Type question in PH
UniData has the _PH_ file which is a DIR type file. There is the DIR() function that will return a lot of information for you without the expense of opening the file. Perhaps UniVerse has something similar. See http://www.pickwiki.com/cgi-bin/wiki.pl?GetOsInfo for examples and code on how to use it to get the OS date/time/size quickly and easily. hth Colin Calgary, Canada -Original Message- From: Perry Taylor If you don't want to mess with the nuances of the PH ID you can call a subroutine which does an OPENSEQ then uses STATUS to get the modification date right from the file system. Perry - Original Message - From: Charles Stevenson You can also get elapsed time by subtracting that ID date-time stamp from the os's date-time-modified stamp, which is when the job ended. (if the job writes to the PH log as it ends.) On 11/29/2011 4:01 PM, John Thompson wrote: Yep... need more sleep. Thanks. On Tue, Nov 29, 2011 at 4:58 PM, Wjhonson wrote: Third field, not second field FIELD(@ID,'_',3) -Original Message- From: John Thompson So I thought I would build an I-type to get the date of thePH items in niverse so I could more easily purge them... The item id looks like so: AUTOMATED.UPDATE.REO_23400_15641 The friendly manual says that the item id is: hantomverb_time_date So my I-type looks like so: 001 I 02 FIELD(@ID,'_',2) 03 04 Date 05 10 06 R And of course, I have not put in the conversion code yet... The output of the I-type is this: ID.. Date.. AUTOMATED.UPDATE.REO_23400_15641 23400.0 What am I missing? Shouldn't Date be 15641? -- ohn Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse to UniData Conversion
Depending on what you are looking for the SCMP(x,y) function may be what you are looking for. Or you can always append a letter to each string you are comparing to force a string comparison. hth Colin Alfke Calgary, Canada From: David I am converting some UniVerse code to UniData. The UniVerse code has a COMPARE function for comparing strings rather than just an = to handle some quirks about string comparisons of numbers. Is there an equivalent in UniData. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting an account from UniVerse to UniData
I thought Dave Taylor from Sysmark might reply to this. They have some tools for dumping accounts that may be what you are looking for. It also looks like Doug's Xlr8 editor may also do this now. hth Colin Alfke From: David Does anyone have experience converting a UniVerse account to UniData. I have used the UV_RESTORE. It creates the files but does not copy the data. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Collaboration
I take it you find the SB+ /COMPARE tool a little wanting -Original Message- From: Steve Romanow Something I have long desired is diff tool for mv records (that will use standard diff/patch output) so it can integrate with other tools. Maybe a packager for SB+ A diff tool for SB+ that understand what records make up an SB+ object. I started some thinking this direction on a sourceforge project, but got busy on many other things. On Wed, Nov 16, 2011 at 5:06 PM, Rex Gozar wrote: So what collaborative project do you want to start? What do you want to build? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ / WRITESEQ and UniObjects
I'd guess it was some type of permission error. Does the user you are connecting with through UniObjects have write permissions on the folder that the open/writeseq is writing on? hth Colin Alfke Calgary, Canada -Original Message- From: Holt, Jake It fails to write. It gives the failure to open error as well, but I believe that is fairly standard if the file doesn't exist before hand. It operations normally, just doesn't write the records to the file. -Original Message- From: Steve Romanow I don't know if we have enough information. Does it start? No output whatsoever? IIRC, you can tell writeseq not to cache and to write to disk immediately. On Fri, Nov 4, 2011 at 3:03 PM, Holt, Jake wrote: I wrote a program to export some data using openseq/writeseq (to a local server drive, tried a UNC path too) and it works perfectly until I try to call it using UniObjects. Is this normal behavior? If so, anyway to make it work with UniObjects? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD Re-indexing
We don't use multi-level files, but usually when I see the permission denied it means a user has the file open at the OS level. I usually use PSTools to find it. When you delete.index ... ALL it actually deletes the X_... file so you get this message if someone has it open. hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I run UD v7.2.7 on a Windows 2008 R2 machine. I've an account that has administrator and unidata group permissions assigned for full control. However, when I try to delete, recreate, then build the index on a particular multi-level file I get: ...removing indexes for APOPEN file... No indices created on file APOPEN ...removing indexes for APOPEN,HISTORY file... errno=13: Permission denied Delete index file 'APOPEN\X_HISTORY' failed ...now creating indexes for APOPEN... INDEX_1.HISTORY: can not create multiple indices on same location No new indices are created ...now creating indexes for APOPEN,HISTORY... One * represents 1000 records 8057 record(s) processed. [Colin] [snip] Does anyone know what's happening here and why I'm getting a permissions error? Things I didn't try; reload Windows, reinstall UniData, deleting and re-creating the data file. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and the LOCKED Option
I've usually only used it where I expect one user to be accessing the file at a time anyway. However, it should (mine does on UD 7.1.6) compile. You are using an END before the next THEN or ELSE - that might do it. hth Colin Alfke Calgary, Canada -Original Message- From: Al DeWitt Unidata 7.1.20 ECLTYPE P Whenever I try to include the LOCKED option in the OPENSEQ statement my test program does not compile. If I leave it out it does compile. When two users run this program one executes the OPENSEQ command and the other appears hung...no message, nothing. When the first user closes the file the second user continues on. Since LOCKED appeared to allow me to tell the other users that the file is locked and not to give up hope what do you folks do to get around this dilemma? Thanks. Al ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and the LOCKED Option
You need to change line 6 to END ELSE (to end the locked clause) -Original Message- From: Al DeWitt Here is my admittedly simple test program and the results: 001: IMPORT.FILE = FILE_IN.CSV 002: CLOSE.IT = 1 003: OPENSEQ DELTAIMPORT,IMPORT.FILE TO FILEIN 004: LOCKED 005: CRT 'FILE IS LOCKED BY SOMEONE ELSE' ; DUMMY='' ; INPUT DUMMY 006: ELSE 007: ERR.CD = STATUS() 008: CRT 'ERROR CODE=':ERR.CD ; DUMMY='' ; INPUT DUMMY 009: CLOSE.IT = 0 010: END 011: IF CLOSE.IT THEN 012: CRT 'HOORAY, FILE_IN IS OPENED' ; DUMMY='' ; INPUT DUMMY 013: CLOSESEQ FILEIN 014: END 015: END *--: FIB Filed ALD1 in file BP. Compiling Unibasic: ..\..\..\FLOPROGS\DEV\DEV.IIBASE8\BP8.0\ALD1 in mode 'p'. main program: syntax error at or before line 16 EOF ^ Expecting: ELSE compilation failed It works fine if I take out lines 4 - 5. Al DeWitt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData AIX commands for commands like LIST.READU and LIST.QUEUE?
I've found UniAdmin can often connect and work when you're out of other licenses. hth Colin Alfke Calgary, Canada -Original Message- From: Kevin King Sent: October 20, 2011 6:15 PM To: U2 Users List Subject: Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE? My apologies on the LLOCKS; Steve's right, that's a Prelude-ism. And while I could write a script to start up udt, the problem here is that if all of the udt licenses are in use, there's no way to get this kind of information in AIX to figure out what might be going on with the system (i.e. a deadlock). And PORT.STATUS is definitely not the same as ps; while both have their place, I'm not entirely certain how I would get the CALL.STACK option from PORT.STATUS out of ps. Jeff, if you have a solution for that one, I'm all ears. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Icons
Try disabling Aero mode for SBClient. Which version of SBClient and is it 32 or 64 bit Windows 7? hth Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. We have a user that just loaded SB onto a Windows 7 box. In GUI mode, she is not getting the icons at the top of the window (Home, Back, Favorites, etc). Anyone know how to fix this? John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Icons
There is a technote on the availability matrix. hth Colin Alfke -Original Message- From: Israel, John R. Disabling Aero sounds familiar! It is Windows 7 - 64 bit. SB Client 5.4. HOW do I disable Aero w/ SB? Thanks John Israel -Original Message- From: Colin Alfke Try disabling Aero mode for SBClient. Which version of SBClient and is it 32 or 64 bit Windows 7? hth Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. We have a user that just loaded SB onto a Windows 7 box. In GUI mode, she is not getting the icons at the top of the window (Home, Back, Favorites, etc). Anyone know how to fix this? John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Icons
You can do it just for SBClient: 1. Right click on the SBClient Icon used to launch SBClient. 2. Select the 'Properties' option. 3. Select the 'Compatibility' Tab. 4. Check the settings box for 'Disable Desktop Composition'. hth Colin Alfke -Original Message- From: Mecki Foerthmann But doesn't that only stop your menu items from disappearing? And of course some of the nicer features of Win7 like window auto-sizing don't work any more with a Basic or Classic theme. On 14/10/2011 16:49, John Thompson wrote: Right click on the desktop. Go to personalization. Choose a Basic or Classic Theme somewhere in there. That should turn off aero... Try that. On 10/14/11, Colin Alfkealfke...@hotmail.com wrote: There is a technote on the availability matrix. hth Colin Alfke -Original Message- From: Israel, John R. Disabling Aero sounds familiar! It is Windows 7 - 64 bit. SB Client 5.4. HOW do I disable Aero w/ SB? Thanks John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22 Index Issue
We came across this a few years back when moving and copying files at the OS level (usually copying the data file but not the associated index). What's even easier than creating a dummy index (especially on a large file) is to simply copy another files index (X_smallfilename) to your working file (X_STUMAST). Then you can do the DELETE.INDEX STUMAST ALL. hth Colin Alfke Calgary, Canada -Original Message- From: regalit...@aol.com This information has been extremely helpful! I had 11 files have the indexes go bad on them, and they needed to be completely rebuilt. The only anomaly is that the DELETE.INDEX fn ALL didn't work right away. There was an index on the file, a V-field, called XERP.SQLTRIG. When the index went bad, it was there, but not really there. On a file called STUMAST for example, I would say: :LIST.INDEX STUMAST No indices created on file STUMAST : Then I would say try to create the index: :CREATE.INDEX STUMAST XERP.SQLTRIG XERP.SQLTRIG: can not create multiple indices on same location No new indices are created : So UniData sort of knows the index was there, but it doesn't really know. And unfortunately, that is my problem. I tried to delete it: DELETE.INDEX STUMAST ALL No indices created on file STUMAST : And the create index would fail again. So what I did was create another index, I actually indexed @ID, then the DELETE.INDEX STUMAST ALL did work, and I was able to re-install my original XERP.SQLTRIG index. So, basically, by creating (I did not actually have to build) a bogus index and then doing the DELETE.INDEX fn ALL it did solve my problem. Is this a UniData bug or two that might be looked into by any chance? :-) (I saw my issue on UniData 7.2.2 for Windows) Thanks! Steve... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PE72 Unidata will not start
Check your logs under @udtbin - especially smm.log and smm.errlog (also double check them in @udtbin\saved_logs). There may be some clues in there. With licensed versions you need to restart everything after applying the license (reboot recommended) - but I'm not sure how the PE version deals with that. Double check with confprod.exe (in @udtbin) to make sure the license is correct and authorized. hth Colin Alfke Calgary, Canada -Original Message- From: Tom Gray Daniel McGrath writes: Okay, first, don't worried about RFS not being licensed. That is additional functionality that doesn't come with the Personal Edition. Since you are getting Start SMM first, you probably have not started the UniData engine. With this, you don't want to actually start SMM by itself directly. All you need to do is run 'startud' to start the UniData engine and it should all be fine. Regards, Dan McGrath -Original Message- From: Tom Gray Installed unidata PE7.2.7, tryimg to start unidata, udt.exe, receive the following messages: RFS is not licensed. SB_FLAG is turned off. Start SMM first! I have looked at the License and it hasn't expired this is a recient download I tried starting the SMM from the command prompt I went to the Bin directory and ran startud it echoed back with It could not start Unidata Service. The following services are running: Uni RPC Service Uni Objectcall Unidata Telnet Service Unidata Terminal Service ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job scheduling in UniVerse
We've done this for years - as long as you don't care that a program contains the login credentials for a SB user. In the login process (prior to the SB.LOGIN) we check various parameters (we run under UniData so they're a little different) and then simply data in the user and password to the SB.LOGIN program. Set up this SB user to have a specific terminal type and printer (so it won't prompt) and then in the Start Sys,Menu,Opt setting enter values that will cause a menu item to run that does what you want. Of course, if you don't need the SB environment to run whatever it is you are trying to run then you can skip the SB.LOGIN and run it directly (just make sure it won't then return to the SB.LOGIN). This will allow you to use the OS scheduling service which is much more robust than trying to get a phantom to sleep and restart itself Hth Colin Alfke Calgary, Canada -Original Message- From: Manu Fernandes Hi, If you start a uv from os scheduller and want to run a SBprocess ; you go to trouble ... because before running your process you must start a SBenvironment Release 5.2 introduce the SB.REMOTE.PROCESS which give ability to start a process from uv shell (then from os shell) without starting a SB+ user login and it works very fine. But you run 3.3.. If you want a SBprocess on phantom scheduled each 15 minutes ... create a parent process with a loop EXEC process ; SLEEP 900 and make a JobScheduling for these parent process. You start it manually one time from within SB+ session. I hope this help. Manu -Message d'origine- De : Martin Hlasensky Hello, I need help with UniVerse and job scheduling. Now we have UniVerse 9.5 and System Builder 3.3.2 (SB) and I want to run process every 15 minutes. I am able schedule job once only in SB. How can I schedule periodically recurring job in UniVerse or SB? Thanks for answer Martin Hlasensky Czech republic ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Just don't do what one of my old bosses did (he was having trouble with SB+ holding locks) - he found one of our main processes and put in RELEASE. Our system relied heavily on pessimistic locking so this caused quite a bit of data loss. Of course, I was the one that had to clean it all up (he didn't like the names I called him after that one). Of course, this was the same genius that taught an entire site to use ctrlq to stop their PC's from beeping... but didn't bother to explain that you shouldn't reboot and try the same thing again. Good luck Colin -Original Message- From: Kevin King We do suspect it is from a custom BASIC subroutine, recently installed. So knowing the file we're looking back through any code that was compiled within the past 2 weeks and manually searching for READU's that don't WRITE, DELETE, or RELEASE. Sure would be nice if the lock table would report the line of code that set the lock. Just sayin'. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19. We have got round it anyway... -Original Message- From: Robert Porter I did a little experimenting with UV under HP-UX as I was curious... I first tried a Type 19 file, and it worked fine. Then tried a Type 1, and it truncated the IDs. SNIP :LIMIT Current Limits are: PROGRAMSIZE: UNLIMITED As you can see, HP-UX has no issue with the long filenames, but UV did when it was a Type 1 file. But Type 19 worked fine... Not sure if this helps or no considering the different platforms both on the U@ and OS side, but I thought it was interesting none-the-less. Robert Symeon Breen 7/22/2011 8:54 AM Which is odd, as linux has the files in the directory no problem and i can work with those files using shell commands, awk, python and php. -Original Message- From: Martin Braid Hi Symeon, LIMIT is giving you the configured operating system limits. Linux is 255 bytes normally. Looks like you have an override. Martin -Original Message- From: Symeon Breen MORE -It is U_MAXFNAME that is stopping it. :LIMIT U_MAXFNAME: Unix file name limit = 46. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = lp -c . U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 8191. U_NIDES: Maximum number of virtual fields in query= 256. How can i change this - i see it sattes they are not configurable - 46 Is pretty small tho ... -Original Message- From: Symeon Breen These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Odd error message
In UD ($basictype 'p') - you get this message when you try to access the zero element in an array. Eg: DIM X(1) X(0) = 'Hello world' Usually, a variable isn't getting set... With $basictype 'u' it puts the excess in (0) and this syntax works. In $basictype 'p' it puts the data in the last element and the syntax results in the error. Hth Colin Alfke Calgary, Canada -Original Message- From: Wols Lists On 22/07/11 16:56, John Thompson wrote: Never seen that one... My initial thought is: Is there a program that has a dimensioned array, where the data that the program is trying to read in is larger than the array that was declared in the BASIC program? The which situation is explicitly handled by (depending on flavour) dumping the excess elements into either element 0, or the last element. Actually, my reaction was very much along those lines. I don't know UD, but could it be that an array was declared in a function compiled in Pick mode, then that array was read into in Prime mode? Unlikely, but it's possible ... Cheers, Wol On Fri, Jul 22, 2011 at 11:52 AM, Glorfield, Gordon Had a user get a message I've not seen before. Message was: Index: 0 to one dimension is out of range. The system kicked the user to TCL after this message. We are running UniData 7.2.4 on HP UX. I went into the system but was unable to duplicate the error. Has anyone seen this message before and what causes it? Thanks, Gordon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] udt dir file max key length
I'm connected to a win 2000 UD 6.0.6 and a win 2003 UD 7.1.6 system and both are 198. I guess they had to lower it to make it consistent among the various OS's. Colin -Original Message- From: Bill Haskett Really! My machine looks like: 5 Dev (0)- LIMIT U_MAXFNAME: File name limit = 118. Windows 2008 R2 and UD v7.2.7 If this isn't configurable, as Wally says, I wonder what accounts for the difference between our two environments? Bill - Original Message - *From:* alfke Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
I believe our licences (as a VAR) with Rocket specify that when we sell UniData and SB+ it's part of the application and is only licenced to run the application it's sold with. So it sounds valid, although they may have the option to only sell UD and SB+ support. Colin From: meckif Well, I don't know Eclipse, but the company I currently work for is running Avante from Epicor. When the company wanted to cancel the Avante maintenance agreement Epicor claimed that this would automatically cancel UniData and SB+ support as well. Avante maintenance was a total waste of money since the original software has been heavily modified (and even though the changes were made by Epicor staff fixing their bugs was still chargeable) and by the time I could prove to Epicor that a fault was a genuine bug I had already a fix for it anyway. Of course we have the source code for Avante. To cut a long story short - we now have UD and SB+ support through another VAR and don't deal with Epicor anymore. Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
Probably not. I haven't looked at our contracts and I've only had a quick scan of ours with Rocket so I'm not sure of the definition of application. If you wrote a report or new interface maybe OK. If you wrote something to keep track of your CD collection - likely not. I'm not sure if it's just us or not (it sounded like Epicor has the same terms with Rocket), but we don't get full licences from Rocket for UD/SB+ - they are for the embedded application. They are significantly cheaper than the full licence - we've got some abnormally good terms from Rocket (at least that's what they keep telling us). Of course, we may be able to upgrade to full licenses - but we've never had a client that required anything like that, and since we've sunsetted our MV application the point is pretty much moot. If you ever go work for a law firm - give me a shout. That's what we do (just not with an MV based application). My original point was simply that Epicor's claim may have been valid. It sounds like you've got lots of valid grievances with them but this may not be one. Colin -Original Message- From: Mecki Foerthmann Colin So I wouldn't be allowed to write a single line of code using U2 or SB+ if I were one of your customers? Because that line of code wouldn't be part of your application and therefore would invalidate my U2 license, right? In that case I would never buy any application software from you. As I see it - I either buy a license for your application and separate ones for the database (U2) and development tools (SB+) or I won't buy from you at all, it's that simple! No wonder MV is struggling! On 08/07/2011 07:06, Colin Alfke wrote: I believe our licences (as a VAR) with Rocket specify that when we sell UniData and SB+ it's part of the application and is only licenced to run the application it's sold with. So it sounds valid, although they may have the option to only sell UD and SB+ support. Colin From: meckif Well, I don't know Eclipse, but the company I currently work for is running Avante from Epicor. When the company wanted to cancel the Avante maintenance agreement Epicor claimed that this would automatically cancel UniData and SB+ support as well. Avante maintenance was a total waste of money since the original software has been heavily modified (and even though the changes were made by Epicor staff fixing their bugs was still chargeable) and by the time I could prove to Epicor that a fault was a genuine bug I had already a fix for it anyway. Of course we have the source code for Avante. To cut a long story short - we now have UD and SB+ support through another VAR and don't deal with Epicor anymore. Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple FMT question
John's correct - you're likely in BASICTYPE 'P' which requires the format X = FMT(X,'R%4') - note that it will truncate the value if it's more than 4 characters. I usually just to a simple LEN check first: IF LEN(X) 4 THEN X = FMT(X,'R%4') If the basictype issue has you confused then I would strongly recommend you not set/change it. Simply realize which you work in and work with it. Most of the help/documentation is for 'U' format - but standard pick documentation should show the syntax required. The UD docs *usually* note when there are basictype differences but don't always make them clear. Good luck Colin Alfke Calgary, Canada -Original Message- From: Bob Woodward Hi Group, I don't know why this is kicking my butt but I'm trying to do a simple X = FMT(X,4\0R) statement, straight out of the HELP UNIBASIC listing and I can't seem to get it to work. The problem is the fill character, in this case the number zero, but what I get back is just the letter R, without the quote marks. I get pretty much the same result no matter what fill character I use. I simply want to format a number to be 4 characters long with leading zeros. If X=1, then it should result in X=0001, or so I've been lead to believe. I know that X = (:X)[4] works to get my results but FMT should work, too. The major benefit is that if the number is more than 4 digits, FMT won't truncate it. I hope. Environment is UniData 6.1 on a Windows server. Comments anyone? Thanks, BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
George - it's not so much the with - I think it's more the =. It's a case of it doing precisely what you ask as opposed to what you are thinking you are doing. The = is creates selection criteria otherwise it considers whatever follows as a record ID and ignores the outstanding select list. Bill - don't forget the REQUIRE.SELECT keyword in UniData. It tests the select list for you. You can even combine them and get consistent (albeit even more confusing) results. Eg: SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME EXISTING_ID 1 records selected to list 0. CLEARSELECT SELECT FILENAME # EXISTING_ID 54 records selected to list 0. SELECT FILENAME = EXISTING_ID No data retrieved from current (S)SELECT statement. SELECT FILENAME # EXISTING_ID 54 records selected to list 0. select FILENAME EXISTING_ID REQUIRE.SELECT 1 records selected to list 0. CLEARSELECT select FILENAME EXISTING_ID REQUIRE.SELECT No active select list. Processing terminated. Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)- BPTEST CMD = \SELECT SOMEFILE WITH INVNO = 1234567\ ; CMD-1 = \SELECT SOMEFILE 3 71*1\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
Sorry I don't have a 64-bit server for testing; however I was searching the kb yesterday (looking at how to install SBClient on 63-bit) and found a couple of articles that may help. One indicated that you should run the installer in Windows 2003 compatibility mode and the other was to change the CPU type (in Visual Studio) to x86 from AnyCpu. The first sounds like it would help and the second doesn't look like it will help until you actually compile/create something. Take a look at the Rocket Knowledge base (or ask your support provider) for more info. hth Colin Alfke Calgary, Canada From: Jim.Stoner Hi, Thanks for the suggestions, folks. So far, I haven't made any progress. I did install the UniData client by right clicking on the installer and using Run As Administrator, while also logged in as an Administrator, with the same results. After David's email mentioned a missing dll and registering them manually, I tried to investigate that possibility. I'm not very familiar with that aspect of Windows systems administration, though, so I don't really know exactly what dlls are required. I looked in the C:\IBM\UniDK\redist\i386\register subdirectory, and made sure that all of those files were present in my C:\Windows\SysWOW64 directory (they were). And then I opened the command prompt (with Run as Administrator), and tried using the REGSVR32 command to register each of those 8 files, including uniobjects.dll. In each case, I got the message DllRegisterServer in c:\windows\syswow64\uniobjects.dll succeeded. However, I still don't see the UnioaifCtrl class in the OLE/COM viewer that comes with the Windows 7 SDK, and I still get the error when I try to call the object in my Domino agent. The one new piece of info that I have is this: When I run (as administrator) the UniData client installer, and then choose the UniDeveloper Kit option, it installs without any visible error as I've mentioned. However, I also tried going into the installer's UNIDK subdirectory, and running (as administrator) the actual setup.exe application for the UniDeveloper Kit. When I do it this way, I do see an error message: * The following files did not self-register or unregister: * 1. C:\Windows\SysWOW64\oc30.dll Error: 0x80040200 * 2. C:\Windows\SysWOW64\oleaut32.dll Access is denied. I do not get that error message when I run the full UniData client installer, though, so I am not sure if that error is because some underlying element that is normally handled by the main installer isn't in available, or if that error is actually occurring all the time and the main installer just isn't reporting it. Since my install isn't working, I'm guessing the error happens all the time, and the main installer is interfering with the error alert. A google search on the error number hasn't helped much. If I try to set the UDK setup program to run in Windows 2003 compatibility mode, it no longer reports an error, but the object still doesn't work or show up in the object viewer. I'll keep looking, but if anyone has any more suggestions, I'd love to hear them! :-) Thanks for the help so far! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
It's been a while since I've seen this one. IIRC in our case it was actually a problem with the data, there were control characters or something in it. The other problem I just ran across Monday was a non-SB program (through a number of twists and turns) calling a program that made a veiled reference to one of the SB+ common variables - which weren't set when called from outside - but were when I ran my test routine It was looking at something in a dimensioned array which was coming across as 0 instead of . In my case it was using the variable to determine the mv position and the 0 was pulling back the whole attribute instead of just the correct mv. You may also want to check your SB+ files.opened variables. Good luck Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: Israel, John R. Let me answer this way: my new stand-alone program selects all the parts, loops through them, and for each part, calls the same subroutines that the web site does (thus ensuring that I am running the same logic). One of these subroutines calls another subroutine that lives in an SB account. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). John Israel -Original Message- From: Dave Davis Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: Israel, John R. We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a TAB as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada From: mstrand send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM char] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through Using UniQuery and the UniQuery Commands Reference with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Video Quirk
I've found doing a CRT TERM.DEFN14,1 resets the colours back to the defined background for the terminal type when I use the SB.INPUT routine in a standalone program. It may help here, but I've never seen this happen in an actual screen. Hth Colin Alfke Calgary, Canada -Original Message- From: mhilbert John, The data you are managing probably has control character sequences. For display purposes, you should replace all characters below char(32) with .. For reseting the colors, try HELP BASIC @ Regards, Marc On Tue, 31 May 2011 11:18:25 -0400, Israel, John R. wrote: I have written a program that runs from TCL to look for bad E-mail addresses in various files. This info is then E-mailed to the user running the program (i.e. me) with an attachment of the problems found. It then asks if you wish to fix the data. If you say yes, it populates WORK1 with all the invalid E-mails, then invokes a stand-alone SB screen that displays the problems (WORK1) on the left and allows you to enter the corrects on the right (WORK2). When you exit this screen (either with F2 or ESC), it exists out of SB and updates the data as desired. The problem I am having is that the video changes colors. While not a disaster, it is a little distracting. Nothing else is impacted, and typing MM to go back into SB re-sets the colors correctly. Does anyone know how to manually re-set the colors to go back to the normal ones? John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Extract a line with a CR and/or LF character in it.
For text files I like to use openseq and readseq. With embedded CR/LF's (which are actually valid in a csv file) you would have to see if you needed to put the lines back together. There were a couple of examples of reading csv files a while back in CDP. The other alternative is to use osopen and osbread. This will read a block of text (size of your choosing and I've found you have to play a bit to get good throughput). You then have to parse through the block literally character by character. hth Colin Alfke Calgary, Canada From: wphaskett I've received some import files (csv) that use either a CR and/or LF character in a test field (surrounded by -marks). It seems to be somebody's idea of multi-value. However, I'm having a hard time extracting them (dynamic length lines) because UD considers it a field-mark. Therefore, the REMOVE() function, READSEQ statements don't work (a single line is considered two lines), and FORMLIST/READNEXT don't work because the key is too long for a select list. Anyone know how to extract a line of a simple csv file that contains a CR and/or LF within the line? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Extract a line with a CR and/or LF character in it.
It's been a while - but I'm pretty sure that OSBREAD keeps the CR/LF as part of the block (you may need to put NO CONVERT ON in the code). READSEQ automatically ends at the CR/LF so you would have to put the lines together if you were short fields. In both cases it would mean going through the block/line a character at a time to parse out each field. Of course, to work with embedded quotes and commas you pretty much have to any way. With READSEQ you know the line ended on a CRLF - you just need to figure out if it's the end of the record or not. Does that make more sense? Hht Colin Alfke Calgary, Canada From: wphaskett I guess that's my problem. I can't use OSBREAD because the Cr/Lf appears in different columns in the line. I can't guarantee where it shows up (or what character position). Using READSEQ doesn't work either because the line read by the statement is only a part of the entire line in the file! e.g. 0,4300,1BEU,Robert,Smith,Julie,Smith,1 Lakewood Dr,,63031,1 Lakewood Dr San Diego, CA 92122,,,$150.00, 0,4300,1CYN,John Randolph,Bones,,,1 Round Ct,,63031,1 Round Ct San Diego, CA 92122,,,$150.00, ...when the lines should look like (only two lines): 0,4300,1BEU,Robert,Smith,Julie,Smith,1 Lakewood Dr,,63031,1 Lakewood Dr, San Diego, CA 92122,,,$150.00, 0,4300,1CYN,John Randolph,Bones,,,1 Round Ct,,63031,1 Round Ct, San Diego, CA 92122,,,$150.00, There's no guarantee the field causing the problem will even have any data in it, so I can't append every 2nd line to the end of every 1st line. :-( Once I get the line I can deal with each character at a time. Any other ideas? As always, thanks. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin
No problem. I just got it working on a 7.1.6 (windows) version. I followed the instructions (and download) under Technote UCC-1001 (or search for XAdmin). There are some programs that need to be installed and cataloged in the SYS_BP folder. It does use the RPC port#31438 and I could only get it to work using Login Account = demo - Nothing else in my UD.ACCOUNT file worked including Demo - as it is in the file. I would get an error: The account name supplied is not a valid account. It seems to use the accounts as defined under Network Services, Database Admin although once I connect the accounts it lists are the ones in UD.ACCOUNT. It starts with demo - but I'm not sure what you would need to do if you didn't install the demo account... perhaps copy/rename a current account as demo and see if you can connect and then add what you need. I had tried the U2-logic editor back when it was free. It worked but I found the overhead of eclipse just a little too much. With U2 now with Rocket I wonder if they will still have the same incentive to use Eclipse Perhaps the port is being blocked at some point or the RPC service isn't active. How far do you get? Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett Thanks Colin. I have several clients running UD v7.2.5 and I still can't connect with them. Is there a reason? Whenever I work with Eclipse, or products based on it, I never seem to be able to get things working. :-( Bill - Original Message - *From:* wphaskett Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only work with UniData 7.2 and higher? I can't seem to connect to any UD v7.1 machines. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin
Good catch (or debugging skills). I've always been a little confused on how UniAdmin connects - I though it was UO for Java as you can run it as an applet, but I never see it logged in and it works even if you're out of licenses. Colin Date: Tue, 17 May 2011 13:54:50 -0700 From: wphaskett Colin: I figured this out! :-) [snip] So, what was the problem? The UOLOGIN program! In the development environment authorized connections are allowed. On our client's servers, there was no need to account for an XAdmin connection. UniAdmin, apparently, doesn't use UniObjects to connect; thus doesn't use the UOLOGIN program. :-) A quick fix in this program allowed connectivity to proceed. Thank goodness for the serverdebug file! Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin
I think so. I believe it's in the release notes. I was trying to get it to connect to a 7.1 windows machine but kept getting a message about an invalid account. I found a tech note saying there were some x... files that were required on the server - but they seemed to be already there. I didn't have time to take it any further. hth Colin Alfke Calgary, Canada From: wphaskett Subject: [U2] XAdmin Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only work with UniData 7.2 and higher? I can't seem to connect to any UD v7.1 machines. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] How to get output-converted results from EXECUTESQL and READNEXTTUPLE?
Jonathan; Why the SQL requirement? It seems arbitrary. Most MV programmers would have done it Jeff's way. Is it mostly so you can have your users enter SQL syntax themselves? (You are guarding against SQL injection attacks right?!?!) Do your users already know SQL, if not, it may even be more intuitive for them to use the ECL syntax - really that's what it was designed for. Without using SQL you can use Jeff's suggestion combined with the calculate function which may make it easier on you. Another option is REFORMAT, although it actually creates the file so you would still have to read it again - but it does have the formatting already done. I would have expected UDT.OPTIONS 91 on to resolve the problem as that's what I use when doing a regular LIST ... TO ..., although I'm not sure how well used that command is. I did report a minor bug with it a while back that was fixed quite quickly so perhaps this can be easily corrected as well. Whether or not you can get a hot fix or if you'll have to wait for a new version though I can't answer. I did test on both 7.1.6 and 7.2.7 and got the same results. If you don't want your users to enter the OCONV(FIELD,FMT) syntax - since you're currently parsing the data anyway - you could inject it into the SQL cmd rather than parsing the data afterwards (ie. 'SELECT OCONV(HIRE_DATE,HIRE_DATE_CNV), OCONV(SALARY,SALARY_CNV) FROM EMPLOYEE TO MY_CAPTURE_FILE;' where you read the format from the dict into HIRE_DATE_CNV and SALARY_CNV.) I think I like how the EXECUTESQL ... TO puts the data into memory somewhere as there is no file to clean up afterwards - like is created from the SQL prompt. I guess it depends on the limits imposed on that structure. Good luck Colin Alfke Calgary, Canada -Original Message- From: jonathanm I got Jeff's reply via email. Really appreciate it. However, his approach involved abandoning SQL. For this project, SQL is a requirement. Any other ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
By definition - if you're creating a write trigger the first parameter is the status. From Developing UniBasic Applications SUBROUTINE trigname(execstat, dictflag, filename, record.ID.expr, recordval) execstat The execution status returned by the trigger subroutine: 0 - No updates are allowed. 1 - Updates are allowed. 2 - Updates are allowed, using the return recordval. So if your before update trigger passes back a 0 as the execstat the write won't be performed. You'll just need to make sure the process calling the write can then deal with it. Hth Colin Alfke Calgary, Canada -Original Message- From: Doug Chanco I am sure I can do this but I am trying to figure out the best way I need to write a WRITE trigger that does the following Call a java web service to update an SQL table (no problem) But if the update fails do NOT update the pick record and if possible notify the user My question is what would be the best method/way to do this? Do triggers use transaction logging that I could roll back the record or should I do something more manual? Copy the record (for example) Any thoughts/suggestions/ideas welcomed and appreciated Dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Upgrading to latest UV/UD PE / Windows
Tony; If it helps - here are some of my experiences installing UD 7.2.7PE at home and upgrading UniAdmin at work. I did uninstall UD beforehand (mostly I had made a mess of the SB/XA personal edition and was cleaning everything up and moving it around). Downloads from the new Rocket site are very similar to the IBM site - you have to fill out a web form to get to the download URL. Nothing besides basic contact info. I did get an auto-generated e-mail: Thank you for your interest in Rocket Software. Your information has been received. A representative from Rocket will be contacting you shortly. But I haven't heard anything since (it's been about a month). Not that I'm complaining :) I don't think you have to license the PE versions - they just have an expiry date. It's all just pre-populated when you go through install and if you check it later. The clients download is still huge. I can't recall if the personal download was split but when downloading through U2BC there are two clients (the smaller being the new DataVue query download). Still not sure where the new Xadmin client is and UniDebugger is still in the client even though it's been deprecated and BDT is a separate download. The install went easy and the default path is much shorter now. I did split out the UniAdmin directory from the client download to send to a client. Testing on my machine caused my earlier version of UniAdmin (in fact all 3 of them) to completely fail. Uninstalling all of them and reinstalling the latest got it working again. I haven't tried it with anything prior to 7.1 but it does have back to 5.1 in the version dropdown list. I was running that many versions because the later versions didn't seem to want to connect to earlier versions of UniData - hopefully this one will Good luck! Hth Colin Alfke Calgary, Canada -Original Message- From: Tony Gravagno A while back I posted a blog with details about upgrading Universe and Unidata. A lot of people found it to be helpful. nospamNebula-RnD.com/blog/tech/mv/2008/09/u2upgrade1.html (please remove 'nospam') I am now about to upgrade once again, just to ensure I have the very latest [ and greatest? ;) ]. I have specific questions about this endeavor: 1) Can anyone at Rocket confirm changes in the Universe 10.3.x installers which invalidate any statements I made about 10.2? Similarly for Unidata 7.2.7 vs 7.2.0. 2) What is the process for renewing PE licenses? Is there a prompt from the installer? Do we need to fill out some website form? Send an email? I don't think I've done this since the IBMRocket change. 3) Rather than installing an entire 600MB Clients for Windows package, is there a base package that can be obtained with just Uniadmin and UO support? 4) Please see issues with the Clients package documented in the blog, and comment if any of that is no longer accurate. 5) Is there a UVPE/Win v11? 6) Are there any other caveats or words of advice for minor upgrades like this? Final note for Rocket. On the download page the Expires date for UVPE shows 11 Nov Feb 2011. http://www.rocketsoftware.com/u2/resources/downloads I'll be happy to blog this experience like I did last time. Thanks! Tony Gravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CoRelating Two Arrays
You might also want to correct the spelling/variable name in: Receeived.Running.Total = 0 Hth Colin Alfke Calgary, Canada -Original Message- From: Brutzman Yup... Before the exit I need to Where.We.Left.Off = Receiver.Count Thanks to Allen, Larry, and Robert. --Bill -Original Message- From: Robert Houben Nothing is resetting Where.We.Left.Off to 1. The code that you are providing below sets it to 1 at the beginning and NEVER CHANGES IT! The only place you reference it in your code is the for Receiver.Count... loop, and there it is only used to set the initial value of Receiver.Count. Its value is never set inside the two for loops. -Original Message- From: Bill Brutzman When I try do something like the following, inside the loop, UV keeps resetting Where.We.Left.Off to 1. To solve this, I am expecting to invoke brute force. I am surprised that UV-Basic behaves this way. An explanation would be appreciated. --Bill Where.We.Left.Off = 1 for Blanket.PO.Count = 1 to Total.Nbr.PO.Releases read R.POD from F.POD... PO.Qty = R.POD, Blanket.PO.Count for Receiver.Count = Where.We.Left.Off to Total.Nbr.Receivers read R.Rcvr from F.Rcvr... Received.Qty = R.RcvrReceiver.Count Received.Running.Total += Received.Qty begin case case Received.Running.Total PO.Line.Item.Qty ; crt PO.Qty : ' ' : Received.Qty Receeived.Running.Total = 0 exit end case next Receiver.Count next Blanket.PO.Count ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unidata
Just Rocket's term for VAR or solution provider. -Original Message- From: jeffrbeall Thanks for the reply, I'll try the backup thing. By the way, what is a ISV? Colin Alfke wrote: The personal editions can be downloaded from: http://www.rocketsoftware.com/u2/resources/downloads but they're limited to 2 users. However, you can buy a backup license from your ISV (or directly from Rocket - I think if you don't have an ISV http://www.rocketsoftware.com/u2/about/contact-sales ). It's quite a bit cheaper but there are some restrictions like - you need the same number of users, same platform, same add-ins (IIRC). I haven't done an Aix install of UD for years, but it wasn't too difficult back then, and the windows version is simplistic. If you e-mail u2as...@rs.com they should be able to help more. Hth Colin Alfke, Calgary Canada -Original Message- From: jeffrbeall I have a HPUX box running a unidata database. I would like to make another server running unidata as a backup, so if the HPUX box goes down, I could switch over to the backup. Isn't there a way to get a unidata backup license from their website? I was told you go to the website ( not sure were ) and register to download unidata. In the registration you put in the comments that what you are downloading is for a backup server? Is that true? Also, I have never setup unidata, but i am comfortable with Unix. is the setup for Unidata something like, un-tarring a tarball file and running make, and then install? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/unidata-tp30624139p30625745.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
The personal editions can be downloaded from: http://www.rocketsoftware.com/u2/resources/downloads but they're limited to 2 users. However, you can buy a backup license from your ISV (or directly from Rocket - I think if you don't have an ISV http://www.rocketsoftware.com/u2/about/contact-sales ). It's quite a bit cheaper but there are some restrictions like - you need the same number of users, same platform, same add-ins (IIRC). I haven't done an Aix install of UD for years, but it wasn't too difficult back then, and the windows version is simplistic. If you e-mail u2as...@rs.com they should be able to help more. Hth Colin Alfke, Calgary Canada -Original Message- From: jeffrbeall I have a HPUX box running a unidata database. I would like to make another server running unidata as a backup, so if the HPUX box goes down, I could switch over to the backup. Isn't there a way to get a unidata backup license from their website? I was told you go to the website ( not sure were ) and register to download unidata. In the registration you put in the comments that what you are downloading is for a backup server? Is that true? Also, I have never setup unidata, but i am comfortable with Unix. is the setup for Unidata something like, un-tarring a tarball file and running make, and then install? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users