Re: How to include Instance ID in SQR output file name?

[Brian Nice <bnice@CCCI.ORG>]

In the process definition for that SQR, under the Process Definition Options tab, SQR Parameters line, change the drop down to Append and add %%INSTANCE%% to the parameter line.  Then in your SQR, use an input statement to get the command line parameter.

  input $processInstance

Now that you have the instance, construct a filename, and use the NEW-REPORT command in SQR to change the name of the .LIS file. Be sure and issue this before any Print statements are done in the SQR.

  let $file = 'abc' || $processInstance || .LIS'
  new-report $file

Hope that helps


/********************
* Brian Nice
* Senior Programmer/Analyst
* Campus Crusade for Christ
* bnice@ccci.org
*********************************/

>>> "madav ." <vmadav@HOTMAIL.COM> 01/05 12:01 PM >>>
I would like to pad Process Instance ID from Process Scheduler with in
the SQR report to generate a unique output filename (eg., abc101234.lis
where 101234 is current Instance ID) .

Any idea to resolve this?
Your help is much appreciated.

Madav

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com