Re: [U2] U2 - Universe - Sage MAS90 - Experiences?
We use MAS90, but only for a small portion of our business and there's no real time connection between it and our UD app. We just do a nightly feed of GL data. The standard product does use ProvideX. I know there has been a SQL option but I think it was discontinued. Sage (the provdier) only works through VARs, so you'd need to track one down if you decide you can't roll your own. I've heard good things about Blythe consulting. I could talk more off-line if you'd like, but I don't know that I can offer much. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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
This thread reminded me of a blog posting I ran across a while ago. His basic premise is that most of our assumptions about names are incorrect, which makes coding a computer to handle them properly is really tough if not impossible. Don't skip the comments section, there's some good stuff there. http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Rocket technote UDT-4359 - udadmin
Can someone confirm/clarify this statement from this recent technote: "UniAdmin and the Extensible Administration Tool (XAdmin) will start udadmin_server when a user connects to a UniData server and will stop it when the user disconnects. However, it is possible to spawn the udadmin_server outside of UniAdmin and XAdmin." I thought I understood what udamin did, but now I'm not so sure. Are the only legitimate calls to udamin made via UniAdmin and XAdmin? TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
We use MAS 90 for a portion of our business, but I'm not too familiar with it. Last I heard, the SQL server version wasn't ready for prime time yet. I'd definitely check on that if you decide to pursue MAS 90. And, yes, you need a good consultant. I don't believe Sage sells direct. > From: John Thompson > To: U2 Users List > Date: 05/22/2012 03:59 PM > Subject: Re: [U2] U2 accounting software question > Sent by: u2-users-boun...@listserver.u2ug.org > > Our CFO likes Sage MAS 90. The trick is finding a decent consultant that > knows what he's doing. I hear more recent versions run on top of MS SQL > Server, although ours does not, and its quite a chunk of change to get the > upgrade. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: Re: Mocking UniSession in .NET
I know this is a serious question with real world implications, and I know a mock isn't exactly a taunt, but I can't believe there hasn't been a single Monty Python reference in this thread. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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
Thanks for the ideas. dd scared me. Lots of warnings about destroying your hard drive. =:O I figured it out with tr. There might be a way to do it in one step, but piping works fine. tr -d '\r' < brad.txt | tr -d '\n' > brad2.txt U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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
Thanks, Larry. > > You should be able to shorten the tr and save a pipe ... > > tr -d ['\r\n'] < brad.txt > brad2.txt > > Larry Hiscock > Western Computer Services U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UD] Disabling/blocking ODBC
We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
> You can can kill the unirpc process ? That would do it. Unfortunately, it would also take down UO and UOJ, which we use. Hmmm. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
This sounds very promising. I will pursue this route. Thanks, Dan. > From: Daniel McGrath > To: U2 Users List , > Date: 01/25/2013 12:49 PM > Subject: Re: [U2] [UD] Disabling/blocking ODBC > Sent by: u2-users-boun...@listserver.u2ug.org > > There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. > > If you are under a support contract, contact your support provider > and they should be able to help you get ODBCLOGIN up and running. > > Cheers, > > Dan McGrath U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
> There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine > that is called for every ODBC call. You can use this to either blank > prevent ODBC, or setting up restricted login access & login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UD] correlative syntax
A coworker just ran across the following in one of our DICTs. The name of the item indicates it was written by someone who is no longer with the organization and was well known for knowing wonderful arcane UniData tidbits. We can't find anything describing what exactly is going on. The end result is very useful. I'm wondering if anyone can explain the @#"" bit. OCONV(@ID,"G*1"); OCONV(@,"FILE;X;0;0"); @#"" The file the DICT is in has a compound key: ACCOUNT.NUMBER*sequential. What this item does is grab the account number, attempt to read from FILE and return a 0 if the account doesn't exist in FILE or a 1 if it does. Pretty nifty. UD7.1 AIX5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] correlative syntax
d'oh! That's exactly what it is. I just needed someone to put the space between the # and the "". Thanks. > > I believe this means "if result of last expression is not empty", > where "last expression" is oconv(@,"file;x;0;0") in this case. > > Written another way: > > OCONV(OCONV(@ID,"G0*1"),"FILE;X;0;0") # "" > U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL input and response logging such as COMO
I can't speak for UV, but we've been required to log all sessions for specific powerful users. It becomes a little simpler if you do it for all users. Make sure you have some type of automated purge of whatever log files you create or you'll probably start filling up your file system. This is what we're doing under UD7.1. Nothing fancy. We added this to our LOGIN: PQ HRUN DIR COMO.PROG P And here's what's in COMO.PROG USERS = 'user1, user2, user3' IF INDEX(USERS,@LOGNAME,1) > 0 THEN FN = @LOGNAME:'_':@USERNO:'_':DATE():'_':TIME() DATA FN EXECUTE 'COMO ON' END U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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?
And if you go that route, I have used Excel a number of times for this type of thing. I use formulas to replicate what a user would type and then paste into either TCL or ED. It takes a little time to work out the details, but once you have it, you can reuse pretty easily. As someone noted earlier, the rub comes in ensuring you don't overwrite an existing record. Assuming you've done that, this might get you started. Bad Good Command A B ED FILE A SV B FD Y Where command is this Excel formula: ="ED FILE "&A2&CHAR(10)&"SV "&B2&CHAR(10)&" FD"&CHAR(10)&"Y"&CHAR(10) Depending on which version of Excel you have, it may include the leading " when you paste. If so, paste into Notepad or Word and remove the leading " HTH, Brad. From: Wjhonson To: u2-users@listserver.u2ug.org, Date: 05/28/2013 02:42 PM Subject:Re: [U2] UniData PreStore to change the KEY of a record? Sent by:u2-users-boun...@listserver.u2ug.org I do not think you can Prestore a replacement command to operate on the KEY (attribute zero) I would suggest giving the task to an expert user and teaching said user how to look at the Key, mentally replace bad with good and then SAVE GOOD1234, followed by FD -Original Message- From: David Wolverton To: 'U2 Users List' Sent: Tue, May 28, 2013 10:48 am Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess permissions. From: Al DeWitt To: U2 Users List , Date: 08/05/2013 09:04 AM Subject:Re: [U2] OPENSEQ Sent by:u2-users-boun...@listserver.u2ug.org 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. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: Kevin King [mailto:ke...@precisonline.com] 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 > ___ 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Old MacDonald had U2 [EI] [EIO].....
I have no idea what to do with this one, George. But thanks for brightening my afternoon. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dick Pick
>Yes I know the link name is a little unfortunate.. Cool picture. Thank you for acknowledging the 12-year old in all of us. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Copyright questions notwithstanding, someone who has one of these could maybe submit to google and they might put it up on google books for the whole world to enjoy. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Silly Gripe
> How would you then compile or catalog such programs - say if it is > BP/typeAprogs/progname We have a similar structure. The compile command is BASIC BP,typeAprogs progname U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Silly Gripe
Yes, on UniData (7.1). And our program BP is outside the application account/directory. So in our case we do have a directory with nothing but code in it and convcode -r would make sense. Brad. > > Symeon Breen > > On unidata ? > > bradley.sch...@usbank.com > Sent: 25 March 2010 14:10 > To: U2 Users List > Subject: Re: [U2] Unidata Silly Gripe > > > How would you then compile or catalog such programs - say if it is > > BP/typeAprogs/progname > > We have a similar structure. The compile command is BASIC > BP,typeAprogs progname U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and stripped drives
I am not a disk guy, but striping has provided significant performance gains for. Separating the busiest files from everything else can also help a lot; it keeps your busiest files from dragging down the rest of the system/account. If you're on *nix, you can do some very creative things like isolating busy files to a subset of disks and then mounting inside your main account(s). This way it looks to uv like the files are all in one location, but the O/S accesses them separately from everything else in the account. This doesn't fully resolve performance hits due to big complex queries on big complex files, but it can help isolate them so the rest of the world doesn't care. hth, Brad. From: George Gallen To: U2 Users List Date: 04/28/2010 11:47 AM Subject: [U2] Universe and stripped drives Sent by: u2-users-boun...@listserver.u2ug.org We are in the process of upgrading our system. When we setup our current system, it was suggested we strip our data drives (5) into one, instead of having 5 separate drives, so it could pull more data at once. The new system will have 6 drives available for striping We were going to have 6 drives striped into one, which would be partitioned into our data areas the thought being it would be faster disk access if it's pulling from all 6 drives at once. BUT...all of the partitions are on that one striped drive. Would it be better to have (2) sets of 3 drives striped into one, and setup the two most used accounts on each of those drives, so now it's only pulling data from 3 drives, but there could be less competition between the two accounts, since they are pulling from separate drives? Anyone played with this at all? FYI, each drive is mirrored as well, so if there is a drive failure, data loss is protected, if there was a drive failure on both the main and mirror (same drive) then with the 6 drive strip, we stand to potentially lose more data, than if there were 2 sets of 3 striped. But...since we have full daily backups, and potentially, considering a second backup during the day, the amount of data loss would be minimalso I'm putting that off the table for now in determining whether to go with a 3 or 6 stripe. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] fnuxi problem
find . ! -name *.30 -print excludes all files ending in .30 under AIX. So I'd think that find . ! -name *.30 -exec fnuxi {} \; could work for you. Brad u2-users-boun...@listserver.u2ug.org wrote on 05/13/2010 10:41:59 AM: > [image removed] > > Re: [U2] fnuxi problem > > Martin Phillips > > to: > > U2 Users List > > 05/13/2010 10:42 AM > > Sent by: > > u2-users-boun...@listserver.u2ug.org > > Please respond to U2 Users List > > Hi Dan, > > Sadly, this doesn't help as it will try to process the DATA.30 files that > cause the hang. > U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again)
> Mr. Bishop's silence through all this is eerie. > > Do you suppose he might have a message filter on U2 posts that > automatically moves them to a folder he never reads thus making him > blissfully unaware of the sport he's become? That's all I can figure. I've never seen anyone so thoroughly mocked in a public forum without any response. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] End of an Era -- AUTO: Haydon Bishop is out of the office. (returning 26/07/2010)
At the risk of incurring the anger of the group due to lost opportunities for humor, I took a stab at contacting Mr. Bishop today. My guess at his email address proved successful. Score one for predictable email addresses! Here is his reply: > Many thanks for letting me know. At some point I erroneously put the emails to go to my junk file instead of unsubscribing so haven't been looking at any of these mail's from the group or all the humour at my expense. > >Glad I could be of some use at least by giving people something to poke fun at and hope I didn't cause others less humorous any aggrevation. >Will unsubscribe as soon as possible. > >Many Thanks > >Haydon U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Auto: Brad Schrag is out of the office
I will be out of the office until 27 July. I will respond to your email when I return. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] End of an Era -- AUTO: Haydon Bishop is out of the office. (returning 26/07/2010)
> And he still hasn't found what he's looking for. Nice! U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Sending interrupt to UniBasic program
All, I'm hoping the bit-heads in the group can help me out with this one. It's kind of difficult to explain, but I'll try my best. My apologies for any lack of clarity. What we're trying to do is automate a third-party batch process. The automation piece is working well. But there's one requirement that's proving problematic, with two key requirements at play. First, batch process must run automagically and completely unattended. Second, operators must have the option to interact directly with the automated batch for trouble-shooting purposes. The second requirement is what's presenting the challenge. Since we need to be able to directly interact with the batch process, we can't use a phantom, since any keyboard I/O causes a phantom to terminate. The solution we chose was to run everything under GNU Screen. If you aren't familiar with Screen, here's a one sentence description from our friends at GNU -- "Screen is a full-screen window manager that multiplexes a physical terminal between several processes, typically interactive shells." You can check http://www.gnu.org/software/screen for more info. I think of Screen as a terminal emulator that runs locally on the server. So if you start screen and then launch UniData from within your screen session, you are safe if the connection from your workstation is dropped; everything continues to run on the server. You just need to issue a command to reconnect to your screen session and you're back in business. Very handy tool. If the batch runs with no issues, this works well. But if we need to diagnose a run-time issue, e.g. a process appears to be hung, we need to do things like send ctrl-c to break the current program. This is where the problem comes in. Screen seems to be sending ctrl-c (or any other interrupt, for that matter) to udt, not the program that is running under udt. This causes the udt session to end which kills the batch process when all we want to do is get to the debug prompt. Questions to the Screen users group have not generated helpful answers. Here's an attempt at an illustration of what I'm talking about. Nesting indicates that a process is running under the outer process. Non-Automated: Can press ctrl-c while PROG1 is running to get to debug prompt AIX udt PROG1 Automated: Ctrl-c and AIX kill's are directed to udt, not PROG1 AIX screen udt PROG1 Does anyone have any thoughts on how to resolve this? My hope is that there's a way to send an interrupt from outside that will be directed towards a specific program. Environment info: AIX 5.3 UniData 7.1 TIA, Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sending interrupt to UniBasic program
Thanks for all the input. Some of the idea look promising. I've got some research to do. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sending interrupt to UniBasic program
Thanks to the suggestions from various posters, I have determined that my incriminations of screen were malicious libel. It's not screen. The issue of not being able to send an interrupt (e.g. kill -2/SIGINT) is a result of how I had to work around something in the third-party code I'm trying to automate. There are a couple input prompts, e.g. "do you want to continue? y/n" that I originally tried to handle with DATA statements. But the 3rd party software is doing something to clear the input stack. I've tried a few different workarounds, including hacking the CLEARINPUT verb, with no success. I finally got it work by doing a PCPERFORM as follows: PCPERFORM 'echo PROGNAME\\nY\\n\\n\\n | udt' This works great except that a SIGINT issued to the newly spawned udt process has not effect. A straight kill works, but it actually kills the udt process which is precisely what I do *not* want to happen. Any creative thoughts on how to get a SIGINT to work? Maybe a different way of calling PROGNAME? Talking to the vendor about changing their code is a theoretical option, but involves $ and a good deal of time, so is not preferred. TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Questions abount Resize on Universe
I can't speak for UV, but UD creates work files in a temp directory (that you can specify at runtime). I've monitored this directory to guesstimate status and completion time. From: "Bob Witney" To: "U2 Users List" Date: 09/07/2010 08:58 AM Subject: Re: [U2] Questions abount Resize on Universe Sent by: u2-users-boun...@listserver.u2ug.org Depends if you are doing it in place or to anmother account Have had probs stopping those done in place Using another account for the work file stop ok -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marcos Fogaca Sent: 07 September 2010 14:44 To: u2-users@listserver.u2ug.org Subject: [U2] Questions abount Resize on Universe Hi, It is possible stop a resize on Universe? How do I estimate when the resize will finish? It is possible monitor the resize progress? Regards, Marcos Fogaca ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Slow READ/WRITE with indexes
How long have these indexes been in place? If they're new, that's one thing. If they've been in place for a while and this is a change in behavior we may need to look in different areas. FYI, on ud I've had performance issues when going above five indexes on a given file when I have a high volume of transactions. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG Member Newsletter -- DataVU
I see no mention of availability or pricing on U2UG and no mention at all on Rocket.com. Does anyone know more? Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CREATE.TRIGGER - Permission denied
> No problem, Dave. I would still like to get a clarification from those >in the know of how Universe and Unidata handle this issue, though. On UD 7.1 / AIX 5.3 I have to be the owner to do a CREATE-TRIGGER, even if the file privs are 777. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
One use we have is to send/consume XML to an external third-party service provider. We also use internally for web service calls. The first time doing it can be a challenge. After that, it's pretty straight-forward. It has been very stable for us. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
> Come on - if something can be in two or more places at the same time it > is "digital"? My hands are digital and they're always in just one place: at the ends of my arms. :-P U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
Phil, I wrestled with this one quite a while a few years back under ud.. Never figured out a code-only solution. Ended up writing exit codes to a text file that the script reads when the program completes. If noone has any other ideas you like, ping me and I can explain what I did. Brad. From: Phil Walker To: U2 Users List Date: 03/16/2011 04:02 PM Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Sent by:u2-users-boun...@listserver.u2ug.org Hi all, I am trying to detect the success of failure of a BASIC program when running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do this, hoping that the exit status of uvsh would reflect the value set for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone know if this works and I am just missing something silly? Possibly VOC entry process mode setting or something? e.g. uvsh "MYBASICPROGRAM SUCCESS" would return exit status of 0 uvsh "MYBASICPROGRAM FAILURE" would return exit status 1 uvsh "MYBASICPROGRAM" would return 9 SUBROUTINE MYBASICPROGRAM @SYSTEM.RETURN.CODE = 9 Get(Arg.) EXITSTATUS ELSE STOP BEGIN CASE CASE EXITSTATUS = 'SUCCESS' @SYSTEM.RETURN.CODE = 0 CASE EXITSTATUS = "FAILURE' @SYSTEM.RETURN.CODE = 1 END CASE RETURN This is a contrived example, but shows what I am trying to do with @SYSTEM.RETURN.CODE. Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PICK Systems Administrator position
> Obviously he didn't provide the information that candidates need to decide whether or not they feel they're qualified. Maybe, just maybe, he meant it when he said it was a very sensitive placement and, as such, he couldn't say anything about it. Maybe he figured there might be someone on this list who was looking for a change and was willing to take a couple minutes to follow up with him in private. Instead, he got piled on by some in this group in what I have to say was a very bizarre and incestuous turn of mood. A very wise friend once told me "you can't ascribe motive." If you don't know Joe, and know him well, you have absolutely no idea what his motive is. Don't try to guess, even if your guess is based on a long history of supposedly relevant experience. If you don't want to talk to him. Don't. Delete his email and move on. > Why do I get bent about this? Because when this is over yet another end-user is going to have more "proof" of how hard it is to find talent in this industry, and some good technicians might remain jobless in a tough economy. Or maybe we'll have yet another end-user, or worse yet, a bunch of recruiters, who are so totally put off by the attitudes of some in U2UG that they'll write us off because it's just not worth the frustration when there are much bigger ponds in which they can go fishing. Just sayin'. My 2 cents, Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
And I've found that I need to be in type U for LIST ... TO DELIM to work. Type P gives "syntax error" Maybe there's a UDT.OPTION for that? Brad From: Colin Alfke To: Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to File Sent by:u2-users-boun...@listserver.u2ug.org 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 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
> > Does anyone know of an Enterprise Scheduler solution that can handle jobs > > across a heterogeneous enterprise, that is also MV or *nix compatible? We use AutoSys from CA. Runs on probably any platform you'd want it to run on. It's big and I'm sure it's not cheap. But it works pretty well. A lot of flexibility in setting up sequences of jobs based on reasonably complex success/failure conditions. We hook into UD via shell scripts that AutoSys calls. > > The Enterprise Scheduler we are interested in can be MV based, or other DB > > based, but must have a graphical front end AutoSys runs on Oracle and has a GUI. We could talk offline if you want to dig into it a bit more to see if AutoSys is a fit. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECT question, paginated select.
I've seen this technique described before but it doesn't work for me on UD7.1. Is there a way of doing this in UniData? Thx, Brad. From: George Gallen To: U2 Users List Date: 07/20/2011 03:23 PM Subject:Re: [U2] SELECT question, paginated select. Sent by:u2-users-boun...@listserver.u2ug.org OK. Try this ED DICT CLIENT ROW 0001: I 0002: @1+1 0003: 0004: ROW 0005: 5R Now, you can SELECT CLIENT WITH . AND WITH ROW >=1 AND ROW <=20 As long as the selection stays the same, This "should" work. George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Chris Austin > Sent: Wednesday, July 20, 2011 1:15 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] SELECT question, paginated select. > > > I'm working on a screen in our webapp where we're using a dojo widjet > to create a drop down with client names. The problem > is that we have 1,000's of clients and when we do a SELECT on this many > clients it takes a while. I know we can index the field but > I was wondering if you can do smart selecting in UniVerse. > > For example if I wanted to use this query: > > SELECT CLIENT WITH @ID = "A]" SAMPLE 10 (returns 10 clients starting > with the letter A). > > I want to paginate my drop down so the first query has the above data. > The problem I'm facing is that I don't know how to > get the NEXT 10 clients? Is there a way to do this? > > For example if I wanted to return the next 10 CLIENTS, without > including any of the first 10. > > Chris > > > > ___ > 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Finding Triggers on files
That's the only way we've figured out to do it. Brad. > From: Jeffrey Butera > To: U2 Users List > Date: 10/10/2011 10:39 AM > Subject: [U2] Finding Triggers on files > Sent by: u2-users-boun...@listserver.u2ug.org > > Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > I've looked at FILEINFO and it doesn't indicate that any parameter would > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > > -- > Jeff Butera, Ph.D. > Manager of ERP Systems > Hampshire College > jbut...@hampshire.edu > 413-559-5556 > > "...we must choose between what is right and what is easy..." >Dumbledore > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] phantom checking - Universe
I don't know about system variables, but in unix/UniData you could do a shell command like CMD = 'ps -ef | grep PHANTOM | grep -v grep wc -l' PCPERFORM CMD CAPTURING CAPTURED This will give you either a number or 0 in CAPTURED Brad [EMAIL PROTECTED] wrote on 04/18/2008 01:23:59 PM: > Is there a system variable that can be used within a Basic program that tells > you how many phantoms you have running from your session. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Setting return code when a Universe process terminates
Ian, I tried for a long time to figure out a way to do this entirely from within UD. Couldn't figure it out. I hit two walls. First, the exit code that nix receives is the status of the udt command. If you're program runs at all, you get a '0'. The second wall was when I tried setting an environment variable from within my code. The issue there is that shelling out starts a new shell that is closed as soon as you return to UD. The only way I could make it work was to echo a status code to an ascii file. I ended up using a shell script to call my UniBasic program and pass in a location and name of an ascii file. The program determines exit status and echoes it to the ascii file. After the program completes, the shell script checks the contents of the ascii file and does an 'exit #'. I've had this working for a couple years with no issues. I'd be willing to discuss details off-list if you like. Brad > > I'm trying to write some Universe programs that plug into an > existing perl framework. For this to work these programs need to set > the standard unix exit code to different values when these programs > terminate. This will allow this framework to test for different > error conditions. (The equivalent test in a ksh script would be on > $?). What is the best way to make this work? Everthing I've tried returns 0. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How do you do a NOPAGE on a SELECT?
If no other suggestions work, how about putting a DATA "N" in there somewhere? I've used that to great effect in the past. Brad owner-u2-us...@listserver.u2ug.org wrote on 04/24/2009 01:21:55 PM: > If I'm typing the commands, no problem...just hit 'n', however, if I put them > in a VOC, and execute the VOC from a program, the operator has to hit 'n'. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] u2blog.org?
FWIW, whois says it's inactive. Hosted in PA. http://www.who.is/whois/u2blog.org IP Location: Wayne, United States Website Status: inactive Brad > > About a year ago I added u2blog.org to my list of blog > affiliates. I have no idea who owns it or whether it's still > maintained. Anyone here know? Until it's identified I've > removed it from my list. > U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Send output from query to text file
I can't speak for UV, but in UD you could do something like SORT VOC ATB1 ATB2 ATB3 TO DELIM "|" \\server\fileshare\file.txt This would create a pipe-delimited txt file. Brad. u2-users-boun...@listserver.u2ug.org wrote on 06/12/2009 08:22:17 AM: > [image removed] > > [U2] Send output from query to text file > > Norman Bauer > > What I really want to do is: > > SORT VOC \\server\fileshare\file.txt > U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] General guidelines on indexing
Our primary application hasn't needed the performance gains offered by indexing, but our database has grown large and complex enough that we're looking at it seriously. Having only dabbled with indexing in test environments, I've got a few general and best practice questions. I've seen some comments in the archives on some of the pitfalls, e.g. the dangers of indexing remote files and indexing on correlatives with subroutines. But posts I found are at least a year old. I'm guessing there may be updated information out there. Feel free to point out that everything I'm asking is in the archives and send me there. Some questions: * Are there guidelines for how many indices is too many for one file (assuming disk space isn't an issue)? * Does BUILD.INDEX with the ONLINE parameter work as advertised? Can it really be run while the file is being updated? * How about data consistency? I seem to remember there being concerns in earlier days of an index not always being updated correctly. * How about indexing multi/subvalued fields? I don't know that we'd want to, but is it advisable? Valuable? * We use EMC to clone our production account so we can run nightly reports off-line. The account is renamed in this process. Might that cause any index issues? The clone is read-only, so there are no updates, just queries. * I've seen mention of index corruption. Is it obvious when an index is corrupt or can it be subtle? If subtle, are there ways to detect issues before our users do? * Performance is what we're after, but are there benefits to indexing other than performance? AIX 5.3 UniData 7.1 All thoughts, comments, observations are most appreciated. Brad Schrag U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
Excellent idea, Baker. I'll work on that after this thread settles down. I won't include the "dynamic array vs. work file" bits since that's not directly related to indexing. Brad Schrag > > Maybe one of you would be willing to pull all these good posts on > indexing into a wiki article? It would be handy reference material > and could save someone from hours of pain can't get this stuff > from reading the system docs. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] General guidelines on indexing - Wiki updated
I took a stab at extracting and compiling index-related info from this thread. It's not pretty, but it's a start. Feel very free to update, restructure or change as seems appropriate. http://212.241.202.162/U2UGWiki/moin.cgi/ForDevelopers Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
Thanks for cleaning up my mess, Brian. You won't have to do it again, at least not because of me. :-) > In the meantime, I've copied those new sections on indexing into the new > wiki and kept the attribution. Brad Schrag Application Consultant Commercial Leasing Development U.S. Bank EP-MN-BGF 2751 Shepard Road St. Paul, MN 55416 651-205-3074 direct sdg U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] More questions on indexing
Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More questions on indexing
Thanks, Rod. One more thing. I've written a test program to simplify index creation and building. When I run it under type U or type P using BUILD.INDEX or BUILD-INDEX, it gives me the "Enter to continue..." prompt after each screen of *'s. Definitely not desirable for an automated process. It doesn't do this at TCL. How can I work around this? I'd rather not throw a bunch of DATA statements in there. EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY' DATA 20 EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY' EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY' TIA, Brad. > > Please respond to U2 Users List > > I think Oracle's indexing scheme is much more complicated that > Unidata's, so I don't think you can compare the two. I do rebuild some > of the dynamic files on occasion to get some space back. Other than > that, I leave them alone and haven't had problems. - Rod > > Research continues and I have more question for the group: my Oracle > buddies rebuild their indexes at least weekly. Seems to be a best > practice. Seems odd to not be able to trust that your index is correct. > Is > this a concern for ud 7.1? > > TIA, > Brad. > > ud 7.1 > AIX 5.3 > U.S. BANCORP made the following annotations U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ETL?
DataStage. Works well for us. Our vendor exposes a somewhat normalized SQL account. We interact with that, not directly to UD. It's graphical if you want. Programmatic if you need. Since we're a U2 shop, we like that it's based on a flavor of UV. Have been using it for a number of years with no real issues to send data directly to Oracle, SQL Server and DB2. Brad > > And I'm waiting for someone to say DataStage... (I don't use it so I can't > recommend it). > > Regards > > Brian U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] BUILD.INDEX CONCURRENT trustworthy? (was: Indexing)
> Are there any testimonials from anyone using it in production? > We're like a flock of penguins waiting for the hungriest one to dive in > first and not get eaten by seals. > If there's no blood in the water, CONCURRENT is a welcome tool for high > availability. > > Chuck Works under UD 5.1. Can't speak for UV. I will say that CONCURRENT is INCREDIBLY slow, e.g. 30 minutes vs. 10+ hours in one test I ran. YMMV U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 is now Rocket U2 - what to call them?
> I spoke to some IBMers... er... Rocketeers Maybe I missed this in the days after the announcement, but has the critical question of what to call Rocket Software employees been discussed? I kinda like Rocketeers but wonder if they'd prefer something else like Rocketers, Rocketmen (gender bias noted) or maybe even Rockettes? What do you say, Rocket Software employees? Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
In *nix I've used cat. Not sure what the syntax would be in Windows. Here's an attempt: CMD = 'cat ':EMAIL.TEMPFILE:' | "C:\usr\lib\sendmail -t' > CMD = '"C:\usr\lib\sendmail -t < ':EMAIL.TEMPFILE:' > -"' > > another option might be to see if sendmail has an option to take > it's input from a file, therefor eliminating the "<" altogether U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uniObjects and PAM
Our security people are trying to migrate us off AIX security to Active Directory. They're using PAM / LDAP. They converted one of our developers and he now gets an invalid id/password error when trying to connect to an account using UniObjects. This happens in mvDeveloper and a couple spreadsheets we've had built that connect to UniData. We can't afford to use the spreadsheet functionality and REALLY don't want to give up mvDeveloper. Has anyone worked with UniObjects / PAM? Have you had this issue? Resolutions? I don't know much about UniObjects and even less about PAM, but I'll try my best to answer any follow-up questions. UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniObjects and PAM
Thanks for the quick reply, Wally. > > PAM support for UO is provided at UniData 7.2.0. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File corrupt
> Would you be willing to share the script? Other users' replies already cover everything I have in my script, so I won't make a duplicate posting. [But I will make a posting indicating that I'm not making a duplicate posting.] U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Security and Permissions
Bill, We've had to resolve a similar issue. We're on AIX, but maybe our solution will give you an idea. We have created two userids. The first is user-specific and has the folder privileges required to use UD. But the login is restricted so that they're forced into UD screens and can't get to the OS level. The second ID is shared (wouldn't have to be, though) and has read-only access to the UD folders but broader access to the rest of the system. So maybe your client sets up two ID's for each of the admins that don't get full control. The first forces them to run the UD app, the second has reduced access to UD but gets them to the OS and admin stuff. Brad. > > A client of ours is running UD. The client has a corporate dbms account > that they only want two people to have access to. Their regular dbms > account is defined, via Windows permissions, to allow access to their > UniData users and Windows administrators. There are several > administrators for this machine, three of which they don't want to have > access to this corporate dbms directory/account and one they do. > > We've created a group "corporate" and assigned this group, and only this > group, as having "full control" of the corporate directory. However, > UniData won't work unless this directory gives access to the > "administrators" group. How can I accommodate our clients requirements? > > Thanks, > > Bill Haskett U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Predicting application performance
I haven't found anything in the archives and I don't remember seeing this specific question addressed by the group. Please forgive if this has already been discussed. This is a mystery upon which I'm hoping this list can shed some light. I'll sit and watch nmon display CPU stats and see *tons* of waits but the end users experience no slowdowns. At other times nmon may show waits more in the 30% - 40% range and users start complaining about bad response times. We've tried watching I/O and memory/paging space also and don't see any discernible patterns. Does anyone have thoughts on how to predict UD app performance based on CPU, I/O or other system stats? UD 7.1 AIX 5.3 Disk: SAN (EMC) U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData/InfoLease: how to map a file descriptor number back to actual filename
We are experiencing intermittent performance issues with InfoLease. Our AIX admin wants to use filemon to monitor individual file activity. The problem is that if a file is already open when filemon is started, filemon returns a pid / file descriptor combo instead of the actual filename (see below). Is it possible to figure out which file is actually being referenced? Most Active Files #MBs #opns #rds #wrs file volume:inode 413.6 0 52939 0 pid=7241756_fd=55 383.5 7 49089 0 LS.MASTER Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData performance problems
We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
Thanks for all the input and for the confirmation that overflow 2 generates more I/O. We tend to see normal or decreased I/O during slow periods, so maybe sizing isn't the root cause. I'll chew on things some more. Maybe I'll even break down and call Tim! Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] EXECUTE in udcs Sessions (UniData)
Bob, I'd suggest figuring out some way for the script to know which userid to use (AIX environment variable? A udt variable? Change your EXECUTE to pass the name in at the command line?). You could then modify your scripts to 'su' to the user before performing the restricted functions. Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF The answer to life, the universe and everything [EMAIL PROTECTED] wrote on 11/29/2006 08:38:03 AM: > We have UniData 6.1.15 running atop AIX 5.2. > > When a user has connected via the web and udcs, and runs applications that > do EXECUTE, the executed process is being run as root, not the user running > the application. > > This creates havoc when running UNIX scripts that rely upon the users name > to complete certain tasks. > > > > Has anyone run into this, and what was your solution? > > > > Regards, > > Bob Wyatt > Ashwood Computer, Inc. > Private E-Mail: [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Screen manager "screen"
We aren't using it yet, but are working on it. For us, screen will be used primarily by operators for long-running processes, so we have to deal with the fact that the person who started a job may not be around to check on it until it completes. We expect to address this by setting up a shared userid. Operators will login as themselves then 'sudo su' to the shared userid. Since screen attempts to connect to the port that is already being used by the operators id, the operators will run ssh under the shared id and then kick off screen. If anyone has any other ideas on how to address port contention, I'd be interested. This approach allows anyone with 'sudo su' to the shared id to monitor the jobs. Using sudo helps address security concerns inherent in shared ids. Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF The answer to life, the universe and everything [EMAIL PROTECTED] wrote on 12/20/2006 04:03:17 AM: > Good day, > > Anybody using the screen manager ('screen' on linux/unix)? > Any gotchas we should know of? > > We are on AIX 5.3; UV 10.1.4 > > Thanks. > Schalk van Zyl > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData Dynamic File Behavior
I've seen this before and had it explained before. The explanation made sense for about ten minutes. This was one of several symptoms we were seeing with dynamic files that caused us to bring IBM in for consultation. Rober DunnMiller was the guy. I think he eats this stuff for breakfast. Very helpful. I wasn't deeply involved in resolution, so I can't tell you much. Brad Schrag The answer to life, the universe and everything [EMAIL PROTECTED] rguson.com Sent by: To [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 01/10/2007 01:26 [U2] UniData Dynamic File Behavior PM Please respond to [EMAIL PROTECTED] er.u2ug.org Hello and happy new year! HpUx 11.11 - UniData 6.1.18 - We have a dynamic file created with KEYDATA using the default split/merge of 95/40. Monday night, an automated purge process kicked off removing approx. 310,000 plus records from this file. On Tuesday, the process was still running and the file was consuming disk space at an alarming rate. We are mystified why the deletion of records from a dynamic file would cause it to grow. It essentially split to the point of more than doubling in size (started with 3 'dat' files and 1 'ovr' file and grew to 8 'dat's and 1 'ovr'). When we resized the file in the wee hours of the morning, we reclaimed approx. 10 gig of disk space. Does anyone know what would cause a dynamic file to grow when removing records? TIA! Shaun P. Ferguson Sr Program Analyst Ferguson Enterprises, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Launching UV via HP-Ux
> 2. Why does it not work when doing... > >#cd /usr/ibm/uv/bin >#uv >sh: uv: not found. ># I'm not real familiar with HP-UX, but try "./uv" instead. Or you could add "." to your PATH statement. Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF The answer to life, the universe and everything -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Running UniData on SAN
A few months ago someone mentioned that a paper was forthcoming from IBM re recommendations on running UniData on a SAN. Does anyone know the status of this paper? I don't see anything out there yet. tia Brad -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Sending Ctrl-break to udt process via kill?
It would take a while to explain exactly why I'm asking this question, but the basic idea is that I'm trying to develop an alternative to GNU screen because screen won't work in a specific context where it would be quite helpful. If anyone who wants more info they're welcome to contact me directly. Is there a way to send the equivalent of a ctrl-break to a udt process externally from the shell? I want this to result in the udt session responding as if the user had pressed ctrl-break themselves, e.g. if a program is running, drop to the debugger. I've experimented with the kill command, but everything either flat out kills the process or seems to be ignored by the process. Any ideas would be most appreciated. TIA, Brad. -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Sending Ctrl-break to udt process via kill?
> Try kill -2 UD_PID# > > The process can't have BREAK OFF or pterm break off or pterm intr off for > this to work. I *know* I tried this exact thing and it didn't work. Now it does. I guess I didn't know what I thought I knew. Thanks, Karl. -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Broadcasting messages
I know you said you've turned off unix messages, but we use a scripted 'wall' command. You can't specify where it shows up on the screen, but it's always in the bottom few lines. depending on how long the message text is. Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF The answer to life, the universe and everything [EMAIL PROTECTED] wrote on 07/06/2007 11:36:37 AM: > We want to send messages to the users when we need to shut the system > down. We tried MESSAGE from Universe, but it displayed the message at > the cursor position and doesn't refresh the screen. We've turned off > UNIX messages because the users were getting all kinds of messages that > were doing the same thing. Anyone know of a way to send messages out to > all logged in users so that it shows up on a specific line of the screen? -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD - Open command
I can't speak authoritatively for UD on Windows, but if this is a sequential file, I think you'll have to use OPENSEQ instead of OPEN. > OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT "File abort." ELSE STOP 201, > 'E:\DataShare\Temp' Brad The answer to life, the universe and everything. sdg -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OCONV Extraction Question
I don't know about OCONV, but FIELD works well. VAR1 = 'SAM':@VM:'TRUDY' CRT VAR1 CRT FIELD(VAR1,@VM,1) Yields: SAM}TRUDY SAM HTH U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question
Didn't work for me either. It may not fit what you need, but SWAP can make it work. VAR1 = 'SAM':@VM:'TRUDY' SWAP @VM WITH '*' IN VAR1 FMTSTR = 'G*1' CRT OCONV(VAR1,FMTSTR) Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] problem calling program from shell script
I'm in the process of automating various vendor processes by calling them from a shell script which can be run by a scheduler. I've done a couple single-threaded processes this way and it works fine. But I'm having difficulty with a multi-threaded process. At least it seems that single/multi-threaded is the key difference. This is a sample from my shell script. The "\n3\n1\n" passes required inputs of 3 and 1 to MT.PROC echo "MT.PROC \n3\n1\n" | udt MT.PROC starts and performs several single-threaded commands without issue. It is then supposed to start 10 phantoms and launch a monitoring process, MT.WATCH. MT.WATCH provides updates on phantom progress every minute. The problem seems to come up when MT.WATCH is started. It seems almost as if MT.WATCH never gets a chance to start since it doesn't display anything. MT.PROC thinks it's done, performs a few more commands and returns to TCL. When I start MT.PROC from TCL it works just fine. So it's the combination of script/UniBasic that's causing the issue. I'd appreciate any ideas on what to look for, trap or, worst case, ask the vendor (for a small fee). UniData 7.1 AIX 5.3 tia Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] problem calling program from shell script
>How is MT.PROC starting MT.WATCH? I wish I knew. That's part of my problem since both MT.PROC and MT.WATCH are 3rd party software. One more clue that may make your question irrelevant: in a successful, non-scripted run, the phantoms start up before MT.WATCH starts displaying status. This might mean that the issue lies in MT.PROC instead. I've started looking at @USER.TYPE. Is there any UniData reason @USER.TYPE = 2 would cause a phantom not to start? My tests suggest No, but would like confirmation. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] problem calling program from shell script
Thank you to those who proposed ideas. The issue appears to be something in the vendor code over which I have no control. Working with vendor now. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OCONV DATE ISSUE.
>The question is when I do >OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, 'DM')-1 I get 1 not 01. >Why? And how do I get these to match? I saw this trick once. Might be adaptable. The idea is to make a string of month numbers and do an index. Only way I can think of to avoid creating/maintaining 36 i-descs is to write a program. S = '010203040506070809101112' PRINT SUBSTRINGS(S,INDEX(S,OCONV(DT,'DM'),1)-2,2) Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/