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!

  • Congratulations Mike Lewis 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: gatetec
  • Order by date
  1. gatetec

    16 bit MS-DOS Subsystem error

    I am getting this error. Please let me know what to do. 16 bit MS-DOS Subsystem C:\Docuemnts\.....\Temp\help.exe The NTVDM CPU has encountered an illegal instruction. Choose ‘Close’ to terminate the application. Thank you
  2. gatetec

    Converting rtf file to ps (postscript) file

    // AIX 5.3.7 SP1 I have been trying to converting to rtf file with graphics to ps file, but am losing the format. After the conversion, ps file doesn't the graphics and/or indentations properly. What I am trying to accomplish is that #1: use a script to covert rtf to ps #2: send the ps file...
  3. gatetec

    Removing the quick access under File menu

    Thanks so much. It is a big help!!
  4. gatetec

    Removing the quick access under File menu

    // Word 2003 Under 'File' Menu, there are quick links (right above 'Exit') for the files I have opened previously regardless the file exists or not at the time I open Word. i.e. 1 C:\Document......\..\abc.doc 2 C:\Document......\..\edf.doc etc How do you remove these links from the 'File'...
  5. gatetec

    cfgmgr hanging

    I have tried so many ways with IBM Support, but no clue. The only solution was rebooting the nodes, which took care of the issue. Thanks so much.
  6. gatetec

    cfgmgr hanging

    No filesytem is full. I don't see any particular error. I have one entry on errpt: rtprod1db:/> errpt -aj 2F3E09A4 |more --------------------------------------------------------------------------- LABEL: REPLACED_FRU IDENTIFIER: 2F3E09A4 Date/Time: Thu Jan 22 15:53:30 EST...
  7. gatetec

    cfgmgr hanging

    cfgmgr -v gives nothing. It just hangs the same.
  8. gatetec

    cfgmgr hanging

    // oslelvel 5.3.7 SP1 I ran cfgmgr, and it is just hanging and nothing happens. The only thing I can do was either ctrl + c or exit the session. What would be the cause and the fix? Thank you
  9. gatetec

    Odd issue with using CASE

    I have this query, and it works fine other than the result for 'CntElseV' select sum (CASE WHEN StatusColumn ='AcceptVac' THEN 1 ELSE 0 END ) AS CntAccV, sum (CASE WHEN StatusColumn ='AcceptNoVac' THEN 1 ELSE 0 END ) AS CntAccNV, sum (CASE WHEN StatusColumn ='DeclineVac' THEN 1 ELSE 0 END ) AS...
  10. gatetec

    Identifying the difference between 2 tables

    That is odd!!! All field names in each table are correct though.
  11. gatetec

    Identifying the difference between 2 tables

    select nullif(B.firstname ,  A.firstname) as a, nullif(B.middlename ,  A.middlename) as b, nullif(B.lastname ,  A.lastname) as c, nullif(B.addr1 ,  A.addr1) as d, nullif(B.addr2 ,  A.addr2) as e, nullif(B.city ,  A.city) as f, nullif(B.state ,  A.state) as g, nullif(B.zip ,  A.zip) as h...
  12. gatetec

    Identifying the difference between 2 tables

    ok. so, do I need to put below without WHERE clause? from TP2000 A left join TP2000Prev B on B.employee = A.employee Thanks much
  13. gatetec

    Identifying the difference between 2 tables

    I have this query and works fine. The output shows the different records between two tables. Is there a way to know what is different in each record? Sometimes, the output returns over 1,000 records. It is not possible to go over all columns of each record to compare what has been changed...
  14. gatetec

    HACMP envents & e-mail

    Thanks so much. I got it!!!
  15. gatetec

    HACMP envents & e-mail

    ok.... There are a number of HA events. When each event occurs, I like to receive e-mail notifications. Of course, I need the e-mail notification when a failover occurs. I thought I can plug my e-mail address somewhere with SMIT hacmp so that I can get e-mail notifications for all/any...
  16. gatetec

    HACMP envents & e-mail

    Thank you for the tip. I am trying to plug my e-mail address to the existing events so that I can get e-mails. I am not sure I am missing something, but I can't find how to plug my e-mail address into them. please advise. Thanks much
  17. gatetec

    HACMP envents & e-mail

    // HA 5.4 There can many types of HA events, and I want to add my e-mail address so that I can be notified via e-mail if there are any HA events. Please advise. Thanks much
  18. gatetec

    virtualizing windows servers

    I am a UNIX guy, and need to deal with 'virtualizing windows servers" at work. Sorry, but can you please let me know the source/info to get myself familiar with 'virtualization'? I am trying to understand what 'virtualization' is in the Windows world. Thanks much
  19. gatetec

    Count for CASE & Group By

    Thank you so much! It works perfect!
  20. gatetec

    Count for CASE & Group By

    Case When M.RespirtoryResult in ('Deferred', 'Exempt', 'Fail') Then 1 End As IsRespirtoryResult and M.RespirtoryResult not in ('Deferred', 'Exempt', 'Fail') I wanted to double-check the counts again. sorry :-) WHERE clause has "and M.RespirtoryResult not in ('Deferred', 'Exempt'...

Part and Inventory Search

Back
Top