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.
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.