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 attachment

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

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 LRGLBR

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 earl

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

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*

[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 resu

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 fo

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 i

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 attach

[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

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 Priva

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 ---

[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 Inf

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 -

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: Joh

[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 outs

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 ther

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 wo

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

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

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.

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...@listserv

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 thi

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. F

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 -

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 annotatio

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

[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, cont

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 volu

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 Univer

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

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

[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 requir

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 co

[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

[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 er

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

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 P

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 is

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 > T

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 -

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

[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*

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

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

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

[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 spreadsh

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 f

[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

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.

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

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

[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 followin

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

[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 -

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

[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 com

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 f

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 her

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 e

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 enviro

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

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/mai

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. Thi

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 m

[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-thread

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 - Ele

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 a

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

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 an

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.

[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.

[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 -- Electro

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 l

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 helpf

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 use

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 Schra

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-

[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 w

[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)