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!

Recent content by toddyl

  1. toddyl

    LEAD Function

    Another group provide data in a flat file and a batch job runs which updates the lots on a daily basis. I dont have access to this system and can only see the resultant output. In the example above on day T they sold off all of lot 1, 50 units, and 25 units of lot2. On T+1 as lot 1 was no...
  2. toddyl

    LEAD Function

    Hi, I have the following scenario in relation to the holding of financial stocks: On 01-Sept-2011 I bought two seperate lots in a stock -- 50 units and 100 units, as depicted below, for day T: Day,Lot_Nbr,Units_Hld,Acq_date ============================== T,1,50,01-Sept-2011...
  3. toddyl

    fopen and getw not working as expected

    Hi, I am working on a Solaris server and have a piece of C code that is meant to read in a text file that contains an integer and it should then increment the integer by 1, use it and then write the new value to the text file. My code has: FILE *uniq_id_file; -- this line is declared near the...
    • toddyl
    • Thread
    • Replies: 1
    • Forum: C
  4. toddyl

    Global Variable and Compiler issue

    xwb, Thanks for your help. What you said corrected the problem and its working now. Cant believe something so simple could cause all the issues I had. Cheers, toddyl
    • toddyl
    • Post #5
    • Forum: C
  5. toddyl

    Global Variable and Compiler issue

    Hi, I have no knowledge of C but have been asked to modify a file to carry out a task. What I am trying to do is to use a global variable to replace a particular variable in a config file. Under the include section I have added the following: int globalvar; In the main() section I have...
    • toddyl
    • Thread
    • Replies: 4
    • Forum: C
  6. toddyl

    Regular Expressions -- Not a particular word

    Annihilannic, Thanks for getting back to me. The doc I have on the app says it uses standard Unix Regular expressions. The values after the word RANGE are taken as the pattern to match. I therefore need to come up with something that will match everything but the ranges above. Cheers, Toddyl
  7. toddyl

    Regular Expressions -- Not a particular word

    Hi, I have an app that uses unix regular expressions to match subjects it will store in its memory cache. I have setup several apps as follows: RANGE: KEY_RANGE_1.[A-T].* RANGE: KEY_RANGE_2.[U-Z].* RANGE: KEY_ROUND.[A-Z].* RANGE: KEY_TOTAL.[0-9].* I need to setup an app that will get all the...
  8. toddyl

    SQLLDR and to_timestamp

    Hi, I have data in the format of server, process, day, time, cpu and value which I am loading into a database table using sqlldr. The day is in the format of DD/MM/YYYY and time is HH24:MI. I am trying to introduce a new column called TIMESTMP of type TIMESTAMP so that I can build an index on...
  9. toddyl

    Writing to a file that is in use by a process

    I have no access or insight into the logging tool so am unable to change that. The only option available to me is to induce/replicate the error so that the Error log eventually contains the message and my monitoring script picks this up. Thanks for the feedback -- its great to get an insight...
  10. toddyl

    Writing to a file that is in use by a process

    Its using its own logger. Unfortunately I have no idea how this works or how to adjust the logger. From what you are saying it looks as if I cannot simply insert my error message into the log but will instead have to find a way or emulating and error so that one appears in the log. Thanks.
  11. toddyl

    Writing to a file that is in use by a process

    Hi, I have a third party process running on a unix box that writes to a log file. The log file is automatically updated every 30 seconds with various stats etc. This file is monitored by another application to see if various errors occur and raised alerts if any are found. I want to test this...
  12. toddyl

    Forecasting algorithm

    Hi, I have been given an Excel sheet for server CPU usage with the following columns in it: Day, Time, Value. I have used the Excel functionality to apply forecasting to this but it is not accurate enough for my needs. Does anyone know of a forecasting algorithm I can apply to this data to...
  13. toddyl

    Partitioning and performance

    Hi, Thanks for your response. It looks as if I may not be able to use partitioning as I appear to be locked down to using only the 1 tablespace -- part of the rules here unfortunately. Is there any other way I can rebuild this table to help improve performance? Thanks for your help, Tom
  14. toddyl

    Partitioning and performance

    Hi, I have a stats table where I am getting 1 minute data from hundreds of server which have serveral processes each on them. The stats themselves are various counters which give me a rate of updates per minute. The table I created used the following SQL: CREATE TABLE STAT_RATE (...
  15. toddyl

    Getting average and max values in PL/SQL

    Hi, I have a table, category_rate, where I am collecting stats per process as follows: Server Process Category Day Time Value ================================================ serv1 a1 Update_FL 15/9 09:00 100 serv1 a2 Update_FL 15/9 09:00 95 serv2 b1...
See more

Part and Inventory Search

Back
Top