AnsweredAssumed Answered

How to increase the MAX characters allowed in script Variable

Question asked by JohnO'Mullane on Oct 14, 2016
Latest reply on Mar 14, 2017 by joel_wiesmann_automic
Hi,
I've written a script that checks the status of my mounts.
The best way I found to send summary email at the end was to keep adding data to a variable and then use SEND_MAIL with this variable as it's body. (Script below)

This works fine but I noticed today that I'm getting this error when there appears to be a large amount of data.

The maximum record length of 1023 characters was exceeded.


Is there a way of increasing this value or should I maybe look at doing this a different way?

John.


:SET &MailText# = "These are the remaining hosts with Mount issue&nl# Please Investiage and resolve&nl#"
:SET &HND2#=PREP_PROCESS_VAR(DBA.BACKUP_MOUNT_RESULTS, ,"0",4)
:PROCESS &HND2#
:   SET &DB_HOST# = GET_PROCESS_LINE(&HND2#,2)
:   SET &BACKDIR# = GET_PROCESS_LINE(&HND2#,4)
:   SET &PROD_DB_NAME# = GET_PROCESS_LINE(&HND2#,6)
:   SET &MailText# = "&MailText#&nl# &DB_HOST# with mount &BACKDIR# on Database &PROD_DB_NAME# &nl# "
:ENDPROCESS
SET &OUT# = SEND_MAIL('johnom@xilinx.com',,'Subject",&MailText#)

Outcomes