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

[Brian Nice <bnice@CCCI.ORG>]

Your welcome. There is an easier way that I didn't think of when I sent the message.  When you do the calls in the SQR
  do Define-Prcs-Vars
  do Get-Run-Control-Parms
(these are in prcsapi.sqc and prcsdef.sqc)

it gets a process instance for you:
   #prcs_process_instance

You should be able to use that variable.
That should be easier!


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

>>> "madav ." <vmadav@HOTMAIL.COM> 01/06 10:47 AM >>>
Thanks for your valuable input and it saves me time.

Madav.

>From owner-sqr-users@list.iex.net Tue Jan  5 12:14:13 1999
>Received: from list.iex.net (list.iex.net [192.156.196.15]) by
list.iex.net (8.8.5/8.8.5) with SMTP id NAA21620; Tue, 5 Jan 1999
13:13:39 -0700 (MST)
>Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release
1.8b) with
>          spool id 30306 for SQR-USERS@LIST.IEX.NET; Tue, 5 Jan 1999
13:13:07
>          -0700
>Received: from ccci.org (ccci.org [208.135.115.37]) by list.iex.net
>          (8.8.5/8.8.5) with SMTP id NAA21546 for
<SQR-USERS@list.iex.net>;
>          Tue, 5 Jan 1999 13:12:58 -0700 (MST)
>Received: from HQ-Message_Server by ccci.org with Novell_GroupWise;
Tue, 05 Jan
>          1999 15:12:30 -0500
>X-Mailer: Novell GroupWise 5.2
>Mime-Version: 1.0
>Content-Type: text/plain; charset=US-ASCII
>Content-Transfer-Encoding: quoted-printable
>Content-Disposition: inline
>Message-ID:  <s6922bde.064@ccci.org>
>Date:         Tue, 5 Jan 1999 15:12:12 -0500
>Reply-To: SQR-USERS@USA.NET 
>Sender: "Discussion of SQR,
>              SQRIBE Technologies's database reporting language"
>              <SQR-USERS@list.iex.net>
>From: Brian Nice <bnice@CCCI.ORG>
>Subject:      Re: How to include Instance ID in SQR output file name?
>X-To:         vmadav@HOTMAIL.COM, SQR-USERS@USA.NET 
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>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 =3D '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 
>


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