Recent content by gatetec

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

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

Thanks so much. It is a big help!!

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

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.

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

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

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

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

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

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

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

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

Thanks so much. I got it!!!

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