From sqr-users-bounces@sqrug.org Sat Oct 01 00:00:46 2005 Date: Sat, 1 Oct 2005 00:00:02 -0500 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.22 $ $Date: 2005/08/19 05:12:40 $ 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 2004/03/04: o New name and URL for "HyperionSQR" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from 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. 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 Oct 02 09:35:31 2005 Date: Sun, 2 Oct 2005 07:34:28 -0700 (PDT) From: Aleksandr Slobodyanik Subject: Re: [sqr-users] RE: Oracle LONG data type processing Just guessing. Try to issue statement: set long (some number). Reduce (some number) if you still getting error. ruscs ___ wrote: Hello, I am using SQR ODBC Version 8.0.2 And I am creating a few flat files containing columns with Oracle LONG data type (Oracle db is the source). Further, I am getting the following error (with LONG data type) while trying to select rows within Begin-Select...End-Select construct: (SQR 5528) ODBC SQL dbexec: SQLExecute error 1459 in cursor 3: [Oracle][ODBC][Ora]ORA-01459: invalid length for variable character string Error on line 57: (SQR 3723) Problem executing cursor. SQR: Program Aborting. ------------------- Obviously, I can't increase the record size because the script does not compile: Open $FileName as 1 For-Writing Record=32767:vary Status=#OpenStat .... In addition, I have two PCs w/ different versions of Oracle ODBC driver and I have run my scipts on both of these PCs. One of these driver versions is 8.01.07.00 I do not get the above error with this driver. The other driver version is 9.02.00.65. And this is the driver version that I am having trouble with... Please help me resolve this problem... Thank you, Ken _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 03 01:19:10 2005 Date: Sun, 2 Oct 2005 23:18:08 -0700 (PDT) From: Harish Krishna Subject: [sqr-users] Read and display BLOB format images onto PDF files using SQR. Hello all, I need to use SQR to print to a PDF output file. The output file that needs to be created is a resume which needs to contain textual data and also a image of the applicant. My problem is that I need to read and position the image of the applicant on to the PDF report. The image is stored in an Oracle database in BLOB format. Can BLOB objects(containing image information) be read using SQR programs, and be printed onto the PDF report? Kindly advice. Regards, Harish. --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 03 09:21:14 2005 Date: Mon, 3 Oct 2005 10:20:05 -0400 From: Bahar Brahme Subject: [sqr-users] Dynamic distribution of multiple reports within one SQR All, My SQR generates different report files which I need to distribute it dynamically to different people. I do not want to send the files in an email but want to distribute them as if the report manager distributes it using the distribution table. It would be like a person 'ABC' running the report himself/herself but only I would run it for him/her. What complicates the matter is that I need to run it for multiple persons using just one SQR. Any response would be greatly appreciated. Thank you. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 03 21:13:26 2005 Date: Mon, 3 Oct 2005 19:12:19 -0700 (PDT) From: Aleksandr Slobodyanik Subject: Re: [sqr-users] Dynamic distribution of multiple reports within one SQR As far as I know you can use command NEW-REPORT $report_name. Put user name or login as $report_name. You can also incorporate date of run. This is for PDF format. Bahar Brahme wrote: All, My SQR generates different report files which I need to distribute it dynamically to different people. I do not want to send the files in an email but want to distribute them as if the report manager distributes it using the distribution table. It would be like a person 'ABC' running the report himself/herself but only I would run it for him/her. What complicates the matter is that I need to run it for multiple persons using just one SQR. Any response would be greatly appreciated. Thank you. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Nov 01 21:27:22 2005 Date: Tue, 1 Nov 2005 18:24:56 -0800 (PST) From: Aleksandr Slobodyanik Subject: [sqr-users] Bold in .CSV Hello. I was looking for the answer, but couldn't find it. I need to write to the .csv bold heading. Anyone has the solution how to do it? Thanks. --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Nov 02 03:35:07 2005 From: "Steve Cavill" Subject: RE: [sqr-users] Bold in .CSV Date: Wed, 2 Nov 2005 19:31:45 +1100 A csv file is a plain ascii text file. So you can't include any formatting. 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 Aleksandr Slobodyanik Sent: Wednesday, 2 November 2005 1:25 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: [sqr-users] Bold in .CSV Hello. I was looking for the answer, but couldn't find it. I need to write to the .csv bold heading. Anyone has the solution how to do it? Thanks. --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. _______________________________________________ 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 Oct 04 10:55:51 2005 Date: Tue, 04 Oct 2005 11:54:38 -0400 From: "Tajinder Chahal" Subject: [sqr-users] SQL Question Hi All, =20 I know this is not a SQL discussion forum but I think SQL is the base langu= age used for all the databases. That is why I'm posting my question here. Which function in DB2 can I use to get the column value before it hits the = blank space. E.g. 1. 'How are you' - I only want to display 'How'. 2. 'This is a test' - I only want to display 'This'. Any help would be greatly appreciated. Thanks, =20 Tajinder _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 04 13:51:54 2005 Date: Tue, 04 Oct 2005 14:50:44 -0400 From: "F. Christopher Costa" Subject: Re: [sqr-users] SQL Question This is a multi-part message in MIME format... --------------090806080706010204030405 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I am not a DB2 programmer, but I would try something along the lines of ..... SELECT CHARINDEX(' ',name), SUBSTRING(name,1,CHARINDEX(' ',name)-1) Tajinder Chahal wrote: >Hi All, > >I know this is not a SQL discussion forum but I think SQL is the base language used for all the databases. That is why I'm posting my question here. > >Which function in DB2 can I use to get the column value before it hits the blank space. > >E.g. >1. 'How are you' - I only want to display 'How'. >2. 'This is a test' - I only want to display 'This'. > >Any help would be greatly appreciated. > >Thanks, > >Tajinder > > > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users > > -- F. Christopher Costa, Software Developer College of the Holy Cross Information Technology Services Smith Hall - Room 101 One College Street Worcester, MA 01610-2395 508.793.3865 --------------090806080706010204030405 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'text/x-vcard' MIME type. It has been automatically discarded before sending the message to the list. --------------090806080706010204030405 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------090806080706010204030405-- From sqr-users-bounces@sqrug.org Tue Oct 04 14:28:12 2005 Date: Tue, 04 Oct 2005 15:26:53 -0400 From: "Tajinder Chahal" Subject: Re: Fwd: [sqr-users] SQL Question Thanks a lot Amy. I changed the query a little bit for DB2: select substr('How are you', 1,locate(' ','How are you')) from dual. >>> Amy Eldridge 10/04/05 01:07PM >>> Lacking a better technique, I'd probably do this: select substr('How are you',1,instr('How are you',' ',1)-1) from dual A. >X-Mailer: Novell GroupWise Internet Agent 6.0.4 >Date: Tue, 04 Oct 2005 11:54:38 -0400 >From: "Tajinder Chahal" >To: >Subject: [sqr-users] SQL Question >X-BeenThere: sqr-users@sqrug.org=20 >X-Mailman-Version: 2.1.5 >Reply-To: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Id: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Unsubscribe: , > >List-Post: >List-Help: >List-Subscribe: , > >Sender: sqr-users-bounces+emgeac=3Dmuohio.edu@sqrug.org=20 >X-Real-ConnectIP: 199.164.165.113 >X-Scanned-By: MIMEDefang 2.45 >X-Scanned-By: MIMEDefang 2.52 on 134.53.6.11 > >Hi All, > >I know this is not a SQL discussion forum but I think SQL is the base=20 >language used for all the databases. That is why I'm posting my question h= ere. > >Which function in DB2 can I use to get the column value before it hits the= =20 >blank space. > >E.g. >1. 'How are you' - I only want to display 'How'. >2. 'This is a test' - I only want to display 'This'. > >Any help would be greatly appreciated. > >Thanks, > >Tajinder > > > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org=20 >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 Oct 04 15:25:50 2005 Date: Tue, 04 Oct 2005 16:24:27 -0400 From: "George Jansen" Subject: Re: Fwd: [sqr-users] SQL Question If this is the only time you'll need to do it, good. If not, look into crea= ting a stored procedure, call it, say "nth_token". First parameter is the s= tring to pull that token out of, 2nd is number (defaulted to 1st if you lik= e), 3rd is a delimiter list, defaulted to a space. >>> Tchaha@Roushind.com 10/04/05 3:26 PM >>> Thanks a lot Amy. I changed the query a little bit for DB2: select substr('How are you', 1,locate(' ','How are you')) from dual. >>> Amy Eldridge 10/04/05 01:07PM >>> Lacking a better technique, I'd probably do this: select substr('How are you',1,instr('How are you',' ',1)-1) from dual A. >X-Mailer: Novell GroupWise Internet Agent 6.0.4 >Date: Tue, 04 Oct 2005 11:54:38 -0400 >From: "Tajinder Chahal" >To: >Subject: [sqr-users] SQL Question >X-BeenThere: sqr-users@sqrug.org=20 >X-Mailman-Version: 2.1.5 >Reply-To: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Id: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Unsubscribe: , > >List-Post: >List-Help: >List-Subscribe: , > >Sender: sqr-users-bounces+emgeac=3Dmuohio.edu@sqrug.org=20 >X-Real-ConnectIP: 199.164.165.113 >X-Scanned-By: MIMEDefang 2.45 >X-Scanned-By: MIMEDefang 2.52 on 134.53.6.11 > >Hi All, > >I know this is not a SQL discussion forum but I think SQL is the base=20 >language used for all the databases. That is why I'm posting my question h= ere. > >Which function in DB2 can I use to get the column value before it hits the= =20 >blank space. > >E.g. >1. 'How are you' - I only want to display 'How'. >2. 'This is a test' - I only want to display 'This'. > >Any help would be greatly appreciated. > >Thanks, > >Tajinder > > > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org=20 >http://www.sqrug.org/mailman/listinfo/sqr-users=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 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 Sun Oct 09 20:51:25 2005 From: "Steve Cavill" Subject: RE: [sqr-users] Question about TOP and SQR Date: Mon, 10 Oct 2005 11:50:16 +1000 I just tried this and it worked fine (Microsoft sql server) Begin-Program Position (1,1) Do Master_Query End-Program Begin-Procedure Master_Query begin-select top 10 sal (1,1) next-Listing from emp end-select end-procedure 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 Leanne Harrisburg Sent: Thursday, 22 September 2005 4:01 AM To: sqr-users@sqrug.org Subject: [sqr-users] Question about TOP and SQR Does SQR allow the use of TOP, as in SELECT TOP 1 MAX(A.COLUMN) FROM DATABASE.TABLE? Thank you, Leanne Harrisburg National University Programmer/Analyst voice: (619) 563-2635 Fax: (619) 563-7933 _______________________________________________ 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 Sun Oct 09 20:54:32 2005 Date: Sun, 09 Oct 2005 22:52:36 -0300 From: "PeterG Clark" Subject: RE: [sqr-users] Question about TOP and SQR I am away on vacation until October 19, 2005. Please contact Brian Bolger, = Bill Cole or Wayne Peters for any questions related to PeopleSoft. (If your intended recipient was the Peter Clark in Legal Services, he appea= rs as "Clark, PeterD -Legal-" in the Groupwise address book.) _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 10 05:29:52 2005 Date: 10 Oct 2005 10:28:47 -0000 From: "Ravi Kiran" Subject: [sqr-users] Language Translation for Fields =A0 Hi we need translate about 175 fields (short description and long descriptions= ) for our country specific implementation.For this iam supposed to open eac= h field via Application designer and update the short and long descriptions= manually. Can we use an SQR to update the short and long descriptions of t= hese fields in the respective application tables (PSDBFIELD,PSDBFLDLABL etc= ). If any one has information on this please pass it to me Thanks in advance Regards, Ravi. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 10 08:18:31 2005 From: "John Tucker" Date: Mon, 10 Oct 2005 09:17:10 -0400 Subject: [sqr-users] defaults for UNSTRING? --===============1033948653== Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 SSdtIHdyaXRpbmcgYW4gaW50ZXJmYWNlIHRoYXQgcmVhZHMgaW4gYSByYXRo ZXIgbGVuZ3RoeSB0YWIgZGVsaW1pdGVkIGZpbGUsIGFuZCB3b25kZXJlZCBp ZiB0aGVyZSB3YXMgYW55IHdheSB0byBwdXQgZGVmYXVsdHMgaW50byB0aGUg VW5zdHJpbmcgY29tbWFuZC4gIEZvciBleGFtcGxlLCBpZiBJIGhhdmUgSm9o blt0YWJdW3RhYl1TbWl0aCBmb3IgJEZpcnN0ICRNaWRkbGUgJExhc3QsIEkn ZCBsb3ZlIGl0IGlmICRNaWRkbGUgY291bGQgY29tZSBvdXQgYXMgJyAnIGlu c3RlYWQgb2YgbnVsbC4NCg0KSSB3cm90ZSBhIHByb2NlZHVyZSBpbiBhbiBT UUMgdGhhdCB0YWtlcyBjYXJlIG9mIHRoYXQgc3R1ZmYgYXMgZm9sbG93cywg YnV0IEkgd2FudGVkIHRvIHNlZSBpZiBhbnkgb2YgeW91IGtuZXcgb2Ygc29t ZXRoaW5nIHNpbXBsZXIgdGhhdCBJJ20gbWlzc2luZy4NCg0KLi4uDQoNClVu c3RyaW5nICRGaWxlX2RhdGEgYnkgJHRhYiBpbnRvICRGaXJzdCAkTWlkZGxl ICRMYXN0DQoNCkRvIENsZWFuLVN0cmluZygkRmlyc3QsICRGaXJzdCkNCkRv IENsZWFuLVN0cmluZygkTWlkZGxlLCAkTWlkZGxlKQ0KRG8gQ2xlYW4tU3Ry aW5nKCRMYXN0LCAkTGFzdCkNCg0KLi4uDQoNCkJlZ2luLVByb2NlZHVyZSBD bGVhbi1TdHJpbmcoJElucHV0LCA6JE91dHB1dCkNCg0KTGV0ICRPdXRwdXQg PSBsdHJpbShydHJpbSgkSW5wdXQsICcgJyksICcgJykNCklmIElzTnVsbCgk T3V0cHV0KQ0KICAgTGV0ICRPdXRwdXQgPSAnICcNCkVuZC1JZiAgDQoNCi4u Lg0KDQpUaGlzIHNob3VsZCB3b3JrIHJlYWxseSB3ZWxsIGZvciBhIGZpeGVk IGxlbmd0aCBmaWxlIC0gRG8gQ2xlYW4tU3RyaW5nKHN1YnN0cigkZmlsZV9k YXRhLCAxLCAzMCksICRGaXJzdCkgLSBzbyBJJ2xsIGhhbmcgb250byBpdCBl dmVuIGlmIHlvdSBhbGwgaGF2ZSBhIGJldHRlciBzdWdnZXN0aW9uIGZvciB0 aGUgdGFiLWRlbGltaXRlZCBmaWxlLiAgVGhhbmtzIGZvciBhbnkgaWRlYXMh DQoNCi1Kb2huIFR1Y2tlcg0K --===============1033948653== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --===============1033948653==-- From sqr-users-bounces@sqrug.org Mon Oct 10 08:24:45 2005 Date: Mon, 10 Oct 2005 09:24:04 -0400 From: don.barclay@srs.gov Subject: Re: [sqr-users] defaults for UNSTRING? Hi John, You can use a replace statement before the unstring to replace [tab][tab] with [tab][space][tab]. Don > I'm writing an interface that reads in a rather lengthy tab > delimited file, and wondered if there was any way to put defaults > into the Unstring command. For example, if I have John[tab][tab] > Smith for $First $Middle $Last, I'd love it if $Middle could come > out as ' ' instead of null. > > I wrote a procedure in an SQC that takes care of that stuff as > follows, but I wanted to see if any of you knew of something simpler > that I'm missing. > > ... > > Unstring $File_data by $tab into $First $Middle $Last > > Do Clean-String($First, $First) > Do Clean-String($Middle, $Middle) > Do Clean-String($Last, $Last) > > ... > > Begin-Procedure Clean-String($Input, :$Output) > > Let $Output = ltrim(rtrim($Input, ' '), ' ') > If IsNull($Output) > Let $Output = ' ' > End-If > > ... > > This should work really well for a fixed length file - Do Clean- > String(substr($file_data, 1, 30), $First) - so I'll hang onto it > even if you all have a better suggestion for the tab-delimited file. > Thanks for any ideas! > > -John Tucker _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 11 08:24:18 2005 Date: Tue, 11 Oct 2005 13:23:09 +0000 (GMT) From: john.tucker@oracle.com Subject: Re: [sqr-users] defaults for UNSTRING? Thanks - looks like Replace wasn't around in the SQR versions my documentation covers, though. I found references to it online, but I can't find the syntax anywhere. Can someone offer assistance? I'm currently using SQR for PeopleSoft 8.46, according to $sqr-ver, in case it matters. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 11 08:33:33 2005 From: "Paul Hoyte" Subject: RE: [sqr-users] defaults for UNSTRING? Date: Tue, 11 Oct 2005 09:32:44 -0400 Here is a sample line of code.... let $store_code1 = replace($store_code,',',''',''') Paul Hoyte (248) 752-6970 www.sharidionne.com pa_hoyte@si-proservices.com -----Original Message----- From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org [mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On Behalf Of john.tucker@oracle.com Sent: Tuesday, October 11, 2005 9:23 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] defaults for UNSTRING? Thanks - looks like Replace wasn't around in the SQR versions my documentation covers, though. I found references to it online, but I can't find the syntax anywhere. Can someone offer assistance? I'm currently using SQR for PeopleSoft 8.46, according to $sqr-ver, in case it matters. _______________________________________________ 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 Oct 11 08:50:40 2005 Date: Tue, 11 Oct 2005 09:50:00 -0400 From: don.barclay@srs.gov Subject: Re: [sqr-users] defaults for UNSTRING? Hi John, I was surprised to see "replace" wasn't in the index for the SQR Language Reference guide (version 6.0). It is one of the functions listed in the LET section (page 219). Syntax: dst_var = replace(source_value, from_string, to_string) You could do something like this: encode '<9>' into $Tab let $FromString = $Tab || $Tab let $ToString = $Tab || ' ' || $Tab let $Line = replace($Line,$FromString, $ToString) Don sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 10/11/2005 09:23:09 AM: > Thanks - looks like Replace wasn't around in the SQR versions my > documentation covers, though. I found references to it online, but > I can't find the syntax anywhere. Can someone offer assistance? > I'm currently using SQR for PeopleSoft 8.46, according to $sqr-ver, > in case it matters. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 11 09:37:37 2005 From: "radhika reddy" Date: Tue, 11 Oct 2005 09:37:00 -0500 Subject: [sqr-users] (SQR 4705) Program line too long; maximum is 511 Hi, I am getting the following error. I checked many times to see if the procedures have a problem after line 1025. But i don't see any problem as i changed the program to have a workable procedure. I checked for mismatch begin-procedure, but still i don't find any problem. Has anybody encountered this kind of error. what would be the different reasons for getting this kind of error. Error on line 1025: (SQR 4705) Program line too long; maximum is 511. Any input would be appreciated. Thanks. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 11 09:43:47 2005 Subject: RE: [sqr-users] (SQR 4705) Program line too long; maximum is 511 Date: Tue, 11 Oct 2005 10:42:21 -0400 From: "Vaidyanathan, Ramakrishnan \(Corporate, consultant\)" Hi I suppose that in SQR the max line length is 511. If u have a line thats= more than that length u can continue it in next line. Ramky -----Original Message----- From: sqr-users-bounces+ramakrishnan.vaidyanathan=3Dge.com@sqrug.org [mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=3Dge.com@sqrug.org]On Behalf Of radhika reddy Sent: Tuesday, October 11, 2005 10:37 AM To: sqr-users@sqrug.org Subject: [sqr-users] (SQR 4705) Program line too long; maximum is 511 Hi, I am getting the following error. I checked many times to see if the=20 procedures have a problem after line 1025. But i don't see any problem as i= =20 changed the program to have a workable procedure. I checked for mismatch=20 begin-procedure, but still i don't find any problem. Has anybody encountered this kind of error. what would be the different=20 reasons for getting this kind of error. Error on line 1025: (SQR 4705) Program line too long; maximum is 511. Any input would be appreciated. Thanks. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE!= =20 http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ 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 Oct 11 10:19:32 2005 Date: Tue, 11 Oct 2005 11:17:51 -0400 From: "Jamie Harris" Subject: Re: [sqr-users] (SQR 4705) Program line too long; maximum is 511 Look at line 1025 itself - it's too long. You can probably shorten it - if you need help with that you can post the contents of that line and we'll show you how it can be broken into two lines. ----------------------------------------------------- James Harris Junior Systems Programmer/Analyst Information Technology Division Frederick Community College ----------------------------------------------------- >>> radhika_05@hotmail.com 10/11/2005 10:37 AM >>> Hi, I am getting the following error. I checked many times to see if the procedures have a problem after line 1025. But i don't see any problem as i changed the program to have a workable procedure. I checked for mismatch begin-procedure, but still i don't find any problem. Has anybody encountered this kind of error. what would be the different reasons for getting this kind of error. Error on line 1025: (SQR 4705) Program line too long; maximum is 511. Any input would be appreciated. Thanks. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ 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 Oct 12 22:25:05 2005 Date: Wed, 12 Oct 2005 20:24:02 -0700 (PDT) From: Aleksandr Slobodyanik Subject: Re: [sqr-users] Configuration for MSSQL Hi, I have a problem to configure SQR for MSSQL Server. Company have 2 types of databases: Sybase and MSSQL. So far I was working with Sybase, but now I need to write report for MSSQL. When I change environment to ODBC it gives me error - SQRDIR environment variable not set even thou I did not change it in SQR.INI. Any hint will be helpful, or maybe I am doing something wrong? A part from SQR.INI that sets environment will be more than appreciated. Thank you. --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 12 22:47:01 2005 Date: Thu, 13 Oct 2005 13:45:44 +1000 From: "Ian Mills" Subject: Re: [sqr-users] Configuration for MSSQL Hi, I think you need to install the SQR for ODBC software to run against the MS= SQL Server database. I would assume that you only have the SQR for Sybase v= ersion installed. If your installation key doesn't give you the option to i= nstall any other version, you will need to contact Hyperion for a new key a= nd possible a new license for the new software. We have 3 versions installed here. Sybase, ODBC and Oracle. Hope this helps Regards, Ian >>> aslobody@yahoo.com 13/10/2005 1:24:02 pm >>> Hi, I have a problem to configure SQR for MSSQL Server. Company have 2 types of databases: Sybase and MSSQL. So far I was working w= ith Sybase, but now I need to write report for MSSQL. When I change environment to ODBC it gives me error - SQRDIR environment v= ariable not set even thou I did not change it in SQR.INI. Any hint will be helpful, or maybe I am doing something wrong? A part from = SQR.INI that sets environment will be more than appreciated. Thank you. =20 =09=09 --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 --=20 This message from ORIX Australia might contain confidential and/or privileged information. If you are not the intended recipient, any use, disclosure or copying of this message (or of any attachments to it) is not authorised. If you have received this message in error, please notify the sender immediately and delete the message and any attachments from your system. Please inform the sender if you do not wish to receive future communications by email. ORIX handles personal information according to a Privacy Policy that is consistent with the National Privacy Principles. Please let us know if you would like a copy. It is also available at http://www.orix.com.au . _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 21 08:40:36 2005 Date: Fri, 21 Oct 2005 08:37:41 -0500 From: "Brooke Funk" Subject: [sqr-users] Formatting Toolbar My Formatting toolbar is visible but everything is greyed out? Am I missin= g something? I need to underline some text in a form letter I am creating = and it won't enable to allow me to do that. Brooke Funk Database Administrator First Federal Bank of Kansas City email: Brooke.Funk@firstfedbankkc.com Wk: 816-245-4163 Fax: 816-245-4138 NOTICE: This e-mail is intended solely for the use of the individual to whom it is addressed and may contain information that is privileged, confidential or otherwise exempt from disclosure. If the reader of this e-mail is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the original message at the listed e-mail address. Thank you. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 21 08:34:53 2005 From: "judeag" Date: Fri, 21 Oct 2005 18:48:33 -0400 Subject: [sqr-users] Setspace sqr and setdbnam not updating psrectblspc Hi, After refresh with production we run setdbname and setspace sqrs. SETSPACE.SQR compares the tablespacename (DDLSPACENAME) defined for each table defined in the PeopleSoft record definition table (PSRECDEFN) to the relational database system catalog for that table. If the DDLSPACENAME does not match the actual tablespace name for an existing table, then the DDLSPACENAME value is updated with the tablespace name from the system catalog.If the table definition is new, and contains a DDLSPACENAME that does not exist in the system catalog, then a default value is inserted. The site sets the default tablespacename when running SETSPACE.SQR. In addition, if the DDLSPACENAME is blank, and no system catalog value exists, the default value is inserted. After running setspace and setdbnam when I ran database audit report I have seen that psrectblspc is not updated properly with underlying system catalog tablespace. In psrectblspc for some tables we have double enteries that is for some records we have two tablespace names, out of this one tablespace name is updated with underlying system catalog tablespace name but the other tablespace name is not updated by setspace sqr. My question is what could be the reason and why the sqr is not updating both the rows where we have double enteries in psrectblspc. Also if we have the tablespace name and dbname in psrectblspc which doesn't exist in system catalog table than in that case what will happen. We are on DB2 database and application is peoplesoft. Any insight on this would be of great help. Cheers, Jude _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 25 12:49:01 2005 Date: Tue, 25 Oct 2005 17:46:22 +0000 (GMT) From: john.tucker@oracle.com Subject: [sqr-users] renaming an input file? I am once again writing the group on a question I already have an answer to, just to see if someone has a better answer. I am writing an interface that reads an incoming file. To prevent someone from running a given file more than once, I need to rename the incoming file after I'm done with it. Here's how I've thought to do it, in pseudo-code: Open file.txt as 10 for-reading record=2226:fixed ... Open renamedfile.txt as 20 for-writing record=2226:fixed ... read a line from 10 write the line to 20 do whatever else I need to with the line loop through until I'm done with the file Close 10 Close 20 Open file.txt as 30 for-writing record=2226:fixed ... write one blank line to 30 Close 30 Clearly (unless my pseudo-code is unreadable), this will get the job done, but I just feel like it's a bit cheesy. I'm guessing that this is a fairly common thing to do, and I may be simply missing something incredibly obvious. Please let me know if any of you have a suggestion on a better way for me to accomplish this. Thanks! -John T. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 25 12:58:51 2005 From: Bill Beckner Subject: RE: [sqr-users] renaming an input file? Date: Tue, 25 Oct 2005 12:56:21 -0500 SQR has a RENAME builtin command: Renames old_filename to new_filename. The function returns either a zero (0) to indicate success or the value returned from the operating system to indicate an error. Syntax: stat_var = rename(old_filename, new_filename) old_filename = text literal, column, variable, or expression. new_filename = text literal, column, variable, or expression. stat_var = decimal, float, or integer variable. Example: let #fstatus = rename($old_filename, $new_filename) Function arguments are enclosed in parentheses and can be nested. Arguments referenced as x, y, and z indicate the first, second, and third argument to a function. Otherwise, functions take a single argument. Use parentheses to override the normal precedence rules. Hope this helps! -----Original Message----- From: sqr-users-bounces+bbeckner=icc.edu@sqrug.org [mailto:sqr-users-bounces+bbeckner=icc.edu@sqrug.org] On Behalf Of john.tucker@oracle.com Sent: Tuesday, October 25, 2005 12:46 PM To: sqr-users@sqrug.org Subject: [sqr-users] renaming an input file? I am once again writing the group on a question I already have an answer to, just to see if someone has a better answer. I am writing an interface that reads an incoming file. To prevent someone from running a given file more than once, I need to rename the incoming file after I'm done with it. Here's how I've thought to do it, in pseudo-code: Open file.txt as 10 for-reading record=2226:fixed ... Open renamedfile.txt as 20 for-writing record=2226:fixed ... read a line from 10 write the line to 20 do whatever else I need to with the line loop through until I'm done with the file Close 10 Close 20 Open file.txt as 30 for-writing record=2226:fixed ... write one blank line to 30 Close 30 Clearly (unless my pseudo-code is unreadable), this will get the job done, but I just feel like it's a bit cheesy. I'm guessing that this is a fairly common thing to do, and I may be simply missing something incredibly obvious. Please let me know if any of you have a suggestion on a better way for me to accomplish this. Thanks! -John T. _______________________________________________ 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 Oct 25 13:16:04 2005 Date: Tue, 25 Oct 2005 14:08:51 -0400 From: don.barclay@srs.gov Subject: Re: [sqr-users] renaming an input file? Hi John, Here's a cheese-free approach that works great for us. We append the current date to the input file to prevent the interface from running a second time, and create a history of input files used. HTH, Don let $RenameFile = '{IMPORTPREFIX}filename_' || $Date || '.txt' let #fstatus = delete($RenameFile) let #fstatus = rename($InputFile,$RenameFile) If #fstatus <> 0 Show 'Could not rename input file ' $InputFile Show 'to ' $RenameFile end-if sqr-users-bounces+don.barclay=srs.gov@sqrug.org wrote on 10/25/2005 01:46:22 PM: > I am once again writing the group on a question I already have an > answer to, just to see if someone has a better answer. I am writing > an interface that reads an incoming file. To prevent someone from > running a given file more than once, I need to rename the incoming > file after I'm done with it. > > -John T. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 25 15:14:45 2005 From: "the dragon" Subject: RE: [sqr-users] renaming an input file? Date: Tue, 25 Oct 2005 15:12:39 -0500 What I notice immediately is that while you're creating another identical file, you're not removing the first file, so it doesn't fill your needs... Why not close the file, and then use an OS command through call system to rename your file?? 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) ----Original Message Follows---- I am once again writing the group on a question I already have an answer to, just to see if someone has a better answer. I am writing an interface that reads an incoming file. To prevent someone from running a given file more than once, I need to rename the incoming file after I'm done with it. Here's how I've thought to do it, in pseudo-code: Open file.txt as 10 for-reading record=2226:fixed ... Open renamedfile.txt as 20 for-writing record=2226:fixed ... read a line from 10 write the line to 20 do whatever else I need to with the line loop through until I'm done with the file Close 10 Close 20 Open file.txt as 30 for-writing record=2226:fixed ... write one blank line to 30 Close 30 Clearly (unless my pseudo-code is unreadable), this will get the job done, but I just feel like it's a bit cheesy. I'm guessing that this is a fairly common thing to do, and I may be simply missing something incredibly obvious. Please let me know if any of you have a suggestion on a better way for me to accomplish this. Thanks! -John T. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 26 07:57:36 2005 Date: Wed, 26 Oct 2005 12:54:10 +0000 (GMT) From: john.tucker@oracle.com Subject: [sqr-users] Re: renaming a file Man, do I love this list - I got three helpful explanations of two good solutions, and no one insulted me for asking a question with such obvious (once you know them) answers. Now I just have to choose between call system and rename. :-) Thanks, all! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 26 08:02:55 2005 Subject: RE: [sqr-users] Re: renaming a file Date: Wed, 26 Oct 2005 08:59:27 -0400 From: "Peter Burton" Rename() is faster ... Creating a sub-process just to rename a file is very expensive.=20 -----Original Message----- From: sqr-users-bounces+peter_burton=3Dhyperion.com@sqrug.org [mailto:sqr-users-bounces+peter_burton=3Dhyperion.com@sqrug.org] On Behalf Of john.tucker@oracle.com Sent: Wednesday, October 26, 2005 8:54 AM To: sqr-users@sqrug.org Subject: [sqr-users] Re: renaming a file Man, do I love this list - I got three helpful explanations of two good solutions, and no one insulted me for asking a question with such obvious (once you know them) answers. Now I just have to choose between call system and rename. :-) Thanks, all! _______________________________________________ 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 Oct 26 08:16:08 2005 Subject: RE: [sqr-users] Re: renaming a file Date: Wed, 26 Oct 2005 08:11:48 -0500 From: "Bob Stone" This is a multi-part message in MIME format... ------_=_NextPart_001_01C5DA2F.0780E896 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable we can do insulting too....but for an extra fee.... =20 and rename() is the better one to use. All processing done in the program = itself is quicker than going out to the OS...but I doubt you'd find either = noticeably slow. ________________________________ From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org on behalf of john.t= ucker@oracle.com Sent: Wed 10/26/2005 7:54 AM To: sqr-users@sqrug.org Subject: [sqr-users] Re: renaming a file Man, do I love this list - I got three helpful explanations of two good sol= utions, and no one insulted me for asking a question with such obvious (onc= e you know them) answers. Now I just have to choose between call system an= d rename. :-) Thanks, all! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------_=_NextPart_001_01C5DA2F.0780E896 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'application/ms-tnef' MIME type. It has been automatically discarded before sending the message to the list. ------_=_NextPart_001_01C5DA2F.0780E896 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------_=_NextPart_001_01C5DA2F.0780E896-- From sqr-users-bounces@sqrug.org Thu Oct 27 11:38:12 2005 Subject: RE: [sqr-users] Re: renaming a file Date: Thu, 27 Oct 2005 11:35:45 -0500 From: "Jim Womeldorf" The biggest advantage to using SQR's RENAME is that it is platform independent. We run on both UNIX and NT and by using RENAME we do not have to code for both (or either:) Jim=20 -----Original Message----- From: sqr-users-bounces+jwomeldo=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+jwomeldo=3Dfastenal.com@sqrug.org] On Behalf Of Bob Stone Sent: Wednesday, October 26, 2005 8:12 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: RE: [sqr-users] Re: renaming a file we can do insulting too....but for an extra fee.... =20 and rename() is the better one to use. All processing done in the program itself is quicker than going out to the OS...but I doubt you'd find either noticeably slow. ________________________________ From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org on behalf of john.tucker@oracle.com Sent: Wed 10/26/2005 7:54 AM To: sqr-users@sqrug.org Subject: [sqr-users] Re: renaming a file Man, do I love this list - I got three helpful explanations of two good solutions, and no one insulted me for asking a question with such obvious (once you know them) answers. Now I just have to choose between call system and rename. :-) Thanks, all! _______________________________________________ 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 Thu Oct 27 11:28:58 2005 Date: Thu, 27 Oct 2005 09:26:54 -0700 (GMT-07:00) From: Long Haired Frique Subject: [sqr-users] install error We installed Hyperion SQR Developer 8.3 with the Oracle SQR Server. Previously we had Brio Report Builder 6.2 (with Oracle). When we open the Developer and pull in a report it works fine. When we open a report by clicking on it, although everything works fine, we get the error: Cannot find the file 'report name' (or one of its components) blah blah. This is only a nuisance, but we are wondering if anyone knows how to get rid of it. Andrew :) _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 16:00:31 2005 From: "Hall, Tara" Date: Thu, 27 Oct 2005 16:58:51 -0400 Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 16:04:56 2005 Subject: RE: [sqr-users] LIS file Date: Thu, 27 Oct 2005 17:02:24 -0400 From: "Kaithi, Murali" There should be atleast one print command in your sqr program to create a lis file. Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 17:50:34 2005 Date: Thu, 27 Oct 2005 15:48:00 -0700 (PDT) From: KaYing Tsang Subject: RE: [sqr-users] LIS file Not for sure you have the -keep at the end of your command line. -ic:\hrmsdev\sqr -zifc:\hrmsdev\sqr\pssqr.ini -fc:\temp\ -keep thanks, Karen T "Kaithi, Murali" wrote: There should be atleast one print command in your sqr program to create a lis file. Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 16:08:05 2005 Subject: Re: [sqr-users] LIS file From: Kaz.Narayanan@averydennison.com Date: Thu, 27 Oct 2005 14:03:17 -0700 Hello, In the SQR, if you do not have any 'PRINT ' commands, it may not create an .LIS file. Thanks Regards K.M.Narayanan |---------+-----------------------------------------------------------> | | "Hall, Tara" | | | Sent by: | | | sqr-users-bounces+kaz.narayanan=averydennison.co| | | m@sqrug.org | | | | | | | | | 10/27/2005 01:58 PM | | | Please respond to "This list is for discussion | | | about the SQR database reporting language from | | | Hyperion Solutions." | | | | |---------+-----------------------------------------------------------> >----------------------------------------------------------------------------------| | | | To: "'sqr-users@sqrug.org'" | | cc: | | Subject: [sqr-users] LIS file | >----------------------------------------------------------------------------------| Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ----------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 16:11:01 2005 Subject: RE: [sqr-users] LIS file Date: Thu, 27 Oct 2005 16:04:39 -0500 From: "Bob Stone" you probably aren't printing anything. At the end of the run, if nothing w= as put into the LIS file, it isn't created. -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org]On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 3:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ 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 Thu Oct 27 16:14:07 2005 From: "Hall, Tara" Subject: RE: [sqr-users] LIS file Date: Thu, 27 Oct 2005 17:11:15 -0400 Thanks for responding. I do have one print command in the sqr program. -----Original Message----- From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] Sent: Thursday, October 27, 2005 5:02 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] LIS file There should be atleast one print command in your sqr program to create a lis file. Murali -----Original Message----- From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Thu Oct 27 16:17:04 2005 Date: Thu, 27 Oct 2005 17:13:26 -0400 From: "Jenny Mckeon" Subject: Re: [sqr-users] LIS file While we are discussing this, can anyone comment on why the report lines w= rap in any *.LIS file wrap ? I want to FTP the file to a mainframe for pri= nting but need to resolve the wrapping issue. Should I generate another t= ype of output file ?=20 Thanks, J.Mackinnon Applications Analyst=20 >>> hallt@talgov.com 10/27/05 4:58 PM >>> Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ 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 Thu Oct 27 16:26:50 2005 Subject: RE: [sqr-users] LIS file Date: Thu, 27 Oct 2005 17:16:05 -0400 From: "Kaithi, Murali" Is your -f parameter set properly in command line parameters of sqr. Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 5:11 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] LIS file Thanks for responding. I do have one print command in the sqr program. -----Original Message----- From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] Sent: Thursday, October 27, 2005 5:02 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] LIS file There should be atleast one print command in your sqr program to create a lis file. Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Email has been scanned for all viruses by PAETEC Email Scanning Servic= es, utilizing MessageLabs proprietary SkyScan infrastructure. For more info= rmation on a proactive anti-virus service working around the clock, around = the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 27 16:23:41 2005 Subject: RE: [sqr-users] LIS file Date: Thu, 27 Oct 2005 16:22:13 -0500 From: "Schaetzly, Kent" Any chance you are inadvertently including -NOLIS or -F command line flags?= -F will redirect the .lis output -----Original Message----- From: sqr-users-bounces+kschaetzly=3Deprod.com@sqrug.org [mailto:sqr-users-bounces+kschaetzly=3Deprod.com@sqrug.org]On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:11 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] LIS file Thanks for responding. I do have one print command in the sqr program. -----Original Message----- From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] Sent: Thursday, October 27, 2005 5:02 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] LIS file There should be atleast one print command in your sqr program to create a lis file. Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ 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 Fri Oct 28 08:03:08 2005 From: "Steve Cavill" Subject: RE: [sqr-users] LIS file Date: Fri, 28 Oct 2005 22:59:44 +1000 What is the command line that calls the sqr. Various parameters affect the output (as mentioned in other responses) -printer -nolis -keep -f Does it create a spf file? 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 Hall, Tara Sent: Friday, 28 October 2005 6:59 AM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ 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 Fri Oct 28 08:14:19 2005 Date: Fri, 28 Oct 2005 10:11:35 -0300 From: "PeterG Clark" Subject: RE: [sqr-users] LIS file But is that PRINT command ever being executed? If there is any data selecti= on logic in the program, it is entirely possible that no data was selected = to be printed ... hence no .LIS file. We usually program in logic that will= indicate that condition to the user so that we don't get calls asking wher= e their .LIS file has gone to :-) >>> hallt@talgov.com 2005/10/27 18:11:15 >>> Thanks for responding. I do have one print command in the sqr program. -----Original Message----- From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com]=20 Sent: Thursday, October 27, 2005 5:02 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] LIS file There should be atleast one print command in your sqr program to create a lis file. Murali=20 -----Original Message----- From: sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org=20 [mailto:sqr-users-bounces+murali.kaithi=3Dspencergifts.com@sqrug.org] On Behalf Of Hall, Tara Sent: Thursday, October 27, 2005 4:59 PM To: 'sqr-users@sqrug.org' Subject: [sqr-users] LIS file Greetings All, Can any one tell me why my SQR isn't creating a *.LIS file? Thanks, Tara L. Hall Business Systems Analyst Accounting Services "When I was a child, my mother said to me, 'If you become a soldier, you'll be a general. If you become a monk you'll end up as Pope.' Instead I became a painter and wound up as Picasso." - Pablo Picasso _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 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 Fri Oct 28 18:37:46 2005 From: "abhay sachar" Date: Fri, 28 Oct 2005 16:35:13 -0700 Subject: [sqr-users] Single quote issue Hi, I was wondering if anyone knows how to work with data that is being passed to an SQR through a run-control page and that data has a (') - single quote in it, which could be anywhere , for example - St Martin's Court What is the way to handle this kind of data, because when it builds the query - it bombs out with the error - ORA-01756: quoted string not properly terminated Any help is greatly appreciated. Thanks, Abhay _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 28 19:04:31 2005 From: "Alexander, Steve" Subject: RE: [sqr-users] Single quote issue Date: Fri, 28 Oct 2005 17:03:42 -0700 You have to replace the single quote with two single quotes. -----Original Message----- From: abhay sachar [mailto:sachar_abhay@hotmail.com] Sent: Friday, October 28, 2005 4:35 PM To: sqr-users@sqrug.org Subject: [sqr-users] Single quote issue Hi, I was wondering if anyone knows how to work with data that is being passed to an SQR through a run-control page and that data has a (') - single quote in it, which could be anywhere , for example - St Martin's Court What is the way to handle this kind of data, because when it builds the query - it bombs out with the error - ORA-01756: quoted string not properly terminated Any help is greatly appreciated. Thanks, Abhay _______________________________________________ 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 Fri Oct 28 19:15:12 2005 From: "abhay sachar" Subject: RE: [sqr-users] Single quote issue Date: Fri, 28 Oct 2005 17:13:08 -0700 Yes, I am aware of that. But that is for the query. But how about in SQR - I am assuming I would have to do a find and replace within the string. So is it that I would have to create a function that does that and use that function to change that run control param in the SQR? Thanks, Abhay >From: "Alexander, Steve" >Reply-To: "This list is for discussion about the SQR database >reportinglanguage from Hyperion Solutions." >To: "'This list is for discussion about the SQR database >reportinglanguagefrom Hyperion Solutions.'" >Subject: RE: [sqr-users] Single quote issue >Date: Fri, 28 Oct 2005 17:03:42 -0700 > >You have to replace the single quote with two single quotes. > >-----Original Message----- >From: abhay sachar [mailto:sachar_abhay@hotmail.com] >Sent: Friday, October 28, 2005 4:35 PM >To: sqr-users@sqrug.org >Subject: [sqr-users] Single quote issue > >Hi, > >I was wondering if anyone knows how to work with data that is being passed >to an SQR through a run-control page and that data has a (') - single quote >in it, which could be anywhere , for example - St Martin's Court > >What is the way to handle this kind of data, because when it builds the >query - it bombs out with the error - ORA-01756: quoted string not properly >terminated > >Any help is greatly appreciated. > >Thanks, >Abhay > > > >_______________________________________________ >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 Fri Oct 28 20:11:21 2005 Date: Fri, 28 Oct 2005 21:15:43 -0400 (EDT) Subject: RE: [sqr-users] Single quote issue From: "Sudeep Vaidya" You can take the value from the run control in a variable.Then use the Replace funtion to replace the single quote with a double quote. If replace doesn't work, then in the worst case, I would think of creating a function which would accept the string with single quotes,unstring it into 2 of more variables(Unstring function), then string them back with a double quote using the String function. Following text is from Peoplebooks. I can suggest you to look the SQR lang-ref. Best source of info on any SQR problem. REPLACE : Inspects the contents of source_value and replaces all occurrences of from_string with to_string and returns the modified string. Syntax: dst_var = replace(source_value, from_string, to_string) source_value = date or text literal, column, variable, or expression from_string = text literal, column, variable, or expression to_string = text literal, column, variable, or expression dst_var = text variable Example: let $replaced = replace($paragraph, 'good', 'excellent') > Yes, I am aware of that. But that is for the query. > > But how about in SQR - I am assuming I would have to do a find and replace > within the string. So is it that I would have to create a function that > does > that and use that function to change that run control param in the SQR? > > Thanks, > Abhay > >>From: "Alexander, Steve" >>Reply-To: "This list is for discussion about the SQR database >>reportinglanguage from Hyperion Solutions." >>To: "'This list is for discussion about the SQR database >>reportinglanguagefrom Hyperion Solutions.'" >>Subject: RE: [sqr-users] Single quote issue >>Date: Fri, 28 Oct 2005 17:03:42 -0700 >> >>You have to replace the single quote with two single quotes. >> >>-----Original Message----- >>From: abhay sachar [mailto:sachar_abhay@hotmail.com] >>Sent: Friday, October 28, 2005 4:35 PM >>To: sqr-users@sqrug.org >>Subject: [sqr-users] Single quote issue >> >>Hi, >> >>I was wondering if anyone knows how to work with data that is being >> passed >>to an SQR through a run-control page and that data has a (') - single >> quote >>in it, which could be anywhere , for example - St Martin's Court >> >>What is the way to handle this kind of data, because when it builds the >>query - it bombs out with the error - ORA-01756: quoted string not >> properly >>terminated >> >>Any help is greatly appreciated. >> >>Thanks, >>Abhay >> >> >> >>_______________________________________________ >>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 > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sat Oct 29 09:58:18 2005 Date: Sat, 29 Oct 2005 07:56:17 -0700 From: David Donnelly Subject: [sqr-users] Re: Single quote issue When I have this problem, I use a translate on all the input strings to translate the quote character ($27) to the reverse quote character ($B4). They look nearly the same, but Oracle doesn't recognize the latter as a quote. You'll also have to do it to data accepted for update before it goes into the database. This requires that you are using an appropriate 8-bit ASCII character set in the database, which most Oracle users do. This may not work if you have a character set for supporting an accented language; the B4 slot maybe used for something else. encode <180> into $revquote let $newstring = translate($original,'''',$revquote) _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 31 12:39:26 2005 Date: Mon, 31 Oct 2005 11:36:51 -0600 From: "Bob Stone" Subject: [sqr-users] dbms_mview.refresh - run procedure in SQR? Hi there. Question on how to use the DBMS_MVIEW.REFRESH procedure in SQR. I cannot s= eem to get this to work. When running other procedures in SQR, we usually do the following :=20 begin-SELECT=20 FASTENAL_OM.FAS_GET_OUTSIDE_SALES_EMPLID( $cust_in, $date_in ) &emplid let $emplid_back =3D &emplid FROM DUAL end-select but when I do that with the DBMS_MVIEW.REFRESH I get the following erro := =20 (SQR 5528) ORACLE OPARSE error -904 in cursor 2: ORA-00904: invalid column name SQL: select DBMS_MVIEW.REFRESH('PS_FAS_AR_AD_CU_MV','c') from dual=20 Error at: REFRESH('PS_FAS_AR_AD_CU_MV','c') Error on line 139: (SQR 3716) Error in SQL statement. Anybody have any idea how to run this procedure in an SQR? any help would = be greatly appreciated. Thanks Bob Stone=20=20 Fastenal PS AP Developer (507) 453-8514 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 31 14:10:26 2005 Subject: RE: [sqr-users] dbms_mview.refresh - run procedure in SQR? Date: Mon, 31 Oct 2005 13:07:58 -0600 From: "Bob Stone" Well, it seems someone in my company was able to point it out to me. For t= hose interested, you can call the stored procedure, but for whatever reason= you need 2 semi-colons, as shown below. begin-sql begin DBMS_MVIEW.REFRESH('PS_FAS_AR_AD_IN_MV','c') ;; end;; end-sql ...well, that mostly makes sense. Pretty intuitive, if you think about it.= ...wait, no. works tho. -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org]On Behalf Of Bob Stone Sent: Monday, October 31, 2005 11:37 AM To: This list is for discussion about the SQR database reporting language from Hyperion Solutions. Subject: [sqr-users] dbms_mview.refresh - run procedure in SQR? Hi there. Question on how to use the DBMS_MVIEW.REFRESH procedure in SQR. I cannot s= eem to get this to work. When running other procedures in SQR, we usually do the following :=20 begin-SELECT=20 FASTENAL_OM.FAS_GET_OUTSIDE_SALES_EMPLID( $cust_in, $date_in ) &emplid let $emplid_back =3D &emplid FROM DUAL end-select but when I do that with the DBMS_MVIEW.REFRESH I get the following erro := =20 (SQR 5528) ORACLE OPARSE error -904 in cursor 2: ORA-00904: invalid column name SQL: select DBMS_MVIEW.REFRESH('PS_FAS_AR_AD_CU_MV','c') from dual=20 Error at: REFRESH('PS_FAS_AR_AD_CU_MV','c') Error on line 139: (SQR 3716) Error in SQL statement. Anybody have any idea how to run this procedure in an SQR? any help would = be greatly appreciated. Thanks Bob Stone=20=20 Fastenal PS AP Developer (507) 453-8514 _______________________________________________ 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 Nov 01 00:02:15 2005 Date: Tue, 1 Nov 2005 00:00:02 -0500 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.22 $ $Date: 2005/08/19 05:12:40 $ 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 2004/03/04: o New name and URL for "HyperionSQR" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from 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. 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 Wed Nov 02 11:37:13 2005 From: "Wright, David L. II" Date: Wed, 2 Nov 2005 08:34:42 -0800 Subject: [sqr-users] Resetting the #page_count to 1 (one) Greetings, I am writing a report that breaks on a change in a Business Unit. I would like to reset the #page_count to 1 (one) for each new Business Unit that starts on a new page via the "On-Break" option of the print command. I've tried "let #page_count = 0" and "move 0 to #page_count" but neither works. Does anyone have (or know of) a solution for my little dilemma? Thanks in advance. Dave David L. Wright, II SAIC Sr. Technical Consultant, PeopleSoft E-mail: wrightdavidl@saic.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Nov 02 11:49:59 2005 From: "Paul Hoyte" Subject: RE: [sqr-users] Resetting the #page_count to 1 (one) Date: Wed, 2 Nov 2005 11:47:51 -0500 Hello Dave: Try resetting #page-count. The variable that you are using (#page_count) is a user variable while the #page-count is where sqr keeps track of the page number. Paul Hoyte (248) 752-6970 www.sharidionne.com pa_hoyte@si-proservices.com -----Original Message----- From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org [mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On Behalf Of Wright, David L. II Sent: Wednesday, November 02, 2005 11:35 AM To: 'sqr-users@sqrug.org' Subject: [sqr-users] Resetting the #page_count to 1 (one) Greetings, I am writing a report that breaks on a change in a Business Unit. I would like to reset the #page_count to 1 (one) for each new Business Unit that starts on a new page via the "On-Break" option of the print command. I've tried "let #page_count = 0" and "move 0 to #page_count" but neither works. Does anyone have (or know of) a solution for my little dilemma? Thanks in advance. Dave David L. Wright, II SAIC Sr. Technical Consultant, PeopleSoft E-mail: wrightdavidl@saic.com _______________________________________________ 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 Thu Nov 03 04:34:19 2005 Date: Thu, 3 Nov 2005 01:30:26 -0800 From: "Janakiraman, Vijayakumar" Subject: [sqr-users] PDF format in SQR. Hi All, I required to create a PDF file through SQR.Can any one help me to do this. Thanks, Vijayakumar.J _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Nov 03 07:02:42 2005 Date: Thu, 03 Nov 2005 05:59:52 -0600 From: "Hallmark, Robert J" Subject: RE: [sqr-users] PDF format in SQR. What version of SQR are you using? -----Original Message----- From: sqr-users-bounces+robert.j.hallmark=lmco.com@sqrug.org [mailto:sqr-users-bounces+robert.j.hallmark=lmco.com@sqrug.org] On Behalf Of Janakiraman, Vijayakumar Sent: Thursday, November 03, 2005 3:30 AM To: sqr-users@sqrug.org Subject: [sqr-users] PDF format in SQR. Hi All, I required to create a PDF file through SQR.Can any one help me to do this. Thanks, Vijayakumar.J _______________________________________________ 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 Thu Nov 03 07:31:39 2005 Subject: RE: [sqr-users] PDF format in SQR. Date: Thu, 3 Nov 2005 07:23:28 -0500 From: "Bob Buford" Hi, You would use the command line flag -PRINT:PD. Printing through PeopleSoft, you would set output type to File, output format to Adobe or PDF in the Process Request Dialog, if working in PeopleTools 8.x. In PeopleTools 7.x, put in the process definition command flags line the following: -PRINT::PD (note, we found that two colons were needed for proper reading of the command in execution ) -----Original Message----- From: Janakiraman, Vijayakumar [mailto:vijayakumar.janakiraman@cingular.com]=20 Sent: Thursday, November 03, 2005 4:30 AM To: sqr-users@sqrug.org Subject: [sqr-users] PDF format in SQR. Hi All, I required to create a PDF file through SQR.Can any one help me to do this. Thanks, Vijayakumar.J _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Nov 03 07:06:27 2005 From: Ravindran Rajan Date: Thu, 3 Nov 2005 17:25:49 +0530 Subject: [sqr-users] Integration of .NET with SQR Hi All, I am using .NET application and using SQR for reporting.. I want to know how i need to intergrate applicaton with SQR.. I heard about Hyperion Objects will help to do so... so I want to know abt the details abt Integration... Thanks in Advance. Regards, Ravindran. ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Nov 03 10:05:13 2005 Subject: Re: [sqr-users] Integration of .NET with SQR Date: Thu, 3 Nov 2005 15:03:21 -0000 From: Hi Ravindran, I just call command line SQR from VB.NET. (Note that your SQR must have been debugged and have the correct command line parameters) For heavy duty DB retrieval I use SQR and for small stuff the set up in VB is easier. John Willson http://www.dssltd.com/ Ravindran Rajan said: > Hi All, > I am using .NET application and using SQR for reporting.. I want > to know how i need to intergrate applicaton with SQR.. > I heard about Hyperion Objects will help to do so... so I want to > know abt the details abt Integration... > > Thanks in Advance. > > Regards, > Ravindran. > > ______________________________________________________________________ > > _______________________________________________ > 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 Thu Nov 03 09:54:24 2005 From: JOHN_HARRIS@qvc.com Date: Thu, 3 Nov 2005 09:51:39 -0500 Subject: [sqr-users] Suppress printing for detail lines but not for summary lines This is a multi-part message in MIME format... --0__=0ABBFA3DDFC2B9C78f9e8a93df938690918c0ABBFA3DDFC2B9C7 Content-type: text/plain; charset=US-ASCII I am trying to print only the totals for each break in my report. I tried using the NOP print attribute, but this has adverse effects on my ON-BREAK logic. Is there another way to do this? Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic03788.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. --0__=0ABBFA3DDFC2B9C78f9e8a93df938690918c0ABBFA3DDFC2B9C7 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/jpeg' MIME type. It has been automatically discarded before sending the message to the list. --0__=0ABBFA3DDFC2B9C78f9e8a93df938690918c0ABBFA3DDFC2B9C7 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --0__=0ABBFA3DDFC2B9C78f9e8a93df938690918c0ABBFA3DDFC2B9C7-- From sqr-users-bounces@sqrug.org Fri Nov 04 13:18:09 2005 From: "Paul Hoyte" Subject: RE: [sqr-users] Suppress printing for detail lines but not for summarylines Date: Fri, 4 Nov 2005 10:29:09 -0500 You didn't say if you were printing the detail lines as well, so lets assume that you are just interested in printing the total lines for each break. You can set the query up to produce only the total for each break and then print them. Or you can use the multiple report option and produce the detail in one report and then just write out the summary lines in the other. Or you could use an if statement to determine when to print the detail/summary lines. Paul Hoyte (248) 752-6970 www.sharidionne.com pa_hoyte@si-proservices.com -----Original Message----- From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org [mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On Behalf Of JOHN_HARRIS@qvc.com Sent: Thursday, November 03, 2005 9:52 AM To: sqr-users@sqrug.org Cc: darrin.miller@1answersolutions.com Subject: [sqr-users] Suppress printing for detail lines but not for summarylines I am trying to print only the totals for each break in my report. I tried using the NOP print attribute, but this has adverse effects on my ON-BREAK logic. Is there another way to do this? Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic03788.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Nov 07 13:12:45 2005 From: "Steve Cavill" Subject: RE: [sqr-users] Suppress printing for detail lines but not for summarylines Date: Mon, 7 Nov 2005 17:35:42 +1100 Just don't specify a print position for the fields you don't want printed. 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 JOHN_HARRIS@qvc.com Sent: Friday, 4 November 2005 1:52 AM To: sqr-users@sqrug.org Cc: darrin.miller@1answersolutions.com Subject: [sqr-users] Suppress printing for detail lines but not for summarylines I am trying to print only the totals for each break in my report. I tried using the NOP print attribute, but this has adverse effects on my ON-BREAK logic. Is there another way to do this? Thank you. Regards, John (Embedded image moved John Harris to file: Programmer/Analyst pic03788.jpg) Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the inform