From owner-sqr-users@list.iex.net Mon Oct 1 00:06:20 2001 Date: Mon, 1 Oct 2001 00:00:02 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.9 $ $Date: 2001-06-17 13:23:18-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2001/01/26: o Announce new sqr-jobs mailing list; Job Announcements section updated to reflect this new list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2001 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. From owner-sqr-users@list.iex.net Mon Oct 1 07:46:43 2001 Date: Mon, 1 Oct 2001 05:41:30 -0700 From: sathya ananth Subject: sqr ini and fonts I am using Brio portal windows 95 and Oracle 8i database. The sqr.ini file does not list section for fonts and in the command line I am using -printer:wp. I am using the Declare-Printer command and font = 5. I am not able to get the font I would like for the report. I am wondering if the font in the Declare-Printer sould also be listed in the INI file. If yes, why the sqr.ini file is created without [Fonts] section. Thanks. Sathya Ananth __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 09:52:32 2001 Date: Mon, 1 Oct 2001 10:37:55 -0400 From: Debra Robarge Subject: Re: sqr ini and fonts Hi Sathya, The font would need to be listed in the SQR.ini file. However, by default, upon installation the fonts section should of been installed. If your ini file does not include the fonts, you will need to add them. I've included the actual code below of the initial install for you to add. As long as the printer you are printing to recognizes this font, which it should being Times New Roman, (but still verify that) and you have put the font in the ini file you should be all set. [Fonts] ; The following are SQR predefined font styles. ; The numbers on the left are associated with font styles on the right. ; Users may define their own associations between font_numbers and font ; styles using the font_numbers 900 thru 999. ; ; Notes: ; ; - If SQR does not find a particular font a substitute is used. ; - If a font style (fixed or proportional) is defined inside SQR, ; its style will override the setting in this file. ; - Proportional is assumed if the second field begins with the character 'p'. ; (i.e., "4=3DArial,p" would equate to "4=3DArial,proportional") ; - Bold is assumed if a third parameter is supplied. ; 3=3DCourier New,fixed 300=3DCourier New,fixed,bold 4=3DArial,proportional 400=3DArial,proportional,bold 5=3DTimes New Roman,proportional 500=3DTimes New Roman,proportional,bold 6=3DAvantGarde,proportional 8=3DPalatino,proportional 800=3DPalatino,proportional,bold 11=3DSymbol,symbol 900=3Dunknown,proportional 901=3DMS Shell Dlg,proportional 902=3D,proportional 903=3D@SimSun,proportional 904=3D@Batang,proportional [PDF Fonts] ;Font Path =3D Directory where the .afm files reside. Default is SQRDIR 3=3DCourier 300=3DCourier-Bold 4=3DHelvetica 400=3DHelvetica-Bold 5=3DTimes-Roman 500=3DTimes-Bold 11=3DSymbol 12=3DZapfDingbats 30=3DCourier-Oblique 3000=3DCourier-BoldOblique 31=3DHelvetica-Oblique 3100=3DHelvetica-BoldOblique 32=3DTimes-Italic 3200=3DTimes-BoldItalic Hope that helps. Debra A. Robarge Software Instructor and Consultant Strafford Technology, Inc. drobarge@strafford.com www.strafford.com www.briotraining.com -----Original Message----- From: sathya ananth [mailto:sathyaananth@YAHOO.COM] Sent: Monday, October 01, 2001 8:42 AM To: SQR-USERS@list.iex.net Subject: sqr ini and fonts I am using Brio portal windows 95 and Oracle 8i database. The sqr.ini file does not list section for fonts and in the command line I am using -printer:wp. I am using the Declare-Printer command and font =3D 5. I am not able to get the font I would like for the report. I am wondering if the font in the Declare-Printer sould also be listed in the INI file. If yes, why the sqr.ini file is created without [Fonts] section. Thanks. Sathya Ananth __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 07:59:17 2001 Date: Mon, 1 Oct 2001 08:46:06 -0400 From: Linda Combs Subject: Re: How to eliminate blank line ? Have you eliminated the data as the source of the problem? We use Empac and have found that an embedded carriage return/line feed sometimes causes this in our sqr reports. Date: Fri, 28 Sep 2001 10:07:24 -0400 From: "Turner, Ivan" Subject: Re: How to eliminate blank line ? MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" The first thing I would look at is if the program is using the page-size statement. If so, I would remove it. -----Original Message----- From: Altair Costa [mailto:altair@ALBRAS.NET] Sent: Thursday, September 27, 2001 12:37 PM To: SQR-USERS@list.iex.net Subject: Re: How to eliminate blank line ? Thank you Arun I tried it, but I didn't get success. look the attached file with a example. look at the fifth block. Altair Costa From owner-sqr-users@list.iex.net Mon Oct 1 09:09:19 2001 Date: Mon, 1 Oct 2001 09:45:35 -0400 From: "Gordon, Darrell R." Subject: Extraneous Rows Inserted in SQR Hello all - We are running PeopleSoft HR 7.5, People Tools 7.58 - with Informix 9.21HC5, and Unix 11.0 I am having a problem with an SQR that is selecting rows that I have inserted in the program. Here is my select: FROM PS_JOB J, PS_PERSONAL_DATA PD, PS_EMPLOYMENT EMP WHERE J.EFFDT = (SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCDN = J.EMPL_RCDN AND J1.EFFDT <= $Process_Date) AND J.EFFSEQ = (SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCDN = J.EMPL_RCDN AND J2.EFFDT = J.EFFDT) AND J.EMPL_STATUS IN ('A', 'L', 'P', 'S') AND J.REG_TEMP IN ('R', 'T') AND J.FULL_PART_TIME IN ('F', 'P') AND J.EMPL_CLASS = 'A' AND J.SAL_ADMIN_PLAN = 'CMA' AND PD.EMPLID = J.EMPLID AND PD.PER_STATUS = 'E' AND EMP.EMPLID = J.EMPLID AND EMP.EMPL_RCDN = J.EMPL_RCDN In the above example, process_date is '2001-10-01'. Based on my Select, I may insert a row with an effective date of 2001-10-01. If one already exists, I increment the sequence # to avoid an error on a duplicate key. One of the LAST steps in the SQR is to perform the COMMIT (after selecting/inserting rows). The problem is my Select is arbitrarily retrieving some of the rows I have just inserted. When it does, it inserts another row (with an incremented sequence #). There is no rhyme or reason or pattern. Sometimes it may insert 1 or up to 5 extraneous rows. We have a workaround - storing the EMPLID in a temporary variable (Temp_Emplid), adding an ORDER BY J.EMPLID and selecting where J.EMPLID is > than Temp_Emplid. Has anyone else experienced this problem ?? Darrell Gordon III WDW Information Technologies tie-line: 8-264-1972 voice: 407-560-1972 fax: 407-560-6562 "This communication is confidential, intended only for the named recipient(s) above and may contain trade secrets or other information that is exempt from disclosure under applicable law. Any use, dissemination, distribution or copying of this communication by anyone other than the named recipient(s) is strictly prohibited. If you have received this communication in error, please immediately notify us by calling (407) 560-1972. Thank you." From owner-sqr-users@list.iex.net Mon Oct 1 10:52:55 2001 Date: Mon, 1 Oct 2001 08:46:08 -0700 From: Arjan Hoornstra Subject: Re: Extraneous Rows Inserted in SQR I have had a similar problem with the update of a row selected by SQR. I can describe the problem which applies for Sybase, don't know how much applies for or can be translated to Informix. The problem is that, if you insert an extra row, it will go to a datapage. The sqr-select creates a cursor on the table. Now if you add a row to the bottom of the table (depending on index) it will be selected in the end by the sqr-cursor. If you insert it at the head of the table, the cursor has passed this page already so it will not be selected again. Then, if you do an insert, the page on which the row is inserted may be split because the extra row must fit between 2 existing rows. This results in a different number and order of pages which can be selected or reselected by the cursor. So the simple advice is: never place your sqr-cursor on the table you wish to insert or update, or never do an insert or update on the table your sqr-cursor is placed on. You should either: - place the table you need in a temporary table where you put the cursor on, insert/update the original - or store your inserts/updates in a temporary table which you all execute after the cursor is finished. Hope this helps... Arjan --- "Gordon, Darrell R." wrote: > Hello all - > > We are running PeopleSoft HR 7.5, People Tools 7.58 - with Informix > 9.21HC5, and Unix 11.0 I am having a problem with an SQR that is > selecting > rows that I have inserted in the program. Here is my select: > > FROM PS_JOB J, > PS_PERSONAL_DATA PD, > PS_EMPLOYMENT EMP > WHERE J.EFFDT = (SELECT MAX(J1.EFFDT) > FROM PS_JOB J1 > WHERE J1.EMPLID = J.EMPLID > AND J1.EMPL_RCDN = J.EMPL_RCDN > AND J1.EFFDT <= $Process_Date) > AND J.EFFSEQ = (SELECT MAX(J2.EFFSEQ) > FROM PS_JOB J2 > WHERE J2.EMPLID = J.EMPLID > AND J2.EMPL_RCDN = J.EMPL_RCDN > AND J2.EFFDT = J.EFFDT) > AND J.EMPL_STATUS IN ('A', 'L', 'P', 'S') > AND J.REG_TEMP IN ('R', 'T') > AND J.FULL_PART_TIME IN ('F', 'P') > AND J.EMPL_CLASS = 'A' > AND J.SAL_ADMIN_PLAN = 'CMA' > AND PD.EMPLID = J.EMPLID > AND PD.PER_STATUS = 'E' > AND EMP.EMPLID = J.EMPLID > AND EMP.EMPL_RCDN = J.EMPL_RCDN > > In the above example, process_date is '2001-10-01'. Based on my > Select, I > may insert a row with an effective date of 2001-10-01. If one > already > exists, I increment the sequence # to avoid an error on a duplicate > key. > One of the LAST steps in the SQR is to perform the COMMIT (after > selecting/inserting rows). > > The problem is my Select is arbitrarily retrieving some of the rows I > have > just inserted. When it does, it inserts another row (with an > incremented > sequence #). There is no rhyme or reason or pattern. Sometimes it > may > insert 1 or up to 5 extraneous rows. > > We have a workaround - storing the EMPLID in a temporary variable > (Temp_Emplid), adding an ORDER BY J.EMPLID and selecting where > J.EMPLID is > > than Temp_Emplid. > > Has anyone else experienced this problem ?? > > > > Darrell Gordon III > WDW Information Technologies > tie-line: 8-264-1972 > voice: 407-560-1972 > fax: 407-560-6562 > "This communication is confidential, intended only for the named > recipient(s) above and may contain trade secrets or other information > that > is exempt from disclosure under applicable law. Any use, > dissemination, > distribution or copying of this communication by anyone other than > the named > recipient(s) is strictly prohibited. If you have received this > communication > in error, please immediately notify us by calling (407) 560-1972. > Thank > you." __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 10:52:48 2001 Date: Mon, 1 Oct 2001 15:50:32 +0000 From: Elvis Pressly Subject: Re: Extraneous Rows Inserted in SQR I assumed that you are inserting new rows in PS_JOB. Since JOB is a table with multiple keys, I would make my select statements according to the placement of the keys such as 1. Emplid 2. Empl_RCD# 3. Effdt and 4. Effseq. In your select statement you did not include the EMPL_RCD# as the first order of select since I also assumed you are reading JOB as ordered by EMPLID. What I would do is create a procedure to read JOB (just like your select statements) except I will order it by Emplid, Empl_Rcd# desc, Effdt desc, Effseq desc. This way I will always have the latest rows as the first record being read. To avoid reading the subsequent rows, I will have to control the reading of rows within the same EMPLID: Eample: Begin-Procedure Read-Job let $OldEmplid = ' ' let #test = 0 begin-select [Your field selection here] TEST: If #test = 0 move 1 to # test move &EMPLID to $OldEmplid [Do you regular processing here like adding rows] else if &emplid = $OldEmplid goto BYPASS else Move 0 to #test goto TEST end-if end-if BYPASS: >From [Your tables here] where ???? Order by emplid, empl_rcd# desc, effdt desc, effseq desc. end-select end-procedure _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp From owner-sqr-users@list.iex.net Mon Oct 1 09:09:14 2001 Date: Mon, 1 Oct 2001 09:55:42 -0400 From: Patricia Stanley Subject: Re: Calling an SQR from an SQR This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_6832E6F6.9DFCD329 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I finally got a successful call to an SQR from an SQR. Here's my next = dilemma. Is there a way to pass the userid/password from the calling SQR = to the SQR being called. Thanks for the help in advance! >>> andrew.rivers@CWCOM.NET 09/30/01 07:41AM >>> Patricia call system '..\sqrwtPath\sqrwt.exe ..\sqrProgramPath\yourSRQprogram= .sqt databaseConnectionString parm1 param2' Note: Only one string is passed to the system. databaseConnectString may be database dependant: databaseName userName password Oracle: databaseName/password@userName If you do not need to pass any parameters then omit param1, param2, etc. Andrew ----- Original Message -----=20 From: Patricia Stanley To: Sent: Monday, September 24, 2001 4:31 PM Subject: Calling an SQR from an SQR I have written a homegrown SQR and would like it to call a Peoplesoft SQR = that is delivered with their Mass Change capabilty. How do I do this? --=_6832E6F6.9DFCD329 Content-Type: text/plain Content-Disposition: attachment; filename="Patricia Stanley.vcf" BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Patricia Stanley ORG:;Information Systems TEL;PREF;FAX:315.443.2376 EMAIL;WORK;PREF;NGW:pjstanle@syr.edu N:Stanley;Patricia X-GWUSERID:pjstanle END:VCARD --=_6832E6F6.9DFCD329-- From owner-sqr-users@list.iex.net Tue Oct 2 12:50:50 2001 Date: Mon, 1 Oct 2001 18:35:18 +0100 From: Andrew Rivers Subject: Re: Calling an SQR from an SQR Patricia Yes. See the statement in my first email below: call system '... databaseConnectionString ... ' =20 Assume: database name: yourDB user name: yourUN your password: yourPW Using these values, the databaseConnectionString within the string that = is passed to the system call will be, for Oracle: yourDB/yourPW@yourUN or yourDB yourUN yourPW or something similar... I think that the database connection string is database dependent. You can also pass other parameter, e.g. parm1 param2 etc.- see below: You could hard code the database string in the first instance. Alternatively, you could hold the database connection string in a field = in the database, or make a user/database selection (and concatenate the = various strings returned ) to get the required database connection = string in the calling sqt routine . Andrew ----- Original Message -----=20 From: Patricia Stanley To: Sent: Monday, October 01, 2001 2:55 PM Subject: Re: Calling an SQR from an SQR I finally got a successful call to an SQR from an SQR. Here's my next = dilemma. Is there a way to pass the userid/password from the calling = SQR to the SQR being called. Thanks for the help in advance! >>> andrew.rivers@CWCOM.NET 09/30/01 07:41AM >>> Patricia call system '..\sqrwtPath\sqrwt.exe = ..\sqrProgramPath\yourSRQprogram.sqt databaseConnectionString parm1 = param2' Note: Only one string is passed to the system. databaseConnectString may be database dependant: databaseName userName password Oracle: databaseName/password@userName If you do not need to pass any parameters then omit param1, param2, etc. Andrew ----- Original Message -----=20 From: Patricia Stanley To: Sent: Monday, September 24, 2001 4:31 PM Subject: Calling an SQR from an SQR I have written a homegrown SQR and would like it to call a Peoplesoft = SQR that is delivered with their Mass Change capabilty. How do I do = this? From owner-sqr-users@list.iex.net Mon Oct 1 13:01:35 2001 Date: Mon, 1 Oct 2001 10:33:37 -0700 From: M J Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 13:14:51 2001 Date: Mon, 1 Oct 2001 14:03:26 -0400 From: "Vallabhu, Bindu" Subject: Re: SQR # variable is one that carries numbers and $ variable carry character values. # variable should be used when you want to do some calculations. -----Original Message----- From: M J [mailto:mjmaxima@YAHOO.COM] Sent: 10/01/2001 1:34 PM To: SQR-USERS@list.iex.net Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 13:19:26 2001 Date: Mon, 1 Oct 2001 14:04:52 -0400 From: Bruce Kelling Subject: Re: SQR # is used to store a number variable $ is used to store a text or date variable like let #Number_Variable = 10 let $Text_Variable = 'The Answer' SQR will convert data type to another, but in answer to second question, use according to your needs. Typically use #Numbers for calculations, and $Text for printing. Bruce -----Original Message----- From: M J [mailto:mjmaxima@YAHOO.COM] Sent: Monday, October 01, 2001 1:34 PM To: SQR-USERS@list.iex.net Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA From owner-sqr-users@list.iex.net Mon Oct 1 13:17:03 2001 Date: Mon, 1 Oct 2001 11:05:01 -0700 From: Rachael Beatty Subject: Re: SQR --0__=7FL81CsyWxVx7AISWnMxd6jrVd3fulw9AjDgaMV45dMGbYlez5mC8pP9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 7bit # represents a floating point number unless defined as an interger $ is a string variable Rachael > -----Original Message----- > From: "M J" @INTERNET > Sent: Monday, October 01, 2001 10:34 AM > To: SQR-USERS@list.iex.net > Subject: SQR > > > Hi folks: > > Questions about SQRs. What is the difference between > # and $. When should each of them be used? > TIA > > > > __________________________________________________ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.com > (See attached file: C.DTF) --0__=7FL81CsyWxVx7AISWnMxd6jrVd3fulw9AjDgaMV45dMGbYlez5mC8pP9 Content-Type: application/octet-stream; name=C.DTF Content-Disposition: attachment; filename=C.DTF Content-Transfer-Encoding: base64 eJ8+IjwSAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0QcKAAEACwAFAAEAAQD1AAEggAMADgAAANEHCgAB AAsAAgA6AAEAKwEBCYABACEAAABGMzAyQzU3NDkzQjZENTExQUM0MzAwMDBFODY3QzBFRgAQBwEE gAEACAAAAFJFOiBTUVIA5wEBDYAEAAIAAAACAAIAAQOQBgAkCgAAOAAAAAMAAIAIIAYAAAAAAMAA AAAAAABGAAAAAFKFAADwEwAAHgABgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41 AAsAAoAIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAA AYUAAAAAAAALAASACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAsABYAIIAYAAAAAAMAAAAAA AABGAAAAAA6FAAAAAAAAAwAGgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAA AADAAAAAAAAARgAAAAARhQAAAAAAAAsAD4AIIAYAAAAAAMAAAAAAAABGAAAAABSFAAAAAAAAAwAI gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAAmACCAGAAAAAADAAAAAAAAARgAAAAA2hQAA AQAAAAEAAAAAAAAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AC4AI IAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALABGACCAGAAAAAADAAAAAAAAARgAA AACChQAAAQAAAAsADIALIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAACwANgAsgBgAAAAAAwAAA AAAAAEYAAAAABYgAAAAAAAACAQkQAQAAAO0CAADpAgAARAQAAExaRnXvXV2pAwAKAHJjcGcxMjU+ MgD0AfcCpAT0AgBjaEEKwHNldDAgCFBtfw3gBgQF4AKDAFAD1AIAcPBycTIgBxMCgw5QA1VEVG0E IFJtbgKDMzcERwhVAoB9CoAIyCA7ewliDjA1CboXIRbTDiA4vwm6GJEW0wmsAoAKgXYIkKR3awuA ZDQMYGMAUC0LA2MAQQtgbg4QMDPjFMELxCAjIBnQEoAHkEUJ8HQEIGEgZgkAYcJ0C4BnIHBvC4AF QAxudQbQBJAgdW5s/weQBCABAQuACYAecB5hA6C7H1EEkGcEkAqiCoAkIUDZHmJzdAUQHwF2CsAH MLUCYGUh1FIA0BBAZQlQXyHjJGUcYAFAEoBvIXBjQxABEeIxNiAtJnJPvQUQZwuAB0AF0CAxYSGg PyZzJGYlhCVRCxMlhmktyDE0NAFAbGkqEwzQUSoTYiBGA2E6DINiARCgIk0gSiIgPBRtagDAeAdw YUBZAEFIT08uQ09NAD5ASU5URVJO/EVUCuMKgStABmACMCunAk0CIGRheSwgT+UlwG8fwjAxMDAB 0DDQoiAc4DozNBLATS53BFRvK6dTUVItVbJTLhBTQCpgIqAuCJAceC4gsBAALod1YmqPJbEymigf KSpzbDIqMfE4EG11bCjhHGATcQvFCyR0MIBqHtB0cGhc/icMASUyE2IL8BuwJNYUwcMUwSYwOCBI aR6QBvCMa3MroCR5ICBRClDdIqBpAiAeYQbgdQVAMyFwcy4gVxBABUAiUXRsaGUgYAaQZgSQCfBj 80AwH8B0dwnhIdQdsABwXSDQJD9yCfAikGgIYGxFINBlJAEgb2ZAAm0nQPEf8BBwZD8h1FRJ9kEk ayR5X0aPR59InSHUsERvIFkIYEogYULAdG8hRGVMM9FCgTBwIP55CGFKZQXQC3ADIAeBJ4J3BCAD UiEReR8gQsAgsC5FIdRoOlE6Ly9OFHm1SoIuBaBtJGoV8QBRMAAAAB4AcAABAAAABAAAAFNRUgAC AXEAAQAAABsAAAABwUqjB6RLhfMYDQVHuZ+DXsXR07pRAAAfR7AAAwAuAAAAAAALACsAAAAAAAsA AgABAAAAAgExAAEAAAAMAQAAUENERkVCMDkAAQACAHMAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAA RU1TTURCLkRMTAAAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABMQVhISE1YUzAxAC9vPUhpbHRv bi9vdT1MQVhISC9jbj1SZWNpcGllbnRzL2NuPXJiZWF0dHkALgAAAAAAAAC2ZtgWTVzVEaxCAADo Z8DvAQDtZ/1wCjXUEawkAASsTJXjAAADMpScAAAAAAAALgAAAAAAAAC2ZtgWTVzVEaxCAADoZ8Dv AQDtZ/1wCjXUEawkAASsTJXjAAADMpSdAAAQAAAA8wLFdJO21RGsQwAA6GfA7wgAAABSRTogU1FS AB4AQhABAAAASwAAADwxNjNFQzNFMDY0QUU0MDQxOTI0MDVENUYwNDlENkY1MzBCQzEyQzk2QGho Y2RjbXhzMDIuaG90ZWxzLmFkLmhpbHRvbi5jb20+AAADAN4/r28AAAMA/T/kBAAAQAA5ABA0xJaj SsEBAwDxPwkEAAAeADFAAQAAAAgAAABSQkVBVFRZAAMAGkAAAAAAHgAwQAEAAAAIAAAAUkJFQVRU WQADABlAAAAAAAMAJgAAAAAAAwA2AAAAAAADAIAQ/////wsA8hABAAAAAgFHAAEAAAA0AAAAYz1V UzthPSA7cD1IaWx0b247bD1MQVhISE1YUzAxLTAxMTAwMTE4MDUwMVotMjE5OTI5AAIB+T8BAAAA SAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1ISUxUT04vT1U9TEFYSEgvQ049UkVD SVBJRU5UUy9DTj1SQkVBVFRZAB4A+D8BAAAADwAAAFJhY2hhZWwgQmVhdHR5AAAeADhAAQAAAAgA AABSQkVBVFRZAAIB+z8BAAAASAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1ISUxU T04vT1U9TEFYSEgvQ049UkVDSVBJRU5UUy9DTj1SQkVBVFRZAB4A+j8BAAAADwAAAFJhY2hhZWwg QmVhdHR5AAAeADlAAQAAAAgAAABSQkVBVFRZAEAABzCqDICVo0rBAUAACDACrKNNo0rBAR4APQAB AAAABQAAAFJFOiAAAAAAHgAdDgEAAAAEAAAAU1FSAB4ANRABAAAAQQAAADxFRDY3RkQ3MDBBMzVE NDExQUMyNDAwMDRBQzRDOTVFMzAzRTEwOTBFQGxheGhobXhzMDEuaGlsdG9uLmNvbT4AAAAACwAp AAEAAAALACMAAQAAAAMABhAsLdrvAwAHEHABAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAA I1JFUFJFU0VOVFNBRkxPQVRJTkdQT0lOVE5VTUJFUlVOTEVTU0RFRklORURBU0FOSU5URVJHRVIk SVNBU1RSSU5HVkFSSUFCTEVSQUNIQUVMLS0tLS1PUklHSU5BTE1FU1NBRwAAAAACAX8AAQAAAEEA AAA8RUQ2N0ZENzAwQTM1RDQxMUFDMjQwMDA0QUM0Qzk1RTMwM0UxMDkwRUBsYXhoaG14czAxLmhp bHRvbi5jb20+AAAAAKEyAgKQBgAOAAAAAgAEAQAA/////wAAAAADBAIQgAEAFAAAAFVudGl0bGVk IEF0dGFjaG1lbnQAcgcCEoADAA4AAADRBwoAAQALAAQAOwABAC4BAhOAAwAOAAAA0QcKAAEACwAE ADsAAQAuAQIFkAYAzA4AAA0AAAADACEOAAAAAAMACzcEAQAAAwAgDk4OAAADAPcPAAAAAAIBEGgB AAAADgAAAAAAAAAAAAAAAAAAAAAAAABAAAcwUMPhlaNKwQFAAAgwUMPhlaNKwQEDAAU3BgAAAAIB AjcBAAAAAAAAAB4AATABAAAAAQAAAAAAAAACAQo3AQAAAAsAAAAqhkiG9xQDCgMCAQACAfkPAQAA ABAAAABZMI+JgbbVEbqrAASsTKV3DQABNwEAAAAQDgAACwAAAAAAAADAAAAAAAAARtDPEeChsRrh AAAAAAAAAAAAAAAAAAAAAD4AAwD+/wkABgAAAAAAAAAAAAAAAQAAAAEAAAAAAAAAABAAAAIAAAAB AAAA/v///wAAAAAAAAAA//////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////f///wQAAAD+ ////BQAAAP7////+//////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////9SAG8AbwB0ACAA RQBuAHQAcgB5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAF AP//////////AgAAABYDAAAAAAAAwAAAAAAAAEYAAAAAAAAAAAAAAADAODeho0rBAQMAAABAAgAA AAAAAAEATwBsAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAKAAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAABQAAAAAAAAAAgBPAGwAZQBQAHIAZQBzADAAMAAwAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABgAAgEBAAAAAwAAAP////8AAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAgAEAAAAAAAADAE0AYQBpAGwAUwB0AHIAZQBhAG0AAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAACAf////8EAAAA/////wAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcAAAAMAAAAAAAAAP7///8CAAAAAwAA AAQAAAAFAAAABgAAAP7////+/////v////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////AQAAAgAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP////8I AAAABAAAAAEAAAD/////AgAAAAAAAADMOgAAaQAAAFABAAAoAAAAOQIAAAQAAAABAAEAAAAAACAB AADEDgAAxA4AAAAAAAAAAAAAAAAAAP///wD///////////////////////////////////////// /////////////////////////////////////////////////////4AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAYD///////////////////////////////////////////////////////// /////////////////////////////////////4BOQU5JAAAAAAEAAADPOgAAagAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABSAGkAYwBoAEUAZABp AHQARgBsAGEAZwBzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHAACAP// /////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAMAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAA////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///////////////wAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAEAAAAAAAQAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlrs= --0__=7FL81CsyWxVx7AISWnMxd6jrVd3fulw9AjDgaMV45dMGbYlez5mC8pP9-- From owner-sqr-users@list.iex.net Mon Oct 1 13:18:47 2001 Date: Mon, 1 Oct 2001 14:09:26 -0400 From: Debra Robarge Subject: Re: SQR # indicates a numeric variable or is used in #define to declare contants called substitution variables in your program. $ indicates either a String or Date variable. By default, SQR will recognize $ as a string variable. This is why it is required to declare $date variables in SQR; SQR needs to be told explicitly when a $ variable is a date. Debra A. Robarge Software Instructor and Consultant Strafford Technology, Inc. drobarge@strafford.com (603) 434-2550 X 229 www.strafford.com www.briotraining.com -----Original Message----- From: M J [mailto:mjmaxima@YAHOO.COM] Sent: Monday, October 01, 2001 1:34 PM To: SQR-USERS@list.iex.net Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 13:20:12 2001 Date: Mon, 1 Oct 2001 13:14:36 -0500 From: "Hins, Thomas D." Subject: Re: SQR MJ, # is used for a numeric and $ is used for assigning a text variable. Use them accordingly. -----Original Message----- From: M J [mailto:mjmaxima@YAHOO.COM] Sent: Monday, October 01, 2001 12:34 PM To: SQR-USERS@list.iex.net Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 13:20:31 2001 Date: Mon, 1 Oct 2001 11:14:59 -0700 From: "Thorburn, David, ITD" Subject: Re: SQR Oh Puhleeeeeeeze! -----Original Message----- From: M J [mailto:mjmaxima@YAHOO.COM] Sent: Monday, October 01, 2001 10:34 AM To: SQR-USERS@list.iex.net Subject: SQR Hi folks: Questions about SQRs. What is the difference between # and $. When should each of them be used? TIA __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Mon Oct 1 13:39:19 2001 Date: Mon, 1 Oct 2001 11:35:23 -0700 From: Rachael Beatty Subject: Re: SQR --0__=C8uyblucQjzUi3HgAiKnpUsqLmwI9FRsG9jT9v10EvzUSDLOnPsi3hbg Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 7bit Oh, forgot to mention that there are some reserved words that can be preceded with # such as #debug to be used with the debug feature of SQR. Rachael > -----Original Message----- > From: "M J" @INTERNET > Sent: Monday, October 01, 2001 10:34 AM > To: SQR-USERS@list.iex.net > Subject: SQR > > > Hi folks: > > Questions about SQRs. What is the difference between > # and $. When should each of them be used? > TIA > > > > __________________________________________________ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.com > (See attached file: C.DTF) --0__=C8uyblucQjzUi3HgAiKnpUsqLmwI9FRsG9jT9v10EvzUSDLOnPsi3hbg Content-Type: application/octet-stream; name=C.DTF Content-Disposition: attachment; filename=C.DTF Content-Transfer-Encoding: base64 eJ8+IhESAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0QcKAAEACwAjABcAAQApAQEggAMADgAAANEHCgAB AAsAIQAOAAEAHgEBCYABACEAAAAwRTBBQzU3NDkzQjZENTExQUM0MzAwMDBFODY3QzBFRgAbBwEE gAEACAAAAFJFOiBTUVIA5wEBDYAEAAIAAAACAAIAAQOQBgA8CgAAOAAAAAMAAIAIIAYAAAAAAMAA AAAAAABGAAAAAFKFAADwEwAAHgABgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41 AAsAAoAIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAA AYUAAAAAAAALAASACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAsABYAIIAYAAAAAAMAAAAAA AABGAAAAAA6FAAAAAAAAAwAGgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAA AADAAAAAAAAARgAAAAARhQAAAAAAAAsAD4AIIAYAAAAAAMAAAAAAAABGAAAAABSFAAAAAAAAAwAI gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAAmACCAGAAAAAADAAAAAAAAARgAAAAA2hQAA AQAAAAEAAAAAAAAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AC4AI IAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALABGACCAGAAAAAADAAAAAAAAARgAA AACChQAAAQAAAAsADIALIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAACwANgAsgBgAAAAAAwAAA AAAAAEYAAAAABYgAAAAAAAACAQkQAQAAAAcDAAADAwAAeQQAAExaRnXKpcC+AwAKAHJjcGcxMjU+ MgD0AfcCpAT0AgBjaEEKwHNldDAgCFBtfw3gBgQF4AKDAFAD1AIAcPBycTIgBxMCgw5QA1VEVG0E IFJtbgKDMzcERwhVAoB9CoAIyCA7ewliDjA1CboXIRbTDiA4vwm6GJEW0wmsAoAKgXYIkKR3awuA ZDQMYGMAUC0LA2MAQQtgbg4QMDODFMELxCBPaCwgAhCIcmdvBUB0byAHgL0CMGkCIB5QEEAeQWgE kOxlIArAH6BzA3AfoBnQSRBwcnYJgCB3BbBk6wQgHxNjA5FiH6ASgAWQywmAILJpHxAgIx/wG9AV IsBhBCAjAQBidWe7HlIh0XUQcCJ1H2EgI5ScZmUfMAhwH6BvZgYAuFFSLgqiCoQKgFIA0P0QQGUJ UCaZHFEBQBKAHjCHBZAQARHiMTYgLSnCek8FEGcLgAdABdAHkHP4YWdlKcMmhijUKKELE0Eo1mkt MTQ0AUBsjmktYwzQLWNiIEYDYQo6DINiEKAiTSBKoCIgPG1qAMB4B3AAYUBZQUhPTy4AQ09NPkBJ TlTgRVJORVQK4wqBLpAXBmACMC73TQIgZGF5NR3QTykQbyHQBcAwMRcd0AHQNCAgHOA6MzRlEsBN McdUby73JkEtJFVTMWBTQC2wc3RiLgiQeC5uEIAxyHU8YmopATXqK28senNsxjItgTtgbXVsLDEc YC8TcQvFJpQz0GofMHRw+GhcJwwBKIITYgvwG7APKCYUwRTBKYA4IEhpMR3hbGtzLvAmmSAg/lEK UDcwHtEEIAGgCGAFQOEmQXMuIFcfIgQAJOQ3BpAlkBnQbiIwIcF0d98J4SaEIuAAcCDAJELCCfD1 H/BoCGBsIMAloCMhJhEVH2FtJBY/JoRUSUF7J7smmV9J30rvS+0mhEQtHnBZCGBNcGFGEG8h3Ue1 TDchRdEeYXkIYU21/wXQC3ADIAeBKtIEIANSRTFeeSHwRhA3oCZ1aD2hOlQvL1FkeU3SLgWgbQsm ihXxAFSAAB4AcAABAAAABAAAAFNRUgACAXEAAQAAABsAAAABwUqjB6RLhfMYDQVHuZ+DXsXR07pR AAE7IMAAAwAuAAAAAAALACsAAAAAAAsAAgABAAAAAgExAAEAAAAMAQAAUENERkVCMDkAAQACAHMA AAAAAAAAOKG7EAXlEBqhuwgAKypWwgAARU1TTURCLkRMTAAAAAAAAAAAG1X6IKpmEc2byACqAC/E WgwAAABMQVhISE1YUzAxAC9vPUhpbHRvbi9vdT1MQVhISC9jbj1SZWNpcGllbnRzL2NuPXJiZWF0 dHkALgAAAAAAAAC2ZtgWTVzVEaxCAADoZ8DvAQDtZ/1wCjXUEawkAASsTJXjAAADMpScAAAAAAAA LgAAAAAAAAC2ZtgWTVzVEaxCAADoZ8DvAQDtZ/1wCjXUEawkAASsTJXjAAADMpSdAAAQAAAADgrF dJO21RGsQwAA6GfA7wgAAABSRTogU1FSAB4AQhABAAAASwAAADwxNjNFQzNFMDY0QUU0MDQxOTI0 MDVENUYwNDlENkY1MzBCQzEyQzk2QGhoY2RjbXhzMDIuaG90ZWxzLmFkLmhpbHRvbi5jb20+AAAD AN4/r28AAAMA/T/kBAAAQAA5AEBdFNWnSsEBAwDxPwkEAAAeADFAAQAAAAgAAABSQkVBVFRZAAMA GkAAAAAAHgAwQAEAAAAIAAAAUkJFQVRUWQADABlAAAAAAAMAJgAAAAAAAwA2AAAAAAADAIAQ//// /wsA8hABAAAAAgFHAAEAAAA0AAAAYz1VUzthPSA7cD1IaWx0b247bD1MQVhISE1YUzAxLTAxMTAw MTE4MzUyM1otMjIwNTAyAAIB+T8BAAAASAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAv Tz1ISUxUT04vT1U9TEFYSEgvQ049UkVDSVBJRU5UUy9DTj1SQkVBVFRZAB4A+D8BAAAADwAAAFJh Y2hhZWwgQmVhdHR5AAAeADhAAQAAAAgAAABSQkVBVFRZAAIB+z8BAAAASAAAAAAAAADcp0DIwEIQ GrS5CAArL+GCAQAAAAAAAAAvTz1ISUxUT04vT1U9TEFYSEgvQ049UkVDSVBJRU5UUy9DTj1SQkVB VFRZAB4A+j8BAAAADwAAAFJhY2hhZWwgQmVhdHR5AAAeADlAAQAAAAgAAABSQkVBVFRZAEAABzAo j7/Tp0rBAUAACDDm+QCIp0rBAR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAAEAAAAU1FSAB4A NRABAAAAQQAAADxFRDY3RkQ3MDBBMzVENDExQUMyNDAwMDRBQzRDOTVFMzAzRTEwOTBGQGxheGho bXhzMDEuaGlsdG9uLmNvbT4AAAAACwApAAEAAAALACMAAQAAAAMABhCrFaQRAwAHEJcBAAADABAQ AAAAAAMAERABAAAAHgAIEAEAAABlAAAAT0gsRk9SR09UVE9NRU5USU9OVEhBVFRIRVJFQVJFU09N RVJFU0VSVkVEV09SRFNUSEFUQ0FOQkVQUkVDRURFRFdJVEgjU1VDSEFTI0RFQlVHVE9CRVVTRURX SVRIVEhFREVCVQAAAAACAX8AAQAAAEEAAAA8RUQ2N0ZENzAwQTM1RDQxMUFDMjQwMDA0QUM0Qzk1 RTMwM0UxMDkwRkBsYXhoaG14czAxLmhpbHRvbi5jb20+AAAAAKM/AgKQBgAOAAAAAgA5AQAA//// /wAAAAA4BAIQgAEAFAAAAFVudGl0bGVkIEF0dGFjaG1lbnQAcgcCEoADAA4AAADRBwoAAQALACMA FgABACgBAhOAAwAOAAAA0QcKAAEACwAjABYAAQAoAQIFkAYAzA4AAA0AAAADACEOAAAAAAMACzc5 AQAAAwAgDk4OAAADAPcPAAAAAAIBEGgBAAAADgAAAAAAAAAAAAAAAAAAAAAAAABAAAcwgHsv1KdK wQFAAAgwgHsv1KdKwQEDAAU3BgAAAAIBAjcBAAAAAAAAAB4AATABAAAAAQAAAAAAAAACAQo3AQAA AAsAAAAqhkiG9xQDCgMCAQACAfkPAQAAABAAAAAWKd7dl7bVEbqrAASsTKV3DQABNwEAAAAQDgAA CwAAAAAAAADAAAAAAAAARtDPEeChsRrhAAAAAAAAAAAAAAAAAAAAAD4AAwD+/wkABgAAAAAAAAAA AAAAAQAAAAEAAAAAAAAAABAAAAIAAAABAAAA/v///wAAAAAAAAAA//////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////f///wQAAAD+////BQAAAP7////+//////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////9SAG8AbwB0ACAARQBuAHQAcgB5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAFAP//////////AgAAABYDAAAAAAAAwAAAAAAAAEYAAAAA AAAAAAAAAADwngYZqErBAQMAAABAAgAAAAAAAAEATwBsAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKAAIB////////////////AAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQAAAAAAAAAAgBPAGwAZQBQAHIAZQBz ADAAMAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABgAAgEBAAAA AwAAAP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAgAEAAAAAAAAD AE0AYQBpAGwAUwB0AHIAZQBhAG0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAGAACAf////8EAAAA/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAcAAAAMAAAAAAAAAP7///8CAAAAAwAAAAQAAAAFAAAABgAAAP7////+/////v////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////AQAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAP////8IAAAABAAAAAEAAAD/////AgAAAAAAAADMOgAAaQAAAFAB AAAoAAAAOQIAAAQAAAABAAEAAAAAACABAADEDgAAxA4AAAAAAAAAAAAAAAAAAP///wD///////// //////////////////////////////////////////////////////////////////////////// /////////4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYD///////////////////////// /////////////////////////////////////////////////////////////////////4BOQU5J AAAAAAEAAADPOgAAagAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAABSAGkAYwBoAEUAZABpAHQARgBsAGEAZwBzAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAHAACAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAgAAAAMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA////////////////AAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///////// //////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAEAAEAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAADrs= --0__=C8uyblucQjzUi3HgAiKnpUsqLmwI9FRsG9jT9v10EvzUSDLOnPsi3hbg-- From owner-sqr-users@list.iex.net Tue Oct 2 08:07:20 2001 Date: Tue, 2 Oct 2001 12:53:53 +0000 From: Jill Hughes Subject: XML I've heard that SQR version 6.0 is 'XML-enabled' from the SQR user group and the Brio web site says SQR has: "Comprehensive XML read and write capabilities" and "Supports numerous report output formats including HTML, XML, WML, paper, text, postscript, email, FAX, PDF, SPF, and others" but there seems to be no information anywhere in the Brio Reports documentation or anywhere on the web to say how it can produce XML files. Does SQR have special commands/procedures to do it or do you just have to write the tags to your output file explicitly? Can anyone tell me any further info about it or point me to a website, please? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp From owner-sqr-users@list.iex.net Tue Oct 2 10:57:04 2001 Date: Tue, 2 Oct 2001 11:55:32 -0400 From: Scott Barnes Subject: SQR-HTLM Font Question? I have SQR 4.3 running on NT and Oracle 8i. I am using the Printer:HT command because I can't get the Printer:EH to work. I want my report not to be in a fixed font. I can not figure how to get the tag out of the htm report I am producing. No matter what I do in the set up: this code above appears in the html code. I tried taking font out and I tried to change the font to 2 which would fit the report in the Browser window better. I tried an alter-printer to change the font to TimesNewRoman. Nothing works. I need some help! Declare-layout default Orientation=Portrait max-columns=135 max-lines=260 char-width=6 TOP-MARGIN=.4 LEFT-MARGIN=.5 !bottom-margin = .25 !.8 End-Declare Declare-printer default-hp font = 2 point-size= 12 pitch = 5 End-Declare Thanks Scotty ---------- Scott A Barnes Programmer/Analyst Wesleyan University North College 860-685-2807 ---------- From owner-sqr-users@list.iex.net Tue Oct 2 16:47:54 2001 Date: Tue, 2 Oct 2001 17:44:53 -0400 From: Kevin Kroen Subject: SQR/Oracle Error We had some reports set up with a stored procedure that returned values in the following format: (DD-Mon-YYYY, DD-Mon-YYYY) We added a new option that in certain instances the stored procedure would return: (DD-Mon-YYYY HH:MI:SS, DD-Mon-YYYY HH:MI:SS) We ran the new stored procedure in an SQL Client and it worked properly. When I run this through SQR, I get the following error: (SQR 5528) ORACLE OEXEC error -6502 in cursor 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Error on line XX: (SQR 3735) Could not execute SQL. SQR: Program Aborting. This is how the SP is called: let $date_stor_proc = 'rpt.storprocedurename' begin-sql begin $business_date := [$date_stor_proc]($option);; end;; end-sql We tried having the function only return (DD-Mon-YYYY HH, DD-Mon-YYYY HH) and it worked with no problem, so I tend to think this problem in on the Brio side with the $business_date string. We are using SQR 6.0 going against an Oracle DB on Solaris. Any ideas? Kevin Kroen ========================================================================= This message is intended for the named addressee(s) only and contains information that may be confidential, non-public or legally privileged. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you received this email in error, please contact the sender and permanently delete the email and any attachments. Unless expressly stated, opinions in this email are those of the individual sender and not of FX Alliance, LLC or its affiliates. ========================================================================= From owner-sqr-users@list.iex.net Tue Oct 2 17:29:26 2001 Date: Tue, 2 Oct 2001 16:28:07 -0600 From: "O'Dorisio, Steve" Subject: Re: SQR/Oracle Error Can you change your database function to a database stored procedure where you can specify the return variable? Example: let $date_stor_proc = 'rpt.storprocedurename' begin-sql begin [$date_stor_proc]($option,$return_variable);; end;; end-sql You can even use "$return_variable" directly, without having to move it to another variable. Or you can move it to another variable if you would prefer (ex. let $business_date = $return_variable). Here is an example of how we are using stored procedures (dynamically): ----------------------------------------------------------------- MOVE 1 TO #in_input MOVE 'test_function' TO $xxx begin-sql begin [$xxx](#in_input, $return_test);; end;; end-sql show $return_test Here is the code from my test_function: ---------------------------------------- CREATE OR REPLACE PROCEDURE test_function( in_input IN number, return_var OUT varchar2) AS BEGIN IF in_input = 1 THEN return_var:= 'A'; ELSIF in_input = 2 THEN return_var := 'B'; ELSE return_var := 'C'; END IF; END test_function; GOOD LUCK, Steve -----Original Message----- From: Kevin Kroen [mailto:kevin.kroen@FXALL.COM] Sent: Tuesday, October 02, 2001 3:45 PM To: SQR-USERS@list.iex.net Subject: SQR/Oracle Error We had some reports set up with a stored procedure that returned values in the following format: (DD-Mon-YYYY, DD-Mon-YYYY) We added a new option that in certain instances the stored procedure would return: (DD-Mon-YYYY HH:MI:SS, DD-Mon-YYYY HH:MI:SS) We ran the new stored procedure in an SQL Client and it worked properly. When I run this through SQR, I get the following error: (SQR 5528) ORACLE OEXEC error -6502 in cursor 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Error on line XX: (SQR 3735) Could not execute SQL. SQR: Program Aborting. This is how the SP is called: let $date_stor_proc = 'rpt.storprocedurename' begin-sql begin $business_date := [$date_stor_proc]($option);; end;; end-sql We tried having the function only return (DD-Mon-YYYY HH, DD-Mon-YYYY HH) and it worked with no problem, so I tend to think this problem in on the Brio side with the $business_date string. We are using SQR 6.0 going against an Oracle DB on Solaris. Any ideas? Kevin Kroen ========================================================================= This message is intended for the named addressee(s) only and contains information that may be confidential, non-public or legally privileged. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you received this email in error, please contact the sender and permanently delete the email and any attachments. Unless expressly stated, opinions in this email are those of the individual sender and not of FX Alliance, LLC or its affiliates. ========================================================================= From owner-sqr-users@list.iex.net Wed Oct 3 10:16:35 2001 Date: Wed, 3 Oct 2001 11:10:35 -0400 From: Kevin Kroen Subject: Re: SQR/Oracle Error That works... I still think the original problem with the function assignment is a bug, but at least this is a workaround. Thanks! Kevin Kroen -----Original Message----- From: O'Dorisio, Steve [mailto:Steven.O'Dorisio@MMS.GOV] Sent: Tuesday, October 02, 2001 6:28 PM To: SQR-USERS@list.iex.net Subject: Re: SQR/Oracle Error Can you change your database function to a database stored procedure where you can specify the return variable? Example: let $date_stor_proc = 'rpt.storprocedurename' begin-sql begin [$date_stor_proc]($option,$return_variable);; end;; end-sql You can even use "$return_variable" directly, without having to move it to another variable. Or you can move it to another variable if you would prefer (ex. let $business_date = $return_variable). Here is an example of how we are using stored procedures (dynamically): ----------------------------------------------------------------- MOVE 1 TO #in_input MOVE 'test_function' TO $xxx begin-sql begin [$xxx](#in_input, $return_test);; end;; end-sql show $return_test Here is the code from my test_function: ---------------------------------------- CREATE OR REPLACE PROCEDURE test_function( in_input IN number, return_var OUT varchar2) AS BEGIN IF in_input = 1 THEN return_var:= 'A'; ELSIF in_input = 2 THEN return_var := 'B'; ELSE return_var := 'C'; END IF; END test_function; GOOD LUCK, Steve -----Original Message----- From: Kevin Kroen [mailto:kevin.kroen@FXALL.COM] Sent: Tuesday, October 02, 2001 3:45 PM To: SQR-USERS@list.iex.net Subject: SQR/Oracle Error We had some reports set up with a stored procedure that returned values in the following format: (DD-Mon-YYYY, DD-Mon-YYYY) We added a new option that in certain instances the stored procedure would return: (DD-Mon-YYYY HH:MI:SS, DD-Mon-YYYY HH:MI:SS) We ran the new stored procedure in an SQL Client and it worked properly. When I run this through SQR, I get the following error: (SQR 5528) ORACLE OEXEC error -6502 in cursor 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Error on line XX: (SQR 3735) Could not execute SQL. SQR: Program Aborting. This is how the SP is called: let $date_stor_proc = 'rpt.storprocedurename' begin-sql begin $business_date := [$date_stor_proc]($option);; end;; end-sql We tried having the function only return (DD-Mon-YYYY HH, DD-Mon-YYYY HH) and it worked with no problem, so I tend to think this problem in on the Brio side with the $business_date string. We are using SQR 6.0 going against an Oracle DB on Solaris. Any ideas? Kevin Kroen ========================================================================= This message is intended for the named addressee(s) only and contains information that may be confidential, non-public or legally privileged. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you received this email in error, please contact the sender and permanently delete the email and any attachments. Unless expressly stated, opinions in this email are those of the individual sender and not of FX Alliance, LLC or its affiliates. ========================================================================= ========================================================================= This message is intended for the named addressee(s) only and contains information that may be confidential, non-public or legally privileged. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you received this email in error, please contact the sender and permanently delete the email and any attachments. Unless expressly stated, opinions in this email are those of the individual sender and not of FX Alliance, LLC or its affiliates. ========================================================================= From owner-sqr-users@list.iex.net Tue Oct 2 17:19:57 2001 Date: Tue, 2 Oct 2001 15:10:49 -0700 From: Allen Cunningham Subject: debug sqr error? sqr version 4.3.4 database Oracle I get the following error when running sqr: Error on line 1612: (SQR 4702) Line found outside paragraph. Since SQC's are included how can I know if this is the correct line where the error is occuring?? From owner-sqr-users@list.iex.net Tue Oct 2 17:33:35 2001 Date: Tue, 2 Oct 2001 15:31:17 -0700 From: laura lopez Subject: Re: debug sqr error? Allen, when the error is in the SQC, it actually tells you. I'd tell you: 'error in the include file... line ....' The error you're getting is because you have a procedure that does not begin or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." check your code on that line (1612) and make sure you do have those keywords if it is the beginning or end of a procedure. Hope that helps! Good luck! Laura. > -----Original Message----- > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > Sent: Tuesday, October 02, 2001 3:11 PM > To: SQR-USERS@list.iex.net > Subject: debug sqr error? > > sqr version 4.3.4 > database Oracle > > I get the following error when running sqr: > Error on line 1612: > (SQR 4702) Line found outside paragraph. > > Since SQC's are included how can I know if this is the correct line where > the error is occuring?? From owner-sqr-users@list.iex.net Tue Oct 2 17:51:17 2001 Date: Tue, 2 Oct 2001 15:46:12 -0700 From: Allen Cunningham Subject: Re: debug sqr error? Actually the error is occuring on the next to last line of the sqr, just before the last comment line, see below. Also, this sqr runs fine on the client, but bombs on the server. #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) !---------------------------- End of Program -------------------------- Also, so anytime I see an error on a line number, it will be pointing to the sqr itself? Not to included sqc code that has been brought in to the sqr? ac -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez Sent: Tuesday, October 02, 2001 3:31 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Allen, when the error is in the SQC, it actually tells you. I'd tell you: 'error in the include file... line ....' The error you're getting is because you have a procedure that does not begin or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." check your code on that line (1612) and make sure you do have those keywords if it is the beginning or end of a procedure. Hope that helps! Good luck! Laura. > -----Original Message----- > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > Sent: Tuesday, October 02, 2001 3:11 PM > To: SQR-USERS@list.iex.net > Subject: debug sqr error? > > sqr version 4.3.4 > database Oracle > > I get the following error when running sqr: > Error on line 1612: > (SQR 4702) Line found outside paragraph. > > Since SQC's are included how can I know if this is the correct line where > the error is occuring?? From owner-sqr-users@list.iex.net Tue Oct 2 18:02:31 2001 Date: Tue, 2 Oct 2001 15:58:06 -0700 From: Rachael Beatty Subject: Re: debug sqr error? --0__=AwA7lehJXuSxCk7G5cQo39okwQO7xUG5jkh1pXb6usq3YwzSSSylOnJH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 7bit I have seen this before, but cannot remember what it was. Validate that you have all your if's and end-ifs and also all the begin procedure and end-procedure. Lastly, validate that you do not have anything in the first column of your sql statements. Rachael > -----Original Message----- > From: "Allen Cunningham" @INTERNET > Sent: Tuesday, October 02, 2001 3:46 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > Actually the error is occuring on the next to last line of the sqr, just > before the last comment line, see below. Also, this sqr runs fine on the > client, but bombs on the server. > > #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) > !---------------------------- End of Program -------------------------- > > Also, so anytime I see an error on a line number, it will be pointing to > the > sqr itself? Not to included sqc code that has been brought in to the sqr? > > ac > > > -----Original Message----- > From: Discussion of SQR, Brio Technology's database reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez > Sent: Tuesday, October 02, 2001 3:31 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > Allen, when the error is in the SQC, it actually tells you. I'd tell you: > 'error in the include file... line ....' > > The error you're getting is because you have a procedure that does not > begin > or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." > check your code on that line (1612) and make sure you do have those > keywords > if it is the beginning or end of a procedure. > > Hope that helps! > > Good luck! > > Laura. > > > -----Original Message----- > > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > > Sent: Tuesday, October 02, 2001 3:11 PM > > To: SQR-USERS@list.iex.net > > Subject: debug sqr error? > > > > sqr version 4.3.4 > > database Oracle > > > > I get the following error when running sqr: > > Error on line 1612: > > (SQR 4702) Line found outside paragraph. > > > > Since SQC's are included how can I know if this is the correct line > where > > the error is occuring?? > (See attached file: C.DTF) --0__=AwA7lehJXuSxCk7G5cQo39okwQO7xUG5jkh1pXb6usq3YwzSSSylOnJH Content-Type: application/octet-stream; name=C.DTF Content-Disposition: attachment; filename=C.DTF Content-Transfer-Encoding: base64 eJ8+IjQWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0QcKAAIADwA6AAYAAgA1AQEggAMADgAAANEHCgAC AA8ANwAzAAIAXwEBCYABACEAAABFNzRGMDE4RDg4QjdENTExQUM0MzAwMDBFODY3QzBFRgAqBwEE gAEAFQAAAFJFOiBkZWJ1ZyBzcXIgZXJyb3I/APcGAQ2ABAACAAAAAgACAAEDkAYA4A0AADgAAAAD AACACCAGAAAAAADAAAAAAAAARgAAAABShQAA8BMAAB4AAYAIIAYAAAAAAMAAAAAAAABGAAAAAFSF AAABAAAABAAAADguNQALAAKACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAA4AIIAYAAAAA AMAAAAAAAABGAAAAAAGFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAALAAWA CCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAA AAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAALAA+ACCAGAAAAAADAAAAAAAAARgAA AAAUhQAAAAAAAAMACIAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAJgAggBgAAAAAAwAAA AAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAA AQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwARgAggBgAA AAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALAAyACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAsA DYALIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAAgEJEAEAAAB2BgAAcgYAACMLAABMWkZ1mZVw jwMACgByY3BnMTI1PjIA9AH3AqQE9AIAY2hBCsBzZXQwIAhQbX8N4AYEBeACgwBQA9QCAHDwcnEy IAcTAoMOUANVRFRtBCBSbW4CgzM3BEcIVQKAfQqACMggO3sJYg4wNQm6FyEW0w4gOL8JuhiRFtMJ rAKACoF2CJCkd2sLgGQ0DGBjAFAtCwNjAEELYG4OEDAzIxTBC8QgSSAQQHZlRiAQcAnwIHRoBAAg pmIBEAWwZSwesHUFQPJjAHBubwVAGdAHgAbQWQSQIHcQQAVAaQVAd0Bhcy4gIFYHQGneZCCgHgAe cCCheQhgHcTfB0ADICJBBcAGkCcEIABw5GQgCfBkLQaQI5QHQLxzbyLDHnAeAB7AZwuA8iASgG9j CYAIcCKxI8UtJecuCqIKgEwhEHRs6nkfIHYhf2Qk4B+yIoR8bnkecRzAIMAeUh4AZi5pEGAfYQbw dRRQIG/yZiMEc3EDICggIbEHgG8CMCEgJ6QnpFIA0BBAZb8JUC25HFEBQCXhIcBjEAGhEeIxNiAt MOJPBRAPJaEHQAXQB5BzYWdlPzDjLaYv9C/BCxMv9mkt+DE0NAFAIYA0gwzQNIOoYiBGA2E6DINi EKDMIkEi4B5BQ3UfoCqxYRBAbSIgPCLRCfAuAmM3J0BTT05PTQBBLkVEVT5ASYBOVEVSTkVUCuNf CoE1sAZgAjA2F1QKUHMrIaAoUU8wMG8gQjAyAx8gAdAwMSAzOjRJMMBQTTpHVG82F1MgUVItVVM5 4FNAiyGAKCAuCJB4Lm4QgDE6SHViajAhNhdSZfo6KZBlH0Aq0CywBcAEkBkDYHI/Mo8zmnNsMuM0 oUTwbXVsM1EcYBNxFwvFLbQ8YGogoHRwaPxcJwwBL6ITYgvwG7AvRrcUwRTBMKA4EsAwMHUi0f55 JTNCwyDABCAmADhABRBvKsECICUzQCB4BUA8UCD/C2ArkSGAQCAsIiVCQoEfIPxqdSggJ6QexCUz TIMFoH5tLUJMwx8gHiEesQkAd78hMDawJNAfIB5zQoJyNyDfBCArYEzyKwMnpGMhgC1Rvx8kBuAG 0ErhKwQQcHId8KJyLZsjSW5TYHUBAA4gI4ACIDIQdGRiLskssGMnIUAgITcQKCCTA3Aw0CBHEIAg RCCgNwGgIRAeAE43kB4AKFQsSEkF8FmxTDmwRSDrMLAOICknpCEw41tvW9TsIEUjwSwxUANgCcA3 kP8w1F4vMkonwlEUJNIqcQdxXx2hUGIDkUp0S5FhTMRu/yvwIEEfICDSAxADIB7AJdD+bwuAYQAq wUxRUtdCgiDQ8RBwbGY/B7AfwUxRC4D/VlMj0FdRK7FWgSHzEEAeou0eQWIDYEJQaCCxHlFks/9C ckMXJ8IA0S7qJ7Mw7zH93zXTWJAEADhABBBpS5EsMVs+8R8gQgUQJOBUBZBo8x+wCQBneSOBIaFY 1BnQf2QQACAqshyiSdAyECekWzcAwAMQPFA6Pv9AA11P+QOgQmUQQGXgPCAsQAtgwwhwYnFvcGV6 J6Q60/s7nzyqMz0gPZY+QT7vP/r/QOZB30LqX6o20R8gIIAeQ/dKWSr1eZBDY0MA0EnGLrDnJMAi MiExSScj0IFSIjL7NhAnsydKdSsEZpUrUTbQni6E4CFATNOE4S4nLar2VEpHIkEnJlFW8WRTHpP/ H4BN8B4AIkgl2SHzKaAHkf8fsiWDJ6QFsSPxY4EecCUzkGtleXcFsGRzfADwIkJFRzmwJviFcjew PQWxIibLjlNTBSVQY2vfIwRnY0uTIKFM0yhaYyOjfwDAjLAeECZCKWUd0x5wb/9ZAYy2J6QGkCDC HpElRzdC346ii+IsMYlpLZtIdeFnpZEusHBzIS2qR28EcHtMcBvQa5obKAB1kS2bPh8w3zHunWBt 9Da+IFtTsE1UUDo37zj4XZ0G+3aPd58xeLidYHlSIUB5n/9ACaORe2apY3wvnRSdBnyCw1UhbrM0 LjMuSGWdYP9wp53QANA20KrNHbBW8SsU/wbwUMEqskp0frNSAZazfIH7gtWdYEVh9kzTWmKxx1eR tiinAaxgNzywkpBMTOL/AhA3IF0RH1AAkFaBCrEyAO9doEdQJ5WrJ1NmkYAjI4K/JlFml5RgB+Af gR2hax+w/wfglZEec5X1BaEZ0DAwTMTffrEZ0J0GSj9LQj9p6xXxAgC/IAAAHgBwAAEAAAAVAAAA UmU6IGRlYnVnIHNxciBlcnJvcj8AAAAAAgFxAAEAAAAbAAAAAcFLlYZzR/eyUF6XS+Gkyvplmx8e EQAAELEQAAMALgAAAAAACwArAAAAAAALAAIAAQAAAAIBMQABAAAAGQEAAFBDREZFQjA5AAEAAgBz AAAAAAAAADihuxAF5RAaobsIACsqVsIAAEVNU01EQi5ETEwAAAAAAAAAABtV+iCqZhHNm8gAqgAv xFoMAAAATEFYSEhNWFMwMQAvbz1IaWx0b24vb3U9TEFYSEgvY249UmVjaXBpZW50cy9jbj1yYmVh dHR5AC4AAAAAAAAAtmbYFk1c1RGsQgAA6GfA7wEA7Wf9cAo11BGsJAAErEyV4wAAAzKUnAAAAAAA AC4AAAAAAAAAtmbYFk1c1RGsQgAA6GfA7wEA7Wf9cAo11BGsJAAErEyV4wAAAzKUnQAAEAAAAOdP AY2It9URrEMAAOhnwO8VAAAAUkU6IGRlYnVnIHNxciBlcnJvcj8AAAAAHgBCEAEAAABLAAAAPDE2 M0VDM0UwNjRBRTQwNDE5MjQwNUQ1RjA0OUQ2RjUzMEJDQ0M4RkJAaGhjZGNteHMwMi5ob3RlbHMu YWQuaGlsdG9uLmNvbT4AAAMA3j+vbwAAAwD9P+QEAABAADkAEPHespVLwQEDAPE/CQQAAB4AMUAB AAAACAAAAFJCRUFUVFkAAwAaQAAAAAAeADBAAQAAAAgAAABSQkVBVFRZAAMAGUAAAAAAAwAmAAAA AAADADYAAAAAAAMAgBD/////CwDyEAEAAAACAUcAAQAAADQAAABjPVVTO2E9IDtwPUhpbHRvbjts PUxBWEhITVhTMDEtMDExMDAyMjI1ODA2Wi0yMzMwNjQAAgH5PwEAAABIAAAAAAAAANynQMjAQhAa tLkIACsv4YIBAAAAAAAAAC9PPUhJTFRPTi9PVT1MQVhISC9DTj1SRUNJUElFTlRTL0NOPVJCRUFU VFkAHgD4PwEAAAAPAAAAUmFjaGFlbCBCZWF0dHkAAB4AOEABAAAACAAAAFJCRUFUVFkAAgH7PwEA AABIAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUhJTFRPTi9PVT1MQVhISC9DTj1S RUNJUElFTlRTL0NOPVJCRUFUVFkAHgD6PwEAAAAPAAAAUmFjaGFlbCBCZWF0dHkAAB4AOUABAAAA CAAAAFJCRUFUVFkAQAAHMODWwLGVS8EBQAAIMKqqHWKVS8EBHgA9AAEAAAAFAAAAUkU6IAAAAAAe AB0OAQAAABEAAABkZWJ1ZyBzcXIgZXJyb3I/AAAAAB4ANRABAAAAQQAAADxFRDY3RkQ3MDBBMzVE NDExQUMyNDAwMDRBQzRDOTVFMzAzRTEwOTI0QGxheGhobXhzMDEuaGlsdG9uLmNvbT4AAAAACwAp AAEAAAALACMAAQAAAAMABhCDPjCRAwAHEGYGAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAA SUhBVkVTRUVOVEhJU0JFRk9SRSxCVVRDQU5OT1RSRU1FTUJFUldIQVRJVFdBU1ZBTElEQVRFVEhB VFlPVUhBVkVBTExZT1VSSUZTQU5ERU5ELUlGU0FOREFMU09BTExUSEVCRQAAAAACAX8AAQAAAEEA AAA8RUQ2N0ZENzAwQTM1RDQxMUFDMjQwMDA0QUM0Qzk1RTMwM0UxMDkyNEBsYXhoaG14czAxLmhp bHRvbi5jb20+AAAAAJqiAgKQBgAOAAAAAgDOAQAA/////wAAAADNBAIQgAEAFAAAAFVudGl0bGVk IEF0dGFjaG1lbnQAcgcCEoADAA4AAADRBwoAAgAPADoABQACADQBAhOAAwAOAAAA0QcKAAIADwA6 AAUAAgA0AQIFkAYAzA4AAA0AAAADACEOAAAAAAMACzfOAQAAAwAgDk4OAAADAPcPAAAAAAIBEGgB AAAADgAAAAAAAAAAAAAAAAAAAAAAAABAAAcw4O8kspVLwQFAAAgw4O8kspVLwQEDAAU3BgAAAAIB AjcBAAAAAAAAAB4AATABAAAAAQAAAAAAAAACAQo3AQAAAAsAAAAqhkiG9xQDCgMCAQACAfkPAQAA ABAAAADfmM/SgLfVEbqrAASsTKV3DQABNwEAAAAQDgAACwAAAAAAAADAAAAAAAAARtDPEeChsRrh AAAAAAAAAAAAAAAAAAAAAD4AAwD+/wkABgAAAAAAAAAAAAAAAQAAAAEAAAAAAAAAABAAAAIAAAAB AAAA/v///wAAAAAAAAAA//////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////f///wQAAAD+ ////BQAAAP7////+//////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////9SAG8AbwB0ACAA RQBuAHQAcgB5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAF AP//////////AgAAABYDAAAAAAAAwAAAAAAAAEYAAAAAAAAAAAAAAACwe3H1lUvBAQMAAABAAgAA AAAAAAEATwBsAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAKAAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAABQAAAAAAAAAAgBPAGwAZQBQAHIAZQBzADAAMAAwAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABgAAgEBAAAAAwAAAP////8AAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAgAEAAAAAAAADAE0AYQBpAGwAUwB0AHIAZQBhAG0AAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAACAf////8EAAAA/////wAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcAAAAMAAAAAAAAAP7///8CAAAAAwAA AAQAAAAFAAAABgAAAP7////+/////v////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////AQAAAgAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP////8I AAAABAAAAAEAAAD/////AgAAAAAAAADMOgAAaQAAAFABAAAoAAAAOQIAAAQAAAABAAEAAAAAACAB AADEDgAAxA4AAAAAAAAAAAAAAAAAAP///wD///////////////////////////////////////// /////////////////////////////////////////////////////4AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAYD///////////////////////////////////////////////////////// /////////////////////////////////////4BOQU5JAAAAAAEAAADPOgAAagAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABSAGkAYwBoAEUAZABp AHQARgBsAGEAZwBzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHAACAP// /////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAMAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAA////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///////////////wAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAEAAAAAAAQAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAqb4= --0__=AwA7lehJXuSxCk7G5cQo39okwQO7xUG5jkh1pXb6usq3YwzSSSylOnJH-- From owner-sqr-users@list.iex.net Tue Oct 2 18:16:29 2001 Date: Tue, 2 Oct 2001 16:11:52 -0700 From: Allen Cunningham Subject: Re: debug sqr error? Thanks Rachael, I'll check it out, but again it runs fine on the client and the error only occurs when running on the server, which is what I don't understand. ac -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael Beatty Sent: Tuesday, October 02, 2001 3:58 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? I have seen this before, but cannot remember what it was. Validate that you have all your if's and end-ifs and also all the begin procedure and end-procedure. Lastly, validate that you do not have anything in the first column of your sql statements. Rachael > -----Original Message----- > From: "Allen Cunningham" @INTERNET > Sent: Tuesday, October 02, 2001 3:46 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > Actually the error is occuring on the next to last line of the sqr, just > before the last comment line, see below. Also, this sqr runs fine on the > client, but bombs on the server. > > #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) > !---------------------------- End of Program -------------------------- > > Also, so anytime I see an error on a line number, it will be pointing to > the > sqr itself? Not to included sqc code that has been brought in to the sqr? > > ac > > > -----Original Message----- > From: Discussion of SQR, Brio Technology's database reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez > Sent: Tuesday, October 02, 2001 3:31 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > Allen, when the error is in the SQC, it actually tells you. I'd tell you: > 'error in the include file... line ....' > > The error you're getting is because you have a procedure that does not > begin > or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." > check your code on that line (1612) and make sure you do have those > keywords > if it is the beginning or end of a procedure. > > Hope that helps! > > Good luck! > > Laura. > > > -----Original Message----- > > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > > Sent: Tuesday, October 02, 2001 3:11 PM > > To: SQR-USERS@list.iex.net > > Subject: debug sqr error? > > > > sqr version 4.3.4 > > database Oracle > > > > I get the following error when running sqr: > > Error on line 1612: > > (SQR 4702) Line found outside paragraph. > > > > Since SQC's are included how can I know if this is the correct line > where > > the error is occuring?? > (See attached file: C.DTF) From owner-sqr-users@list.iex.net Tue Oct 2 20:35:48 2001 Date: Tue, 2 Oct 2001 18:32:12 -0700 From: Arun Kumar Subject: Re: debug sqr error? Allen, Did you make sure that all the Search paths are fine on the Server. If the search path to include file are missing you would get this error. And you wont get this error on your client m/c where the search path are defined properly. Hope this helps --- Allen Cunningham wrote: > Thanks Rachael, I'll check it out, but again it runs > fine on the client and > the error only occurs when running on the server, > which is what I don't > understand. > > ac > > -----Original Message----- > From: Discussion of SQR, Brio Technology's database > reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael > Beatty > Sent: Tuesday, October 02, 2001 3:58 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > > > > I have seen this before, but cannot remember what it > was. Validate that you > have all your if's and end-ifs and also all the > begin procedure and > end-procedure. > Lastly, validate that you do not have anything in > the first column of your > sql statements. > > Rachael > > > -----Original Message----- > > From: "Allen Cunningham" > @INTERNET > > Sent: Tuesday, October 02, 2001 3:46 PM > > To: SQR-USERS@list.iex.net > > Subject: Re: debug sqr error? > > > > > > Actually the error is occuring on the next to last > line of the sqr, just > > before the last comment line, see below. Also, > this sqr runs fine on the > > client, but bombs on the server. > > > > #Include 'songetdb.sqc' !Custom - Get Database > Name (THIS IS LINE 1612) > > !---------------------------- End of Program > -------------------------- > > > > Also, so anytime I see an error on a line number, > it will be pointing to > > the > > sqr itself? Not to included sqc code that has been > brought in to the sqr? > > > > ac > > > > > > -----Original Message----- > > From: Discussion of SQR, Brio Technology's > database reporting language > > [mailto:SQR-USERS@list.iex.net]On Behalf Of laura > lopez > > Sent: Tuesday, October 02, 2001 3:31 PM > > To: SQR-USERS@list.iex.net > > Subject: Re: debug sqr error? > > > > > > Allen, when the error is in the SQC, it actually > tells you. I'd tell you: > > 'error in the include file... line ....' > > > > The error you're getting is because you have a > procedure that does not > > begin > > or end with the keywords: "BEGIN-procedure ..." or > "end-procedure ..." > > check your code on that line (1612) and make sure > you do have those > > keywords > > if it is the beginning or end of a procedure. > > > > Hope that helps! > > > > Good luck! > > > > Laura. > > > > > -----Original Message----- > > > From: Allen Cunningham > [SMTP:allen.cunningham@SONOMA.EDU] > > > Sent: Tuesday, October 02, 2001 3:11 PM > > > To: SQR-USERS@list.iex.net > > > Subject: debug sqr error? > > > > > > sqr version 4.3.4 > > > database Oracle > > > > > > I get the following error when running sqr: > > > Error on line 1612: > > > (SQR 4702) Line found outside paragraph. > > > > > > Since SQC's are included how can I know if this > is the correct line > > where > > > the error is occuring?? > > > > (See attached file: C.DTF) __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Wed Oct 3 11:03:31 2001 Date: Wed, 3 Oct 2001 09:00:14 -0700 From: Allen Cunningham Subject: Re: debug sqr error? -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Arun Kumar Sent: Tuesday, October 02, 2001 6:32 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Arun - On the server all sqr's and sqc's are in the same dir. I am starting to think it's a problems with our ASP who hosts the databases at a remote location, and they might not have set things up correctly. I am sending off a help desk ticket to check on it. Thanks for the response. ac Allen, Did you make sure that all the Search paths are fine on the Server. If the search path to include file are missing you would get this error. And you wont get this error on your client m/c where the search path are defined properly. Hope this helps --- Allen Cunningham wrote: > Thanks Rachael, I'll check it out, but again it runs > fine on the client and > the error only occurs when running on the server, > which is what I don't > understand. > > ac > > -----Original Message----- > From: Discussion of SQR, Brio Technology's database > reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael > Beatty > Sent: Tuesday, October 02, 2001 3:58 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > > > > I have seen this before, but cannot remember what it > was. Validate that you > have all your if's and end-ifs and also all the > begin procedure and > end-procedure. > Lastly, validate that you do not have anything in > the first column of your > sql statements. > > Rachael > > > -----Original Message----- > > From: "Allen Cunningham" > @INTERNET > > Sent: Tuesday, October 02, 2001 3:46 PM > > To: SQR-USERS@list.iex.net > > Subject: Re: debug sqr error? > > > > > > Actually the error is occuring on the next to last > line of the sqr, just > > before the last comment line, see below. Also, > this sqr runs fine on the > > client, but bombs on the server. > > > > #Include 'songetdb.sqc' !Custom - Get Database > Name (THIS IS LINE 1612) > > !---------------------------- End of Program > -------------------------- > > > > Also, so anytime I see an error on a line number, > it will be pointing to > > the > > sqr itself? Not to included sqc code that has been > brought in to the sqr? > > > > ac > > > > > > -----Original Message----- > > From: Discussion of SQR, Brio Technology's > database reporting language > > [mailto:SQR-USERS@list.iex.net]On Behalf Of laura > lopez > > Sent: Tuesday, October 02, 2001 3:31 PM > > To: SQR-USERS@list.iex.net > > Subject: Re: debug sqr error? > > > > > > Allen, when the error is in the SQC, it actually > tells you. I'd tell you: > > 'error in the include file... line ....' > > > > The error you're getting is because you have a > procedure that does not > > begin > > or end with the keywords: "BEGIN-procedure ..." or > "end-procedure ..." > > check your code on that line (1612) and make sure > you do have those > > keywords > > if it is the beginning or end of a procedure. > > > > Hope that helps! > > > > Good luck! > > > > Laura. > > > > > -----Original Message----- > > > From: Allen Cunningham > [SMTP:allen.cunningham@SONOMA.EDU] > > > Sent: Tuesday, October 02, 2001 3:11 PM > > > To: SQR-USERS@list.iex.net > > > Subject: debug sqr error? > > > > > > sqr version 4.3.4 > > > database Oracle > > > > > > I get the following error when running sqr: > > > Error on line 1612: > > > (SQR 4702) Line found outside paragraph. > > > > > > Since SQC's are included how can I know if this > is the correct line > > where > > > the error is occuring?? > > > > (See attached file: C.DTF) __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com From owner-sqr-users@list.iex.net Tue Oct 2 18:31:26 2001 Date: Tue, 2 Oct 2001 16:28:47 -0700 From: laura lopez Subject: Re: debug sqr error? Allen, according to my SQR book that error: (SQR 4702) Line found outside paragraph - means the following: "All commands must be within BEGIN-... END-statements. Correct the source code". Sometimes it is true that it may have an error in the main sql so make sure that is ok. Make sure the versions you are testing on the client and on the server is the exact same version. I know it may sound silly but it's happened before! Good luck! LL > -----Original Message----- > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > Sent: Tuesday, October 02, 2001 3:46 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > Actually the error is occuring on the next to last line of the sqr, just > before the last comment line, see below. Also, this sqr runs fine on the > client, but bombs on the server. > > #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) > !---------------------------- End of Program -------------------------- > > Also, so anytime I see an error on a line number, it will be pointing to > the > sqr itself? Not to included sqc code that has been brought in to the sqr? > > ac > > > -----Original Message----- > From: Discussion of SQR, Brio Technology's database reporting language > [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez > Sent: Tuesday, October 02, 2001 3:31 PM > To: SQR-USERS@list.iex.net > Subject: Re: debug sqr error? > > > Allen, when the error is in the SQC, it actually tells you. I'd tell you: > 'error in the include file... line ....' > > The error you're getting is because you have a procedure that does not > begin > or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." > check your code on that line (1612) and make sure you do have those > keywords > if it is the beginning or end of a procedure. > > Hope that helps! > > Good luck! > > Laura. > > > -----Original Message----- > > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > > Sent: Tuesday, October 02, 2001 3:11 PM > > To: SQR-USERS@list.iex.net > > Subject: debug sqr error? > > > > sqr version 4.3.4 > > database Oracle > > > > I get the following error when running sqr: > > Error on line 1612: > > (SQR 4702) Line found outside paragraph. > > > > Since SQC's are included how can I know if this is the correct line > where > > the error is occuring?? From owner-sqr-users@list.iex.net Thu Oct 4 10:21:57 2001 Date: Thu, 4 Oct 2001 11:15:03 -0400 From: "Risman, Mark" Subject: Re: debug sqr error? Allen, Check to see that this #include line is in the right spot. I believe that whatever is inside the included file will show up in the calling SQR, exactly in place of the "#include" statement; the compiler replaced the #include statement with the file and then compiles the whole thing. If you do something like this, for example: BEGIN-PROCEDURE . . . #include 'xyz.sqc' . . . END-PROCEDURE and your sqc has: BEGIN-PROCEDURE . . . END-PROCEDURE then the final version would look like this BEGIN-PROCEDURE . . . BEGIN-PROCEDURE . . . END-PROCEDURE . . . END-PROCEDURE and the compiler would get confused and you'll get an error kind of like the one you saw. hope this helps, - Mark -----Original Message----- From: Allen Cunningham [mailto:allen.cunningham@SONOMA.EDU] Sent: Tuesday, October 02, 2001 6:46 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Actually the error is occuring on the next to last line of the sqr, just before the last comment line, see below. Also, this sqr runs fine on the client, but bombs on the server. #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) !---------------------------- End of Program -------------------------- Also, so anytime I see an error on a line number, it will be pointing to the sqr itself? Not to included sqc code that has been brought in to the sqr? ac -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez Sent: Tuesday, October 02, 2001 3:31 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Allen, when the error is in the SQC, it actually tells you. I'd tell you: 'error in the include file... line ....' The error you're getting is because you have a procedure that does not begin or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." check your code on that line (1612) and make sure you do have those keywords if it is the beginning or end of a procedure. Hope that helps! Good luck! Laura. > -----Original Message----- > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > Sent: Tuesday, October 02, 2001 3:11 PM > To: SQR-USERS@list.iex.net > Subject: debug sqr error? > > sqr version 4.3.4 > database Oracle > > I get the following error when running sqr: > Error on line 1612: > (SQR 4702) Line found outside paragraph. > > Since SQC's are included how can I know if this is the correct line where > the error is occuring?? Visit our website at http://www.ubswarburg.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. From owner-sqr-users@list.iex.net Thu Oct 4 10:57:30 2001 Date: Thu, 4 Oct 2001 08:53:29 -0700 From: Allen Cunningham Subject: Re: debug sqr error? Hi Mark - Thanks for the input, but I ended up finding the problem. Here is a post-mortem of the problem: Somehow a single control char got introduced into the sqr text file, at the very bottom past the last '#include'. It showed up like a small box in a text editor. The sqr ran fine on the client, becuase Win NT doesn't care about such things, but on the unix server it did care, and generated the error of finding a command outside of a begin-end block. ac -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Risman, Mark Sent: Thursday, October 04, 2001 8:15 AM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Allen, Check to see that this #include line is in the right spot. I believe that whatever is inside the included file will show up in the calling SQR, exactly in place of the "#include" statement; the compiler replaced the #include statement with the file and then compiles the whole thing. If you do something like this, for example: BEGIN-PROCEDURE . . . #include 'xyz.sqc' . . . END-PROCEDURE and your sqc has: BEGIN-PROCEDURE . . . END-PROCEDURE then the final version would look like this BEGIN-PROCEDURE . . . BEGIN-PROCEDURE . . . END-PROCEDURE . . . END-PROCEDURE and the compiler would get confused and you'll get an error kind of like the one you saw. hope this helps, - Mark -----Original Message----- From: Allen Cunningham [mailto:allen.cunningham@SONOMA.EDU] Sent: Tuesday, October 02, 2001 6:46 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Actually the error is occuring on the next to last line of the sqr, just before the last comment line, see below. Also, this sqr runs fine on the client, but bombs on the server. #Include 'songetdb.sqc' !Custom - Get Database Name (THIS IS LINE 1612) !---------------------------- End of Program -------------------------- Also, so anytime I see an error on a line number, it will be pointing to the sqr itself? Not to included sqc code that has been brought in to the sqr? ac -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of laura lopez Sent: Tuesday, October 02, 2001 3:31 PM To: SQR-USERS@list.iex.net Subject: Re: debug sqr error? Allen, when the error is in the SQC, it actually tells you. I'd tell you: 'error in the include file... line ....' The error you're getting is because you have a procedure that does not begin or end with the keywords: "BEGIN-procedure ..." or "end-procedure ..." check your code on that line (1612) and make sure you do have those keywords if it is the beginning or end of a procedure. Hope that helps! Good luck! Laura. > -----Original Message----- > From: Allen Cunningham [SMTP:allen.cunningham@SONOMA.EDU] > Sent: Tuesday, October 02, 2001 3:11 PM > To: SQR-USERS@list.iex.net > Subject: debug sqr error? > > sqr version 4.3.4 > database Oracle > > I get the following error when running sqr: > Error on line 1612: > (SQR 4702) Line found outside paragraph. > > Since SQC's are included how can I know if this is the correct line where > the error is occuring?? Visit our website at http://www.ubswarburg.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. From owner-sqr-users@list.iex.net Wed Oct 3 07:45:54 2001 Date: Wed, 3 Oct 2001 08:42:22 -0400 From: Steve Rogers Subject: Creating multiple reports on mainframe Good morning all - We are running PeopleSoft DB2 for MVS, version 7.51. All of our SQR's are processed using the mainframe as our server. I am attempting to create two different reports from the same SQR. I used the DECLARE-REPORT options according to the SQR server Language Reference. When I attempt to run the SQR, I am receiving the following error - (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF (13): Improper function argument It appears as if the the SQROUT DD name is automatically receiving the .SPF suffix, which MVS can't seem to process. Does anyone know how to resolve this problem? thanks, Steve From owner-sqr-users@list.iex.net Wed Oct 3 08:03:51 2001 Date: Wed, 3 Oct 2001 09:59:15 -0300 From: Peter Clark Subject: Re: Creating multiple reports on mainframe It would be more helpful if we knew what version of SQR you are on rather than what version of PeopleSoft. I believe there is a multiple reports command line flag in the later versions of SQR (-MR) that might be helpful to you ... but then, it all depends on your version of SQR. >>> Steve Rogers 2001/10/03 9:42:22 am >>> Good morning all - We are running PeopleSoft DB2 for MVS, version 7.51. All of our SQR's are processed using the mainframe as our server. I am attempting to create two different reports from the same SQR. I used the DECLARE-REPORT options according to the SQR server Language Reference. When I attempt to run the SQR, I am receiving the following error - (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF (13): Improper function argument It appears as if the the SQROUT DD name is automatically receiving the .SPF suffix, which MVS can't seem to process. Does anyone know how to resolve this problem? thanks, Steve From owner-sqr-users@list.iex.net Wed Oct 3 08:57:11 2001 Date: Wed, 3 Oct 2001 09:53:04 -0400 From: Steve Rogers Subject: Re: Creating multiple reports on mainframe Peter, Thank you for responding. I believe that our SQR version is 4.1.7.3. thanks, steve Peter Clark on 10/03/2001 08:59:15 AM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Steve Rogers/North/KayBee) Subject: Re: Creating multiple reports on mainframe It would be more helpful if we knew what version of SQR you are on rather than what version of PeopleSoft. I believe there is a multiple reports command line flag in the later versions of SQR (-MR) that might be helpful to you ... but then, it all depends on your version of SQR. >>> Steve Rogers 2001/10/03 9:42:22 am >>> Good morning all - We are running PeopleSoft DB2 for MVS, version 7.51. All of our SQR's are processed using the mainframe as our server. I am attempting to create two different reports from the same SQR. I used the DECLARE-REPORT options according to the SQR server Language Reference. When I attempt to run the SQR, I am receiving the following error - (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF (13): Improper function argument It appears as if the the SQROUT DD name is automatically receiving the .SPF suffix, which MVS can't seem to process. Does anyone know how to resolve this problem? thanks, Steve From owner-sqr-users@list.iex.net Wed Oct 3 09:19:04 2001 Date: Wed, 3 Oct 2001 11:13:07 -0300 From: Peter Clark Subject: Re: Creating multiple reports on mainframe Steve, There was a discussion just a few days ago on multiple reports on the PeopleSoft-Fans listserve. You may want to refer to the solutions offered there under the heading "SQR With Multiple Reports". I suspect you may be out of luck with the -MR flag since you are on such an old version of SQR, but there was a PeopleSoft resolution number mentioned that might be of help. Good luck. http://groups.yahoo.com/group/peoplesoft-fans/ >>> Steve Rogers 2001/10/03 10:53:04 am >>> Peter, Thank you for responding. I believe that our SQR version is 4.1.7.3. thanks, steve Peter Clark on 10/03/2001 08:59:15 AM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Steve Rogers/North/KayBee) Subject: Re: Creating multiple reports on mainframe It would be more helpful if we knew what version of SQR you are on rather than what version of PeopleSoft. I believe there is a multiple reports command line flag in the later versions of SQR (-MR) that might be helpful to you ... but then, it all depends on your version of SQR. >>> Steve Rogers 2001/10/03 9:42:22 am >>> Good morning all - We are running PeopleSoft DB2 for MVS, version 7.51. All of our SQR's are processed using the mainframe as our server. I am attempting to create two different reports from the same SQR. I used the DECLARE-REPORT options according to the SQR server Language Reference. When I attempt to run the SQR, I am receiving the following error - (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF (13): Improper function argument It appears as if the the SQROUT DD name is automatically receiving the .SPF suffix, which MVS can't seem to process. Does anyone know how to resolve this problem? thanks, Steve From owner-sqr-users@list.iex.net Wed Oct 3 10:05:20 2001 Date: Wed, 3 Oct 2001 11:02:50 -0400 From: Cindy Chen Subject: Re: Creating multiple reports on mainframe Hi Steve, You need : 1. in the member of your parmlib, make sure you have flags: -FRPT1 -FRPT2 .... 2. then in your JCL, you will need to have ddname RPT1 and RPT2 which point to a pre-allocated PDS, ex., //RPT1 dd dsn=your.pds(myrpt1)... //RPT2 dd dsn=your.pds(myrpt2)... HTH Cindy At 08:42 AM 10/3/2001 -0400, you wrote: > Good morning all - > > We are running PeopleSoft DB2 for MVS, version 7.51. All of our > SQR's are >processed using the mainframe as our server. I am attempting to create two >different reports from the same SQR. I used the DECLARE-REPORT options >according to the SQR server Language Reference. When I attempt to run the >SQR, >I am receiving the following error - > >(SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF >(13): Improper function argument > > It appears as if the the SQROUT DD name is automatically receiving > the .SPF >suffix, which MVS can't seem to process. > > Does anyone know how to resolve this problem? > > thanks, > Steve From owner-sqr-users@list.iex.net Wed Oct 3 10:16:34 2001 Date: Wed, 3 Oct 2001 11:09:26 -0400 From: Ed Mahoney Subject: Re: Creating multiple reports on mainframe I'm not sure if this applies to V4.1.7.3, but it does seem to apply to V6.1.4 delivered with PeopleSoft 8.13. You will need to have the SQROUT directed to a file instead of SYSOUT=. The name of the SPF file is built from the SQROUT file name and it can't use SYSOUT= to build the SPF file name. Ed Mahoney UnumProvident Corporation Chattanooga Office - 3S (423) 755-1572 |--------+------------------------> | | Steve Rogers | | | | | | Sent by: | | | "Discussion of| | | SQR, Brio | | | Technology's | | | database | | | reporting | | | language" | | | | | | | | | | | | 10/03/2001 | | | 08:42 AM | | | Please respond| | | to sqr-users | | | | |--------+------------------------> >----------------------------------------------------------------------------| | | | To: SQR-USERS@list.iex.net | | cc: | | Subject: Creating multiple reports on mainframe | >----------------------------------------------------------------------------| Good morning all - We are running PeopleSoft DB2 for MVS, version 7.51. All of our SQR's are processed using the mainframe as our server. I am attempting to create two different reports from the same SQR. I used the DECLARE-REPORT options according to the SQR server Language Reference. When I attempt to run the SQR, I am receiving the following error - (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF (13): Improper function argument It appears as if the the SQROUT DD name is automatically receiving the .SPF suffix, which MVS can't seem to process. Does anyone know how to resolve this problem? thanks, Steve From owner-sqr-users@list.iex.net Wed Oct 3 10:18:47 2001 Date: Wed, 3 Oct 2001 11:14:56 -0400 From: "Ballesty, Lorraine" Subject: Re: Creating multiple reports on mainframe Steve - I encountered a similar problem a while back, but instead of an error message, the additional reports were being sent to unix 'Never-Never Land'. It turned out that while SQR supports multiple report functionality, PeopleSoft did not. What I think is happening to you is that the default names for the additional reports are not compatible with your system's naming conventions. I got around my particular problem by calling each new report in the beginning of the program, and then deliberately setting the output file, thereby bypassing the default output file ($sqr-report). It's little lengthy, but the following had to happen: !SQR: MultipleReports.sqr ! Set up and write to 3 separate output reports !************************************************************** begin-setup !declare report names and formats used !------------------------------------- declare-report interface_errors ! error report end-declare declare-report Summary_Rpt ! summary report end-declare declare-report Detail_Rpt ! detail report end-declare end-setup !Do the following in your initialization phase to attach !the report output names to the correct reports. You !CANNOT write to any of these reports until this is done. !*********************************************************** begin-procedure init-program use-report interface_errors !This first call sets the value of $sqr-report !i.e., $sqr-report = '\bin\output\MultipleReports.lis' !Use this variable to set the value of the next output report use-report Summary_Rpt new-report '\bin\output\MultipleReports1.lis' use-report Detail_Rpt new-report '\bin\output\MultipleReports2.lis' end-procedure !Now call each report as you need it with the 'use-report' command !***************************************************************** begin-procedure Process-Main use-report interface_errors !perform processing.... use-report Summary_Rpt !perform processing... !etc.... end-procedure I don't know if the problem you're having is exactly the same, but please feel free to contact me with questions. Hope this helps! Lorraine Ballesty, Analyst/Programmer Lead HRIS, Information Technology Services University of Rochester phone: (716) 273-2606 pager: (716) 220-0803 e-mail: LBallesty@ACS.Rochester.edu > -----Original Message----- > From: Steve Rogers [SMTP:srogers@KBTOYS.COM] > Sent: Wednesday, October 03, 2001 9:53 AM > To: SQR-USERS@list.iex.net > Subject: Re: Creating multiple reports on mainframe > > Peter, > > Thank you for responding. I believe that our SQR version is 4.1.7.3. > > thanks, > steve > > > > > Peter Clark on 10/03/2001 08:59:15 AM > > Please respond to sqr-users@list.iex.net > > To: SQR-USERS@list.iex.net > cc: (bcc: Steve Rogers/North/KayBee) > > Subject: Re: Creating multiple reports on mainframe > > > > It would be more helpful if we knew what version of SQR you are on rather > than > what version of PeopleSoft. I believe there is a multiple reports command > line > flag in the later versions of SQR (-MR) that might be helpful to you ... > but > then, it all depends on your version of SQR. > > >>> Steve Rogers 2001/10/03 9:42:22 am >>> > Good morning all - > > We are running PeopleSoft DB2 for MVS, version 7.51. All of our > SQR's are > processed using the mainframe as our server. I am attempting to create > two > different reports from the same SQR. I used the DECLARE-REPORT options > according to the SQR server Language Reference. When I attempt to run the > SQR, > I am receiving the following error - > > (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF > (13): Improper function argument > > It appears as if the the SQROUT DD name is automatically receiving > the .SPF > suffix, which MVS can't seem to process. > > Does anyone know how to resolve this problem? > > thanks, > Steve From owner-sqr-users@list.iex.net Wed Oct 3 10:48:24 2001 Date: Wed, 3 Oct 2001 11:44:26 -0400 From: Steve Rogers Subject: Re: Creating multiple reports on mainframe Cindy, Thank you very much for responding. I would just like to clarify a few things- -When you mention the member of your parmlib, are you referring to - - the Config Manager SQR flag settings in PeopleSoft - the SQRPARMS member, which in our environment looks like this - DSN SYSTEM(DHP2) RUN PROG(SQR) - PLAN(DBCALLS) - LIB('SYS3.PSOFT.SQR.LOAD') - PARMS('DDN:SQRIN DSN/PSOFTPRD -FDDN:SQROUT -P:HP -S - -IDDN:SQRINC( -TBZ -MDDN:MAXIN') END - something else? - We typically run our SQR's from PeopleSoft using shell JCL, which defaults the print file to a DDNAME of SYSOUT. We do have a few SQR's that we don't run from PeopleSoft. They are run on the mainframe as stand alone jobs. If we need to use "custom" DDNAMES for the multiple reports, then I assume I will have to create a new stand alone job, with it's own JCL. I don't see how I could do this using the shell JCL. Is this what you had in mind, or am I missing something? Thanks again for your help. This is the first time we have attempted this. It could be quite helpful now and in the future. Steve Cindy Chen on 10/03/2001 11:02:50 AM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Steve Rogers/North/KayBee) Subject: Re: Creating multiple reports on mainframe Hi Steve, You need : 1. in the member of your parmlib, make sure you have flags: -FRPT1 -FRPT2 .... 2. then in your JCL, you will need to have ddname RPT1 and RPT2 which point to a pre-allocated PDS, ex., //RPT1 dd dsn=your.pds(myrpt1)... //RPT2 dd dsn=your.pds(myrpt2)... HTH Cindy At 08:42 AM 10/3/2001 -0400, you wrote: > Good morning all - > > We are running PeopleSoft DB2 for MVS, version 7.51. All of our > SQR's are >processed using the mainframe as our server. I am attempting to create two >different reports from the same SQR. I used the DECLARE-REPORT options >according to the SQR server Language Reference. When I attempt to run the >SQR, >I am receiving the following error - > >(SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF >(13): Improper function argument > > It appears as if the the SQROUT DD name is automatically receiving > the .SPF >suffix, which MVS can't seem to process. > > Does anyone know how to resolve this problem? > > thanks, > Steve From owner-sqr-users@list.iex.net Wed Oct 3 13:14:58 2001 Date: Wed, 3 Oct 2001 14:12:23 -0400 From: Cindy Chen Subject: Re: Creating multiple reports on mainframe Steve, I was assuming that you ran the report from a stand alone JCL job. The parm member I meant is the SQRPARMS like the one you have in your mail. Instead of -FDDN:SYSOUT you would have -FRPT1 -RPT2 (here RPT1 and RPT2 should match the DDNAME you have in JCL pointing to the preallocated PDS and should match the name in your DECLARE-REPORT RPT1 in your program). We ended up creating one parm member which has -FP1 -FP2 -FP3 -FP4 -FP5 , and that give us the flexibility of using the same parm member without having to recreate that for each program. But then each of our multiple report program need to use report name as P1, P2, etc., and we don't have much choice about the report names because of the constraint of the command line length. if we have a program that generates only 3 reports, we would still need to define as many (in this case, P1 - P5) declare-report as the -F in the SQRPARMS. Same rule applies for JCL. ex., the JCL might look like : //P1 DD DISP=SHR,DSN=PROD.UGL.REPORT(RPT01) //P2 DD DISP=SHR,DSN=PROD.UGL.REPORT(RPT02) //P3 DD DISP=SHR,DSN=PROD.UGL.REPORT(RPT03) //P4 DD DUMMY //P5 DD DUMMY our SQR is 4.1.7.3 same as yours. We don't have multiple report program run from PeopleSoft , but I think you will need a special shell JCL (or JCLs) for multiple report programs to run in MVS server. HTH. -Cindy At 11:44 AM 10/3/2001 -0400, you wrote: >Cindy, > > Thank you very much for responding. I would just like to clarify a few >things- > > -When you mention the member of your parmlib, are you referring to - > - the Config Manager SQR flag settings in PeopleSoft > - the SQRPARMS member, which in our environment looks like this - > > DSN SYSTEM(DHP2) > RUN PROG(SQR) - > PLAN(DBCALLS) - > LIB('SYS3.PSOFT.SQR.LOAD') - > PARMS('DDN:SQRIN DSN/PSOFTPRD -FDDN:SQROUT -P:HP -S - > -IDDN:SQRINC( -TBZ -MDDN:MAXIN') > END > > - something else? > > - We typically run our SQR's from PeopleSoft using shell JCL, which >defaults the print file to a DDNAME of SYSOUT. We do have a few >SQR's that >we don't run from PeopleSoft. They are run on the mainframe as stand alone >jobs. If we need to use "custom" DDNAMES for the multiple reports, >then >I assume I will have to create a new stand alone job, with it's >own JCL. >I don't see how I could do this using the shell JCL. Is this what you had in >mind, or am I missing something? > > Thanks again for your help. This is the first time we have > attempted this. >It could be quite helpful now and in the future. > > Steve > > > > > >Cindy Chen on 10/03/2001 11:02:50 AM > >Please respond to sqr-users@list.iex.net > >To: SQR-USERS@list.iex.net >cc: (bcc: Steve Rogers/North/KayBee) > >Subject: Re: Creating multiple reports on mainframe > > > >Hi Steve, > > You need : >1. in the member of your parmlib, make sure you have flags: > -FRPT1 -FRPT2 .... >2. then in your JCL, you will need to have ddname RPT1 and RPT2 which point >to a pre-allocated PDS, ex., > //RPT1 dd dsn=your.pds(myrpt1)... > //RPT2 dd dsn=your.pds(myrpt2)... > >HTH > >Cindy >At 08:42 AM 10/3/2001 -0400, you wrote: > > Good morning all - > > > > We are running PeopleSoft DB2 for MVS, version 7.51. All of our > > SQR's are > >processed using the mainframe as our server. I am attempting to create two > >different reports from the same SQR. I used the DECLARE-REPORT options > >according to the SQR server Language Reference. When I attempt to run the > >SQR, > >I am receiving the following error - > > > >(SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF > >(13): Improper function argument > > > > It appears as if the the SQROUT DD name is automatically receiving > > the .SPF > >suffix, which MVS can't seem to process. > > > > Does anyone know how to resolve this problem? > > > > thanks, > > Steve From owner-sqr-users@list.iex.net Wed Oct 3 09:00:36 2001 Date: Wed, 3 Oct 2001 14:57:07 +0100 From: "Maheshwari, Amit" Subject: How to restrict any user from modifying or viewing my reports ' s ource code I have written floated this query earlier also but couldn't follow it up. Here is my problem, I am running my report from Reportbuilder.Whenever I make a new report from reportbuilder, the following files are generated by default --> (if file name is rep1) rep1.htm rep1.log rep1.spf rep1.sqr rep1.srm rep1.xml Now if a user ,unknown to the query and reports, wants to run a report on a database, which file should he click on? I am assuming that rep1.srm is the one he should be clicking.By default the reportbuilder gets opened.Now the whole code is visible to the user.Is there any way out by which just the generated report comes up and not the code as well!!! Please let me have your valuable suggestion. Thanks amit ***************************************************************************** This message is confidential and for use by the addressee only. If you are not the intended recipient, you must not use, disclose, distribute, copy, print, or rely on this message. Please notify the sender by return email and then delete the message from your computer. Royal Skandia accepts no responsibility for changes made to this message after it was sent nor for any loss or damage from receipt or use. Royal Skandia Life Assurance Limited - a member of the Skandia Group of Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated by the Personal Investment Authority for UK Investment Business - Member of the Association of International Life Offices. Internet: http://www.royalskandia.com ***************************************************************************** From owner-sqr-users@list.iex.net Wed Oct 3 09:10:36 2001 Date: Wed, 3 Oct 2001 10:07:18 -0400 From: "Vallabhu, Bindu" Subject: Re: How to restrict any user from modifying or viewing my reports ' s ource code Try rep1.htm and rep1.spf. -----Original Message----- From: Maheshwari, Amit [mailto:Amit.Maheshwari@ROYALSKANDIA.COM] Sent: 10/03/2001 9:57 AM To: SQR-USERS@list.iex.net Subject: How to restrict any user from modifying or viewing my reports ' s ource code I have written floated this query earlier also but couldn't follow it up. Here is my problem, I am running my report from Reportbuilder.Whenever I make a new report from reportbuilder, the following files are generated by default --> (if file name is rep1) rep1.htm rep1.log rep1.spf rep1.sqr rep1.srm rep1.xml Now if a user ,unknown to the query and reports, wants to run a report on a database, which file should he click on? I am assuming that rep1.srm is the one he should be clicking.By default the reportbuilder gets opened.Now the whole code is visible to the user.Is there any way out by which just the generated report comes up and not the code as well!!! Please let me have your valuable suggestion. Thanks amit **************************************************************************** * This message is confidential and for use by the addressee only. If you are not the intended recipient, you must not use, disclose, distribute, copy, print, or rely on this message. Please notify the sender by return email and then delete the message from your computer. Royal Skandia accepts no responsibility for changes made to this message after it was sent nor for any loss or damage from receipt or use. Royal Skandia Life Assurance Limited - a member of the Skandia Group of Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated by the Personal Investment Authority for UK Investment Business - Member of the Association of International Life Offices. Internet: http://www.royalskandia.com **************************************************************************** * From owner-sqr-users@list.iex.net Wed Oct 3 09:33:33 2001 Date: Wed, 3 Oct 2001 15:28:23 +0100 From: "Maheshwari, Amit" Subject: Re: How to restrict any user from modifying or viewing my reports ' s ource code But these are just the static image of the report build some time back.I want the latest picture of my database! -----Original Message----- From: Vallabhu, Bindu [mailto:Bindu.Vallabhu@STAPLES.COM] Sent: 03 October 2001 15:07 To: SQR-USERS@list.iex.net Subject: Re: How to restrict any user from modifying or viewing my reports ' s ource code Try rep1.htm and rep1.spf. -----Original Message----- From: Maheshwari, Amit [mailto:Amit.Maheshwari@ROYALSKANDIA.COM] Sent: 10/03/2001 9:57 AM To: SQR-USERS@list.iex.net Subject: How to restrict any user from modifying or viewing my reports ' s ource code I have written floated this query earlier also but couldn't follow it up. Here is my problem, I am running my report from Reportbuilder.Whenever I make a new report from reportbuilder, the following files are generated by default --> (if file name is rep1) rep1.htm rep1.log rep1.spf rep1.sqr rep1.srm rep1.xml Now if a user ,unknown to the query and reports, wants to run a report on a database, which file should he click on? I am assuming that rep1.srm is the one he should be clicking.By default the reportbuilder gets opened.Now the whole code is visible to the user.Is there any way out by which just the generated report comes up and not the code as well!!! Please let me have your valuable suggestion. Thanks amit **************************************************************************** * This message is confidential and for use by the addressee only. If you are not the intended recipient, you must not use, disclose, distribute, copy, print, or rely on this message. Please notify the sender by return email and then delete the message from your computer. Royal Skandia accepts no responsibility for changes made to this message after it was sent nor for any loss or damage from receipt or use. Royal Skandia Life Assurance Limited - a member of the Skandia Group of Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated by the Personal Investment Authority for UK Investment Business - Member of the Association of International Life Offices. Internet: http://www.royalskandia.com **************************************************************************** * ***************************************************************************** This message is confidential and for use by the addressee only. If you are not the intended recipient, you must not use, disclose, distribute, copy, print, or rely on this message. Please notify the sender by return email and then delete the message from your computer. Royal Skandia accepts no responsibility for changes made to this message after it was sent nor for any loss or damage from receipt or use. Royal Skandia Life Assurance Limited - a member of the Skandia Group of Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated by the Personal Investment Authority for UK Investment Business - Member of the Association of International Life Offices. Internet: http://www.royalskandia.com ***************************************************************************** From owner-sqr-users@list.iex.net Wed Oct 3 10:12:42 2001 Date: Wed, 3 Oct 2001 11:09:22 -0400 From: "Vallabhu, Bindu" Subject: Re: How to restrict any user from modifying or viewing my reports ' s ource code I am sorry - i got your question wrong. Are you using the Brio Portal? -----Original Message----- From: Maheshwari, Amit [mailto:Amit.Maheshwari@ROYALSKANDIA.COM] Sent: 10/03/2001 10:28 AM To: SQR-USERS@list.iex.net Subject: Re: How to restrict any user from modifying or viewing my reports ' s ource code But these are just the static image o