Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content
  • Clearing SQL database with Scribe

    Manoj Chaurasia

    Recently working on a migration project using Scribe, we load big volumes of testdata in SQL staging tables, but when we want to clear the tables it takes a very long time to clear all records for reloading data.

    Is there a quicker way to clear a SQL database table using Scribe without deleting records one by one?


    1) With the Scribe Microsoft SQL Server Connector:

    Use the "Native Query" Block with a double SQL statement and add "for each result Block", make sure you test and validate your native query and save your map.

    SELECT  1 AS One;

    DELETE FROM [dbo].[mytablename];

    2) Alternatively, you can use storedprocedures(to clear the data faster) and call/trigger them from a Scribe map using 

    Scribelabs Tools connector Query block to trigger one scribe run with current timestamp then call the storedprocedure once. 

    See Scribe Tools Connector documentation here:  

    See SQL Server Connector documentation on using Storedprocedures:

    User Feedback

    Recommended Comments

    There are no comments to display.

  • Create New...