Is the SQL SUM function allowed in a DB Read step?
I'm trying to pull in the sum from one column from a row of data into a variable I have in my script. Unfortunately, this sum is a field that is stored somehwere in my financial database so I'm having to use the sum function in SQL to get that sum. Is this something I can use in the DB Read step and then assign it to a variable in my script in my DB Get step?
If there's a different way I can do this, let me know.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.