I'm trying to figure out how this would work. If you had an INSERT Trigger on a table and did an UNLOAD ALL, when you bring the file in would it execute the insert trigger for every that's reloaded? That's something to be concerned about if it's true. I always separate an Unload Structure and Data, never do an "all" if I can help it, so it would be possible to modify the structure file and delete the trigger command. I'm thinking that trigger commands should come after the data is loaded into a table?
Karen -----Original Message----- From: A. Razzak Memon <[email protected]> To: [email protected] Sent: Mon, Mar 8, 2021 8:37 am Subject: [RBASE-L] - Tip of the Day: Enhanced UNLOAD Output for Stored Procedures Monday, March 08, 2021 Tip of the Day: Enhanced UNLOAD Output for Stored Procedures Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.........: 10.5.3.20304 or higher Sections......: Commands Keywords......: UNLOAD, STRUCTURE, DATA, Stored Procedure Did you know that the UNLOAD STRUCTURE and UNLOAD DATA commands were enhanced with the generated output, where stored procedure data is now placed in the structure output? The UNLOAD STRUCTURE output now includes stored procedure data, before triggers, allowing the file output from subsequent UNLOAD STRUCTURE and UNLOAD DATA processes to be utilized for database rebuilds. With this change, stored procedure data is not unloaded as part of the data unload. Also, when performing an UNLOAD ALL, you will now see the procedure data in its new location (right before triggers) rather than in the middle of the data for all the other tables. If your output is going to the SCREEN, rather than a file, and you do an UNLOAD which requires LOB output, a SCREEN.LOB file will be created in the current directory. The end result allows database with stored procedures to be easily rebuild from the separated UNLOAD STRUCTURE and UNLOAD DATA output, which is helpful in database maintenance! Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0MAxNa-1lQvzz3kEW-00A27R%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1405242385.483513.1615215840617%40mail.yahoo.com.
