File Mover Blog

March 19, 2022

SQL Source – RecordCount as variable?

Q: With the SQL Source is there a way to access the RecordCount as variable? Would be nice to include it in the subject line of an email Destination. Many thanks!

A: We added two new parameters in version v2022.3.18.0.

  1. %QDC = Query Destination record Count, when using SQL as Destination
  2. %QSC = Query Source record Count, when using SQL as Source

You can use %QDC and %QSC within your email or at other positions where parameters can be used. Some screenshots to get you started.

1. In our example we’ll be using SQL as Source. You can find more information about the setup of ‘SQL as Source’ in our Blog.
Limagito File Mover SQL as Source
2. We’ll be using the new %QSC parameter in an email event:
Limagito File Mover Rule Events
3. We enabled the ‘On Success’ event and the ‘Enable Mail’ option:

Limagito File Mover Rule Event Setup

4. In the email setup we used our new %QSC parameter so the RecordCount will be displayed.

Limagito File Mover Email Message RecordCount

4. Received Email:

Limagito File Mover SQL RecordCount Email

#SQL #Filetransfer

If you need any info about this ‘RecordCount as variable’ option, please let us know.

Best regards,

Limagito Team

By Limagito-Team SQL , Share:
SEARCH