Quiz question (.txt extension)
brian_matthewsbrian matthews
brian_matthews_bmw@hotmail.com
Thu, 02 Jun 2005 18:48:03 +0000
the Windows platform variable approach works fine, and so I assumed Unix
worked in the same way. I wonder way Cognos do not make the platforms work
consistently ?
Many thanks to Goparaju for this feedback to the list - so often I get the
impression that issues are being discussed offlist - which begs the question
- why join a list if you are not going to dialogue with it ?
regards Bri,
>From: "Goparaju, Vidyasagar" <VGoparaju@tradepointsystems.com>
>To: "Pat Shugart" <ShugartP@trinity-health.org>,
><brian_matthews_bmw@hotmail.com>, <powerh-l@lists.sowder.com>
>Subject: RE: Quiz question (.txt extension)
>Date: Thu, 2 Jun 2005 14:07:18 -0400
>
>The only trick that really worked for me was to establish a symbolic link
>to quizlist.txt --> xxx.rpt
>And delete the symbolic link after the report generation.
>
>$ ln -s SAGAR.SAGAR quizlist.txt
>$ quiz
>Q U I Z (PowerHouse 8.43.D)
>Copyright 2004 COGNOS INCORPORATED
>Licensed PH8-UNIX-RUNTIME-W-REPORTING for customer: 0007140001 GENERAL
>MOTORS IU
>
> > access shipment_dates in asa
> > rep file_no
> > set rep limit 10
> > set rep dev disc
> > go
>
>*W* The maximum number of records has been selected.
>
>Records selected: 10
>Lines printed: 12
>Pages printed: 1
>
> > e
>$ rm quizlist.txt
>
>$ ls -l SAGAR*
>-rw-rw-rw- 1 vgoparaj tpsapps 234 Jun 02 14:07 SAGAR.SAGAR
>
>
>Good luck
>
>Sagar
>TradePoint Systems LLC
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Pat Shugart
>Sent: Thursday, June 02, 2005 12:52 PM
>To: brian_matthews_bmw@hotmail.com; powerh-l@lists.sowder.com
>Subject: RE: Quiz question (.txt extension)
>
>Brian,
>
>That's pretty much what we're doing already. Maybe the code snippets
>below will clarify things a bit...
>
>Job Script:
>export mbar0023="$AMISYS_SPOOL/${AMISYS_JOBNUM}_mbar0023.rpt"
>quiz << !EOQUIZ
>USE $CQUIZ/mbar0023.qzc
>EXIT
>!EOQUIZ
>
>Quiz Program:
>SET REP LIM 2000000 NAME $mbar0023 DEV DISC
>
>Output:
>$ ls /aa/2/dev/jcl/spool/j405_mbar0023*
>/aa/2/dev/jcl/spool/j405_mbar0023.rpt.txt
>
>/pat
>
> >>> "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
>06/02/05 1:20 PM >>>
>you could always try a setsystemval to create a variable
>'QUIZREP'containing
>the required file name and the then add the following to the quiz
>report
>'set report device disk name $QUIZREP'
>
>regards Bri,
>
>
>
>
> >From: "Pat Shugart" <ShugartP@trinity-health.org>
> >To: powerh-l@lists.sowder.com
> >Subject: Quiz question (.txt extension)
> >Date: Thu, 02 Jun 2005 13:01:52 -0400
> >
> >Greetings Listers,
> >
> >Environment: HP-9000, HP-UX, v8.43D
> >Amisys migration from HP3k to Amisys Advance2 on HP9k
> >
> >When we run Quiz reports, the reports have a .txt extension on them.
> >We're trying to force another extension on the filename but are not
> >having any success. We get filenames like <reportname.rpt.txt> with
>that
> >pesky .txt sticking around no matter what we do. We've reviewed the
> >documentation, but are not finding anything that addresses this
> >situation.
> >
> >Does anyone have any ideas?
> >
> >TIA,
> >
> >--
> >Pat Shugart
> >Trinity Information Services
> >34605 Twelve Mile Road
> >Farmington Hills, MI 48331
> >248.489.6123
> >248.488.9195 (fax)
> >
> >--
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >Mailing list: powerh-l@lists.sowder.com
> >Subscribe: "subscribe" in message body to
>powerh-l-request@lists.sowder.com
> >Unsubscribe: "unsubscribe <password>" in message body to
> >powerh-l-request@lists.sowder.com
> >http://lists.sowder.com/mailman/listinfo/powerh-l
> >This list is closed, thus to post to the list you must be a
>subscriber.
>
>_________________________________________________________________
>Be the first to hear what's new at MSN - sign up to our free
>newsletters!
>http://www.msn.co.uk/newsletters
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a
>subscriber.
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>STATEMENT OF CONFIDENTIALITY:
>The information contained in this electronic message is intended for the
>exclusive use of the addressee(s) and may contain confidential information.
> If you are not the intended recipient of this email, be advised you have
>received this message in error and that any use, dissemination, forwarding,
>printing, or copying is strictly prohibited. Please notify TradePoint
>Systems LLC immediately at (603) 889-3200 and destroy all copies of this
>message and any attachments.
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
_________________________________________________________________
Winks & nudges are here - download MSN Messenger 7.0 today!
http://messenger.msn.co.uk