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: alexhu
  • Content: Threads
  • Order by date
  1. alexhu

    Brand New Home Machine - What Security?

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

    Excel - Editing Multiple Formula

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

    SUMPRODUCT Formula Problem - Dates

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

    Lass.exe Error

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

    sys_refcursor pre 9i

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

    Column headers and concatenation

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

    AIX 5.1 & 5.2 - Any Difference ?

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

    Expanding Filesystems

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

    Confused about Maintainance Levels!

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

    inetd won't start

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

    ORA-01841 troubles

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

    ps -ef¦ grep takes forever

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

    Insert with union

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

    3570 Tape Library - DLT Tape Life

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

    Help with SQL

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

    Column headings

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

    Yes, you need a database and a list

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

    Confirmed / response pending with Project Central

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

    Project Central Woes!

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

    dpid2.log

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

Part and Inventory Search

Back
Top