hexagon logo
Register Sign in
  • Replies 4 replies
  • Subscribers 9 subscribers
  • Views 95 views
  • Users 0 members are here
Options
Related

UPDATE command

Matthew D. Hoedeman
I have known about the update command and have even posted it as a possible solution for other users. I have never used it.

So, my question is, have any of you ever had any issues with using the UPDATE command?

I know some of you have had issues with databases getting messed up and then never being able to get any of the data back out of them, do you same people use UPDATE?

The reason I am asking is that I am going to ahve to run a rather large study soon (like, 300 or more!) and I want to automate the process as much as I can. Looping, UPDATE, that kind of thing, with a simple COMMENT to pause the loop and just pressing the DONE button on the remote to get it going through the next cycle. But, for obvious reasons, I do not want to risk losing any of the data and then have to start over (THAT WOULD SUCK!!!!!!).

So, are there ANY draw-backs to using the UPDATE command? What is gonna bite me in the rump on this?
Parents
  • The UPDATE command calls DPUPDATE.EXE to update the database. There is a somewhat undocumented feature that if a file named "STATUTIL.BAT" exists in the pcdmis folder, DPUPDATE will create a copy of the XSTATS11.TMP file, move it to a subdirectory called "STAT", and then process the original file. The STATUTIL.BAT file does not need to do anything - just exist. It could be used to copy the stats file to another location to save it.
    The saved name would be in the format:
    yyMddHttt.TMP where:
    yy - year
    M - month where A - Jan, B - Feb, ...
    dd - day
    H - hour where A = 0, B - 1, (24 hour format)
    ttt - minute & second
    So the data could be sent to the DB again if needed.

    Examples of STATUTIL.BAT:
    ! don't do anything - just can't be an empty file

    or

    @echo off
    ! copy duplicate stats file to a 'safe' location
    copy %1 c:\temp\.
Reply
  • The UPDATE command calls DPUPDATE.EXE to update the database. There is a somewhat undocumented feature that if a file named "STATUTIL.BAT" exists in the pcdmis folder, DPUPDATE will create a copy of the XSTATS11.TMP file, move it to a subdirectory called "STAT", and then process the original file. The STATUTIL.BAT file does not need to do anything - just exist. It could be used to copy the stats file to another location to save it.
    The saved name would be in the format:
    yyMddHttt.TMP where:
    yy - year
    M - month where A - Jan, B - Feb, ...
    dd - day
    H - hour where A = 0, B - 1, (24 hour format)
    ttt - minute & second
    So the data could be sent to the DB again if needed.

    Examples of STATUTIL.BAT:
    ! don't do anything - just can't be an empty file

    or

    @echo off
    ! copy duplicate stats file to a 'safe' location
    copy %1 c:\temp\.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement