LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  DB Execute: Rowcount for update

    Employee
    Posted 01-15-2015 06:07

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Mario.Maleitzke

    Hi all,

    I'm using a DB Execute node to update records in an Oracle database. Is there any way to let the DB execute node output the number of records that has been updated?

    Thanks a lot for oyur help and with best regards

    Mario


  • 2.  RE: DB Execute: Rowcount for update

    Employee
    Posted 01-30-2015 04:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Mario.Maleitzke

    Nobody there with any idea?


  • 3.  RE: DB Execute: Rowcount for update

    Employee
    Posted 01-30-2015 10:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    You could probably run SQL statements to count the number of records with the sqlSelect() BRAINscript function. You could even do this count both before and after the update statement you are running.

    So:
    To answer your question directly, currently there is no feature on the sqlNonSelect() function or feature you can turn on with the DB Execute node that will give you that information.