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 Chriss Miller 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
  • Content: Threads
  • 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

    // 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'...
  4. 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
  5. 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...
  6. 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...
  7. 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
  8. 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
  9. gatetec

    Count for CASE & Group By

    I have a script and need to have the counts for A.AssociateID (to get the total emp count per dept) and vComply (which has three outputs, 'Compliant', 'Non-Compliant', 'Current'), grouped by dept. So, the outputs I want are: DEPT EMP_COUNT Compliant Current Non-Compliant 1S 44...
  10. gatetec

    SMT enabled?

    I believe my system is SMT enabled already as the smtctl output shows below. Please let me know if that is not case. Is there anything I need to double-check? Thanks much # smtctl This system is SMT capable. SMT is currently enabled. SMT boot mode is not set. SMT threads are bound to...
  11. gatetec

    Formatting with decimal

    SELECT count(TRANSTYPE)/(select datediff (day, '11/10/2005', '12/31/2008')) as CntperDay FROM dbo.PTINFO Please advise how to format this in decimal i.e. 51.23 Thanks so much
  12. gatetec

    Incorrect SUM returned

    I am trying to get the SUM of c.Assonum, which should return 2,606, but if I plug in sum (c.Assonum) here it returns the SUM of 80,899. Obviously, it is adding a lot more than what is there. Please advise how to get the correct SUM of c.Assonum in this query. select sum (c.Assonum), sum...
  13. gatetec

    Changing output with multiple queries

    I have 6 queries like below. The output I want is: Category(=the 1st column), Yr, Qtr, Cnt. SELECT 'Medication', YEAR(convert (datetime,NurDateOfOcc)) AS Yr, DATEPART(qq,convert (datetime,NurDateOfOcc)) AS Qtr, COUNT(*) AS Cnt FROM .... SELECT 'Falls', YEAR(convert...
  14. gatetec

    Records not qualfying with CASE

    // SQL Server 2000 In the 'DailyLog' table, there is a field called 'VisitReason'. If 'VisitReason' contains both of 'Flu Accept' and 'Flu Vaccine' in the date range given, then I need the count AS AcceptVac. If 'VisitReason' contains 'Flu Accept' but no 'Flu Vaccine' in the date range...
  15. gatetec

    Making directory on each in sync

    I have a cluster node with 5.3 TL 7, and each node has a directory called /tempfs. If there are any changes on /tempfs on Node #1, I want to have it sync'd with /tempfs on Node #2 or vice versa. I can think of using cron with * * * * * to copy from /tempfs on Node #1 to /tempfs on Node #2...
  16. gatetec

    Combining distinctive queries to one

    I have 4 queries below that each query should return different results due to the qualifications in WHERE. What I want is the output is showing in a row i.e. Qry1 Qry2 Qry3 Qry4 Dept A 11 0 1 9 Dept B 3 4 4 7...
  17. gatetec

    Excluding rows with NULL or empty fields

    I have this query to extract the rows that have invalid date data in them. This query pulls out all of rows with empty fields and/or NULL. How do you exclude those with empty fields and/or NULL so that the output contains the rows with wrong dates in them? If any of fields contains a wrong...
  18. gatetec

    "aioserver" and find the db activities

    Is there a way to identify which/what is using "aioserve" processes? I have 6 CPUs, so it gives me 120 max # (6 * 2* 10) of "aioserver", but one thing I am not for sure is what is using the "aioserver"s. The reason I am asking is that I have two identical db cluster nodes. One is having 9 of...
  19. gatetec

    increase # of aioserver

    Is there a way to increase the max # of "aioserver" w/o taking the system down? I have 6 CPUs, so it gives us 120 max # (6 * 2* 10) of "aioserver". I need to increase it if possible. ps -Ao vsz,etime,pcpu,pid,args | sort -rnk 4 |grep aio 448 45-03:41:05 0.0 2666710 aioserver 448...
  20. gatetec

    rm with date range & exception

    temp files are filing up /temp so quickly, and I want to remove all files under /temp with a cron job 1) if there are older than 1 day and 2) if their prefixes are not cmb* pls advise. thx much

Part and Inventory Search

Back
Top