Using the latest update of R:BASE X.5, I suggest to try everything
first, and then make any comments, if necessary.
Very Best R:egards,
Razzak
At 10:04 AM 3/8/2021, 'Karen Tellef' via RBASE-L wrote:
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.
--
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/1MXYdX-1lFhzm0cBz-00Z3Ge%40mrelay.perfora.net.
