From sqr-users-bounces@sqrug.org Sun Jul 01 00:02:24 2007 Date: Sun, 1 Jul 2007 00:00:03 -0400 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.23 $ $Date: 2006/07/27 16:28:24 $ This document gathers in one location information about the sqr-users mail list. It includes instructions for changing your subscription settings (including unsubscribing), as well are guidelines for using the list. ______________________________________________________________________ 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. Interacting with the list server 3.1 Subscribing to the list 3.2 Unsubscribing from the list 3.3 When your email address changes 3.4 Digests 3.5 Obtaining your password 3.6 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 2005/08/19: o Added note about spam filtering and sender verification systems blocking subscription confirmation messages. 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 Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". 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.org/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-2004 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 Here are some mailing lists that cover topics relating to SQR in some way. 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. HyperionSQR : Hyperion- SQR List for discussion of SQR, SQR Developer (formerly called Brio.Report and Report Builder), and SQR iServer. To join, follow the link above, or send any message to "HyperionSQR- subscribe@yahoogroups.com". rm-users : Report- Mart 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.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. Many sites are now implementing spam filtering and/or sender verification systems, which can prevent your confirmation message from getting delivered to you. You may need check for a message from "sqr- users-request[-AT-]sqrug.org" caught in the filter, or add that address to your list of authorized senders, in order to complete the confirmation process. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. 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. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 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 as other subscribers' mail systems repond....) 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.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. 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. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". 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 SQR product name and version number (see notes below) o Operating system name 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. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy 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 and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 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.) 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. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Jul 01 12:30:13 2007 Date: Sun, 1 Jul 2007 09:27:30 -0700 (PDT) From: Ajith Nyalakonda Subject: [sqr-users] Error with Brio Report Hi all,I could get following error when i run the Brio Report on windows environment. If anyone has faced the similar situation please help me out. (SQR 5528) Sybase DBRESULTS error in cursor 2: (10331) CREATE PROCEDURE permission denied, database tempdb, owner Invalid pointer param number 4, pointer value 0x1102192b8 Error on line 314: (SQR 3733) Could not create procedure for SQL. Errors were found in the program file. SQR: Program Aborting. Brio SQR v6.2 for Sybase \u003cspan lang\u003d\"en-us\"\>\u003cfont face\u003d\"Century Gothic\"\> 12.5\u003c/font\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\> \u003c/span\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003ca name\u003d\"11379a03465802fa_\"\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" face\u003d\"Lucida Calligraphy\"\>Thanks,\u003c/font\>\u003c/span\>\u003c/a\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#800080\" size\u003d\"5\"\>Venkata Madhu\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>   (C607629)\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>BCNIT - FARE Team\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>Application Developer\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>(O) 248-455-2702\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\> \u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>(C) 586-215-6981\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003ca href\u003d\"mailto:VMadhu@bcbsm.com\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003cu\>\u003c/u\>\u003c/i\>\u003c/span\>\u003ci\>\u003cu\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>VMadhu@bcbsm.com\u003c/font\>\u003c/span\>\u003c/u\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/a\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>",1] ); //--> 12.5 Thanks, Ajith. --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 02 08:34:59 2007 Subject: RE: [sqr-users] Error with Brio Report Date: Mon, 2 Jul 2007 08:30:07 -0400 From: "Venkat Maligireddy" One way Use -XP on the command line so no procedures will be created from t= he selects Or=20 Grant create procedure permissions for the user=20 Thanks Venkat -----Original Message----- From: sqr-users-bounces+venkat.reddy=3Dharlandfs.com@sqrug.org [mailto:sqr-= users-bounces+venkat.reddy=3Dharlandfs.com@sqrug.org] On Behalf Of Ajith Ny= alakonda Sent: Sunday, July 01, 2007 12:28 PM To: sqr-users@sqrug.org Subject: [sqr-users] Error with Brio Report=20 Hi all,I could get following error when i run the Brio Report on windows e= nvironment. If anyone has faced the similar situation please help me out. =20=20=20 (SQR 5528) Sybase DBRESULTS error in cursor 2: (10331) CREATE PROCEDURE permission denied, database tempdb, owner Invalid pointer param number 4, pointer value 0x1102192b8 Error on line 314: (SQR 3733) Could not create procedure for SQL. Errors were found in the program file. SQR: Program Aborting. =20=20 =20 Brio SQR v6.2 for Sybase \u003cspan lang\u003d\"en-us\"\>\u003cfont face= \u003d\"Century Gothic\"\> 12.5\u003c/font\>\u003c/span\>\u003cspan lang\u0= 03d\"en-us\"\> \u003c/span\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cs= pan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003= c/span\>\u003ca name\u003d\"11379a03465802fa_\"\>\u003cspan lang\u003d\"en-= us\"\>\u003cfont color\u003d\"#0000FF\" face\u003d\"Lucida Calligraphy\"\>T= hanks,\u003c/font\>\u003c/span\>\u003c/a\>\u003c/p\>\n\n\u003cp dir\u003d\"= LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan lang\u003d\"= en-us\"\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003c/p= \>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u= 003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u0= 03c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"= #800080\" size\u003d\"5\"\>Venkata Madhu\u003c/font\>\u003c/span\>\u003c/i\= >\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d= \"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"= en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>=A0=A0 (C607629= )\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003c= i\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/s= pan\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u003= d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\= >\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\= u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>BCNIT - FARE Team\u003c/f= ont\>\u003c/span\>\u003c/i\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c= /i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u00= 3c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003ci\>\u003cspan lang\u003= d\"en-us\"\>Application Developer\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003= cp dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003= c/span\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u0= 03ci\>\u003cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" siz= e\u003d\"2\"\>(O) 248-455-2702\u003c/font\>\u003c/span\>\u003c/i\>\u003cspa= n lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan = lang\u003d\"en-us\"\> \u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003= d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\= u003cspan lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u0= 03cspan lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"= 2\"\>(C) 586-215-6981\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan lang\u0= 03d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003= d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>= \u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003ca href\u003d\"mailto:VMadhu@bcbsm.com\" target\u003d\"_blank\" onclick\u003d= \"return top.js.OpenExtLink(window,event,this)\"\>\u003cspan lang\u003d\"en= -us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan lang\u003d\"en-us\"\>\u00= 3ci\>\u003cu\>\u003c/u\>\u003c/i\>\u003c/span\>\u003ci\>\u003cu\>\u003cspan= lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>VM= adhu@bcbsm.com\u003c/font\>\u003c/span\>\u003c/u\>\u003c/i\>\u003cspan lang= \u003d\"en-us\"\>\u003c/span\>\u003c/a\>\u003cspan lang\u003d\"en-us\"\>\u0= 03ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>\u003= c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp dir\u003d\"LTR\"\>\u003cspan lang\u= 003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan lang\u00= 3d\"en-us\"\>",1] ); //--> 12.5=20 =20=20=20 Thanks, Ajith. =20=20=20=20=20=20=20 --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel.=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 02 18:20:57 2007 Date: Mon, 2 Jul 2007 18:18:23 -0400 From: ajji Subject: Re: [sqr-users] Error with Brio Report Thanks Venkat,I will give a shot On 7/2/07, Venkat Maligireddy wrote: > > One way Use -XP on the command line so no procedures will be created from > the selects > > Or > > Grant create procedure permissions for the user > > Thanks > Venkat > > -----Original Message----- > From: sqr-users-bounces+venkat.reddy=harlandfs.com@sqrug.org [mailto: > sqr-users-bounces+venkat.reddy=harlandfs.com@sqrug.org] On Behalf Of Ajith > Nyalakonda > Sent: Sunday, July 01, 2007 12:28 PM > To: sqr-users@sqrug.org > Subject: [sqr-users] Error with Brio Report > > Hi all,I could get following error when i run the Brio Report on windows > environment. > If anyone has faced the similar situation please help me out. > > (SQR 5528) Sybase DBRESULTS error in cursor 2: > (10331) CREATE PROCEDURE permission denied, database tempdb, owner > Invalid pointer param number 4, pointer value 0x1102192b8 > Error on line 314: > (SQR 3733) Could not create procedure for SQL. > Errors were found in the program file. > SQR: Program Aborting. > > > Brio SQR v6.2 for Sybase \u003cspan lang\u003d\"en-us\"\>\u003cfont > face\u003d\"Century Gothic\"\> 12.5\u003c/font\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\> \u003c/span\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003ca > name\u003d\"11379a03465802fa_\"\>\u003cspan lang\u003d\"en-us\"\>\u003cfont > color\u003d\"#0000FF\" face\u003d\"Lucida > Calligraphy\"\>Thanks,\u003c/font\>\u003c/span\>\u003c/a\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#800080\" > size\u003d\"5\"\>Venkata Madhu\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\> > (C607629)\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" > size\u003d\"2\"\>BCNIT - FARE > Team\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003ci\>\u003cspan lang\u003d\"en-us\"\>Application > Developer\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>(O) > 248-455-2702\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\> \u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\>(C) > 586-215-6981\u003c/font\>\u003c/span\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan lang\u003d\"en-us\"\>\u003c/span\>\u003ca > href\u003d\"mailto:VMadhu@bcbsm.com\" target\u003d\"_blank\" > onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003cu\>\u003c/u\>\u003c/i\>\u003c/span\>\u003ci\>\u003cu\>\u003cspan > lang\u003d\"en-us\"\>\u003cfont color\u003d\"#0000FF\" size\u003d\"2\"\> > VMadhu@bcbsm.com\u003c/font\>\u003c/span\>\u003c/u\>\u003c/i\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/a\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>\u003c/span\>\u003c/i\>\u003c/p\>\n\n\u003cp > dir\u003d\"LTR\"\>\u003cspan > lang\u003d\"en-us\"\>\u003ci\>\u003c/i\>\u003c/span\>\u003ci\>\u003cspan > lang\u003d\"en-us\"\>",1] ); //--> 12.5 > > Thanks, > Ajith. > > > --------------------------------- > Need a vacation? Get great deals to amazing places on Yahoo! Travel. > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > -- Ajith _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 09 15:10:58 2007 Date: Mon, 9 Jul 2007 12:08:15 -0700 (PDT) From: Sonny Subject: [sqr-users] Need help with placing an image in SQR report v 4.3.4 Hello All I am in a desparate need to print a signature (Jpeg file) to an existing SQR report. I tried the following code (test code) which keeps failing and gives me the following error: Error on line 20: (SQR 6108) Invalid chart size or placement. The code is as follows: begin-setup declare-report label_report layout=default_label printer-type=hp end-declare declare-layout default_label orientation=portrait left-margin=0.5 top-margin=1.85 line-height=4.5 end-declare declare-image logo type = JPEG-FILE image-size = (336,115) source = 'd:\carl2.jpg' end-declare end-setup begin-program print-image logo (1,1) end-program Thanks for all the help in advance, Sonny _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 03:05:08 2007 Date: Tue, 10 Jul 2007 00:01:44 -0700 From: "Mimi Bekele" Subject: [sqr-users] Problem with .spf output file Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? =20 Thanks, MiMi=20=20 ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 03:25:17 2007 From: "R Gumbo" Subject: RE: [sqr-users] Problem with .spf output file Date: Tue, 10 Jul 2007 09:24:01 +0200 Only creates spf if -KEEP flag is set on runtime options at least that is the case in Version 5. Otherwise it only creates .lis -----Original Message----- From: sqr-users-bounces+rgumbo=cottco.co.zw@sqrug.org [mailto:sqr-users-bounces+rgumbo=cottco.co.zw@sqrug.org]On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 9:02 AM To: sqr-users@sqrug.org Subject: [sqr-users] Problem with .spf output file Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? Thanks, MiMi ---------------------------------------------------------------------------- -------------------------------------------- This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 06:36:48 2007 From: "the dragon" Subject: RE: [sqr-users] Problem with .spf output file Date: Tue, 10 Jul 2007 05:33:18 -0500 Unless sqr has changed, the .spf output is an intermediary stage to the final output. It's always there I believe, you just don't generally see it. The -keep switch allows you to keep it around, as it usually goes away when the final output is created. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony ----Original Message Follows---- Only creates spf if -KEEP flag is set on runtime options at least that is the case in Version 5. Otherwise it only creates .lis -----Original Message----- Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? Thanks, MiMi _________________________________________________________________ Local listings, incredible imagery, and driving directions - all in one place! http://maps.live.com/?wip=69&FORM=MGAC01 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 06:53:12 2007 From: "Peter Burton" Subject: RE: [sqr-users] Problem with .spf output file Date: Tue, 10 Jul 2007 06:49:25 -0400 MiMi, SQR will create an .SPF file under the following conditions ... 1) -KEEP is specified 2) -PRINTER:xx is specified 3) If SQR commands are used which require the need for an .SPF file. Peter -----Original Message----- From: sqr-users-bounces+peter_burton=3Dhyperion.com@sqrug.org [mailto:sqr-u= sers-bounces+peter_burton=3Dhyperion.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 3:02 AM To: sqr-users@sqrug.org Subject: [sqr-users] Problem with .spf output file Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? =20 Thanks, MiMi=20=20 ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 07:28:10 2007 Date: Tue, 10 Jul 2007 13:24:38 +0200 (MEST) From: Luc Van der Veurst Subject: [sqr-users] Performance difference v3 vs v9 Hello, We are still running sqr version V3.0.7.0.1 :-). Since re-investigating in what report generation tool we will use in the future will be on next year's budget, we wondered if our sqr code would sitll run under v9. Therefore, we installed version 9.3.0.1.0.836. Our reports still work, so that was the good news, but version 9 is much slower than version 3. A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report just selects one column from one tuple in the database. We see this difference in all our reports: they take about 10 seconds more to run. Our environment : OS : Soralis 8 DB : Sybase ASE 12.5.3 Hyperion says that the difference is due to the fact that v3 uses dblib while v9 uses ctlib. I find this hard to believe, we have other dblib and ctlib programs to compare. What I did notice is that sybase's libraries are linked statically into sqr v3 while there are more libraries dynamically loaded in v9 : v3 : $ ldd /local/sybase/workbench_30/bin/sqr libnsl.so.1 => /lib/libnsl.so.1 libc.so.1 => /lib/libc.so.1 libdl.so.1 => /lib/libdl.so.1 libmp.so.2 => /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 v9 : $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr libbtunicode.so => /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so libCrun.so.1 => /lib/libCrun.so.1 libC.so.5 => /lib/libC.so.5 libsocket.so.1 => /lib/libsocket.so.1 libnsl.so.1 => /lib/libnsl.so.1 libct.so => /local/sybase/sdk125/clt/lib/libct.so libcs.so => /local/sybase/sdk125/clt/lib/libcs.so libtcl.so => /local/sybase/sdk125/clt/lib/libtcl.so libcomn.so => /local/sybase/sdk125/clt/lib/libcomn.so libintl.so => /local/sybase/sdk125/clt/lib/libintl.so libm.so.1 => /lib/libm.so.1 libdl.so.1 => /lib/libdl.so.1 libc.so.1 => /lib/libc.so.1 libthread.so.1 => /lib/libthread.so.1 libmp.so.2 => /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 $ 1. Does anyone had similar experiences with performance after an upgrade ? 2. Does anyone has relinked ldd so that more libraries are statically linked ? Thanks, Luc. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 08:08:04 2007 From: "Peter Burton" Subject: RE: [sqr-users] Performance difference v3 vs v9 Date: Tue, 10 Jul 2007 08:04:13 -0400 Luc, You might try changing the fetch buffer row value (-Bnn). Other than passi= ng this value to the CT-Lib software this is not used by SQR. The default = value for SQR 9.3 is 100. Earlier versions of SQR used different values. Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Luc Van der Ve= urst Sent: Tuesday, July 10, 2007 7:25 AM To: sqr-users@sqrug.org Subject: [sqr-users] Performance difference v3 vs v9 Hello, We are still running sqr version V3.0.7.0.1 :-). Since re-investigating in what report generation tool we will use in the future will be on next year's budget, we wondered if our sqr code would sitll run under v9. Therefore, we installed version 9.3.0.1.0.836. Our reports still work, so that was the good news, but version 9 is much slower than version 3. A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report just selects one column from one tuple in the database. We see this difference in all our reports: they take about 10 seconds more to run. Our environment : OS : Soralis 8 DB : Sybase ASE 12.5.3 Hyperion says that the difference is due to the fact that v3 uses dblib while v9 uses ctlib. I find this hard to believe, we have other dblib and ctlib programs to compare. What I did notice is that sybase's libraries are linked statically into sqr v3 while there are more libraries dynamically loaded in v9 : v3 : $ ldd /local/sybase/workbench_30/bin/sqr libnsl.so.1 =3D> /lib/libnsl.so.1 libc.so.1 =3D> /lib/libc.so.1 libdl.so.1 =3D> /lib/libdl.so.1 libmp.so.2 =3D> /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 v9 : $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr libbtunicode.so =3D> /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so libCrun.so.1 =3D> /lib/libCrun.so.1 libC.so.5 =3D> /lib/libC.so.5 libsocket.so.1 =3D> /lib/libsocket.so.1 libnsl.so.1 =3D> /lib/libnsl.so.1 libct.so =3D> /local/sybase/sdk125/clt/lib/libct.so libcs.so =3D> /local/sybase/sdk125/clt/lib/libcs.so libtcl.so =3D> /local/sybase/sdk125/clt/lib/libtcl.so libcomn.so =3D> /local/sybase/sdk125/clt/lib/libcomn.so libintl.so =3D> /local/sybase/sdk125/clt/lib/libintl.so libm.so.1 =3D> /lib/libm.so.1 libdl.so.1 =3D> /lib/libdl.so.1 libc.so.1 =3D> /lib/libc.so.1 libthread.so.1 =3D> /lib/libthread.so.1 libmp.so.2 =3D> /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 $ 1. Does anyone had similar experiences with performance after an upgrade ? =20 2. Does anyone has relinked ldd so that more libraries are statically linked ? =20 Thanks, Luc. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 12:08:28 2007 Subject: RE: [sqr-users] Problem with .spf output file Date: Tue, 10 Jul 2007 09:04:56 -0700 From: "Mimi Bekele" No actually it does create .spf file even without -KEEP flag being used at run time. The -KEEP flag is used if you want to keep the .spf file after the program is run. In other words -KEEP will keep the .spf as well as .lis file. -MiMi=20 -----Original Message----- From: R Gumbo [mailto:rgumbo@cottco.co.zw]=20 Sent: Tuesday, July 10, 2007 12:24 AM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Problem with .spf output file Only creates spf if -KEEP flag is set on runtime options at least that is the case in Version 5. Otherwise it only creates .lis -----Original Message----- From: sqr-users-bounces+rgumbo=3Dcottco.co.zw@sqrug.org [mailto:sqr-users-bounces+rgumbo=3Dcottco.co.zw@sqrug.org]On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 9:02 AM To: sqr-users@sqrug.org Subject: [sqr-users] Problem with .spf output file Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? Thanks, MiMi ------------------------------------------------------------------------ ---- -------------------------------------------- This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 12:11:58 2007 Subject: RE: [sqr-users] Problem with .spf output file Date: Tue, 10 Jul 2007 12:08:59 -0400 From: "Larry Roux" SQR uses the SPF file to create the LIS. First it runs and creates the generically tagged output (SPF) then it uses various settings to convert the SPF file to the other output types (pdf/html/etc). the SPF file is then usually deleted. the KEEP flag simply tells SQR not to do the delete. -----Original Message----- From: sqr-users-bounces+lroux=3Dsyr.edu@sqrug.org [mailto:sqr-users-bounces+lroux=3Dsyr.edu@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:05 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Problem with .spf output file No actually it does create .spf file even without -KEEP flag being used at run time. The -KEEP flag is used if you want to keep the .spf file after the program is run. In other words -KEEP will keep the .spf as well as .lis file. -MiMi=20 -----Original Message----- From: R Gumbo [mailto:rgumbo@cottco.co.zw]=20 Sent: Tuesday, July 10, 2007 12:24 AM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Problem with .spf output file Only creates spf if -KEEP flag is set on runtime options at least that is the case in Version 5. Otherwise it only creates .lis -----Original Message----- From: sqr-users-bounces+rgumbo=3Dcottco.co.zw@sqrug.org [mailto:sqr-users-bounces+rgumbo=3Dcottco.co.zw@sqrug.org]On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 9:02 AM To: sqr-users@sqrug.org Subject: [sqr-users] Problem with .spf output file Hi we are currently using SQR V6.0 on Unix and AIX platform. My question is why does SQR creates .spf file before creating .lis and is there a way to by pass the creation of the .spf file? Thanks, MiMi ------------------------------------------------------------------------ ---- -------------------------------------------- This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 12:34:49 2007 Date: Tue, 10 Jul 2007 09:31:18 -0700 From: "Mimi Bekele" Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 12:44:55 2007 From: "Peter Burton" Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Date: Tue, 10 Jul 2007 12:41:54 -0400 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 12:58:32 2007 Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Date: Tue, 10 Jul 2007 09:54:58 -0700 From: "Mimi Bekele" Thanks again Peter. I see I'm using the declare-layout to set the report type to landscape. I don't know if there is another way of achieving this without actually using the declare-layout.=20 Below you will see my code. Please let me know if you have any suggestions Begin-Setup=20 Declare-Layout default top-margin =3D 0 left-margin =3D 0 max-lines =3D 58 max-columns =3D 176 End-Declare End-Setup=20 Thanks, MiMi=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 9:42 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 13:29:58 2007 From: "Peter Burton" Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Date: Tue, 10 Jul 2007 13:27:01 -0400 MiMi, Nope ... You must use Declare-Layout to set "Landscape" mode. What is the problem with having the SPF file being created anyway? Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:55 PM To: This list is for discussion about the SQR database reporting language f= rom Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Thanks again Peter. I see I'm using the declare-layout to set the report type to landscape. I don't know if there is another way of achieving this without actually using the declare-layout.=20 Below you will see my code. Please let me know if you have any suggestions Begin-Setup=20 Declare-Layout default top-margin =3D 0 left-margin =3D 0 max-lines =3D 58 max-columns =3D 176 End-Declare End-Setup=20 Thanks, MiMi=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 9:42 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 13:43:24 2007 Date: Tue, 10 Jul 2007 10:39:41 -0700 From: "Mimi Bekele" Subject: [sqr-users] RE: Problem with .spf That's what I thought.... Well the problem is since I can't rename the .spf file at run time, the .spf file gets corrupted from time to time when multiple users are running the program at the same time.=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 10:27 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Nope ... You must use Declare-Layout to set "Landscape" mode. What is the problem with having the SPF file being created anyway? Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:55 PM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Thanks again Peter. I see I'm using the declare-layout to set the report type to landscape. I don't know if there is another way of achieving this without actually using the declare-layout.=20 Below you will see my code. Please let me know if you have any suggestions Begin-Setup=20 Declare-Layout default top-margin =3D 0 left-margin =3D 0 max-lines =3D 58 max-columns =3D 176 End-Declare End-Setup=20 Thanks, MiMi=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 9:42 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 13:50:58 2007 From: "Peter Burton" Subject: RE: [sqr-users] RE: Problem with .spf Date: Tue, 10 Jul 2007 13:47:44 -0400 MiMi, Use the -F command line flag with the name of the users directory (e.g. -F/= home/user/). That way all of the files will go there and there shouldn't b= e any problems with users clobbering the files.=20 Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 1:40 PM To: This list is for discussion about the SQR database reporting language f= rom Hyperion Solutions. Subject: [sqr-users] RE: Problem with .spf That's what I thought.... Well the problem is since I can't rename the .spf file at run time, the .spf file gets corrupted from time to time when multiple users are running the program at the same time.=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 10:27 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Nope ... You must use Declare-Layout to set "Landscape" mode. What is the problem with having the SPF file being created anyway? Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:55 PM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Thanks again Peter. I see I'm using the declare-layout to set the report type to landscape. I don't know if there is another way of achieving this without actually using the declare-layout.=20 Below you will see my code. Please let me know if you have any suggestions Begin-Setup=20 Declare-Layout default top-margin =3D 0 left-margin =3D 0 max-lines =3D 58 max-columns =3D 176 End-Declare End-Setup=20 Thanks, MiMi=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 9:42 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 14:19:46 2007 Subject: RE: [sqr-users] RE: Problem with .spf Date: Tue, 10 Jul 2007 11:16:17 -0700 From: "Mimi Bekele" Yes actually I was thinking of doing something along that line. Currently all the output from all of our production programs goes to a common directory but I will need to re-direct the output to some temporary directory and then clean up the directory and move the .lis file to common directory. Thanks for all your help. MiMi =20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 10:48 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: Problem with .spf MiMi, Use the -F command line flag with the name of the users directory (e.g. -F/home/user/). That way all of the files will go there and there shouldn't be any problems with users clobbering the files.=20 Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 1:40 PM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: [sqr-users] RE: Problem with .spf That's what I thought.... Well the problem is since I can't rename the .spf file at run time, the .spf file gets corrupted from time to time when multiple users are running the program at the same time.=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 10:27 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Nope ... You must use Declare-Layout to set "Landscape" mode. What is the problem with having the SPF file being created anyway? Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:55 PM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Thanks again Peter. I see I'm using the declare-layout to set the report type to landscape. I don't know if there is another way of achieving this without actually using the declare-layout.=20 Below you will see my code. Please let me know if you have any suggestions Begin-Setup=20 Declare-Layout default top-margin =3D 0 left-margin =3D 0 max-lines =3D 58 max-columns =3D 176 End-Declare End-Setup=20 Thanks, MiMi=20 -----Original Message----- From: sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org [mailto:sqr-users-bounces+mimi.bekele=3Dmedimpact.com@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, July 10, 2007 9:42 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 MiMi, Here are some of them ... declare-toc declare-report declare-layout declare-printer declare-procedure use-procedure alter-printer use-report use-printer-type toc-entry print-direct printer=3DXXX Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Mimi Bekele Sent: Tuesday, July 10, 2007 12:31 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4 Peter, Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR commands could cause the creation of the .SPF file. Do you know what are some of the sqr commands that could cause the creation of the .spf file? The reason I'm asking is if I knew what the commands are maybe I can re-write the program so that it will not create the .spf file. Thanks, MiMi=20 ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------ ------------------------------------------------ This transmission, together with any attachments, is intended only for the use of those to whom it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any distribution or copying of this transmission is strictly prohibited. If you received this transmission in error, please notify the original sender immediately and delete this message, along with any attachments, from your computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------------= --------------------------------------------- This transmission, together with any attachments, is intended only for the = use of those to whom it is addressed and may contain information that is pr= ivileged, confidential, and exempt from disclosure under applicable law. I= f you are not the intended recipient, you are hereby notified that any dist= ribution or copying of this transmission is strictly prohibited. If you re= ceived this transmission in error, please notify the original sender immedi= ately and delete this message, along with any attachments, from your comput= er. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 10 16:38:38 2007 Date: Tue, 10 Jul 2007 13:35:55 -0700 (PDT) From: rchan mudambir Subject: [sqr-users] Image not getting printed to its full size Hi all, I am trying to print an jpg image to its full size in SQR in Portrait orientation, A4 paper. The width of the image in SQR output is reduced in size by 2 millimeters. The SQR version used is " SQR for PeopleSoft/8.42/PC/Windows NT 4.0/Oracle 8.0.6/Nov 05 2002 " .The code used is as follows: begin-setup declare-layout def paper-size=(8.27 in, 11.69 in) top-margin=0.4 in left-margin=0.0 in right-margin=0.0 in bottom-margin=0.0 in orientation=portrait end-declare declare-report r1 layout=def end-declare declare-image I1 type = JPEG-FILE source = 'C:\scan0006.jpg' image-size = (81,65) end-declare end-setup Begin-procedure im1 use-report r1 print-image I1 (0, 0) type = JPEG-FILE source = 'C:\scan0006.jpg' image-size = (81,65) End-procedure begin-program do im1 End-program Thanks, Chandra. ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 06:48:35 2007 From: "Steve Cavill" Subject: RE: [sqr-users] Performance difference v3 vs v9 Date: Wed, 11 Jul 2007 20:45:03 +1000 If the difference is always 10s, then it looks more like a startup problem than a sql perf problem (i.e. the increase is not linear) i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? How long does a report that returns 0 rows take? You could trace the SQR execution time by placing a datenow() function as the first as last commands of the program. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of Peter Burton Sent: Tuesday, 10 July 2007 10:04 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Performance difference v3 vs v9 Luc, You might try changing the fetch buffer row value (-Bnn). Other than passing this value to the CT-Lib software this is not used by SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR used different values. Peter -----Original Message----- From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Luc Van der Veurst Sent: Tuesday, July 10, 2007 7:25 AM To: sqr-users@sqrug.org Subject: [sqr-users] Performance difference v3 vs v9 Hello, We are still running sqr version V3.0.7.0.1 :-). Since re-investigating in what report generation tool we will use in the future will be on next year's budget, we wondered if our sqr code would sitll run under v9. Therefore, we installed version 9.3.0.1.0.836. Our reports still work, so that was the good news, but version 9 is much slower than version 3. A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report just selects one column from one tuple in the database. We see this difference in all our reports: they take about 10 seconds more to run. Our environment : OS : Soralis 8 DB : Sybase ASE 12.5.3 Hyperion says that the difference is due to the fact that v3 uses dblib while v9 uses ctlib. I find this hard to believe, we have other dblib and ctlib programs to compare. What I did notice is that sybase's libraries are linked statically into sqr v3 while there are more libraries dynamically loaded in v9 : v3 : $ ldd /local/sybase/workbench_30/bin/sqr libnsl.so.1 => /lib/libnsl.so.1 libc.so.1 => /lib/libc.so.1 libdl.so.1 => /lib/libdl.so.1 libmp.so.2 => /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 v9 : $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr libbtunicode.so => /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so libCrun.so.1 => /lib/libCrun.so.1 libC.so.5 => /lib/libC.so.5 libsocket.so.1 => /lib/libsocket.so.1 libnsl.so.1 => /lib/libnsl.so.1 libct.so => /local/sybase/sdk125/clt/lib/libct.so libcs.so => /local/sybase/sdk125/clt/lib/libcs.so libtcl.so => /local/sybase/sdk125/clt/lib/libtcl.so libcomn.so => /local/sybase/sdk125/clt/lib/libcomn.so libintl.so => /local/sybase/sdk125/clt/lib/libintl.so libm.so.1 => /lib/libm.so.1 libdl.so.1 => /lib/libdl.so.1 libc.so.1 => /lib/libc.so.1 libthread.so.1 => /lib/libthread.so.1 libmp.so.2 => /lib/libmp.so.2 /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 $ 1. Does anyone had similar experiences with performance after an upgrade ? 2. Does anyone has relinked ldd so that more libraries are statically linked ? Thanks, Luc. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 07:20:31 2007 Date: Wed, 11 Jul 2007 13:17:07 +0200 Subject: RE: [sqr-users] Performance difference v3 vs v9 From: "franck\.masson" The approach of steve is correct first try to execute a sqr code without any select statement to get the time needed to launch sqr and to do a login to the database. Franck, ---------- Debut du message initial ----------- De : sqr-users-bounces+franck.masson2002=3Dlaposte.net@sqrug.org A : "This list is for discussion about the SQR database reportinglangu= age from Hyperion Solutions." sqr-users@sqrug.org Copies : Date : Wed, 11 Jul 2007 20:45:03 +1000 Objet : RE: [sqr-users] Performance difference v3 vs v9 > If the difference is always 10s, then it looks more like a startup proble= m than a sql perf problem (i.e. the increase is not linear) > i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? > How long does a report that returns 0 rows take? > You could trace the SQR execution time by placing a datenow() function as= the first as last commands of the program. > Steve. > > -----Original Message----- > From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org] On= Behalf Of Peter Burton > Sent: Tuesday, 10 July 2007 10:04 PM > To: This list is for discussion about the SQR database reporting language= from Hyperion Solutions. > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > Luc, > > You might try changing the fetch buffer row value (-Bnn). Other than pas= sing this value to the CT-Lib software this is not used by > SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR used= different values. > > Peter > > -----Original Message----- > From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-u= sers-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of > Luc Van der Veurst > Sent: Tuesday, July 10, 2007 7:25 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Performance difference v3 vs v9 > > > Hello, > > We are still running sqr version V3.0.7.0.1 :-). > > Since re-investigating in what report generation tool we will use in the = future will be on next year's budget, we wondered if our > sqr code would sitll run under v9. > > Therefore, we installed version 9.3.0.1.0.836. > > Our reports still work, so that was the good news, but version 9 is much = slower than version 3. > > A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The repor= t just selects one column from one tuple in the database. > > We see this difference in all our reports: they take about 10 seconds mor= e to run. > > Our environment : > > OS : Soralis 8 > DB : Sybase ASE 12.5.3 > > Hyperion says that the difference is due to the fact that > v3 uses dblib while v9 uses ctlib. > I find this hard to believe, we have other dblib and ctlib programs to co= mpare. > > What I did notice is that sybase's libraries are linked statically into s= qr v3 while there are more libraries dynamically loaded in > v9 : > > v3 : > > $ ldd /local/sybase/workbench_30/bin/sqr > libnsl.so.1 =3D> /lib/libnsl.so.1 > libc.so.1 =3D> /lib/libc.so.1 > libdl.so.1 =3D> /lib/libdl.so.1 > libmp.so.2 =3D> /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > v9 : > > $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr > libbtunicode.so =3D> > /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so > libCrun.so.1 =3D> /lib/libCrun.so.1 > libC.so.5 =3D> /lib/libC.so.5 > libsocket.so.1 =3D> /lib/libsocket.so.1 > libnsl.so.1 =3D> /lib/libnsl.so.1 > libct.so =3D> /local/sybase/sdk125/clt/lib/libct.so > libcs.so =3D> /local/sybase/sdk125/clt/lib/libcs.so > libtcl.so =3D> /local/sybase/sdk125/clt/lib/libtcl.so > libcomn.so =3D> /local/sybase/sdk125/clt/lib/libcomn.so > libintl.so =3D> /local/sybase/sdk125/clt/lib/libintl.so > libm.so.1 =3D> /lib/libm.so.1 > libdl.so.1 =3D> /lib/libdl.so.1 > libc.so.1 =3D> /lib/libc.so.1 > libthread.so.1 =3D> /lib/libthread.so.1 > libmp.so.2 =3D> /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > $ > > > 1. Does anyone had similar experiences with performance after an > upgrade ? > > 2. Does anyone has relinked ldd so that more libraries are statically > linked ? > > Thanks, > Luc. > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 Cr=E9ez votre adresse =E9lectronique prenom.nom@laposte.net 1 Go d'espace de stockage, anti-spam et anti-virus int=E9gr=E9s. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 07:34:47 2007 Date: Wed, 11 Jul 2007 07:31:45 -0400 From: "bobby b" Subject: [sqr-users] hi hi Friends is there any flag in SQR that show the Path of how the SQCs and variables are changed while executing SQR the S flag is used to find the trace of execution regarding excution sequence is there any flag in SQR if any one have answer pls reply me Thanks in advance _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 07:43:55 2007 From: "the dragon" Subject: RE: [sqr-users] hi Date: Wed, 11 Jul 2007 06:40:13 -0500 Go here http://dev.hyperion.com/techdocs/sqr/sqr_langref80.pdf download/read document answer question peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony ----Original Message Follows---- hi Friends is there any flag in SQR that show the Path of how the SQCs and variables are changed while executing SQR the S flag is used to find the trace of execution regarding excution sequence is there any flag in SQR if any one have answer pls reply me Thanks in advance _________________________________________________________________ http://newlivehotmail.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 07:48:03 2007 Date: Wed, 11 Jul 2007 13:40:41 +0200 (MEST) From: Luc Van der Veurst Subject: RE: [sqr-users] Performance difference v3 vs v9 Hello, Peter, changing the -B parameter doesn't help. > If the difference is always 10s, then it looks more like a startup problem than a sql perf problem (i.e. the increase is not linear) Yes, that's what I thought too. It certainly is not a database sql performance problem since the database is the same for both versions. The increase is not linear, always about 9 to 10 seconds slower, no matter how long the report runs. My sqr program looks like : $ cat sqrworld.sqr begin-report show 'Hello World.' end-report $ I execute the program with the unix time command. executed with v3 : SQR: Structured Query Report Writer V3.0.7.0.1 Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. Hello World. SQR: End of Run. real 0m0.03s user 0m0.02s sys 0m0.01s executed with v9 : Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserved. (SQR 8906) Warning: The product license will expire on 20-aug-2007. Hello World. SQR: End of Run. real 0m9.47s user 0m0.61s sys 0m0.23s Could it be because this is a test license ? The time is spent between printing the copyright line and the warning about the expiration date (I don't know if that output is buffered). (There is a difference between 3 and 9: even when the program doesn't need a database connection, v 9 establishes a connection while 3 doesn't (I know because I have to provide valid username/password/server information for v9 and not for v3). If the program requires a database connection, the time difference between the 2 is also between 9 and 10 seconds). Thanks, Luc. > i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? > How long does a report that returns 0 rows take? > You could trace the SQR execution time by placing a datenow() function as the first as last commands of the program. > Steve. > > -----Original Message----- > From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of Peter Burton > Sent: Tuesday, 10 July 2007 10:04 PM > To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > Luc, > > You might try changing the fetch buffer row value (-Bnn). Other than passing this value to the CT-Lib software this is not used by > SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR used different values. > > Peter > > -----Original Message----- > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of > Luc Van der Veurst > Sent: Tuesday, July 10, 2007 7:25 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Performance difference v3 vs v9 > > > Hello, > > We are still running sqr version V3.0.7.0.1 :-). > > Since re-investigating in what report generation tool we will use in the future will be on next year's budget, we wondered if our > sqr code would sitll run under v9. > > Therefore, we installed version 9.3.0.1.0.836. > > Our reports still work, so that was the good news, but version 9 is much slower than version 3. > > A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report just selects one column from one tuple in the database. > > We see this difference in all our reports: they take about 10 seconds more to run. > > Our environment : > > OS : Soralis 8 > DB : Sybase ASE 12.5.3 > > Hyperion says that the difference is due to the fact that > v3 uses dblib while v9 uses ctlib. > I find this hard to believe, we have other dblib and ctlib programs to compare. > > What I did notice is that sybase's libraries are linked statically into sqr v3 while there are more libraries dynamically loaded in > v9 : > > v3 : > > $ ldd /local/sybase/workbench_30/bin/sqr > libnsl.so.1 => /lib/libnsl.so.1 > libc.so.1 => /lib/libc.so.1 > libdl.so.1 => /lib/libdl.so.1 > libmp.so.2 => /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > v9 : > > $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr > libbtunicode.so => > /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so > libCrun.so.1 => /lib/libCrun.so.1 > libC.so.5 => /lib/libC.so.5 > libsocket.so.1 => /lib/libsocket.so.1 > libnsl.so.1 => /lib/libnsl.so.1 > libct.so => /local/sybase/sdk125/clt/lib/libct.so > libcs.so => /local/sybase/sdk125/clt/lib/libcs.so > libtcl.so => /local/sybase/sdk125/clt/lib/libtcl.so > libcomn.so => /local/sybase/sdk125/clt/lib/libcomn.so > libintl.so => /local/sybase/sdk125/clt/lib/libintl.so > libm.so.1 => /lib/libm.so.1 > libdl.so.1 => /lib/libdl.so.1 > libc.so.1 => /lib/libc.so.1 > libthread.so.1 => /lib/libthread.so.1 > libmp.so.2 => /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > $ > > > 1. Does anyone had similar experiences with performance after an > upgrade ? > > 2. Does anyone has relinked ldd so that more libraries are statically > linked ? > > Thanks, > Luc. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 07:56:56 2007 From: "Peter Burton" Subject: RE: [sqr-users] Performance difference v3 vs v9 Date: Wed, 11 Jul 2007 07:53:11 -0400 Luc, Could be the license logic but that is not something that can be controlled= by any setting available to the user. You do not need to provide a database connection for those reports which do= not require one. Simply specify "/" for the connectivity and specify the = -XL command line flag. sqr hello / -xl Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Luc Van der Ve= urst Sent: Wednesday, July 11, 2007 7:41 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Performance difference v3 vs v9 Hello, Peter, changing the -B parameter doesn't help. > If the difference is always 10s, then it looks more like a startup problem than a sql perf problem (i.e. the increase is not linear) Yes, that's what I thought too. It certainly is not a database sql performance problem since the database is the same for both versions. The increase is not linear, always about 9 to 10 seconds slower, no matter how long the report runs. My sqr program looks like : $ cat sqrworld.sqr begin-report show 'Hello World.' end-report $ I execute the program with the unix time command. executed with v3 : SQR: Structured Query Report Writer V3.0.7.0.1 Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. Hello World. SQR: End of Run. real 0m0.03s user 0m0.02s sys 0m0.01s executed with v9 : Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserve= d. (SQR 8906) Warning: The product license will expire on 20-aug-2007. Hello World. SQR: End of Run. real 0m9.47s user 0m0.61s sys 0m0.23s Could it be because this is a test license ? The time is spent between printing the copyright line and the warning about the expiration date (I don't know if that output is buffered). (There is a difference between 3 and 9: even when the program doesn't need a database connection, v 9 establishes a connection while 3 doesn't (I know because I have to provide valid username/password/server information for v9 and not for v3). If the program requires a database connection, the time difference between the 2 is also between 9 and 10 seconds). Thanks, Luc. > i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? > How long does a report that returns 0 rows take? > You could trace the SQR execution time by placing a datenow() function as= the first as last commands of the program. > Steve. > > -----Original Message----- > From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org] On= Behalf Of Peter Burton > Sent: Tuesday, 10 July 2007 10:04 PM > To: This list is for discussion about the SQR database reporting language= from Hyperion Solutions. > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > Luc, > > You might try changing the fetch buffer row value (-Bnn). Other than pas= sing this value to the CT-Lib software this is not used by > SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR used different values. > > Peter > > -----Original Message----- > From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of > Luc Van der Veurst > Sent: Tuesday, July 10, 2007 7:25 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Performance difference v3 vs v9 > > > Hello, > > We are still running sqr version V3.0.7.0.1 :-). > > Since re-investigating in what report generation tool we will use in the future will be on next year's budget, we wondered if our > sqr code would sitll run under v9. > > Therefore, we installed version 9.3.0.1.0.836. > > Our reports still work, so that was the good news, but version 9 is much slower than version 3. > > A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report just selects one column from one tuple in the database. > > We see this difference in all our reports: they take about 10 seconds mor= e to run. > > Our environment : > > OS : Soralis 8 > DB : Sybase ASE 12.5.3 > > Hyperion says that the difference is due to the fact that > v3 uses dblib while v9 uses ctlib. > I find this hard to believe, we have other dblib and ctlib programs to compare. > > What I did notice is that sybase's libraries are linked statically into s= qr v3 while there are more libraries dynamically loaded in > v9 : > > v3 : > > $ ldd /local/sybase/workbench_30/bin/sqr > libnsl.so.1 =3D> /lib/libnsl.so.1 > libc.so.1 =3D> /lib/libc.so.1 > libdl.so.1 =3D> /lib/libdl.so.1 > libmp.so.2 =3D> /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > v9 : > > $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr > libbtunicode.so =3D> > /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so > libCrun.so.1 =3D> /lib/libCrun.so.1 > libC.so.5 =3D> /lib/libC.so.5 > libsocket.so.1 =3D> /lib/libsocket.so.1 > libnsl.so.1 =3D> /lib/libnsl.so.1 > libct.so =3D> /local/sybase/sdk125/clt/lib/libct.so > libcs.so =3D> /local/sybase/sdk125/clt/lib/libcs.so > libtcl.so =3D> /local/sybase/sdk125/clt/lib/libtcl.so > libcomn.so =3D> /local/sybase/sdk125/clt/lib/libcomn.so > libintl.so =3D> /local/sybase/sdk125/clt/lib/libintl.so > libm.so.1 =3D> /lib/libm.so.1 > libdl.so.1 =3D> /lib/libdl.so.1 > libc.so.1 =3D> /lib/libc.so.1 > libthread.so.1 =3D> /lib/libthread.so.1 > libmp.so.2 =3D> /lib/libmp.so.2 > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > $ > > > 1. Does anyone had similar experiences with performance after an > upgrade ? > > 2. Does anyone has relinked ldd so that more libraries are statically > linked ? > > Thanks, > Luc. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 08:33:25 2007 Date: Wed, 11 Jul 2007 14:29:21 +0200 (MEST) From: Luc Van der Veurst Subject: RE: [sqr-users] Performance difference v3 vs v9 Thanks, Peter. > Could be the license logic but that is not something that can be controlled by any setting available to the user. > > You do not need to provide a database connection for those reports which do not require one. Simply specify "/" for the connectivity and specify the -XL command line flag. > > sqr hello / -xl ok, there is no difference wether I include the -xl option or not : $ sqr sqrworld / -xl Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserved. (SQR 8906) Warning: The product license will expire on 20-aug-2007. Hello World. SQR: End of Run. real 0m9.48s user 0m0.54s sys 0m0.24s In any case, this must rule out that the difference is due to the database interface. Thanks, Luc. > -----Original Message----- > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Luc Van der Veurst > Sent: Wednesday, July 11, 2007 7:41 AM > To: sqr-users@sqrug.org > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > Hello, > > Peter, changing the -B parameter doesn't help. > > > > If the difference is always 10s, then it looks more like a startup problem > than a sql perf problem (i.e. the increase is not linear) > > Yes, that's what I thought too. It certainly is not a database sql > performance problem since the database is the same for both versions. > > The increase is not linear, always about 9 to 10 seconds slower, no > matter how long the report runs. > > My sqr program looks like : > > $ cat sqrworld.sqr > begin-report > show 'Hello World.' > end-report > $ > > I execute the program with the unix time command. > > executed with v3 : > > SQR: Structured Query Report Writer V3.0.7.0.1 > Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. > > Hello World. > > SQR: End of Run. > > real 0m0.03s > user 0m0.02s > sys 0m0.01s > > executed with v9 : > > Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 > Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserved. > > (SQR 8906) Warning: The product license will expire on 20-aug-2007. > Hello World. > > SQR: End of Run. > > real 0m9.47s > user 0m0.61s > sys 0m0.23s > > > Could it be because this is a test license ? > The time is spent between printing the copyright line and the > warning about the expiration date (I don't know if that output > is buffered). > > (There is a difference between 3 and 9: even when the program doesn't > need a database connection, v 9 establishes a connection while 3 doesn't > (I know because I have to provide valid username/password/server information > for v9 and not for v3). If the program requires a database connection, > the time difference between the 2 is also between 9 and 10 seconds). > > Thanks, > Luc. > > > > > > > i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? > > How long does a report that returns 0 rows take? > > You could trace the SQR execution time by placing a datenow() function as the > first as last commands of the program. > > Steve. > > > > -----Original Message----- > > From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org > > [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf > Of Peter Burton > > Sent: Tuesday, 10 July 2007 10:04 PM > > To: This list is for discussion about the SQR database reporting languagefrom > Hyperion Solutions. > > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > > Luc, > > > > You might try changing the fetch buffer row value (-Bnn). Other than passing > this value to the CT-Lib software this is not used by > > SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR used > different values. > > > > Peter > > > > -----Original Message----- > > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org > [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of > > Luc Van der Veurst > > Sent: Tuesday, July 10, 2007 7:25 AM > > To: sqr-users@sqrug.org > > Subject: [sqr-users] Performance difference v3 vs v9 > > > > > > Hello, > > > > We are still running sqr version V3.0.7.0.1 :-). > > > > Since re-investigating in what report generation tool we will use in the > future will be on next year's budget, we wondered if our > > sqr code would sitll run under v9. > > > > Therefore, we installed version 9.3.0.1.0.836. > > > > Our reports still work, so that was the good news, but version 9 is much > slower than version 3. > > > > A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The report > just selects one column from one tuple in the database. > > > > We see this difference in all our reports: they take about 10 seconds more to > run. > > > > Our environment : > > > > OS : Soralis 8 > > DB : Sybase ASE 12.5.3 > > > > Hyperion says that the difference is due to the fact that > > v3 uses dblib while v9 uses ctlib. > > I find this hard to believe, we have other dblib and ctlib programs to > compare. > > > > What I did notice is that sybase's libraries are linked statically into sqr v3 > while there are more libraries dynamically loaded in > > v9 : > > > > v3 : > > > > $ ldd /local/sybase/workbench_30/bin/sqr > > libnsl.so.1 => /lib/libnsl.so.1 > > libc.so.1 => /lib/libc.so.1 > > libdl.so.1 => /lib/libdl.so.1 > > libmp.so.2 => /lib/libmp.so.2 > > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > > > v9 : > > > > $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr > > libbtunicode.so => > > /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so > > libCrun.so.1 => /lib/libCrun.so.1 > > libC.so.5 => /lib/libC.so.5 > > libsocket.so.1 => /lib/libsocket.so.1 > > libnsl.so.1 => /lib/libnsl.so.1 > > libct.so => /local/sybase/sdk125/clt/lib/libct.so > > libcs.so => /local/sybase/sdk125/clt/lib/libcs.so > > libtcl.so => /local/sybase/sdk125/clt/lib/libtcl.so > > libcomn.so => /local/sybase/sdk125/clt/lib/libcomn.so > > libintl.so => /local/sybase/sdk125/clt/lib/libintl.so > > libm.so.1 => /lib/libm.so.1 > > libdl.so.1 => /lib/libdl.so.1 > > libc.so.1 => /lib/libc.so.1 > > libthread.so.1 => /lib/libthread.so.1 > > libmp.so.2 => /lib/libmp.so.2 > > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > $ > > > > > > 1. Does anyone had similar experiences with performance after an > > upgrade ? > > > > 2. Does anyone has relinked ldd so that more libraries are statically > > linked ? > > > > Thanks, > > Luc. > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > ____ Luc Van der Veurst UZ Brussel. Email efficient: mail niet in html, gebruik geen images in signatures! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 08:42:47 2007 From: "Peter Burton" Subject: RE: [sqr-users] Performance difference v3 vs v9 Date: Wed, 11 Jul 2007 08:38:43 -0400 Luc, What .lic files are in the license directory /opt/hyperion/common/LicenseStandalone/Licenses There should only be the one for SQR in that directory (unless you have oth= er products installed). Also, make sure that there isn't an environment variable called LM_LICENSE_= FILE set. This could cause some problems. Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of Luc Van der Ve= urst Sent: Wednesday, July 11, 2007 8:29 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Performance difference v3 vs v9 Thanks, Peter. > Could be the license logic but that is not something that can be controll= ed by any setting available to the user. > > You do not need to provide a database connection for those reports which = do not require one. Simply specify "/" for the connectivity and specify the -= XL command line flag. > > sqr hello / -xl ok, there is no difference wether I include the -xl option or not : $ sqr sqrworld / -xl Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserve= d. (SQR 8906) Warning: The product license will expire on 20-aug-2007. Hello World. SQR: End of Run. real 0m9.48s user 0m0.54s sys 0m0.24s In any case, this must rule out that the difference is due to the database interface. Thanks, Luc. > -----Original Message----- > From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of= Luc Van der Veurst > Sent: Wednesday, July 11, 2007 7:41 AM > To: sqr-users@sqrug.org > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > Hello, > > Peter, changing the -B parameter doesn't help. > > > > If the difference is always 10s, then it looks more like a startup prob= lem > than a sql perf problem (i.e. the increase is not linear) > > Yes, that's what I thought too. It certainly is not a database sql > performance problem since the database is the same for both versions. > > The increase is not linear, always about 9 to 10 seconds slower, no > matter how long the report runs. > > My sqr program looks like : > > $ cat sqrworld.sqr > begin-report > show 'Hello World.' > end-report > $ > > I execute the program with the unix time command. > > executed with v3 : > > SQR: Structured Query Report Writer V3.0.7.0.1 > Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. > > Hello World. > > SQR: End of Run. > > real 0m0.03s > user 0m0.02s > sys 0m0.01s > > executed with v9 : > > Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 > Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reser= ved. > > (SQR 8906) Warning: The product license will expire on 20-aug-2007. > Hello World. > > SQR: End of Run. > > real 0m9.47s > user 0m0.61s > sys 0m0.23s > > > Could it be because this is a test license ? > The time is spent between printing the copyright line and the > warning about the expiration date (I don't know if that output > is buffered). > > (There is a difference between 3 and 9: even when the program doesn't > need a database connection, v 9 establishes a connection while 3 doesn't > (I know because I have to provide valid username/password/server informat= ion > for v9 and not for v3). If the program requires a database connection, > the time difference between the 2 is also between 9 and 10 seconds). > > Thanks, > Luc. > > > > > > > i.e. a 0.07s report now takes 10.81s/ Does a 100s report take 110s? > > How long does a report that returns 0 rows take? > > You could trace the SQR execution time by placing a datenow() function = as the > first as last commands of the program. > > Steve. > > > > -----Original Message----- > > From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org > > [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org] = On Behalf > Of Peter Burton > > Sent: Tuesday, 10 July 2007 10:04 PM > > To: This list is for discussion about the SQR database reporting languagefrom > Hyperion Solutions. > > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > > Luc, > > > > You might try changing the fetch buffer row value (-Bnn). Other than passing > this value to the CT-Lib software this is not used by > > SQR. The default value for SQR 9.3 is 100. Earlier versions of SQR us= ed > different values. > > > > Peter > > > > -----Original Message----- > > From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org > [mailto:sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf = Of > > Luc Van der Veurst > > Sent: Tuesday, July 10, 2007 7:25 AM > > To: sqr-users@sqrug.org > > Subject: [sqr-users] Performance difference v3 vs v9 > > > > > > Hello, > > > > We are still running sqr version V3.0.7.0.1 :-). > > > > Since re-investigating in what report generation tool we will use in the > future will be on next year's budget, we wondered if our > > sqr code would sitll run under v9. > > > > Therefore, we installed version 9.3.0.1.0.836. > > > > Our reports still work, so that was the good news, but version 9 is much > slower than version 3. > > > > A report that runs with v3 in 0.07s seconds takes 10.81s in v9. The rep= ort > just selects one column from one tuple in the database. > > > > We see this difference in all our reports: they take about 10 seconds m= ore to > run. > > > > Our environment : > > > > OS : Soralis 8 > > DB : Sybase ASE 12.5.3 > > > > Hyperion says that the difference is due to the fact that > > v3 uses dblib while v9 uses ctlib. > > I find this hard to believe, we have other dblib and ctlib programs to > compare. > > > > What I did notice is that sybase's libraries are linked statically into= sqr v3 > while there are more libraries dynamically loaded in > > v9 : > > > > v3 : > > > > $ ldd /local/sybase/workbench_30/bin/sqr > > libnsl.so.1 =3D> /lib/libnsl.so.1 > > libc.so.1 =3D> /lib/libc.so.1 > > libdl.so.1 =3D> /lib/libdl.so.1 > > libmp.so.2 =3D> /lib/libmp.so.2 > > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > > > v9 : > > > > $ ldd /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/bin/sqr > > libbtunicode.so =3D> > > /local/sybase/Hyperion/BIPlus/bin/SQR/Server/Sybase/lib/libbtunicode.so > > libCrun.so.1 =3D> /lib/libCrun.so.1 > > libC.so.5 =3D> /lib/libC.so.5 > > libsocket.so.1 =3D> /lib/libsocket.so.1 > > libnsl.so.1 =3D> /lib/libnsl.so.1 > > libct.so =3D> /local/sybase/sdk125/clt/lib/libct.so > > libcs.so =3D> /local/sybase/sdk125/clt/lib/libcs.so > > libtcl.so =3D> /local/sybase/sdk125/clt/lib/libtcl.so > > libcomn.so =3D> /local/sybase/sdk125/clt/lib/libcomn.so > > libintl.so =3D> /local/sybase/sdk125/clt/lib/libintl.so > > libm.so.1 =3D> /lib/libm.so.1 > > libdl.so.1 =3D> /lib/libdl.so.1 > > libc.so.1 =3D> /lib/libc.so.1 > > libthread.so.1 =3D> /lib/libthread.so.1 > > libmp.so.2 =3D> /lib/libmp.so.2 > > /usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1 > > $ > > > > > > 1. Does anyone had similar experiences with performance after an > > upgrade ? > > > > 2. Does anyone has relinked ldd so that more libraries are statically > > linked ? > > > > Thanks, > > Luc. > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > ____ Luc Van der Veurst UZ Brussel. Email efficient: mail niet in html, gebruik geen images in signatures! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 11 09:20:57 2007 Date: Wed, 11 Jul 2007 15:15:49 +0200 (MEST) From: Luc Van der Veurst Subject: RE: [sqr-users] Performance difference v3 vs v9 Hi Peter, > What .lic files are in the license directory > > /opt/hyperion/common/LicenseStandalone/Licenses > > There should only be the one for SQR in that directory (unless you have other products installed). There are 2 files in the Licenses directory : -rwxrwxr-x 1 sybase infd 6731 Jun 19 13:29 HS9_SA_TempFile.lic -rwxrwxr-x 1 sybase infd 25857 Jun 19 13:29 HS9_TempFile.lic > Also, make sure that there isn't an environment variable called LM_LICENSE_FILE set. This could cause some problems. The LM_LICENSE_FILE variable was not set. When I remove file HS9_TempFile.lic file, I got performance closer to the version 3 performance. The difference is now 0.7s which should be acceptable. Case closed. Thanks for your help ! Luc. > -----Original Message----- > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Luc Van der Veurst > Sent: Wednesday, July 11, 2007 8:29 AM > To: sqr-users@sqrug.org > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > Thanks, Peter. > > > Could be the license logic but that is not something that can be controlled by > any setting available to the user. > > > > You do not need to provide a database connection for those reports which do > not require one. Simply specify "/" for the connectivity and specify the -XL > command line flag. > > > > sqr hello / -xl > > ok, there is no difference wether I include the -xl option or not : > > $ sqr sqrworld / -xl > Hyperion System 9 BI+ Production Reporting Server - 9.3.0.1.0.836 > Copyright (c) 1994-2007 Hyperion Solutions Corporation. All Rights Reserved. > > (SQR 8906) Warning: The product license will expire on 20-aug-2007. > Hello World. > > SQR: End of Run. > > real 0m9.48s > user 0m0.54s > sys 0m0.24s > > In any case, this must rule out that the difference is due to the > database interface. > > Thanks, > Luc. > > > > > > > -----Original Message----- > > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org > [mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Luc > Van der Veurst > > Sent: Wednesday, July 11, 2007 7:41 AM > > To: sqr-users@sqrug.org > > Subject: RE: [sqr-users] Performance difference v3 vs v9 > > > > > > Hello, > > > > Peter, changing the -B parameter doesn't help. > > > > > > > If the difference is always 10s, then it looks more like a startup problem > > than a sql perf problem (i.e. the increase is not linear) > > > > Yes, that's what I thought too. It certainly is not a database sql > > performance problem since the database is the same for both versions. > > > > The increase is not linear, always about 9 to 10 seconds slower, no > > matter how long the report runs. > > > > My sqr program looks like : > > > > $ cat sqrworld.sqr > > begin-report > > show 'Hello World.' > > end-report > > $ > > > > I execute the program with the unix time command. > > > > executed with v3 : > > > > SQR: Structured Query Report Writer V3.0.7.0.1 > > Copyright (C) MITI