From sqr-users-bounces@sqrug.org Sun Oct 01 00:02:21 2006 Date: Sun, 1 Oct 2006 00:00:03 -0400 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.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 2005/08/19: o Added note about spam filtering and sender verification systems blocking subscription confirmation messages. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.org/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2004 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. HyperionSQR : Hyperion- SQR List for discussion of SQR, SQR Developer (formerly called Brio.Report and Report Builder), and SQR iServer. To join, follow the link above, or send any message to "HyperionSQR- subscribe@yahoogroups.com". rm-users : Report- Mart Users List for discussion of Brio Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. Many sites are now implementing spam filtering and/or sender verification systems, which can prevent your confirmation message from getting delivered to you. You may need check for a message from "sqr- users-request[-AT-]sqrug.org" caught in the filter, or add that address to your list of authorized senders, in order to complete the confirmation process. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. If you use digests, you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list as other subscribers' mail systems repond....) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQR product name and version number (see notes below) o Operating system name and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 02 05:32:35 2006 Subject: RE: [sqr-users] Re: DUAL table: String2Em: String to Decimal ObjectConversion Error Date: Mon, 2 Oct 2006 05:28:22 -0400 From: "Peter Burton" All, The problem here is that Oracle 9.2.0.3 changed they way they return numerical values without specifying a scale. SQR Server 8.1 was modified to handle both the old and new mechanisms. Oracle provided a work-around -- alter system set event=3D'10499 trace name context forever,level 1'=20 COMMENT=3D'return 0 for the scale if NUMBER created without specifying the scale' SCOPE=3DSPFILE but that fix will not work in Oracle 10g -- this was by design from Oracle. Therefore, you need to upgrade you version of SQR Server to at least 8.1 or always return a character and then have SQR convert it a number before you use it. Peter -----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 Nathan Stratton Treadway Sent: Friday, September 29, 2006 10:02 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: [sqr-users] Re: DUAL table: String2Em: String to Decimal ObjectConversion Error On Wed, Sep 27, 2006 at 03:34:35PM -0300, April Wells wrote: > I keep getting the above error ((SQR 6806) String2Em: String to Decimal=20 > Object Conversion Error.) > when I select from DUAL. We've recently migrated our databases from Oracle=20 > 8 to 10G which I know causes this error, and I was able to fix the error in=20 > my main SQR programs in a normal select (by putting a TO_CHAR around=20 > numeric fields with no scale), but I can't seem to resolve this error when=20 > selecting from the DUAL table. > ie. >=20 > .... > $seq_type =3D ID_SEQ.NEXTVAL >=20 > BEGIN-SELECT ON-ERROR=3Dfatal_error > [$seq_type] &new_seq=3DNUMBER > FROM DUAL > END-SELECT >=20 > .... > (SQR 6806) String2Em: String to Decimal Object Conversion Error. >=20 > Any suggestions greatly appreciated! You don't mention exactly what different approaches you tried, or if you really are doing something "fancy" that would require the use of dynamic SQL as you show here... so I'll just stick to the "simple" answer: when I have been using SQR v6.2 against Oracle 9i, I was able to use the following code to read from a sequence: begin-select round(ID_SEQ.NEXTVAL) &new_seq from dual end-select Note in particular that if you use ROUND() instead of TO_CHAR(), the value returned by Oracle will be of a numeric datatype rather than character, so you don't need to say "=3DNUMBER" in the SQR. (Actually, if you tried to assign the result of a TO_CHAR() into "&new_seq=3DNUMBER", I assume you got a type-mismatch error from SQR anyway.) If you do actually need to use dynamic SQL for some reason, you should be able to do so by just moving the ROUND() expression into the dynamic portion. In any case, this error is caused by the datatype of the column or expression that's being selected; the fact that you are selection from DUAL instead of some other table shouldn't matter. Hope that helps. Nathan ------------------------------------------------------------------------ ---- Nathan Stratton Treadway - nathanst@ontko.com - Mid-Atlantic region Ray Ontko & Co. - Software consulting services - http://www.ontko.com/ GPG Key: http://www.ontko.com/~nathanst/gpg_key.txt ID: 1023D/ECFB6239 Key fingerprint =3D 6AD8 485E 20B9 5C71 231C 0C32 15F3 ADCD ECFB 6239 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users If you have received this e-mail in error, please delete it and notify the = sender as soon as possible. The contents of this e-mail may be confidential= and the unauthorized use, copying, or dissemination of it and any attachme= nts to it, is prohibited. Internet communications are not secure and Hyperi= on does not, therefore, accept legal responsibility for the contents of thi= s message nor for any damage caused by viruses. The views expressed here do= not necessarily represent those of Hyperion. For more information about Hy= perion, please visit our Web site at: www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 02 14:36:44 2006 Date: Mon, 2 Oct 2006 14:34:21 -0400 From: Nathan Stratton Treadway Subject: [sqr-users] Re: DUAL table: String2Em: String to Decimal ObjectConversion Error On Mon, Oct 02, 2006 at 05:28:22AM -0400, Peter Burton wrote: > The problem here is that Oracle 9.2.0.3 changed they way they return > numerical values without specifying a scale. SQR Server 8.1 was [...] > Therefore, you need to upgrade you version of SQR Server to at least 8.1 > or always return a character and then have SQR convert it a number > before you use it. At the client site where I ran into this problem they did end up implementing the "event 10499" fix eventually (and they will have upgraded to SQR v8.x before they move to Oracle v10.x.) -- and thus I no longer need to use source-code changes to work around the String2Em error, and don't have an environment in which I can test the long-term operation of such changes. However, while I was waiting for the EVENT fix to be implemented, I was able to get the SQR programs to work again against the Oracle 9 instances by using ROUND() on the columns/expressions that were producing the error. This seems to work by specifying an explict scale for the expression, which avoids the "unspecified-scale" situation that triggers the problem. I can certainly see how using TO_CHAR() would also avoid the error, but I'm wondering if you know of any specific situations where the ROUND() workaround would fail and _only_ TO_CHAR() would work? Thanks. Nathan ---------------------------------------------------------------------------- Nathan Stratton Treadway - nathanst@ontko.com - Mid-Atlantic region Ray Ontko & Co. - Software consulting services - http://www.ontko.com/ GPG Key: http://www.ontko.com/~nathanst/gpg_key.txt ID: 1023D/ECFB6239 Key fingerprint = 6AD8 485E 20B9 5C71 231C 0C32 15F3 ADCD ECFB 6239 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 11:01:29 2006 Date: Wed, 04 Oct 2006 11:58:27 -0300 From: "PeterG Clark" Subject: [sqr-users] Number to Character Hi folks, Normally, this would be the sort of thing I would like to play with until I= got it working, but I am pressed for time and turning to the tremendous kn= owledge base on this list :-) I have a Number(25) field on a table (Oracle) that I know will never contai= n more than three significant digits (i.e. 999) and I need to get it into a= 3 character field on a flatfile ... i.e. if the column contains 7, I need = to put 007 in the flatfile field, if it contains 29, I need 029 to be in th= e flatfile field, 0 needs to be 000, 567 needs to be 567, etc. Anything I've tried with edits, to_char's, pads and trims isn't working ...= or at least I am not hitting the right combination. Thanks in advance. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 11:15:17 2006 From: "Don Duwe" Subject: RE: [sqr-users] Number to Character Date: Wed, 4 Oct 2006 11:11:16 -0400 MOVE ?? TO $?? 999 -----Original Message----- From: sqr-users-bounces+dduwe=nookind.com@sqrug.org [mailto:sqr-users-bounces+dduwe=nookind.com@sqrug.org]On Behalf Of PeterG Clark Sent: Wednesday, October 04, 2006 10:58 AM To: sqr-users@sqrug.org Subject: [sqr-users] Number to Character Hi folks, Normally, this would be the sort of thing I would like to play with until I got it working, but I am pressed for time and turning to the tremendous knowledge base on this list :-) I have a Number(25) field on a table (Oracle) that I know will never contain more than three significant digits (i.e. 999) and I need to get it into a 3 character field on a flatfile ... i.e. if the column contains 7, I need to put 007 in the flatfile field, if it contains 29, I need 029 to be in the flatfile field, 0 needs to be 000, 567 needs to be 567, etc. Anything I've tried with edits, to_char's, pads and trims isn't working ... or at least I am not hitting the right combination. Thanks in advance. _______________________________________________ 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 04 11:24:59 2006 Subject: RE: [sqr-users] Number to Character Date: Wed, 4 Oct 2006 11:12:56 -0400 From: "Kaithi, Murali" Move #variable to $variable 099=20 Murali -----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 PeterG Clark Sent: Wednesday, October 04, 2006 10:58 AM To: sqr-users@sqrug.org Subject: [sqr-users] Number to Character Hi folks, Normally, this would be the sort of thing I would like to play with until I got it working, but I am pressed for time and turning to the tremendous knowledge base on this list :-) I have a Number(25) field on a table (Oracle) that I know will never contain more than three significant digits (i.e. 999) and I need to get it into a 3 character field on a flatfile ... i.e. if the column contains 7, I need to put 007 in the flatfile field, if it contains 29, I need 029 to be in the flatfile field, 0 needs to be 000, 567 needs to be 567, etc. Anything I've tried with edits, to_char's, pads and trims isn't working ... or at least I am not hitting the right combination. Thanks in advance. _______________________________________________ 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 Wed Oct 04 11:20:21 2006 Subject: RE: [sqr-users] Number to Character Date: Wed, 4 Oct 2006 08:15:53 -0700 From: "Janakiraman, Vijayakumar" Hi, You can perform this through oracle sql. select lpad(to_char(),3,'0') from dual Substitute the number and run the query.=20 Thanks, Vijayakumar.J Desk:469-229-7465 -----Original Message----- From: sqr-users-bounces+vijayakumar.janakiraman=3Dcingular.com@sqrug.org [mailto:sqr-users-bounces+vijayakumar.janakiraman=3Dcingular.com@sqrug.org ] On Behalf Of Don Duwe Sent: Wednesday, October 04, 2006 10:11 AM To: SQR USERS Subject: RE: [sqr-users] Number to Character MOVE ?? TO $?? 999 -----Original Message----- From: sqr-users-bounces+dduwe=3Dnookind.com@sqrug.org [mailto:sqr-users-bounces+dduwe=3Dnookind.com@sqrug.org]On Behalf Of PeterG Clark Sent: Wednesday, October 04, 2006 10:58 AM To: sqr-users@sqrug.org Subject: [sqr-users] Number to Character Hi folks, Normally, this would be the sort of thing I would like to play with until I got it working, but I am pressed for time and turning to the tremendous knowledge base on this list :-) I have a Number(25) field on a table (Oracle) that I know will never contain more than three significant digits (i.e. 999) and I need to get it into a 3 character field on a flatfile ... i.e. if the column contains 7, I need to put 007 in the flatfile field, if it contains 29, I need 029 to be in the flatfile field, 0 needs to be 000, 567 needs to be 567, etc. Anything I've tried with edits, to_char's, pads and trims isn't working ... or at least I am not hitting the right combination. Thanks in advance. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 13:52:25 2006 Date: Wed, 4 Oct 2006 15:19:33 -0230 From: "Ryan, David" Subject: [sqr-users] SQR User Guide Folks, =20 I've just joined this group, and I've noticed various references to the 'SQR3 User Guide'. I user SQR for PeopleSoft, and have been referencing the documentation provided with PeopleBooks, but would like some additional documentation. Does anyone know where I can obtain a copy of the SQR User Guide.. =20 many thanks, =20 David The information contained in this email is strictly confidential and subjec= t to the Confidentiality Notice at http://www.stratosglobal.com/email-priva= cy.html _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 13:59:36 2006 Subject: Re: [sqr-users] SQR User Guide From: Roger.Harris@certegy.com Date: Wed, 4 Oct 2006 13:56:38 -0400 Here is the link to Hyperion's tech docs. SQR is near the bottom of the page. http://dev.hyperion.com/resource_library/technical_documentation/ Roger L. Harris Programmer Analyst Sr Product Development Certegy Check Services Fidelity National Information Services, Inc 11601 N. Roosevelt Blvd St Petersburg, FL 33716 (727) 227-5850 direct (800) 215-6280 x75850 toll free (727) 570-4917 Fax |---------+----------------------------------------------------> | | "Ryan, David" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=certegy.co| | | m@sqrug.org | | | | | | | | | 10/04/2006 03:19 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] SQR User Guide | >---------------------------------------------------------------------------------------------| Folks, I've just joined this group, and I've noticed various references to the 'SQR3 User Guide'. I user SQR for PeopleSoft, and have been referencing the documentation provided with PeopleBooks, but would like some additional documentation. Does anyone know where I can obtain a copy of the SQR User Guide.. many thanks, David The information contained in this email is strictly confidential and subject to the Confidentiality Notice at http://www.stratosglobal.com/email-privacy.html _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. ============================================================================== _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 14:32:22 2006 Subject: RE: [sqr-users] Number to Character Date: Wed, 4 Oct 2006 14:29:25 -0400 From: "Violet Martin" This code comes directly from a flat file I am creating: Let $GPA =3D EDIT((&HS.EXT_GPA*100),'0000') Violet Martin -----Original Message----- From: sqr-users-bounces+vmartin=3Dvccs.edu@sqrug.org [mailto:sqr-users-bounces+vmartin=3Dvccs.edu@sqrug.org] On Behalf Of PeterG Clark Sent: Wednesday, October 04, 2006 10:58 AM To: sqr-users@sqrug.org Subject: [sqr-users] Number to Character Hi folks, Normally, this would be the sort of thing I would like to play with until I got it working, but I am pressed for time and turning to the tremendous knowledge base on this list :-) I have a Number(25) field on a table (Oracle) that I know will never contain more than three significant digits (i.e. 999) and I need to get it into a 3 character field on a flatfile ... i.e. if the column contains 7, I need to put 007 in the flatfile field, if it contains 29, I need 029 to be in the flatfile field, 0 needs to be 000, 567 needs to be 567, etc. Anything I've tried with edits, to_char's, pads and trims isn't working ... or at least I am not hitting the right combination. Thanks in advance. _______________________________________________ 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 04 14:50:29 2006 Date: Wed, 4 Oct 2006 16:17:51 -0230 From: "Ryan, David" Subject: [sqr-users] Reading from a tab delimited file Hello, =20 I'm trying to read from a tab delimited .txt file and insert values into variables. I do not now know what the length of each field within the file is. Could someone provide an example that would allow me to=20 start at the beginning of a line, read from the beginning to the first tab, insert into a variable; read from the first tab to second tab, insert into a variable.....and so on... =20 thanks =20 =20 The information contained in this email is strictly confidential and subjec= t to the Confidentiality Notice at http://www.stratosglobal.com/email-priva= cy.html _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 04 14:57:41 2006 Subject: RE: [sqr-users] Reading from a tab delimited file Date: Wed, 4 Oct 2006 14:54:53 -0400 From: "Overcashier, Patricia" Her is the code. I read int the file and unstring it by the tab into variableks.=20=20 encode <09> into $tab open 'MasterMatch.TXT' as 1 for-reading record=3D1500 status=3D#filestat ! read 1 into $in_rec:1500 status=3D#filestat =20 unstring $in_rec by $tab into $EmplId $Last_Name $Location $Empl_Type $Email_Addr -----Original Message----- From: sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org [mailto:sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org] On Behalf Of Ryan, David Sent: Wednesday, October 04, 2006 2:48 PM To: sqr-users@sqrug.org Subject: [sqr-users] Reading from a tab delimited file Hello, =20 I'm trying to read from a tab delimited .txt file and insert values into variables. I do not now know what the length of each field within the file is. Could someone provide an example that would allow me to=20 start at the beginning of a line, read from the beginning to the first tab, insert into a variable; read from the first tab to second tab, insert into a variable.....and so on... =20 thanks =20 =20 The information contained in this email is strictly confidential and subject to the Confidentiality Notice at http://www.stratosglobal.com/email-privacy.html _______________________________________________ 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 04 15:03:52 2006 Subject: RE: [sqr-users] Reading from a tab delimited file Date: Wed, 4 Oct 2006 14:00:56 -0500 From: "Aguirre, Jose" 1-First open the file: !----------------------------------------------------------------------! ! Procedure: Open-Flat-File ! ! Desc: This procedure opens the file that will be read from. ! !----------------------------------------------------------------------! begin-procedure Open-Flat-File DISPLAY ' Open-Flat-File ' =09 let $newfile =3D 'folder_path\file.txt' open $newfile as 1 for-reading record=3D700:vary status=3D#secondfile if #secondfile !=3D 0 let $error_lit =3D 'error opening file' display $error_lit (0,+2) display $file () else let $file_open =3D 'Y' display 'successful opening file' end-if=20=20=20=20=20 END-PROCEDURE=20=20 2- Extract the data: !----------------------------------------------------------------------! ! Procedure: Extract-Row ! ! Desc: This procedure reads the data from the flat file. ! !----------------------------------------------------------------------! begin-procedure Extract-Row =20=20 DISPLAY ' Extract-Row ' while not #end-file let $RecordData =3D ' ' read 1 into $RecordData:500 Let $RecordData =3D ltrim(rtrim($RecordData,' '),' ') let #space =3D instr($RecordData,' ',1)=20=20=20=20 extract $var1 from $RecordData 0 5 (position and char. Length) extract $var2 from $RecordData 11 6 extract $var3 from $RecordData 20 5=20=20=20 =20=20=20=20 Let $var1 =3D ltrim(rtrim($var1,' '),' ') Let $var2 =3D ltrim(rtrim($2,' '),' ') Let $var3 =3D ltrim(rtrim($var3,' '),' ')......and so on. DISPLAY ' END-Extract-Row ' end-procedure Good luck, Jos=E9 A. Aguirre -----Original Message----- From: sqr-users-bounces+jaguir=3Dlsuhsc.edu@sqrug.org [mailto:sqr-users-bou= nces+jaguir=3Dlsuhsc.edu@sqrug.org] On Behalf Of Ryan, David Sent: Wednesday, October 04, 2006 1:48 PM To: sqr-users@sqrug.org Subject: [sqr-users] Reading from a tab delimited file Hello, =20 I'm trying to read from a tab delimited .txt file and insert values into va= riables. I do not now know what the length of each field within the file is. Could someone provide an example that would allow me to start at the beginn= ing of a line, read from the beginning to the first tab, insert into a vari= able; read from the first tab to second tab, insert into a variable.....and= so on... =20 thanks =20 =20 The information contained in this email is strictly confidential and subjec= t to the Confidentiality Notice at http://www.stratosglobal.com/email-priva= cy.html _______________________________________________ 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 06 10:38:52 2006 Date: Fri, 6 Oct 2006 09:36:03 -0500 From: "Bob Helm" Subject: [sqr-users] barcode limits - sqr6 If I understand barcodes in sqr, there is a limit of 30 characters that can= be encoded into a barcode.=20 Is this correct, or can I fit a lot more data into a barcode? Thanks for any info, Bob Mediware Information Systems, Inc. Medication Management Division bob.helm@mediware.com This message (including any attachments) constitutes a confidential communi= cation and/or contains confidential information intended for a specific ind= ividual and purpose, and is protected by law. If you are not the intended= recipient, please notify the sender by return email and delete this messag= e and any attachments. Any disclosure, copying, or distribution of this me= ssage, or the taking of any action based on it, is strictly prohibited. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 06 10:47:47 2006 Subject: RE: [sqr-users] barcode limits - sqr6 Date: Fri, 6 Oct 2006 09:45:33 -0500 From: "Knapp, Richard" It depends on the type of barcode but 30 characters is the upper limit for all types in the 4.3 documentation. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Bob Helm Sent: Friday, October 06, 2006 9:36 AM To: SQR Users (E-mail) Subject: [sqr-users] barcode limits - sqr6 If I understand barcodes in sqr, there is a limit of 30 characters that can be encoded into a barcode.=20 Is this correct, or can I fit a lot more data into a barcode? Thanks for any info, Bob Mediware Information Systems, Inc. Medication Management Division bob.helm@mediware.com This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. _______________________________________________ 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 06 11:10:19 2006 Date: Fri, 06 Oct 2006 11:07:59 -0400 From: Donald Mellen Subject: Re: [sqr-users] barcode limits - sqr6 Yes, in SQR 6.x, 30 characters is the upper limit for the following barcodes ... 3 of 9 (code 39) Extended 3 of 9 Interleaved 2 of 5 Code 128 Codabar MSI Plessey Code 93 Extended 93 HIBC these limits were raised to 100 in sqr 8.2 HTH, Don Bob Helm wrote: > If I understand barcodes in sqr, there is a limit of 30 characters that can be encoded into a barcode. > Is this correct, or can I fit a lot more data into a barcode? > > Thanks for any info, > Bob > > > > Mediware Information Systems, Inc. > Medication Management Division > bob.helm@mediware.com > > This message (including any attachments) constitutes a confidential communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > -- ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 11:28:54 2006 Date: Mon, 9 Oct 2006 08:26:10 -0700 (PDT) From: sagar minn Subject: [sqr-users] printing Landscape Legal size paper Hi, I'm trying to print to Legal Size paper in landscape. But unalbe to do so. I'm using sqr 8.2 nd trying to print to HP laser printer. Any help is greatly appreciated. Thanks Sagar --------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 11:41:45 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 10:39:09 -0500 From: "Aguirre, Jose" I have not seen an .SQC with Legal size settings - but you could append -ZI= V in the SQR flag in the process definition options panel/page. This way -= SQR VIEWER will be invoked in order to print the format desired. Jos=E9 A. Aguirre -----Original Message----- From: sqr-users-bounces+jaguir=3Dlsuhsc.edu@sqrug.org [mailto:sqr-users-bou= nces+jaguir=3Dlsuhsc.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 10:26 AM To: sqr-users@sqrug.org Subject: [sqr-users] printing Landscape Legal size paper Hi, =20=20=20 I'm trying to print to Legal Size paper in landscape. But unalbe to do so= . I'm using sqr 8.2 nd trying to print to HP laser printer. Any help is gre= atly appreciated. Thanks =20=20=20 Sagar =20=09=09 --------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out.=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 11:47:13 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 10:44:50 -0500 From: "Knapp, Richard" Or you could prepend the printer control sequences that select the legal pa= per tray to your text document if you are _NOT_ printing from a windows env= ironment. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-b= ounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Aguirre, Jose Sent: Monday, October 09, 2006 10:39 AM To: This list is for discussion about the SQR database reportinglanguage fr= omHyperion Solutions. Subject: RE: [sqr-users] printing Landscape Legal size paper I have not seen an .SQC with Legal size settings - but you could append -ZI= V in the SQR flag in the process definition options panel/page. This way -= SQR VIEWER will be invoked in order to print the format desired. Jos=E9 A. Aguirre -----Original Message----- From: sqr-users-bounces+jaguir=3Dlsuhsc.edu@sqrug.org [mailto:sqr-users-bou= nces+jaguir=3Dlsuhsc.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 10:26 AM To: sqr-users@sqrug.org Subject: [sqr-users] printing Landscape Legal size paper Hi, =20=20=20 I'm trying to print to Legal Size paper in landscape. But unalbe to do so= . I'm using sqr 8.2 nd trying to print to HP laser printer. Any help is gre= atly appreciated. Thanks =20=20=20 Sagar =20=09=09 --------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out.=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 11:58:47 2006 Date: Mon, 9 Oct 2006 08:55:52 -0700 (PDT) From: sagar minn Subject: RE: [sqr-users] printing Landscape Legal size paper I'm using the following script in my code and I'm using unix declare-layout landscape2 paper-size= (8.5,14,legal) orientation = landscape top-margin = 0.2 bottom-margin = 0.05 left-margin = 0.25 max-columns = 260 char-width = 4.32 line-height = 10 end-declare but somehow when I run it the pdf report generated is still in portrait and letter. Is there any default settings which must be overwritten. Thanks Vinil Vinil --------------------------------- How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 12:03:42 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 11:01:16 -0500 From: "Knapp, Richard" Sorry. I thought you were trying to get the printer to print legal landscape. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 10:56 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] printing Landscape Legal size paper I'm using the following script in my code and I'm using unix declare-layout landscape2 paper-size=3D (8.5,14,legal) orientation =3D landscape top-margin =3D 0.2 bottom-margin =3D 0.05 left-margin =3D 0.25 max-columns =3D 260 char-width =3D 4.32 line-height =3D 10 end-declare but somehow when I run it the pdf report generated is still in portrait and letter. Is there any default settings which must be overwritten. =20=20=20 Thanks =20=20=20 Vinil =20=20=20 Vinil =20=09=09 --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 13:20:12 2006 Date: Mon, 9 Oct 2006 10:17:32 -0700 (PDT) From: sagar minn Subject: RE: [sqr-users] printing Landscape Legal size paper Hi Richard, Sorry for confusing you and everyone else. I'm actually trying to get the printer to print legal landscape. Can you send me an example script for the printer control sequences Thanks Sagar --------------------------------- How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 15:14:55 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 14:12:43 -0500 From: "Knapp, Richard" Sagar, I looked but could not find an example although I have done this myself. My contribution has been wiped from the collective memory. How quickly they forget. As long as your printer is an HP or speaks HP Printer Control Language (many do) and you are not printing via a windows machine, you can begin your document with PCL control sequences. You can look these up on the HP web site. They allow you to control any of the features the printer(s) support. All sequences employ the escape character which you can encode with chr(27). Everything else in the sequence must be verbatim as it appears in the HP documentation - caps are caps, etc.. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 12:18 PM To: sqr users Subject: RE: [sqr-users] printing Landscape Legal size paper Hi Richard, =20=20=20 Sorry for confusing you and everyone else. =20=20=20 I'm actually trying to get the printer to print legal landscape. =20=20=20 Can you send me an example script for the printer control sequences=20 Thanks =20=20=20 Sagar =20=09=09 --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 15:22:21 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 14:19:36 -0500 From: "Bob Helm" I think this would work... In some kind of initialization procedure: encode '<27>&l3A' into $legal_size Then let it be the very first thing you print: print $legal_size (1,1) HTH, Bob -----Original Message----- From: sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org [mailto:sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org]On Behalf Of Knapp, Richard Sent: Monday, October 09, 2006 2:13 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] printing Landscape Legal size paper Sagar, I looked but could not find an example although I have done this myself. My contribution has been wiped from the collective memory. How quickly they forget. As long as your printer is an HP or speaks HP Printer Control Language (many do) and you are not printing via a windows machine, you can begin your document with PCL control sequences. You can look these up on the HP web site. They allow you to control any of the features the printer(s) support. All sequences employ the escape character which you can encode with chr(27). Everything else in the sequence must be verbatim as it appears in the HP documentation - caps are caps, etc.. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 12:18 PM To: sqr users Subject: RE: [sqr-users] printing Landscape Legal size paper Hi Richard, =20=20=20 Sorry for confusing you and everyone else. =20=20=20 I'm actually trying to get the printer to print legal landscape. =20=20=20 Can you send me an example script for the printer control sequences=20 Thanks =20=20=20 Sagar =20=09=09 --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. _______________________________________________ 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 Mon Oct 09 15:26:15 2006 Subject: RE: [sqr-users] printing Landscape Legal size paper Date: Mon, 9 Oct 2006 12:22:06 -0700 From: "McCown, Larry" Below is the code I use for landscape. Not sure if you could just change the Paper-size to (11, 14) for legal? Hope this helps Larry begin-setup DECLARE-LAYOUT DEFAULT PAPER-SIZE =3D (11, 8.5) ORIENTATION =3D LANDSCAPE LEFT-MARGIN =3D 0.25 TOP-MARGIN =3D 0.50 RIGHT-MARGIN =3D 0.05=20=20 bottom-margin =3D 0.05=20 END-DECLARE DECLARE-PRINTER HPLASERJET TYPE =3D HPLASERJET=20=20=20=20 POINT-SIZE =3D 6 END-DECLARE Declare-Image LOGO=20 TYPE =3D BMP-FILE SOURCE =3D 'f:\sqr4\LOGO.BMP' IMAGE-SIZE =3D (25,3)=20 END-DECLARE #DEFINE WIDTH 156 #DEFINE HEADLINERS 5 #DEFINE FOOTLINES 5 !#sqr-max-lines=20 end-setup -----Original Message----- From: sqr-users-bounces+larry.mccown=3Dngc.com@sqrug.org [mailto:sqr-users-bounces+larry.mccown=3Dngc.com@sqrug.org] On Behalf Of Knapp, Richard Sent: Monday, October 09, 2006 12:13 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] printing Landscape Legal size paper Sagar, I looked but could not find an example although I have done this myself. My contribution has been wiped from the collective memory. How quickly they forget. As long as your printer is an HP or speaks HP Printer Control Language (many do) and you are not printing via a windows machine, you can begin your document with PCL control sequences. You can look these up on the HP web site. They allow you to control any of the features the printer(s) support. All sequences employ the escape character which you can encode with chr(27). Everything else in the sequence must be verbatim as it appears in the HP documentation - caps are caps, etc.. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of sagar minn Sent: Monday, October 09, 2006 12:18 PM To: sqr users Subject: RE: [sqr-users] printing Landscape Legal size paper Hi Richard, =20=20=20 Sorry for confusing you and everyone else. =20=20=20 I'm actually trying to get the printer to print legal landscape. =20=20=20 Can you send me an example script for the printer control sequences Thanks =20=20=20 Sagar =20=09=09 --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. _______________________________________________ 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 Mon Oct 09 17:13:27 2006 Date: Mon, 9 Oct 2006 17:10:31 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Invoking dos commands thru sqr Hi All, Iam trying to use a dos sort command in sqr. it shud sort the file a= nd redirect the output to another file. I tried but its not working for me. Let $cmd_sort =3D 'Sort /+16 ' || $file1 || '>' || $file2 Iam not getting any error msg. The file is not sorted and iam not getting a= ny sorted output file. Please help Thanks Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 17:27:56 2006 Subject: RE: [sqr-users] Invoking dos commands thru sqr Date: Mon, 9 Oct 2006 16:25:48 -0500 From: "Knapp, Richard" Invoke the command interpreter with the /C flag so let $cmd =3D cmd /C ... (your commands) Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 09, 2006 4:11 PM To: sqr-users@sqrug.org Subject: [sqr-users] Invoking dos commands thru sqr Hi All, Iam trying to use a dos sort command in sqr. it shud sort the file and redirect the output to another file. I tried but its not working for me. Let $cmd_sort =3D 'Sort /+16 ' || $file1 || '>' || $file2 Iam not getting any error msg. The file is not sorted and iam not getting any sorted output file. Please help Thanks Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 09 17:47:54 2006 Subject: RE: [sqr-users] Invoking dos commands thru sqr Date: Mon, 9 Oct 2006 17:45:08 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" I tried that also now its putting a blank sorted file..There is no data in = the second file.. Let $cmd =3D '/C Sort /+16 ' || $file1 || '>' || $file2 -----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 Knapp, Richard Sent: Monday, October 09, 2006 5:26 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Invoking dos commands thru sqr Invoke the command interpreter with the /C flag so let $cmd =3D cmd /C ... (your commands) Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 09, 2006 4:11 PM To: sqr-users@sqrug.org Subject: [sqr-users] Invoking dos commands thru sqr Hi All, Iam trying to use a dos sort command in sqr. it shud sort the file and redirect the output to another file. I tried but its not working for me. Let $cmd_sort =3D 'Sort /+16 ' || $file1 || '>' || $file2 Iam not getting any error msg. The file is not sorted and iam not getting any sorted output file. Please help Thanks Ram _______________________________________________ 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 Mon Oct 09 21:13:56 2006 Subject: RE: [sqr-users] Invoking dos commands thru sqr Date: Mon, 9 Oct 2006 20:11:06 -0500 From: "Jim Womeldorf" I have had the best luck pointing the command to the correct folder something like this: LET $PATH =3D GETENV('comspec') LET #L =3D LENGTH($PATH) WHILE 1 IF SUBSTR($PATH, #L,1) =3D '\' BREAK END-IF LET #L =3D #L - 1 END-WHILE LET $PATH =3D SUBSTR($PATH,1,#L) LET $CMD =3D $path || 'Sort /+16 ' || $file1 || '>' || $file2 Jim =20=20 -----Original Message----- From: sqr-users-bounces+jwomeldo=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+jwomeldo=3Dfastenal.com@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate, consultant) Sent: Monday, October 09, 2006 4:45 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Invoking dos commands thru sqr I tried that also now its putting a blank sorted file..There is no data in the second file.. Let $cmd =3D '/C Sort /+16 ' || $file1 || '>' || $file2 -----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 Knapp, Richard Sent: Monday, October 09, 2006 5:26 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Invoking dos commands thru sqr Invoke the command interpreter with the /C flag so let $cmd =3D cmd /C ... (your commands) Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 09, 2006 4:11 PM To: sqr-users@sqrug.org Subject: [sqr-users] Invoking dos commands thru sqr Hi All, Iam trying to use a dos sort command in sqr. it shud sort the file and redirect the output to another file. I tried but its not working for me. Let $cmd_sort =3D 'Sort /+16 ' || $file1 || '>' || $file2 Iam not getting any error msg. The file is not sorted and iam not getting any sorted output file. Please help Thanks Ram _______________________________________________ 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 Tue Oct 10 08:19:12 2006 From: "Bambach, Tom" Subject: RE: [sqr-users] Invoking dos commands thru sqr Date: Tue, 10 Oct 2006 08:15:43 -0400 Below procedure works on Windows & UNIX Input file must be closed first begin-procedure sort-file let $syscmd = 'sort ' || $dat_file_tmpx || ' /O ' || $dat_file_tmps display $syscmd CALL SYSTEM USING $syscmd #stat WAIT if #stat <> 0 : : : end-procedure sort-file -----Original Message----- From: Vaidyanathan, Ramakrishnan (GE, Corporate, consultant) [mailto:ramakrishnan.vaidyanathan@ge.com] Sent: Monday, October 09, 2006 5:11 PM To: sqr-users@sqrug.org Subject: [sqr-users] Invoking dos commands thru sqr Hi All, Iam trying to use a dos sort command in sqr. it shud sort the file and redirect the output to another file. I tried but its not working for me. Let $cmd_sort = 'Sort /+16 ' || $file1 || '>' || $file2 Iam not getting any error msg. The file is not sorted and iam not getting any sorted output file. Please help Thanks Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 10 09:32:57 2006 Date: Tue, 10 Oct 2006 06:30:04 -0700 From: David Donnelly Subject: [sqr-users] Re: Invoking dos commands thru sqr Ram, Here are some ideas. First, please display $cmd_sort so we can see that your filenames are properly constructed. Next, how are you executing this? Are you waiting for the sort to finish? call system using $cmd_sort #statusvar wait ?? Did you check the statusvar value? Sometimes I have better luck using a batch file containing start/wait commands, and invoking the batch file. What is the file you are trying to sort? If it's one you're making in the current SQR, did you close it first? If you don't have good results yet, use a simpler, short dos command (like 'dir') as a test and see if you get the output. This will help isolate whether the problem is in the invocation, or in the filename and sort command. Try it without the > $file2 redirection and see if you see the output. Dave Dave Donnelly ISIS BioComp phone (951) 677-2446 fax (775) 314-7897 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 10 10:48:39 2006 Date: Tue, 10 Oct 2006 07:45:55 -0700 (PDT) From: sagar minn Subject: RE: [sqr-users] printing Landscape Legal size paper Hi, Thank you all for your response, using your suggestio9n I got one part of my report working, I was able to change my report orientation to landscape and paper size to legal. Now second part: I'm still not able to print in legal size landscape orientation, when I print the pdf report created from my sqr program it generates a letter size landscape orientation page. I'm printing this report from a windows machine, while the sqr runs on a unix platform. Also I include the following flag in my run command sqrt -PRINTER :PD --> which causes printer type to be PDF I don't know if this s causing problem.. Thanks again. Sagar --------------------------------- How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 10 11:13:21 2006 From: "Kim Meyrowitz" Date: Tue, 10 Oct 2006 11:10:40 -0400 Subject: [sqr-users] #current-column This doesn't seem like this should be a hard issue but I have two pieces of text that I am trying to print. Basically, the text had to be split up due to data constraints, but I want to display it as if it was one continous line... Example: start of text 1 5.00 63.00 45.00 xxxxxxxx start of text 2 here What happens with my stuff is that it starts printing on top of text that is already there. I tried using #currrent-column (even adding +10 to it), but it still overwrites existing text. Here is a code snippet I have been working with... while #arr_cnt <= 0 let comments = cmmts.prtl_string(1) if $is_doc = 'Y' let $hdr_dscr = ' ' let $hdr_dscr = $comments||{CR_CODE}||$hdr_dscr end-if if #arr_cnt <= 0 let #start_column = {PURPOSE_X} let #start_line = {PURPOSE_Y} else let #start_column = #current-column + 10 let #start_line = #current-line end-if do wrap_with_cr($hdr_dscr, #start_line, #start_column, 100, {MAX_PURPOSE_LINES_P1}, 1, 8, 'regular', 5, 8, 'F', $addl_purpose) print 'HERE I AM ' () (note, this line keeps over writing existing text, even when I tried inserting the current-column and/or added an additional value to to the current-column to make it move over) let #arr_cnt = #arr_cnt + 1 end-while When I have displayed the value of the current column, it does change - for example it will enter the wrap_with_cr procedure with a value of 10 and before I print 'HERE I AM', it will have a value of 27, but that still over writes text. Seems like an simple task, so why is it overwritting stuff? Thanks in advance! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 10:22:13 2006 Date: Wed, 11 Oct 2006 07:19:25 -0700 (PDT) From: prashanth reddy Subject: [sqr-users] same file different directories Hi, I'm working on interface where it writes 4 files to one directory. My requirement is writing one of the 4 files in two different places. Ex: file1, file2, file 3 and file4 are written in c:\data, file3 should also be written in c:\data\new. Thanks & Regards Prashanth __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 10:29:33 2006 Subject: RE: [sqr-users] same file different directories Date: Wed, 11 Oct 2006 15:26:44 +0100 From: "Simpson, Don I \(UK\)" Prashanth, Either open 2 file channels to the "two paths" file and WRITE to both (i.e. file3 and file5), or WRITE to one, then after closing it, use system commands to copy the file to the other. Regards, Don Simpson BAE Systems -----Original Message----- From: sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org [mailto:sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org] On Behalf Of prashanth reddy Sent: 11 October 2006 15:19 To: sqr-users@sqrug.org Subject: [sqr-users] same file different directories *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet.=20 Keep this in mind if you answer this message.=20 Hi, I'm working on interface where it writes 4 files to one directory. My requirement is writing one of the 4 files in two different places. Ex: file1, file2, file 3 and file4 are written in c:\data, file3 should also be written in c:\data\new.=20 Thanks & Regards Prashanth=20 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 10:55:26 2006 From: "the dragon" Subject: RE: [sqr-users] same file different directories Date: Wed, 11 Oct 2006 09:52:40 -0500 OK... so explicitly names the paths.... And quit using that crappy Windoze OS :-D 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---- Hi, I'm working on interface where it writes 4 files to one directory. My requirement is writing one of the 4 files in two different places. Ex: file1, file2, file 3 and file4 are written in c:\data, file3 should also be written in c:\data\new. Thanks & Regards Prashanth _________________________________________________________________ All-in-one security and maintenance for your PC.  Get a free 90-day trial! http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 17:14:44 2006 Date: Wed, 11 Oct 2006 17:11:59 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Encountering an error... Hi All, Iam executing a sqr and the program takes long time to complete. In betwee= n the sqr errors out saying "(SQR 3725) Bad Return Fetching Row From The Da= tabase". Iam not encountering this error every time. This happens occasionally. Coul= d u pls tell what could be the possible reason? Thanks In Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 17:23:48 2006 Subject: Re: [sqr-users] Encountering an error... From: Kaz.Narayanan@averydennison.com Date: Wed, 11 Oct 2006 14:14:44 -0700 Vaidyanathan, Your select statements in the SQR could be 1. a Cartesian product. 2. The extents in the Database is not enough. talk to your DBA. Regards K.M.Narayanan "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Sent by: sqr-users-bounces+kaz.narayanan=averydennison.com@sqrug.org 10/11/2006 02:11 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: cc: Subject: [sqr-users] Encountering an error... Hi All, Iam executing a sqr and the program takes long time to complete. In between the sqr errors out saying "(SQR 3725) Bad Return Fetching Row From The Database". Iam not encountering this error every time. This happens occasionally. Could u pls tell what could be the possible reason? Thanks In Advance Ram _______________________________________________ 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 Wed Oct 11 17:31:06 2006 Subject: RE: [sqr-users] Encountering an error... Date: Wed, 11 Oct 2006 17:28:14 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" But the same sqr works fine other times...Iam getting this some times... -----Original Message-----=0D From: sqr-users-bounces+ramakrishnan.vaidyanathan=3Dge.com@sqrug.org [mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=3Dge.com@sqrug.org]On Behalf Of Kaz.Narayanan@averydennison.com Sent: Wednesday, October 11, 2006 5:15 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Encountering an error... Vaidyanathan, Your select statements in the SQR could be 1. a Cartesian product. 2. The extents in the Database is not enough. talk to your DBA. Regards K.M.Narayanan "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)"=20 Sent by: sqr-users-bounces+kaz.narayanan=3Daverydennison.com@sqrug.org 10/11/2006 02:11 PM Please respond to "This list is for discussion about the SQR database=20 reporting language from Hyperion Solutions." =20 To: cc:=20 Subject: [sqr-users] Encountering an error... Hi All, Iam executing a sqr and the program takes long time to complete. In=20 between the sqr errors out saying "(SQR 3725) Bad Return Fetching Row From= =20 The Database". Iam not encountering this error every time. This happens occasionally.=20 Could u pls tell what could be the possible reason? Thanks In Advance Ram _______________________________________________ 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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 18:06:04 2006 From: "the dragon" Subject: RE: [sqr-users] Encountering an error... Date: Wed, 11 Oct 2006 17:03:24 -0500 you connection is timing out or your rollback segment is filling up. 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---- Hi All, Iam executing a sqr and the program takes long time to complete. In between the sqr errors out saying "(SQR 3725) Bad Return Fetching Row From The Database". Iam not encountering this error every time. This happens occasionally. Could u pls tell what could be the possible reason? Thanks In Advance Ram _________________________________________________________________ Search—Your way, your world, right now! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM=WLMTAG _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 11 18:09:28 2006 From: "the dragon" Subject: RE: [sqr-users] Encountering an error... Date: Wed, 11 Oct 2006 17:05:47 -0500 from an oracle perspective, if you're using a shared temp table space, and something else is running, you could be running out of space. Most DBAs will *NOT* extend this because in most cases it's not required - check your code - maybe have the dba do an explain plan on it, or choose a time when other proceses are not running. 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---- But the same sqr works fine other times...Iam getting this some times... -----Original Message----- Vaidyanathan, Your select statements in the SQR could be 1. a Cartesian product. 2. The extents in the Database is not enough. talk to your DBA. Regards K.M.Narayanan _________________________________________________________________ Be seen and heard with Windows Live Messenger and Microsoft LifeCams http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://www.microsoft.com/hardware/digitalcommunication/default.mspx?locale=en-us&source=hmtagline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 12 09:07:35 2006 Date: Thu, 12 Oct 2006 09:05:05 -0400 From: "White . Denise" Subject: [sqr-users] RE: Encountering an error... Hi Ram, That error message is a kind of generic one, that could mean any one of a number of different things. I have seen this happen in the past due to data contention - when someone was in the system updating data that the program was trying to select. As you can see from the other replies, there are other reasons that could also cause it. Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation ------------------------------ Message: 4 Date: Wed, 11 Oct 2006 17:11:59 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Encountering an error... To: Message-ID: =09 Content-Type: text/plain; charset=3D"iso-8859-1" Hi All, Iam executing a sqr and the program takes long time to complete. In between the sqr errors out saying "(SQR 3725) Bad Return Fetching Row =46rom The Database". Iam not encountering this error every time. This happens occasionally. Could u pls tell what could be the possible reason? Thanks In Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 12 09:11:33 2006 Date: Thu, 12 Oct 2006 09:08:21 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Reg Num Formatting Hi All, I have a file that has the amounts displayed in the Mainframe format i.e i= t has A's, B's, { etc signs to display the numbers. I have converted it int= o appropriate number values. For eg the result that i get after conversion = is 00728436. I want it to be displayed as 7284.36. Total length of the fiel= d is 8 (6.2) (6 real no and 2 decvimal point.) Is there any edit mask to ac= complish this. Thanks in advance Ram=20=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 12 09:19:05 2006 Date: Thu, 12 Oct 2006 09:16:39 -0400 From: "Larry Roux" Subject: Re: [sqr-users] Reg Num Formatting An easy ( and perhaps not the most elegant) way is: Let #tempvar = ''00728436' Let #tempvar = #tempvar * .01 Let $outvar = edit(#tempvar,'999999.99') Larry Roux Information Systems Syracuse University lroux@syr.edu >>> ramakrishnan.vaidyanathan@ge.com 10/12/2006 9:08 AM >>> Hi All, I have a file that has the amounts displayed in the Mainframe format i.e it has A's, B's, { etc signs to display the numbers. I have converted it into appropriate number values. For eg the result that i get after conversion is 00728436. I want it to be displayed as 7284.36. Total length of the field is 8 (6.2) (6 real no and 2 decvimal point.) Is there any edit mask to accomplish this. Thanks in advance Ram _______________________________________________ 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 12 09:30:18 2006 From: "Angelika Scheffera" Subject: RE: [sqr-users] Reg Num Formatting Date: Thu, 12 Oct 2006 08:27:22 -0500 Ram, Try this: print #number_var () edit 999999.99 Kind regards, Angelika -----Original Message----- From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org [mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Thursday, October 12, 2006 8:08 AM To: sqr-users@sqrug.org Subject: [sqr-users] Reg Num Formatting Hi All, I have a file that has the amounts displayed in the Mainframe format i.e it has A's, B's, { etc signs to display the numbers. I have converted it into appropriate number values. For eg the result that i get after conversion is 00728436. I want it to be displayed as 7284.36. Total length of the field is 8 (6.2) (6 real no and 2 decvimal point.) Is there any edit mask to accomplish this. Thanks in advance Ram _______________________________________________ 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 13 08:09:53 2006 Date: Fri, 13 Oct 2006 08:06:15 -0400 From: "Overcashier, Patricia" Subject: [sqr-users] quickest way to count how many commas are in a string I have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 08:24:53 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 13:20:43 +0100 From: "Simpson, Don I \(UK\)" I haven't tried this myself, but it should/might work. Copy your string into a second temporary variable. Do a REPLACE on this string to change all ',' to '' (null). Get the length of your original and the "replaced" temporary string. The difference in length is the number of commas. Regards, Don Simpson BAE Systems=20 -----Original Message----- From: sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org [mailto:sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org] On Behalf Of Overcashier, Patricia Sent: 13 October 2006 13:06 To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] quickest way to count how many commas are in a string *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet.=20 Keep this in mind if you answer this message. I have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 08:39:06 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 08:34:44 -0400 From: "Peter Burton" Don, Good idea .. Begin-Report Input $A Let #C =3D Length($A) - Length(Replace($A, ',', '')) Show #C End-Report=20 Peter -----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 Simpson, Don I (UK) Sent: Friday, October 13, 2006 8:21 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string I haven't tried this myself, but it should/might work. Copy your string into a second temporary variable. Do a REPLACE on this string to change all ',' to '' (null). Get the length of your original and the "replaced" temporary string. The difference in length is the number of commas. Regards, Don Simpson BAE Systems=20 -----Original Message----- From: sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org [mailto:sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org] On Behalf Of Overcashier, Patricia Sent: 13 October 2006 13:06 To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] quickest way to count how many commas are in a string *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet.=20 Keep this in mind if you answer this message. I have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users If you have received this e-mail in error, please delete it and notify the = sender as soon as possible. The contents of this e-mail may be confidential= and the unauthorized use, copying, or dissemination of it and any attachme= nts to it, is prohibited. Internet communications are not secure and Hyperi= on does not, therefore, accept legal responsibility for the contents of thi= s message nor for any damage caused by viruses. The views expressed here do= not necessarily represent those of Hyperion. For more information about Hy= perion, please visit our Web site at: www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 08:55:20 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 18:21:07 +0530 From: Cool Trick... Kaushik -----Original Message----- From: sqr-users-bounces+r.kaushik=3Diflexsolutions.com@sqrug.org [mailto:sqr-users-bounces+r.kaushik=3Diflexsolutions.com@sqrug.org] On Behalf Of Peter Burton Sent: Friday, October 13, 2006 6:05 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string Don, Good idea .. Begin-Report Input $A Let #C =3D Length($A) - Length(Replace($A, ',', '')) Show #C End-Report=20 Peter -----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 Simpson, Don I (UK) Sent: Friday, October 13, 2006 8:21 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string I haven't tried this myself, but it should/might work. Copy your string into a second temporary variable. Do a REPLACE on this string to change all ',' to '' (null). Get the length of your original and the "replaced" temporary string. The difference in length is the number of commas. Regards, Don Simpson BAE Systems=20 -----Original Message----- From: sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org [mailto:sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org] On Behalf Of Overcashier, Patricia Sent: 13 October 2006 13:06 To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] quickest way to count how many commas are in a string *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet.=20 Keep this in mind if you answer this message. I have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion. For more information about Hyperion, please visit our Web site at: www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users DISCLAIMER: This message contains privileged and confidential information and is intend= ed only for the individual named.If you are not the intended recipient you = should not disseminate,distribute,store,print, copy or deliver this message= .Please notify the sender immediately by e-mail if you have received this e= -mail by mistake and delete this e-mail from your system.E-mail transmissio= n cannot be guaranteed to be secure or error-free as information could be i= ntercepted,corrupted,lost,destroyed,arrive late or incomplete or contain vi= ruses.The sender therefore does not accept liability for any errors or omis= sions in the contents of this message which arise as a result of e-mail tra= nsmission. If verification is required please request a hard-copy version. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 08:58:56 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 08:55:03 -0400 From: "Overcashier, Patricia" Excellent! Works like a charm! Thanks! -----Original Message----- From: sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org [mailto:sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org] On Behalf Of Peter Burton Sent: Friday, October 13, 2006 8:35 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string Don, Good idea .. Begin-Report Input $A Let #C =3D Length($A) - Length(Replace($A, ',', '')) Show #C End-Report=20 Peter -----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 Simpson, Don I (UK) Sent: Friday, October 13, 2006 8:21 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string I haven't tried this myself, but it should/might work. Copy your string into a second temporary variable. Do a REPLACE on this string to change all ',' to '' (null). Get the length of your original and the "replaced" temporary string. The difference in length is the number of commas. Regards, Don Simpson BAE Systems=20 -----Original Message----- From: sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org [mailto:sqr-users-bounces+don.i.simpson=3Dbaesystems.com@sqrug.org] On Behalf Of Overcashier, Patricia Sent: 13 October 2006 13:06 To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] quickest way to count how many commas are in a string *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet.=20 Keep this in mind if you answer this message. I have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion. For more information about Hyperion, please visit our Web site at: www.hyperion.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 Fri Oct 13 09:07:03 2006 From: "the dragon" Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 08:03:39 -0500 I guess my question is why would you need this? A comma deliminated file should always have the same number of commas in it, for every row. If not, you wouldn't really know what data goes with what variable anyway, and that statement goes if you don't know how many commas are in the row of data. If I have the row Clark, the dragon, Willis, 48, PeopleSloth Admin and any of those commas were missing, I wouldn't know what values would get placed into the corresponding variables, because I would never know which comma was missing. 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 have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _________________________________________________________________ The next generation of Search—say hello! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM=WLMTAG _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 09:14:33 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Fri, 13 Oct 2006 09:11:52 -0400 From: "Overcashier, Patricia" The variable that I am dissecting does not come from a file.=20 I need to know how many columns are in the primary index for the record name in the audit table. Through a previous query, all of the column names of the primary index for the record are in one variable. I am splitting them out and then using them as separate columns in a dynamic select statement. Hope that helps clarify it. -----Original Message----- From: sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org [mailto:sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org] On Behalf Of the dragon Sent: Friday, October 13, 2006 9:04 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] quickest way to count how many commas are in a string I guess my question is why would you need this? A comma deliminated file=20 should always have the same number of commas in it, for every row. If not,=20 you wouldn't really know what data goes with what variable anyway, and that=20 statement goes if you don't know how many commas are in the row of data. If I have the row Clark, the dragon, Willis, 48, PeopleSloth Admin and any=20 of those commas were missing, I wouldn't know what values would get placed=20 into the corresponding variables, because I would never know which comma was=20 missing. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your=20 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=20 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=20 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 have a string called $selectlist I need to know how many commas are in it. Once I know I can unstring it by commas into the right number of variables and then use those variables What is the simplest way to get a count of the commas? Thanks! _________________________________________________________________ The next generation of Search-say hello!=20=20 http://imagine-windowslive.com/minisites/searchlaunch/?locale=3Den-us&FORM =3DWLMTAG _______________________________________________ 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 13 10:30:54 2006 Date: Fri, 13 Oct 2006 10:27:41 -0400 From: "George Jansen" Subject: RE: [sqr-users] quickest way to count how many commas are in a string It seems to me that the route SQL -> string -> SQL is a bit cumbersome. You have a dynamic select statement, but what are you selecting? _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 11:05:32 2006 Date: Fri, 13 Oct 2006 11:02:50 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Edit mask Hi All Is there any way to edit mask the number such that the last 2 digits shud = always be a decimal portion. For eg if i have a number 1234 then it shud be= masked in suach a way that the result shud be 12.34. If the no is 123456 t= hen result shud be 1234.56. Is there any way to acheive this? Thanks In Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Oct 13 12:26:21 2006 Date: Fri, 13 Oct 2006 13:23:53 -0300 From: "PeterG Clark" Subject: Re: [sqr-users] Edit mask Larry Roux provided the solution. Let #tempvar =3D ''00728436' Let #tempvar =3D #tempvar * .01=20=20 Let $outvar =3D edit(#tempvar,'999999.99') I'll try to explain in simple terms. Multipling by .01 moves the implied decimal within the variable to the seco= nd position. Then when edited as above or with a print command, the decimal= point will print where you are wanting it. example: your field (let's call it #field) contains "00728436^" (^ =3D implied de= cimal position) "let #field =3D #field * .01" moves the implied decimal position to "007284= ^36" Then when you edit, the decimal point will print between the 4 and the 3 (w= here the implied decimal position moved to after the multiply) >>> ramakrishnan.vaidyanathan@ge.com 2006/10/13 12:02:50 >>> Hi All Is there any way to edit mask the number such that the last 2 digits shud = always be a decimal portion. For eg if i have a number 1234 then it shud be= masked in suach a way that the result shud be 12.34. If the no is 123456 t= hen result shud be 1234.56. Is there any way to acheive this? Thanks In Advance Ram _______________________________________________ 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 Sat Oct 14 08:26:29 2006 Date: Sat, 14 Oct 2006 17:53:47 +0530 From: Subject: [sqr-users] selecting all rows from a table without specifying the column names Dear all, I would like to know whether I can retrieve all rows of a table using, I do not want to code in all the column names.. Begin-select * =46rom table_name End-select If so , how are the print positions assigned? Thanks in advance for all responses. :) Kaushik _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 07:05:38 2006 Date: Mon, 16 Oct 2006 08:02:09 -0300 From: "PeterG Clark" Subject: Re: [sqr-users] selecting all rows from a table without specifying the column names No, you cannot use the asterisk. The SQR reference manual is quite clear on this in the section describing t= he BEGIN-SELECT. >>> R.Kaushik@iflexsolutions.com 2006/10/14 09:23:47 >>> Dear all, I would like to know whether I can retrieve all rows of a table using, I do not want to code in all the column names.. Begin-select * =46rom table_name End-select If so , how are the print positions assigned? Thanks in advance for all responses. :) Kaushik _______________________________________________ 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 Mon Oct 16 08:08:50 2006 Subject: RE: [sqr-users] quickest way to count how many commas are in a string Date: Mon, 16 Oct 2006 08:04:32 -0400 From: "Overcashier, Patricia" You are right. After actually pulling it off, I found an easier way.=20=20 But this is what I was originally trying to do. I was going against the user_ind_columns to get the columns of the primary key to use in a select statement.=20=20 I get the tablename from my audit table (select recname from psaudit), but want to display the primary keys on a report. Begin-select Column_name Table_name $table_name =3D &table_name $column1 =3D &column_name =46rom user_ind_columns Where index_name =3D 'PS_'||$recname Order by column_position End-select Then I use the column names as a dynamic select Begin-select [$column1] [$column2] From=20 [$table_name] End-select There were a lot more twists and turns to get through this, but since then I have recoded and simplified it greatly.=20=20 Thanks all for your help. -----Original Message----- From: sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org [mailto:sqr-users-bounces+patricia.overcashier=3Daam.com@sqrug.org] On Behalf Of George Jansen Sent: Friday, October 13, 2006 10:28 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] quickest way to count how many commas are in a string It seems to me that the route SQL -> string -> SQL is a bit cumbersome. You have a dynamic select statement, but what are you selecting? _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:01:41 2006 Date: Mon, 16 Oct 2006 08:58:56 -0500 From: "Kelly Cookson" Subject: [sqr-users] Changing font family and font size line by line Newbie here...=20 I'd like to be able to change the font family and font size on a line by line basis. For example, I'd like to print the first line of a report heading in 14pt Arial font, then print the next line of the heading in 12pt Times New Roman font. How can I do this? Thanks in advance, Kelly _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:04:48 2006 Date: Mon, 16 Oct 2006 10:00:17 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error -=20 (SQR 6006) String 2Em - String To Decimal Object Conversion Error=20 Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT =3D &COUNTTMR LET $COUNT =3D ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE =3D 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE =3D $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:09:45 2006 Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 09:06:55 -0500 From: "Knapp, Richard" Check the archives. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:00 AM To: sqr-users@sqrug.org Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error -=20 (SQR 6006) String 2Em - String To Decimal Object Conversion Error=20 Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT =3D &COUNTTMR LET $COUNT =3D ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE =3D 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE =3D $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:12:52 2006 Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 09:07:10 -0500 From: "Bob Helm" I think it's in the LET $COUNT =3D ROUND(#COUNT,0) line. Maybe try LET $COUNT =3D to_char(ROUND(#COUNT,0)) -----Original Message----- From: sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org [mailto:sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org]On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:00 AM To: sqr-users@sqrug.org Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error -=20 (SQR 6006) String 2Em - String To Decimal Object Conversion Error=20 Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT =3D &COUNTTMR LET $COUNT =3D ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE =3D 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE =3D $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:16:08 2006 From: "Angelika Scheffera" Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 09:12:10 -0500 Good morning, Instead of using the LET command try using the MOVE command. Kind regards, Angelika -----Original Message----- From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org [mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:00 AM To: sqr-users@sqrug.org Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error - (SQR 6006) String 2Em - String To Decimal Object Conversion Error Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT = &COUNTTMR LET $COUNT = ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE = 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE = $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:19:32 2006 From: "Angelika Scheffera" Subject: RE: [sqr-users] Changing font family and font size line by line Date: Mon, 16 Oct 2006 09:15:46 -0500 Kelly, Lookup the ALTER-PRINTER command. Would go something like this: alter-printer font=4 ! Helvetica point-size=8 ! Font size Kind regards, Angelika -----Original Message----- From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org [mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of Kelly Cookson Sent: Monday, October 16, 2006 8:59 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] Changing font family and font size line by line Newbie here... I'd like to be able to change the font family and font size on a line by line basis. For example, I'd like to print the first line of a report heading in 14pt Arial font, then print the next line of the heading in 12pt Times New Roman font. How can I do this? Thanks in advance, Kelly _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 16 10:28:58 2006 Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 10:26:17 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" hi all, Even after using to_char function Iam getting the same error. Thanks Ram -----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 Bob Helm Sent: Monday, October 16, 2006 10:07 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Error encountered I think it's in the LET $COUNT =3D ROUND(#COUNT,0) line. Maybe try LET $COUNT =3D to_char(ROUND(#COUNT,0)) -----Original Message----- From: sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org [mailto:sqr-users-bounces+bob.helm=3Dmediware.com@sqrug.org]On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:00 AM To: sqr-users@sqrug.org Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error -=20 (SQR 6006) String 2Em - String To Decimal Object Conversion Error=20 Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT =3D &COUNTTMR LET $COUNT =3D ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE =3D 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE =3D $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ 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 Mon Oct 16 11:00:04 2006 From: "Angelika Scheffera" Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 09:57:26 -0500 Did you try the MOVE command instead of the LET? Replace: LET #COUNT = &COUNTTMR LET $COUNT = ROUND(#COUNT,0) With: MOVE &COUNTTMR TO #COUNT LET #COUNT = ROUND(#COUNT,0) MOVE #COUNT TO $COUNT Kind regards, Angelika -----Original Message----- From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org [mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:26 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Error encountered hi all, Even after using to_char function Iam getting the same error. Thanks Ram -----Original Message----- From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org [mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On Behalf Of Bob Helm Sent: Monday, October 16, 2006 10:07 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Error encountered I think it's in the LET $COUNT = ROUND(#COUNT,0) line. Maybe try LET $COUNT = to_char(ROUND(#COUNT,0)) -----Original Message----- From: sqr-users-bounces+bob.helm=mediware.com@sqrug.org [mailto:sqr-users-bounces+bob.helm=mediware.com@sqrug.org]On Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant) Sent: Monday, October 16, 2006 9:00 AM To: sqr-users@sqrug.org Subject: [sqr-users] Error encountered Hi All, Iam getting the following error when i execute the below code Error - (SQR 6006) String 2Em - String To Decimal Object Conversion Error Code - BEGIN-SELECT COUNTM &COUNTTMR LET #COUNT = &COUNTTMR LET $COUNT = ROUND(#COUNT,0) !Others,Matchingrows,302635 Let $WRITE_SUM_LINE = 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT Write 99107 From $WRITE_SUM_LINE FROM ( SELECT COUNT(1) COUNTM FROM PS_GE_QA_CMP_LINE_DTL WHERE DRIVER_CODE = $upp_filepath ) END-SELECT Thanks in Advance Ram _______________________________________________ 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 Mon Oct 16 11:12:19 2006 Subject: RE: [sqr-users] Error encountered Date: Mon, 16 Oct 2006 11:09:26 -0400 From: "Peter Burton" Ram, The problem here is that Oracle 9.2.0.3 changed they way they return numerical values without specifying a