Search results for query: *

I am installing a new machine (XP SP2) for my sister and would appreicate your comments on what security measures i should take I am going to install; Anitivirus Adaware Spybot Spywareblaster Zonealarm (and switch off the MS firewall) Anything else ? Alex

I have a workbook containing entries for outstanding and closed project issues (one sheet for each) There are currently 8 of these pairs for various sub projects I have linked the sheets to the 'front page' by formula in order to give a summary overview of everything For each sub project...

I'm using SUMPRODUCT in the following way to compare dates =SUMPRODUCT((Orange!$A$2:$A$247>0)*1,(Orange!$I$2:$I$247<NOW()-14)*1) This will give me the number of dates that are 14 days or older than todays date Good so far! Now I want to find the number of dates which are 7 days older than...

On shutdown I usually get an error box complaining that 'lass.exe has experienced an error' Any clues ? Alex NOTE - this is lass.exe NOT lsass.exe

I have code to create a procedure create or replace procedure SP_RSV ( warehouse IN STSTYL00.ST00_COM_DIV%TYPE, startpoint IN PXSTYL00.PX00_DCR%TYPE, endpoint IN PXSTYL00.PX00_DCR%TYPE, o_result_set OUT sys_refcursor) IS BEGIN OPEN o_result_set FOR............ however...

I have a script [code] select ordernr||'|'|| ordstatcd||'|'|| clientordref||'|'|| custordref||'|'|| soheadref1||'|'|| soheadref2||'|'|| collection\$acccd||'|'|| RECIPIENT\$ACCCD||'|'|| carrcd||'|'|| to_char(delivery\$date, 'DD-MON-YYYY HH24:MI')||'|'|| to_char(delivery\$time, 'DD-MON-YYYY...

Is there any difference between AIX 5.1 & 5.2 apart from the machine architecture on which they run ? Alex

rootvg as below VOLUME GROUP: rootvg VG IDENTIFIER: 0048273c99e78cd8 VG STATE: active PP SIZE: 32 megabyte(s) VG PERMISSION: read/write TOTAL PPs: 1084 (34688 megabytes) MAX LVs: 256 FREE PPs...

AIX 4.3.3 assumed to be ML 6 BUT oslevel 4.3.3.0 oslevel -r 4320-02 instfix -i | grep ML All filesets for AIX43ML were found. All filesets for 4.3.0.0_AIX_ML were found. All filesets for 4.3.1.0_AIX_ML were found. All filesets for 4.3.2.0_AIX_ML were found. All filesets...

44p - AIX 4.3.3 trying to clone one of my other systems onto the 44p (have done this at least 8 times with no problem) When the system reboots I get the following error 0781-199 unable to create socket errno=66 type of socket not supported in this protocol family inetd does not start Any...

Oracle 8.0.5.1 AIX 4.3.3 I have a table column defined as char(50) It contains a time and date stamp defined as YY,MM,DD,HH,MI,SS I am trying to convert this to a real date using select to_date(PH00_CUSTOM_RESERVED, 'YY,MM,DD,HH,MI,SS') from phpick00 but get select...

RS/6000 S70 8 x 125Mhz procs Running Oracle 8.0.5 Load factor about 4 Total processes on the system ~2000 When I check the databases are up ( ps -ef| grep ora_ ) the result takes at least 1 minute to come back. This has slowed down over the last month or so example of sar is 09:00:10...

I am trying to do this (the real code is a bit large - so for brevity....) insert into <table> select a.column, b.column from table_a table_b where <statement> union select a.column, b.column from table_a table_b where <statement> and I get the error ERROR at line 1: <table> ORA-00947: not...

We use a 3570 library to back up our RS/6000s Recently we have done a Disaster Recovery test and found we could not read the tapes from one of our systems. Many days later (our systems are all geographically seperated) I found that I could not read the tapes on either of our 2 other libraries...

I have 2 tables one containing headers (ahasnf00) the other containing detail (adasnf00) I need to purge both, but cannot work out how to purge the detail table. The connection between the 2 tables is shipment number as in the following SQL select b.AD00_SHIPMENT_NBR from ahasnf00 a...

I have a query; select a.depotcd ||'|'|| b.carrcd ||'|'|| b.name ||'|'|| b.address1 ||'|'|| b.address2 ||'|'|| b.city ||'|'|| b.state ||'|'|| b.zipcd ||'|'|| b.contact ||'|'|| b.telnr ||'|'|| b.faxnr ||'|'|| b.currencycd ||'|'|| b.scac ||'|' from zzzzzz a, carriers b; How can I...

Yes, you need a database and a listener. You need to look here http://technet.oracle.com/documentation/oracle8i.html (you have to register, but its free) Checkout the AIX install guide and the Concepts manual in the Oracle8i On-Line Generic Documentation Release 3 (8.1.7) (view library) Alex

I am using Project 2000 SR1 with Central SR1. When I assign a task using team assign it updates the confirmed field to Yes instead of Response pending (as per the help). Is this a known bug or has anyone seen it before and know how to get around it? Alex

I am a new user of Project Central and am trying to upload a project. I have been told that the way to do this is as follows; set up tools/options/workgroup settings set up ODBC data source to server open project to be saved 'save as' project using ODBC to server. login as administrator and...

This log keeps growing on my H70 - I've had IBM look at the problem and they didn't really explain what the dpid2 daemon is and if I should have it running. I run Oracle 8.0.5 and 9.0.1 on this box and need the Oracle Intelligent Agent for interface with HP Openview. Do I need to run the dpid2...