Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RCPD700
  • Order by date
  1. RCPD700

    How can I update one file with data from a second file using a script?

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

    How can I substitute a literal for a specific column value?

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

    How can I substitute a literal for a specific column value?

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

    How can I substitute a literal for a specific column value?

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

    How can I substitute a literal for a specific column value?

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

    Export report to Excel fails w/OLE server registration error

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

    Export report to Excel fails w/OLE server registration error

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

    Canot mv or cp file having name beginning with $

    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)
  9. RCPD700

    Canot mv or cp file having name beginning with $

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

    How to MOVE A TO B with specs

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

    Need COBOL Compiler Selection Help

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

    How to MOVE A TO B with specs

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

    smit logintimes error

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

    smit logintimes error

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

    "Error accessing file..." msg during Excel chart copy

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

    "Error accessing file..." msg during Excel chart copy

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

    "Error accessing file..." msg during Excel chart copy

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

    Need to concat text with calculated number

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

    Need to concat text with calculated number

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

    Select User ID from tbl based on users' Network Name

    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

Part and Inventory Search

Back
Top