Re: Edit Mask for '%'

["Sarabudla, Raji R." <Raji.R.Sarabudla@KP.ORG>]

Hi Kishore,

There is  no such mask or format, which can multiply with 100 and concat
with %. But you can simplify the  above problem by just multiplying with 100
or using the substr & instr  function. You can mask with % (Percentage sign)
using edit in print command.   The following example simplifies your problem

Ex:

Let #number = 0.56
      or databse column

Let $percent = #number * 100
      Or
Let $percent  = substr(#number,instr(#number,'.')+1,2)

Print $percent edit  xx%

Hope this may help,

Raji


----------
From:  *Krishna Kishore [SMTP:KKishore@SMTPGW.ARMS.OHIO-STATE.EDU]
Sent:  Thursday, July 15, 1999 11:38 AM
To:  Multiple recipients of list SQR-USERS
Subject:  Edit Mask for '%'

I am trying to print a report, I want to show a field in percentage:
say
$percent = 0.34
in print section on the report I want it to be printed as 34%.
Print $percent  ( 2,14) ?????????
I know that we can multiply with 100 and concat with '%'
Is there any mask for this.
SQRW V4.0
Any ideas would be appreciated.
Kishore.

----------
From:  Johnson, Dan [SMTP:Dan_Johnson@WRIGHTEXPRESS.COM]
Sent:  Thursday, July 15, 1999 9:24 AM
To:  Multiple recipients of list SQR-USERS
Subject:  Re: Setting Process Scheduler Status to Error

We use 'Control M' as our process scheduler and by setting the SQR variable
#return-status to a recognized error code just before your stop command your
process scheduler should pick this up.

        Example:

          if $Pay_Confirm_Run = 'Y'
            show 'Cannot Run Process, Payroll has already been confirmed.'
            move #error_code to #return-status
            stop
          end-if

        Dan Johnson

        -----Original Message-----
        From:   Shawn Robinson [SMTP:Shawn.Robinson@NOTES.OSIPC.CAN.EDS.COM]
        Sent:   Wednesday, July 14, 1999 3:48 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Setting Process Scheduler Status to Error

        I have developed an SQR, which runs fine in SQRW and from a Custom
Run
        Control Panel.

        Upon completion I successfully update the Process Scheduler to a
'Success'
        Status via   do Stdapi-Term

        In certain circumstances I want to stop the SQR, see example below,
but I'm
        not sure how to update the Process Scheduler Status (to ERROR).

        Example:

          if $Pay_Confirm_Run = 'Y'
            show 'Cannot Run Process, Payroll has already been confirmed.'
            stop
          end-if

        Any help would be appreciated.

        Thanks

        Shawn R
        Information Analyst
        EDS Systemhouse Inc.
        Shawn.Robinson@notes.osipc.can.eds.com