Recent content by ohchaos

  1. O

    table count does not change after importing records

    Thank you Tom for sharing your insight, knowledge and experience. I will bring it to my manager and try to delete only records that we have to for the upgrade.
  2. O

    table count does not change after importing records

    The issue is resolved. Thank you, Rob and Tom, so much for reading and comments. After changing the import script by adding "Create", I was able to see the total record counts was correctly increased. I would like to keep the database small as possible as I can. so I would like to delete...
  3. O

    table count does not change after importing records

    Sorry, I just did not put the delete command file. It works fine that I can confirm that it actually delete records.
  4. O

    table count does not change after importing records

    I put the same cono=999 in all three codes, export, import and delete statements. There is no other condition in where statement.
  5. O

    table count does not change after importing records

    It's one of the table I am having same issue. There is no cono=888 records. The condition I put in export, import and delete statements is same.
  6. O

    table count does not change after importing records

    I am using the code for exporting and importing the data Here is the script to export. OUTPUT TO /impero/scripts/export/com.data. FOR EACH com WHERE cono=999: EXPORT DELIMITER "~011" com. END. OUTPUT CLOSE. And here is the script to import. INPUT FROM /impero/scripts/export/com.data...
  7. O

    table count does not change after importing records

    Hello all, I need to export some old records and delete them, but want to import them later when a user wants to access those records. so I am testing my scripts and run into an issue that I can not understand. The SQL query or ABL query returns the total records, let's say 1000. I export 100...
  8. O

    Fast and safe way to delete large number of records

    It worked. This is what I was looking for. Thank you so much.
  9. O

    Fast and safe way to delete large number of records

    Rob is correct. Your requirements are really quite vague and any advice we give will have to make far too many assumptions about what you are trying to accomplish. Thank you so much for the code. I am not familiar with 4GL. I need to join two tables to find the orphan records. In MS SQL, this...
  10. O

    Fast and safe way to delete large number of records

    Hello, I need to delete lots of records which is half of the big table (over 60 million records) joining the other table in other database. I can write the delete statement, but wan to run it fast and more importantly do commit after deleting1000 records to avoid the blocking. How can I do...
Top