Search results for query: *

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

Well, so much for the Hotfix... I'm already at SP3 which reinforces Laila 's original response. There are some similar hits in MS Support, but no exact matches so far... plus MS shows SP3 as resolution for all I've read -- yeah, right. [thumbsdown] Jim

I maintain project status reports using Excel, Powerpoint and Word, as part of my job. One report for the executive level requires that I copy an Excel status chart and paste it onto a Powerpoint slide. On my old machine, a Dell Latitude C840 w/Windows 2000 Pro, it worked just fine. I now...

That nailed it! Thank you very much. :-) I don't work Excel enough to be really proficient, I'm much better with Access. A gold star for you. Thanks again, Jim Be kind to your neighbor, he knows where you live

Rather than having to type full task numbers into a bunch of cells for tasks on a project, what I want to do is concatenate a calculated number to the right of a milestone number. Example: 2-00010 first task for milestone 2 Now, I want to "calculate" the task numbers for all remaining tasks...

Thanks very much for the starting point. I had to mess around with it a bit, but finally got it working with =DLookUp("[User_ID]","CJIS_Team_Members","[User_LAN_ID]='" & udfGetNetWorkUserName() & "'") as the default value setting for my User ID field. Jim