Recent content by RCPD700

I'm still fairly new to AIX, so I need some help... We're running a transaction processing system similar to CICS (Unikix) which runs 24x7 except for a very brief recycle at 0430 Tue-Sat to implement terminal and user table updates. The recycle normally takes less than 1 minute. When our user...

Not knowing a blasted thing about Oracle, except for its location (down the road), I'll take a WAG and say 8 bytes. I suspect they have a trick or two up their sleeve for handling the BC/AD and more. It probably also may have something to do with whether its unicode or not. Like I say, purely...

Santa, That looks just like what I'm after. No surprise about the "ambiguity" given all the "normal" stuff I'm trying to accomplish while working a pretty nasty problem. But I digress... I put the prompt in my query for our Help Desk folks, so they could enter a single user's initials, or...

I see you noticed an issue... that has been one of my pet peeves for the 15 years I've been working on this system. It was originally designed to run on an IBM mainframe under CICS using CA's Datacom/DB database - which of course is not really relational, though it tries to be. In 2009 we...

I'm new to Oracle and SQL Plus etc. having migrated from Datacom/DB, so I'm basically teaching myself. I wrote a query and debugged it in SQL Plus to assist our Help Desk determine what terminal a user is logged on at. The result was put into a read-only APEX (application express) app by our...

Thanks for the tip Triacona. Unfortunately, there is no form involved, simply a report definition which I use to either list all personnel in all departments, or filter to report personnel for a specific department. I will save your tip for future use however. One never knows when such...

Get in your time machine for this... I have an Access 2000 SP3 database that pulls data via ODBC and produces a report. I tried using the Office Links to "Analyze It with MS Excel" so I could put it into a spreadsheet but the operation fails with the message: "database name can't start the...

You da man" p5wizard! Both suggestions worked perfectly and I was able to successfully rename the files. More importantly, I have learned something. Thanks you very much! RCPD700 Running 4 p550's (9133-55A)

My searching has not been able to find an answer to this, so I'm hoping someone here may have a solution. I was doing some clean-up of unneeded files and found 3 files having names that begin with a dollar sign. If I use cat or more to try to view the file, cat hangs and more responds...

Thank you very much coboldeke, I really appreciate the assistance. You were correct, by length of field A, I intended the positions being used, not the PIC length. Using JUSTIFIED on the receiving field occurred to me, but I immediately dumped that idea since it is being used for just about...

I have a copy of Micro Focus Net Express 3.0 University Edition. I don't recall if it was free of cheap, but cheap is your next best option. I've been using IBM COBOL for 40 years and just made the conversion to Micro Focus Server Express 5.1 on AIX about 18 months ago. I'd rather have their...

Excuse the subject as I was trying to be brief w/o being too cryptic. I would like to find a way to move field A to field B specifying the offset into field B for the length of A. The application needs to construct a signature line where the person's name concatenated with a known job title in...

Entering mon-fri:0800-1800 worked just fine. System didn't complain about a thing. Apparently the single digit day specification for Allowed LOGIN TIMES applies to AIX version 6, not to version 5. I need to find a good AIX reference. Having to learn things "on the fly" is not much fun...

Forgive the rookie question, but we just migrated off a z/OS mainframe to p500 servers running AIX 5.3 and I'm trying to get oriented to the new OS. I'm trying to set the logintimes with smit for a specific user that I want to limit to logging in Mon-Fri between 0600-1800 hours. I've tried...

You're the man (or lady)! That did the trick. Security for both programs was originally set to High. I set both to low as you suggested, then copied the Excel chart into Powerpoint without any error messages! Just for grins, I changed the security level for both programs to Medium, then...