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

["madav ." <vmadav@HOTMAIL.COM>]

You are correct , I did same way , I got solution.

Thanks to Brian and Tony.

-Madav


>From owner-sqr-users@list.iex.net Wed Jan  6 08:41:17 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 JAA03048; Wed, 6 Jan 1999
09:40:17 -0700 (MST)
>Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release
1.8b) with
>          spool id 27269 for SQR-USERS@LIST.IEX.NET; Wed, 6 Jan 1999
09:34:38
>          -0700
>Received: from mx04.netaddress.usa.net (mx04.netaddress.usa.net
>          [204.68.24.141]) by list.iex.net (8.8.5/8.8.5) with SMTP id
JAA01122
>          for <sqr-users@list.iex.net>; Wed, 6 Jan 1999 09:20:09 -0700
(MST)
>Received: (qmail 24967 invoked by uid 0); 6 Jan 1999 16:20:09 -0000
>Received: from ccci.org [208.135.115.37] by mx04 via mtad (2.6) with
ESMTP id
>          139DaFqui0047M04; Wed, 06 Jan 1999 16:20:08 GMT
>Received: from HQ-Message_Server by ccci.org with Novell_GroupWise;
Wed, 06 Jan
>          1999 11:20:07 -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:  <s69346e7.061@ccci.org>
>Date:         Wed, 6 Jan 1999 11:19:50 -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:         SQR-USERS@USA.NET
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>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=3DUS-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=20
>>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=20
>>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>>
>>In the process definition for that SQR, under the Process Definition
=3D
>>Options tab, SQR Parameters line, change the drop down to Append and
>add =3D
>>%%INSTANCE%% to the parameter line.  Then in your SQR, use an input
=3D
>>statement to get the command line parameter.
>>
>>  input $processInstance
>>
>>Now that you have the instance, construct a filename, and use the =3D
>>NEW-REPORT command in SQR to change the name of the .LIS file. Be sure
>and =3D
>>issue this before any Print statements are done in the SQR.
>>
>>  let $file =3D3D 'abc' || $processInstance || .LIS'
>>  new-report $file
>>
>>Hope that helps
>>
>>
>>/********************
>>* Brian Nice
>>* Senior Programmer/Analyst
>>* Campus Crusade for Christ
>>* bnice@ccci.org=20
>>*********************************/
>>
>>>>> "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=20
>>
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>


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