From sqr-users-bounces@sqrug.org Fri Jul 01 00:00:44 2005 Date: Fri, 1 Jul 2005 00:00:03 -0500 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.21 $ $Date: 2004-03-04 02:47:15-05 $ 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 2003/11/01: o Update subscribe/unsubscribe instructions for new version of list server software. o New URL for "brio-l" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.org/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2004 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. BrioSQRReport : Brio SQR Report List for discussion of SQR and SQR Developer (formerly called Brio.Report and Report Builder). To join, follow the link above, or send any message to "BrioSQRReport- subscribe@yahoogroups.com". rm-users : Report- Mart Users List for discussion of Brio Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. If you use digests, you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list as other subscribers' mail systems repond....) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQR product name and version number (see notes below) o Operating system name and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 00:41:52 2005 Date: Fri, 01 Jul 2005 15:10:46 +0930 From: Tim Peters Subject: Re: [sqr-users] print How about something like this (untested): begin-procedure print-unless-blank ($str) if not isblank($str) print $str (+1,1) end-if end-procedure ... print $address1 (0,1) do print-unless-blank($address2) do print-unless-blank($address3) ! etc... Regards, Tim radhika reddy wrote: > Hi, > > I have to print the in the following format: > > Address1 > Address2 > Address3 > phone > county - line by line > > I would do something like this: > > print address1 (0,1) > print address2 (+1,1) > print address3 (+1,1) > print phone (+1,1) > print county (+1,1) > > My problem is sometimes address2, addr3,phone,county might be empty then > there would be 4 lines of space which i don't want to have. > > I don't want to put If statement for each of these to see if they are > empty. Is there any better way to do this? > > Thanks. Any help is great. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 10:54:52 2005 From: "Alexander, Steve" Subject: RE: [sqr-users] print Date: Fri, 1 Jul 2005 08:54:27 -0700 Now I feel dumb for not thinking of a subroutine. Thanks, Tim. -----Original Message----- From: Tim Peters [mailto:timothy.peters@adelaide.edu.au] Sent: Thursday, June 30, 2005 10:41 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] print How about something like this (untested): begin-procedure print-unless-blank ($str) if not isblank($str) print $str (+1,1) end-if end-procedure ... print $address1 (0,1) do print-unless-blank($address2) do print-unless-blank($address3) ! etc... Regards, Tim radhika reddy wrote: > Hi, > > I have to print the in the following format: > > Address1 > Address2 > Address3 > phone > county - line by line > > I would do something like this: > > print address1 (0,1) > print address2 (+1,1) > print address3 (+1,1) > print phone (+1,1) > print county (+1,1) > > My problem is sometimes address2, addr3,phone,county might be empty then > there would be 4 lines of space which i don't want to have. > > I don't want to put If statement for each of these to see if they are > empty. Is there any better way to do this? > > Thanks. Any help is great. _______________________________________________ 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 Jul 01 11:00:50 2005 Subject: RE: [sqr-users] print Date: Fri, 1 Jul 2005 11:59:37 -0400 From: "Peter Burton" Tim, However using a routine is a lot slower than just putting the "if" around t= he print and it also makes assumptions about the print itself (location, at= tributes, etc.). 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 Alexander, Steve Sent: Friday, July 01, 2005 11:54 AM To: 'This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions.' Subject: RE: [sqr-users] print Now I feel dumb for not thinking of a subroutine. Thanks, Tim. -----Original Message----- From: Tim Peters [mailto:timothy.peters@adelaide.edu.au] Sent: Thursday, June 30, 2005 10:41 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] print How about something like this (untested): begin-procedure print-unless-blank ($str) if not isblank($str) print $str (+1,1) end-if end-procedure ... print $address1 (0,1) do print-unless-blank($address2) do print-unless-blank($address3) ! etc... Regards, Tim radhika reddy wrote: > Hi, >=20 > I have to print the in the following format: >=20 > Address1 > Address2 > Address3 > phone > county - line by line >=20 > I would do something like this: >=20 > print address1 (0,1) > print address2 (+1,1) > print address3 (+1,1) > print phone (+1,1) > print county (+1,1) >=20 > My problem is sometimes address2, addr3,phone,county might be empty then= =20 > there would be 4 lines of space which i don't want to have. >=20 > I don't want to put If statement for each of these to see if they are=20 > empty. Is there any better way to do this? >=20 > Thanks. Any help is great. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 11:13:02 2005 From: "radhika reddy" Subject: RE: [sqr-users] print Date: Fri, 01 Jul 2005 11:11:59 -0500 Thanks to all. I finally decided to have If statements. I wanted to have a second opinion on this which i always get from this group. Thanks again. >From: "Peter Burton" >Reply-To: "This list is for discussion about the SQR database >reportinglanguage from Hyperion Solutions." >To: "This list is for discussion about the SQR database reportinglanguage >fromHyperion Solutions." >Subject: RE: [sqr-users] print >Date: Fri, 1 Jul 2005 11:59:37 -0400 > >Tim, > >However using a routine is a lot slower than just putting the "if" around >the print and it also makes assumptions about the print itself (location, >attributes, etc.). > >Peter > >-----Original Message----- >From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org >[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org]On Behalf >Of Alexander, Steve >Sent: Friday, July 01, 2005 11:54 AM >To: 'This list is for discussion about the SQR database >reportinglanguagefrom Hyperion Solutions.' >Subject: RE: [sqr-users] print > > >Now I feel dumb for not thinking of a subroutine. Thanks, Tim. > >-----Original Message----- >From: Tim Peters [mailto:timothy.peters@adelaide.edu.au] >Sent: Thursday, June 30, 2005 10:41 PM >To: This list is for discussion about the SQR database reporting >languagefrom Hyperion Solutions. >Subject: Re: [sqr-users] print > > >How about something like this (untested): > >begin-procedure print-unless-blank ($str) > if not isblank($str) > print $str (+1,1) > end-if >end-procedure > >... > > print $address1 (0,1) > do print-unless-blank($address2) > do print-unless-blank($address3) > ! etc... > >Regards, >Tim > >radhika reddy wrote: > > Hi, > > > > I have to print the in the following format: > > > > Address1 > > Address2 > > Address3 > > phone > > county - line by line > > > > I would do something like this: > > > > print address1 (0,1) > > print address2 (+1,1) > > print address3 (+1,1) > > print phone (+1,1) > > print county (+1,1) > > > > My problem is sometimes address2, addr3,phone,county might be empty then > > there would be 4 lines of space which i don't want to have. > > > > I don't want to put If statement for each of these to see if they are > > empty. Is there any better way to do this? > > > > Thanks. Any help is great. > > >_______________________________________________ >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 _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 17:23:13 2005 From: "Steve Cavill" Subject: RE: [sqr-users] print Date: Sat, 2 Jul 2005 08:23:55 +1000 If the fields are empty, rather than containing blanks, Maybe next-listing no-advance would help? (I haven't tested that) Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of Alexander, Steve Sent: Friday, 1 July 2005 9:18 AM To: 'This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions.' Subject: RE: [sqr-users] print I don't blame Radhika for looking for another way. It's frustrating to have to repeat the same concept to the compiler over and over. It would be nice if SQR had a conditional print statement that only advanced the position pointer and printed a variable if that variable weren't null. Even if the address lines were in an array, the loop would be awkward because the print statement doesn't take array elements. -----Original Message----- From: Bob Stone [mailto:bstone@fastenal.com] Sent: Thursday, June 30, 2005 2:47 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] print Good word, Steve: verbose. I think Steve's right...the easiest way to do it is with an IF statement for each of them. Not just easiest to write, but also easiest to follow. The if statements won't slow up the program any noticeable amount...I'm not sure why you would want to find a harder way to do it?? Just because it's the 'easy way' doesn't mean it's not also smart, good programming. -----Original Message----- From: sqr-users-bounces+bstone=fastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of Alexander, Steve Sent: Thursday, June 30, 2005 3:45 PM To: 'This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions.' Subject: RE: [sqr-users] print I can think of other ways to handle this, but they're all more complex and verbose than putting each print in an IF statement. -----Original Message----- From: radhika reddy [mailto:radhika_05@hotmail.com] Sent: Thursday, June 30, 2005 1:30 PM To: sqr-users@sqrug.org Subject: [sqr-users] print Hi, I have to print the in the following format: Address1 Address2 Address3 phone county - line by line I would do something like this: print address1 (0,1) print address2 (+1,1) print address3 (+1,1) print phone (+1,1) print county (+1,1) My problem is sometimes address2, addr3,phone,county might be empty then there would be 4 lines of space which i don't want to have. I don't want to put If statement for each of these to see if they are empty. Is there any better way to do this? Thanks. Any help is great. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 12:14:00 2005 Date: Fri, 1 Jul 2005 12:12:55 -0500 From: Chandra Yarlagadda Subject: [sqr-users] Eliminate printer specific character from SQR report Hi, I am trying to produce an SQR report from an Unix machine in .lis format. I am using the option of printer:lp. The report looks fine when I view in VI editor except for the first line which looks like ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G I know this are printer specific character. But I need to send the report output to mainframe and viewed from there. So I need an option to eliminate these characters. Can anyone help me in eliminating these character using any options. Thanks, Chandra _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 12:59:43 2005 Subject: RE: [sqr-users] Eliminate printer specific character from SQR report Date: Fri, 1 Jul 2005 12:59:05 -0500 From: "Turner, Ivan" The purpose of that line is to send control charachers to the printer for things such as paper orientation, center, bold, etc. There is no way I know of to remove them. If you copy the file to windows, you can then COPY it to a printer path and it will give you the orientation specified by the control characters. Fron the command line of windows,=20 copy abc.lis //device/printer/abc.lis -----Original Message----- From: sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org [mailto:sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org] On Behalf Of Chandra Yarlagadda Sent: Friday, July 01, 2005 1:13 PM To: sqr-users@sqrug.org Subject: [sqr-users] Eliminate printer specific character from SQR report Hi, I am trying to produce an SQR report from an Unix machine in .lis format. I am using the option of printer:lp. The report looks fine when I view in VI editor except for the first line which looks like ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G I know this are printer specific character. But I need to send the report output to mainframe and viewed from there. So I need an option to eliminate these characters. Can anyone help me in eliminating these character using any options. Thanks, Chandra _______________________________________________ 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 Jul 01 15:16:36 2005 From: "Alexander, Steve" Subject: RE: [sqr-users] Eliminate printer specific character from SQR report Date: Fri, 1 Jul 2005 13:16:09 -0700 I think those codes are specified in a "printer-init" command. In the Peoplesoft world, that command is part of the SETUPxxx.SQC include files. -----Original Message----- From: Turner, Ivan [mailto:Ivan.Turner@qwest.com] Sent: Friday, July 01, 2005 10:59 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Eliminate printer specific character from SQR report The purpose of that line is to send control charachers to the printer for things such as paper orientation, center, bold, etc. There is no way I know of to remove them. If you copy the file to windows, you can then COPY it to a printer path and it will give you the orientation specified by the control characters. Fron the command line of windows, copy abc.lis //device/printer/abc.lis -----Original Message----- From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org [mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of Chandra Yarlagadda Sent: Friday, July 01, 2005 1:13 PM To: sqr-users@sqrug.org Subject: [sqr-users] Eliminate printer specific character from SQR report Hi, I am trying to produce an SQR report from an Unix machine in .lis format. I am using the option of printer:lp. The report looks fine when I view in VI editor except for the first line which looks like ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G I know this are printer specific character. But I need to send the report output to mainframe and viewed from there. So I need an option to eliminate these characters. Can anyone help me in eliminating these character using any options. Thanks, Chandra _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 01 17:26:38 2005 From: "Steve Cavill" Subject: RE: [sqr-users] Eliminate printer specific character from SQR report Date: Sat, 2 Jul 2005 08:27:35 +1000 That doesn't look like printer:lp that looks like PCL (printer:hp) Printer:lp should be plain text. You should check if you have a priner-init command in your sqr code which looks like it may be incorrect. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of Alexander, Steve Sent: Saturday, 2 July 2005 6:16 AM To: 'This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Eliminate printer specific character from SQR report I think those codes are specified in a "printer-init" command. In the Peoplesoft world, that command is part of the SETUPxxx.SQC include files. -----Original Message----- From: Turner, Ivan [mailto:Ivan.Turner@qwest.com] Sent: Friday, July 01, 2005 10:59 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Eliminate printer specific character from SQR report The purpose of that line is to send control charachers to the printer for things such as paper orientation, center, bold, etc. There is no way I know of to remove them. If you copy the file to windows, you can then COPY it to a printer path and it will give you the orientation specified by the control characters. Fron the command line of windows, copy abc.lis //device/printer/abc.lis -----Original Message----- From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org [mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of Chandra Yarlagadda Sent: Friday, July 01, 2005 1:13 PM To: sqr-users@sqrug.org Subject: [sqr-users] Eliminate printer specific character from SQR report Hi, I am trying to produce an SQR report from an Unix machine in .lis format. I am using the option of printer:lp. The report looks fine when I view in VI editor except for the first line which looks like ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G I know this are printer specific character. But I need to send the report output to mainframe and viewed from there. So I need an option to eliminate these characters. Can anyone help me in eliminating these character using any options. Thanks, Chandra _______________________________________________ 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 Jul 05 08:56:48 2005 Date: Tue, 5 Jul 2005 08:55:43 -0500 From: Chandra Yarlagadda Subject: Re: [sqr-users] Eliminate printer specific character from SQR report I use setup32.sqc to produce the report. It has Printer-init command in it. Is there another sqc to produce a landscape layout and not produce the printer characters. Chandra. On 7/1/05, Steve Cavill wrote: > That doesn't look like printer:lp that looks like PCL (printer:hp) > Printer:lp should be plain text. > You should check if you have a priner-init command in your sqr code which= looks like it may be incorrect. > Steve. >=20 > -----Original Message----- > From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org] On= Behalf Of Alexander, Steve > Sent: Saturday, 2 July 2005 6:16 AM > To: 'This list is for discussion about the SQR database reportinglanguage= from Hyperion Solutions.' > Subject: RE: [sqr-users] Eliminate printer specific character from SQR re= port >=20 > I think those codes are specified in a "printer-init" command. In the Pe= oplesoft world, that command is part of the SETUPxxx.SQC > include files. >=20 > -----Original Message----- > From: Turner, Ivan [mailto:Ivan.Turner@qwest.com] > Sent: Friday, July 01, 2005 10:59 AM > To: This list is for discussion about the SQR database reportinglanguage = fromHyperion Solutions. > Subject: RE: [sqr-users] Eliminate printer specific character from SQR re= port >=20 >=20 > The purpose of that line is to send control charachers to the printer for= things such as paper orientation, center, bold, etc. > There is no way I know of to remove them. If you copy the file to window= s, you can then COPY it to a printer path and it will give > you the orientation specified by the control characters. >=20 > Fron the command line of windows, > copy abc.lis //device/printer/abc.lis >=20 > -----Original Message----- > From: sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org > [mailto:sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org] On Behalf Of= Chandra Yarlagadda > Sent: Friday, July 01, 2005 1:13 PM > To: sqr-users@sqrug.org > Subject: [sqr-users] Eliminate printer specific character from SQR report >=20 > Hi, >=20 > I am trying to produce an SQR report from an Unix machine in .lis format.= I am using the option of printer:lp. The report looks fine > when I view in VI editor except for the first line which looks like >=20 > ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G >=20 > I know this are printer specific character. But I need to send the report= output to mainframe and viewed from there. So I need an > option to eliminate these characters. >=20 > Can anyone help me in eliminating these character using any options. >=20 > Thanks, > Chandra >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 >=20 >=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 Tue Jul 05 09:29:53 2005 Date: Tue, 05 Jul 2005 11:29:30 -0300 From: "PeterG Clark" Subject: Re: [sqr-users] Eliminate printer specific character from SQR report Yes, there are other sqc's (and if there isn't, it is no big deal to create= your own). But don't lose sight of the fact that by using "print" aspects = (PRINT commands, printer declarations, page setup declarations, etc) you ca= nnot expect SQR to *not* prepare your output for actual printing (in any of= the many print mediums available in SQR). If you want a file that contains= no printer control characters in it (and don't want to pass it through a s= ubsequent process to strip the print control characters), it seems to me th= at you would have to create a flat file (with sufficient formatting to repl= icate your report layout) using OPEN, WRITE, CLOSE statements. >>> yarlagaddacs@gmail.com 2005/07/05 10:55:43 >>> I use setup32.sqc to produce the report. It has Printer-init command in it. Is there another sqc to produce a landscape layout and not produce the printer characters. Chandra. On 7/1/05, Steve Cavill wrote: > That doesn't look like printer:lp that looks like PCL (printer:hp) > Printer:lp should be plain text. > You should check if you have a priner-init command in your sqr code which= looks like it may be incorrect. > Steve. >=20 > -----Original Message----- > From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org=20 > [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org] On= Behalf Of Alexander, Steve > Sent: Saturday, 2 July 2005 6:16 AM > To: 'This list is for discussion about the SQR database reportinglanguage= from Hyperion Solutions.' > Subject: RE: [sqr-users] Eliminate printer specific character from SQR re= port >=20 > I think those codes are specified in a "printer-init" command. In the Pe= oplesoft world, that command is part of the SETUPxxx.SQC > include files. >=20 > -----Original Message----- > From: Turner, Ivan [mailto:Ivan.Turner@qwest.com]=20 > Sent: Friday, July 01, 2005 10:59 AM > To: This list is for discussion about the SQR database reportinglanguage = fromHyperion Solutions. > Subject: RE: [sqr-users] Eliminate printer specific character from SQR re= port >=20 >=20 > The purpose of that line is to send control charachers to the printer for= things such as paper orientation, center, bold, etc. > There is no way I know of to remove them. If you copy the file to window= s, you can then COPY it to a printer path and it will give > you the orientation specified by the control characters. >=20 > Fron the command line of windows, > copy abc.lis //device/printer/abc.lis >=20 > -----Original Message----- > From: sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org=20 > [mailto:sqr-users-bounces+ivan.turner=3Dqwest.com@sqrug.org] On Behalf Of= Chandra Yarlagadda > Sent: Friday, July 01, 2005 1:13 PM > To: sqr-users@sqrug.org=20 > Subject: [sqr-users] Eliminate printer specific character from SQR report >=20 > Hi, >=20 > I am trying to produce an SQR report from an Unix machine in .lis format.= I am using the option of printer:lp. The report looks fine > when I view in VI editor except for the first line which looks like >=20 > ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G >=20 > I know this are printer specific character. But I need to send the report= output to mainframe and viewed from there. So I need an > option to eliminate these characters. >=20 > Can anyone help me in eliminating these character using any options. >=20 > Thanks, > Chandra >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org=20 > http://www.sqrug.org/mailman/listinfo/sqr-users=20 >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org=20 > http://www.sqrug.org/mailman/listinfo/sqr-users=20 >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org=20 > http://www.sqrug.org/mailman/listinfo/sqr-users=20 >=20 >=20 >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org=20 > http://www.sqrug.org/mailman/listinfo/sqr-users=20 > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Jul 03 22:04:49 2005 From: "ANUPEE PERLMUTTER" Date: Mon, 04 Jul 2005 03:03:48 +0000 Subject: [sqr-users] Re: Printing blank page after printing checks thru pay003 Hi, We have recently added a new logo and signature to our check print program pay003.sqr (PeoplSoft). Whenever we print a range of manual checks, it prints an extra blank page at the end. I have tried formfeed =NO. it printed more extra blank pages. It is printing to a HP laserjet TROY printer. I cannot find anything in the program that is causing this issue. The only part in the code is as follows: IF #begincheck <= #thrucheck new-page else end-if Please let me know if anybody has come across this problem or has a resolution. Thanks, Aupee IS Analyst _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 04 12:21:34 2005 From: "Denise White" Date: Mon, 4 Jul 2005 13:20:55 -0400 Subject: [sqr-users] Re: Printing blank page after printing checks Hi Aupee, I'm not familiar with that program, but if the code you posted is the only place it is causing a formfeed, I would try changing the <= to just <, as it would appear it is the time when they are equal that is causing that last formfeed. HTH, Denise White denisemwhite@earthlink.net EarthLink Revolves Around You. ---------------------------------------------------------------------- Message: 1 Date: Mon, 04 Jul 2005 03:03:48 +0000 From: "ANUPEE PERLMUTTER" Subject: [sqr-users] Re: Printing blank page after printing checks thru pay003 To: sqr-users@sqrug.org Message-ID: Content-Type: text/plain; format=flowed Hi, We have recently added a new logo and signature to our check print program pay003.sqr (PeoplSoft). Whenever we print a range of manual checks, it prints an extra blank page at the end. I have tried formfeed =NO. it printed more extra blank pages. It is printing to a HP laserjet TROY printer. I cannot find anything in the program that is causing this issue. The only part in the code is as follows: IF #begincheck <= #thrucheck new-page else end-if Please let me know if anybody has come across this problem or has a resolution. Thanks, Aupee IS Analyst _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 08:06:28 2005 From: June_Whelan-Contractor@adp.com Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? Date: Tue, 5 Jul 2005 09:08:14 -0400 Does anyone have any recommendations for useful (good) books on this subject? Thanks, June ----------------------------------------- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 08:18:52 2005 From: "the dragon" Subject: RE: [sqr-users] Any suggestions for a book on optimizing OracleS ql commands? Date: Tue, 05 Jul 2005 08:17:45 -0500 Download the pdf Sqr Reference manual for your version... http://dev.hyperion.com/resource_library/technical_documentation/ Also, amazon.com: SQR Programmer Reference-Second Edition SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 8.4 SQR Cheat Sheet 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---- Does anyone have any recommendations for useful (good) books on this subject? Thanks, June _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 08:50:10 2005 Subject: RE: [sqr-users] Any suggestions for a book on optimizing OracleS ql commands? Date: Tue, 5 Jul 2005 13:49:31 -0000 From: Hi. See also Harnessing SQR at http://www.sqrevangelism.com/ John Willson http://www.dssltd.com the dragon said: > Download the pdf Sqr Reference manual for your version... > http://dev.hyperion.com/resource_library/technical_documentation/ > > Also, amazon.com: > SQR Programmer Reference-Second Edition > SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 > 8.4 SQR Cheat Sheet > > 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---- > > Does anyone have any recommendations for useful (good) books on this > subject? > > Thanks, > June > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > -- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 09:21:10 2005 From: "the dragon" Subject: RE: [sqr-users] Any suggestions for a book on optimizing OracleS qlcommands? Date: Tue, 05 Jul 2005 09:20:06 -0500 Thanks! I wanted to include that one, but I couldn't remember it. dragon 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. See also Harnessing SQR at http://www.sqrevangelism.com/ John Willson http://www.dssltd.com the dragon said: > Download the pdf Sqr Reference manual for your version... > http://dev.hyperion.com/resource_library/technical_documentation/ > > Also, amazon.com: > SQR Programmer Reference-Second Edition > SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 > 8.4 SQR Cheat Sheet > > peace, > clark 'the dragon' willis > > > > ----Original Message Follows---- > > Does anyone have any recommendations for useful (good) books on this > subject? > > Thanks, > June > > > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 09:14:31 2005 Date: Tue, 05 Jul 2005 10:12:57 -0400 From: "George Jansen" Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? Have a look at _Optimizing Oracle Performance_ by Cary Millsap with Jeff Ho= lt, about $35 US from O'Reilly Associates.=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 11:08:37 2005 From: June_Whelan-Contractor@adp.com Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? Date: Tue, 5 Jul 2005 12:10:34 -0400 Thanks. I'll check into it! -----Original Message----- From: George Jansen [mailto:GJANSEN@aflcio.org] Sent: Tuesday, July 05, 2005 10:13 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? Have a look at _Optimizing Oracle Performance_ by Cary Millsap with Jeff Holt, about $35 US from O'Reilly Associates. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ----------------------------------------- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 05 11:00:02 2005 Date: Tue, 05 Jul 2005 12:02:14 -0400 From: "Robert K. Foster" Subject: [sqr-users] Re: Printing blank page after printing checks thru pay003 This is a multi-part message in MIME format... --------------020305080908020501090500 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Aupee, You say you added a logo and signature. The problem might be as simple as too many lines or dots on the page now that the new data is added. You might try counting lines or dots or shortening the page down to the bare minimum and see if that indicates the problem. Also check the page definition to make sure it matches the height of the logo and the number of lines. Once you introduce a bitmap or other graphic you need to calculate using dots instead of lines. Bob. sqr-users-request@sqrug.org wrote: > Hi, > > We have recently added a new logo and signature to our check print > program pay003.sqr (PeoplSoft). Whenever we print a range of manual > checks, it prints an extra blank page at the end. I have tried > formfeed =NO. it printed more extra blank pages. -- === Bob Foster Info. Systems Coordinator Mid-Michigan MRI, Inc. Direct Line: (517) 364-2673 rkf@radiology.msu.edu Need a Better Web Browser? Get Firefox! --------------020305080908020501090500 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'text/x-vcard' MIME type. It has been automatically discarded before sending the message to the list. --------------020305080908020501090500 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------020305080908020501090500-- From sqr-users-bounces@sqrug.org Tue Jul 05 11:15:15 2005 Subject: RE: [sqr-users] Re: Printing blank page after printing checks thrupay003 Date: Tue, 5 Jul 2005 12:14:08 -0400 From: "Beller, Jay" Aupee, You might want to examine your "signature". Depending on how your signatur= e was created (e.g., stripping bitmap data from another program), it might = contain a character (decimal 12) as the last byte and you would = need to strip it off.=20=20 Jay -----Original Message----- From: sqr-users-bounces+jbeller=3Dlbisoftware.com@sqrug.org [mailto:sqr-users-bounces+jbeller=3Dlbisoftware.com@sqrug.org]On Behalf Of Robert K. Foster Sent: Tuesday, July 05, 2005 12:02 PM To: sqr-users@sqrug.org Subject: [sqr-users] Re: Printing blank page after printing checks thrupay003 Aupee, You say you added a logo and signature. The problem might be as simple=20 as too many lines or dots on the page now that the new data is added.=20 You might try counting lines or dots or shortening the page down to the=20 bare minimum and see if that indicates the problem. Also check the page=20 definition to make sure it matches the height of the logo and the number=20 of lines. Once you introduce a bitmap or other graphic you need to=20 calculate using dots instead of lines. Bob. sqr-users-request@sqrug.org wrote: > Hi, > > We have recently added a new logo and signature to our check print=20 > program pay003.sqr (PeoplSoft). Whenever we print a range of manual=20 > checks, it prints an extra blank page at the end. I have tried=20 > formfeed =3DNO. it printed more extra blank pages. --=20 =3D=3D=3D Bob Foster Info. Systems Coordinator Mid-Michigan MRI, Inc. Direct Line: (517) 364-2673 rkf@radiology.msu.edu Need a Better Web Browser? Get Firefox! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 06 15:40:21 2005 Subject: RE: [sqr-users] Any suggestions for a book on optimizing Date: Wed, 6 Jul 2005 16:39:18 -0400 From: "Barilleaux, Rebecca" I really like SQL Performance Tuning by Peter Gulutzan and Trudy Pelzer. It's not Oracle specific, but covers performance tuning techniques for the "big 8 databases" including Oracle.=20 =20 =20 Date: Tue, 5 Jul 2005 09:08:14 -0400 From: June_Whelan-Contractor@adp.com Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? To: sqr-users@sqrug.org Message-ID: <4D6D27333868D611BD190002B3A6E4EB2802BE14@ROSEEXCHMB> Content-Type: text/plain Does anyone have any recommendations for useful (good) books on this subject? Thanks, June CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,=20 is for the sole use of the intended recipient(s) and may contain confidenti= al and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 06 15:47:11 2005 From: June_Whelan-Contractor@adp.com Subject: RE: [sqr-users] Any suggestions for a book on optimizing Date: Wed, 6 Jul 2005 16:49:11 -0400 Thanks! I'll check into it. I appreciate the feedback. -----Original Message----- From: Barilleaux, Rebecca [mailto:Rebecca.Barilleaux@anthem.com] Sent: Wednesday, July 06, 2005 4:39 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Any suggestions for a book on optimizing I really like SQL Performance Tuning by Peter Gulutzan and Trudy Pelzer. It's not Oracle specific, but covers performance tuning techniques for the "big 8 databases" including Oracle. Date: Tue, 5 Jul 2005 09:08:14 -0400 From: June_Whelan-Contractor@adp.com Subject: RE: [sqr-users] Any suggestions for a book on optimizing Oracle S ql commands? To: sqr-users@sqrug.org Message-ID: <4D6D27333868D611BD190002B3A6E4EB2802BE14@ROSEEXCHMB> Content-Type: text/plain Does anyone have any recommendations for useful (good) books on this subject? Thanks, June CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ----------------------------------------- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 11 08:43:41 2005 From: "tam kag" Date: Mon, 11 Jul 2005 13:42:38 +0000 Subject: [sqr-users] Exceptions in SQR Hello, I'm trying to write an exception report, I have copied this code from the Brio Manual. then published the file in Brio Portal and allowed exceptions to occur then subscribed to receive exceptions, then ran the job but I have not received the exception report. the code used: begin-program print 'testing exceptions' (5,5) move 'testing exceptions in SQR' to $excpetion_text do exception end-program begin-procedure exception open 'output.properties' as 0 for-append record=32767:vary write 0 from 'rating=high_priority' write 0 from 'exception.default=on' write 0 from $excpetion_text close 0 end-procedure Please advice. Thank you _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 12 06:25:15 2005 Subject: RE: [sqr-users] Exceptions in SQR Date: Tue, 12 Jul 2005 07:23:49 -0400 From: "Bob Buford" Hi Tam, Try fully qualifying the filename with complete path - it's possible that the file is being created in a folder that you didn't expect to be used.=20 Also you could get the status value when opening the 'output.properties' file and print that to the log. Code looks valid and you should have 2 files created: - output.properties - sqr.log, with 1 line entry 'testing exceptions'. Note that sqr.log might be named and located differently if you run it at batch server vs. client.=20 =20 Bob Buford -----Original Message----- From: tam kag [mailto:kaghdot@hotmail.com]=20 Sent: Monday, July 11, 2005 9:43 AM To: sqr-users@sqrug.org Subject: [sqr-users] Exceptions in SQR Hello, I'm trying to write an exception report, I have copied this code from the Brio Manual. then published the file in Brio Portal and allowed exceptions to occur then subscribed to receive exceptions, then ran the job but I have not received the exception report. the code used: begin-program print 'testing exceptions' (5,5) move 'testing exceptions in SQR' to $excpetion_text do exception end-program begin-procedure exception open 'output.properties' as 0 for-append record=3D32767:vary write 0 from 'rating=3Dhigh_priority' write 0 from 'exception.default=3Don' write 0 from $excpetion_text close 0 end-procedure Please advice. Thank you _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 14 05:20:12 2005 From: "Steve Cavill" Subject: RE: [sqr-users] Exceptions in SQR Date: Thu, 14 Jul 2005 20:18:50 +1000 I think you need: move 'exception.text=testing exceptions in SQR' to $excpetion_text Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of tam kag Sent: Monday, 11 July 2005 11:43 PM To: sqr-users@sqrug.org Subject: [sqr-users] Exceptions in SQR Hello, I'm trying to write an exception report, I have copied this code from the Brio Manual. then published the file in Brio Portal and allowed exceptions to occur then subscribed to receive exceptions, then ran the job but I have not received the exception report. the code used: begin-program print 'testing exceptions' (5,5) move 'testing exceptions in SQR' to $excpetion_text do exception end-program begin-procedure exception open 'output.properties' as 0 for-append record=32767:vary write 0 from 'rating=high_priority' write 0 from 'exception.default=on' write 0 from $excpetion_text close 0 end-procedure Please advice. Thank you _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 11 17:01:59 2005 Date: Mon, 11 Jul 2005 18:04:57 -0400 From: "Jolene Osei" Subject: [sqr-users] Extrating a CLOB and formating the output Hi Can someone help Please with a query to extract from Banner tables. I am extracting from a CLOB field and I would like the output to be in paragraph format. I have been looking at this SQR program http://www.sqrug.org/ftp/reflow_text.sq If there is anyone who can help expand on this program I would greatly appreciate it. Please help if there is anyone who can help crack this CLOB problem Thanks Sibonginkosi Jolene Osei Data Base Analyst Kalamazoo Valley Community College 6767 West 'O' Avenue Kalamazoo, MI 49003-4070 (269) 488-4139 phone (269) 488-4565 fax _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 12 10:55:03 2005 Date: Tue, 12 Jul 2005 08:54:04 -0700 From: "Howard Thompson" Subject: [sqr-users] SQR-4503 Errors with 0 line offset in print command (There is probably a way better way to accomplish what I'm trying to do...;= if so, let me know). I have a report that lists a person's name and from 0 to many messages for/= about the person. Person Name Message =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D Abel, Alan This is message 1 for Alan This is message 2 for Alan Builder, Betty This is the only message for Betty Corva, Charles=20=20=20=20=20=20=20=20=20 Davis, Danielle This is message 1 for Danielle This is message 2 for Danielle As I go through the process for a person, I store the messages in an array = and at the end of the person I print the name and then loop through the array to print any accumulated m= essages. On my first message for a person, I want the line offset to be 0; for subse= quent messages, I want the line offset to be +1 I tried the followoing and got the SQR 4503 error (presumably because if th= e line offset is a variable it can't be 0) PRINT $fmt_name (+1, {COL01}) Let #LineOffset =3D 0 LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit ! AryLimit is the number if me= ssages GET $RptMsg FROM MsgArray(#AryIdx) Msg PRINT $RptMsg (#LineOffset, {COL02}, 0) LET #LineOffset =3D +1 ADD 1 TO #AryIdx END-WHILE=20 The only way I can get it to work is this: LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit GET $RptMsg FROM MsgArray(#AryIdx) Msg IF #AryIdx =3D 0 ! First message PRINT $RptMsg (0, {COL03}, 0) ELSE PRINT $RptMsg (+1, {COL03}, 0) END-IF ADD 1 TO #AryIdx END-WHILE I appreciate any ideas. -- Howard Thompson Senior IS Project Lead Oregon Health & Science University thompsoh@ohsu.edu 503-494-5936 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 12 11:01:21 2005 Subject: RE: [sqr-users] SQR-4503 Errors with 0 line offset in print command Date: Tue, 12 Jul 2005 12:00:02 -0400 From: "Peter Burton" Howard, Begin-Report Print 'Line 1' (10,10) Let #Advance =3D 0 Print 'Part A' (+#Advance, 20) Let #Advance =3D 1 Print 'Part B' (+#Advance, 20) End-Report Produces Line 1 Part A Part B 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 Howard Thompson Sent: Tuesday, July 12, 2005 11:54 AM To: sqr-users@sqrug.org Subject: [sqr-users] SQR-4503 Errors with 0 line offset in print command (There is probably a way better way to accomplish what I'm trying to do...; if so, let me know). I have a report that lists a person's name and from 0 to many messages for/about the person. Person Name Message =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D Abel, Alan This is message 1 for Alan This is message 2 for Alan Builder, Betty This is the only message for Betty Corva, Charles=20=20=20=20=20=20=20=20=20 Davis, Danielle This is message 1 for Danielle This is message 2 for Danielle As I go through the process for a person, I store the messages in an array and at the end of the person I print the name and then loop through the array to print any accumulated messages. On my first message for a person, I want the line offset to be 0; for subsequent messages, I want the line offset to be +1 I tried the followoing and got the SQR 4503 error (presumably because if the line offset is a variable it can't be 0) PRINT $fmt_name (+1, {COL01}) Let #LineOffset =3D 0 LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit ! AryLimit is the number if messages GET $RptMsg FROM MsgArray(#AryIdx) Msg PRINT $RptMsg (#LineOffset, {COL02}, 0) LET #LineOffset =3D +1 ADD 1 TO #AryIdx END-WHILE=20 The only way I can get it to work is this: LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit GET $RptMsg FROM MsgArray(#AryIdx) Msg IF #AryIdx =3D 0 ! First message PRINT $RptMsg (0, {COL03}, 0) ELSE PRINT $RptMsg (+1, {COL03}, 0) END-IF ADD 1 TO #AryIdx END-WHILE I appreciate any ideas. -- Howard Thompson Senior IS Project Lead Oregon Health & Science University thompsoh@ohsu.edu 503-494-5936 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 12 11:07:20 2005 Date: Tue, 12 Jul 2005 09:06:22 -0700 From: kevin.reschenberg@sparkpath.com Subject: RE: [sqr-users] SQR-4503 Errors with 0 line offset in print command Try putting the plus sign in front of your offset variable: (+#LineOffset,,0) One line of your code is "LET #LineOffset = +1". In that situation, the plus sign doesn't count. SQR is simply treating that as the value 1. You need to code the plus sign in the PRINT offset to tell SQR that it's a relative offset and not an absolute position. Kevin Reschenberg SparkPath Technologies, Inc. sparkpath.com | sqr-info.com -------- Original Message -------- Subject: [sqr-users] SQR-4503 Errors with 0 line offset in print command From: "Howard Thompson" Date: Tue, July 12, 2005 8:54 am To: sqr-users@sqrug.org (There is probably a way better way to accomplish what I'm trying to do...; if so, let me know). I have a report that lists a person's name and from 0 to many messages for/about the person. Person Name Message ===================== =================================== Abel, Alan This is message 1 for Alan This is message 2 for Alan Builder, Betty This is the only message for Betty Corva, Charles Davis, Danielle This is message 1 for Danielle This is message 2 for Danielle As I go through the process for a person, I store the messages in an array and at the end of the person I print the name and then loop through the array to print any accumulated messages. On my first message for a person, I want the line offset to be 0; for subsequent messages, I want the line offset to be +1 I tried the followoing and got the SQR 4503 error (presumably because if the line offset is a variable it can't be 0) PRINT $fmt_name (+1, ) Let #LineOffset = 0 LET #AryIdx = 0 WHILE #AryIdx <= #AryLimit ! AryLimit is the number if messages GET $RptMsg FROM MsgArray(#AryIdx) Msg PRINT $RptMsg (#LineOffset, , 0) LET #LineOffset = +1 ADD 1 TO #AryIdx END-WHILE The only way I can get it to work is this: LET #AryIdx = 0 WHILE #AryIdx <= #AryLimit GET $RptMsg FROM MsgArray(#AryIdx) Msg IF #AryIdx = 0 ! First message PRINT $RptMsg (0, , 0) ELSE PRINT $RptMsg (+1, , 0) END-IF ADD 1 TO #AryIdx END-WHILE I appreciate any ideas. -- Howard Thompson Senior IS Project Lead Oregon Health & Science University thompsoh@ohsu.edu 503-494-5936 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 12 11:20:08 2005 Date: Tue, 12 Jul 2005 09:19:15 -0700 From: "Howard Thompson" Subject: RE: [sqr-users] SQR-4503 Errors with 0 line offset in print command Perfect, that did it; reading the error message I thought it was saying it = didn't like "+0" as a position, but I must not have deciphered the message = correctly. =20 I totally appreciate your quick response.=20 =20 =20 -- Howard Thompson Senior IS Project Lead Oregon Health & Science University thompsoh@ohsu.edu 503-494-5936 >>> kevin.reschenberg@sparkpath.com 07/12/05 9:06 AM >>> Try putting the plus sign in front of your offset variable:=20 (+#LineOffset,,0) One line of your code is "LET #LineOffset =3D +1". In that situation, the plus sign doesn't count. SQR is simply treating that as the value 1. You need to code the plus sign in the PRINT offset to tell SQR that it's a relative offset and not an absolute position. =20=20 Kevin Reschenberg SparkPath Technologies, Inc. sparkpath.com | sqr-info.com -------- Original Message -------- Subject: [sqr-users] SQR-4503 Errors with 0 line offset in print command From: "Howard Thompson" Date: Tue, July 12, 2005 8:54 am To: sqr-users@sqrug.org (There is probably a way better way to accomplish what I'm trying to do...; if so, let me know). I have a report that lists a person's name and from 0 to many messages for/about the person. Person Name Message =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D Abel, Alan This is message 1 for Alan This is message 2 for Alan Builder, Betty This is the only message for Betty Corva, Charles=20=20=20=20=20=20=20=20=20 Davis, Danielle This is message 1 for Danielle This is message 2 for Danielle As I go through the process for a person, I store the messages in an array and at the end of the person I print the name and then loop through the array to print any accumulated messages. On my first message for a person, I want the line offset to be 0; for subsequent messages, I want the line offset to be +1 I tried the followoing and got the SQR 4503 error (presumably because if the line offset is a variable it can't be 0) PRINT $fmt_name (+1, ) Let #LineOffset =3D 0 LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit ! AryLimit is the number if messages GET $RptMsg FROM MsgArray(#AryIdx) Msg PRINT $RptMsg (#LineOffset, , 0) LET #LineOffset =3D +1 ADD 1 TO #AryIdx END-WHILE=20 The only way I can get it to work is this: LET #AryIdx =3D 0 WHILE #AryIdx <=3D #AryLimit GET $RptMsg FROM MsgArray(#AryIdx) Msg IF #AryIdx =3D 0 ! First message PRINT $RptMsg (0, , 0) ELSE PRINT $RptMsg (+1, , 0) END-IF ADD 1 TO #AryIdx END-WHILE I appreciate any ideas. -- Howard Thompson Senior IS Project Lead Oregon Health & Science University thompsoh@ohsu.edu 503-494-5936 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users=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 Tue Jul 19 11:48:09 2005 From: "tam kag" Date: Tue, 19 Jul 2005 16:47:05 +0000 Subject: [sqr-users] Running a SQR program from another SQR program Hello, Within my SQR(program A), I'm trying to execute another SQR(program B) by building a string variable and using the CALL SYSTEM command. I have tested my command by typing it manually and running it in our AIX box, the command ran successfully, but when I copy the same command an paste it in program A it is returning an error code 6. any info is most appreciated Thanks _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 19 12:06:36 2005 Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 12:05:55 -0500 From: "Knapp, Richard" Is there any text with the error code? Is it SQR or the operating system that is originating the error? Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 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 tam kag Sent: Tuesday, July 19, 2005 11:47 AM To: sqr-users@sqrug.org Subject: [sqr-users] Running a SQR program from another SQR program Hello, Within my SQR(program A), I'm trying to execute another SQR(program B) by=20 building a string variable and using the CALL SYSTEM command. I have tested my command by typing it manually and running it in our AIX box, the command ran successfully, but when I copy the same command an paste=20 it in program A it is returning an error code 6. any info is most appreciated Thanks _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 19 12:25:55 2005 From: "tam kag" Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 17:24:50 +0000 the error code is the code returned from CALL SYSTEM USING $cmd_ln #return_status. #return_status is equal to 6, I couldn't find out what error code 6 means >From: "Knapp, Richard" >Reply-To: "This list is for discussion about the SQR database >reportinglanguage from Hyperion Solutions." >To: "This list is for discussion about the SQR database reportinglanguage >fromHyperion Solutions." >Subject: RE: [sqr-users] Running a SQR program from another SQR program >Date: Tue, 19 Jul 2005 12:05:55 -0500 > > >Is there any text with the error code? Is it SQR or the operating >system that is originating the error? > >Richard Knapp >Database Programmer/Analyst >Institutional Research and Planning >University of Missouri System >573-882-8856 >knappr@umsystem.edu > >-----Original Message----- >From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org >[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of >tam kag >Sent: Tuesday, July 19, 2005 11:47 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] Running a SQR program from another SQR program > >Hello, >Within my SQR(program A), I'm trying to execute another SQR(program B) >by >building a string variable and using the CALL SYSTEM command. > >I have tested my command by typing it manually and running it in our AIX > >box, the command ran successfully, but when I copy the same command an >paste >it in program A it is returning an error code 6. > >any info is most appreciated > >Thanks > > > >_______________________________________________ >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 Jul 19 12:33:06 2005 Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 12:32:30 -0500 From: "Knapp, Richard" That's the operating system. Somewhere AIX documents what that error code means. All of the operations are run on the AIX box, right? No windows clients involved? Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 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 tam kag Sent: Tuesday, July 19, 2005 12:25 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Running a SQR program from another SQR program the error code is the code returned from CALL SYSTEM USING $cmd_ln=20 #return_status. #return_status is equal to 6, I couldn't find out what error code 6 means >From: "Knapp, Richard" >Reply-To: "This list is for discussion about the SQR database=20 >reportinglanguage from Hyperion Solutions." >To: "This list is for discussion about the SQR database reportinglanguage=20 >fromHyperion Solutions." >Subject: RE: [sqr-users] Running a SQR program from another SQR program >Date: Tue, 19 Jul 2005 12:05:55 -0500 > > >Is there any text with the error code? Is it SQR or the operating >system that is originating the error? > >Richard Knapp >Database Programmer/Analyst >Institutional Research and Planning >University of Missouri System >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 >tam kag >Sent: Tuesday, July 19, 2005 11:47 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] Running a SQR program from another SQR program > >Hello, >Within my SQR(program A), I'm trying to execute another SQR(program B) >by >building a string variable and using the CALL SYSTEM command. > >I have tested my command by typing it manually and running it in our AIX > >box, the command ran successfully, but when I copy the same command an >paste >it in program A it is returning an error code 6. > >any info is most appreciated > >Thanks > > > >_______________________________________________ >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 Jul 19 12:37:10 2005 From: "tam kag" Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 17:36:06 +0000 Yes all the operations are on the AIX machine >From: "Knapp, Richard" >Reply-To: "This list is for discussion about the SQR database >reportinglanguage from Hyperion Solutions." >To: "This list is for discussion about the SQR database reportinglanguage >fromHyperion Solutions." >Subject: RE: [sqr-users] Running a SQR program from another SQR program >Date: Tue, 19 Jul 2005 12:32:30 -0500 > > >That's the operating system. Somewhere AIX documents what that error >code means. > >All of the operations are run on the AIX box, right? No windows clients >involved? > >Richard Knapp >Database Programmer/Analyst >Institutional Research and Planning >University of Missouri System >573-882-8856 >knappr@umsystem.edu > >-----Original Message----- >From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org >[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of >tam kag >Sent: Tuesday, July 19, 2005 12:25 PM >To: sqr-users@sqrug.org >Subject: RE: [sqr-users] Running a SQR program from another SQR program > >the error code is the code returned from CALL SYSTEM USING $cmd_ln >#return_status. > >#return_status is equal to 6, I couldn't find out what error code 6 >means > > > > >From: "Knapp, Richard" > >Reply-To: "This list is for discussion about the SQR database > >reportinglanguage from Hyperion Solutions." > >To: "This list is for discussion about the SQR database >reportinglanguage > >fromHyperion Solutions." > >Subject: RE: [sqr-users] Running a SQR program from another SQR program > >Date: Tue, 19 Jul 2005 12:05:55 -0500 > > > > > >Is there any text with the error code? Is it SQR or the operating > >system that is originating the error? > > > >Richard Knapp > >Database Programmer/Analyst > >Institutional Research and Planning > >University of Missouri System > >573-882-8856 > >knappr@umsystem.edu > > > >-----Original Message----- > >From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org > >[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of > >tam kag > >Sent: Tuesday, July 19, 2005 11:47 AM > >To: sqr-users@sqrug.org > >Subject: [sqr-users] Running a SQR program from another SQR program > > > >Hello, > >Within my SQR(program A), I'm trying to execute another SQR(program B) > >by > >building a string variable and using the CALL SYSTEM command. > > > >I have tested my command by typing it manually and running it in our >AIX > > > >box, the command ran successfully, but when I copy the same command an > >paste > >it in program A it is returning an error code 6. > > > >any info is most appreciated > > > >Thanks > > > > > > > >_______________________________________________ > >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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 19 14:30:36 2005 From: "the dragon" Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 14:28:31 -0500 My guess off the top of my head.... When you call the new sqr from the old sqr you're shelling out without inheriting the environment variables. You'll probably need to use fully qualified paths. 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---- Yes all the operations are on the AIX machine >That's the operating system. Somewhere AIX documents what that error >code means. > >All of the operations are run on the AIX box, right? No windows clients >involved? > >Richard Knapp > >-----Original Message----- > >the error code is the code returned from CALL SYSTEM USING $cmd_ln >#return_status. > >#return_status is equal to 6, I couldn't find out what error code 6 >means > > > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Jul 19 15:44:35 2005 Subject: RE: [sqr-users] Running a SQR program from another SQR program Date: Tue, 19 Jul 2005 15:43:45 -0500 From: "Knapp, Richard" Also my intuition. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 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 the dragon Sent: Tuesday, July 19, 2005 2:29 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Running a SQR program from another SQR program My guess off the top of my head.... When you call the new sqr from the old=20 sqr you're shelling out without inheriting the environment variables.=20=20 You'll probably need to use fully qualified paths. 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---- Yes all the operations are on the AIX machine >That's the operating system. Somewhere AIX documents what that error >code means. > >All of the operations are run on the AIX box, right? No windows clients >involved? > >Richard Knapp > >-----Original Message----- > >the error code is the code returned from CALL SYSTEM USING $cmd_ln >#return_status. > >#return_status is equal to 6, I couldn't find out what error code 6 >means > > > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 01:56:13 2005 From: Amol Gokhale Date: Wed, 20 Jul 2005 12:25:40 +0530 Subject: [sqr-users] sqr command line parameters not being accepted Hi, I am trying to accept parameters in an SQR file from the command line and unfortunately the parameters are not being accepted. I have given a print command on the parameter and it is not being printed.. I've posted my program below. I dont know whats wrong. begin-setup Declare-Variable ! default-numeric = Decimal(12) Text $num End-Declare ask $num !random number end-setup begin-program print $num (1) center do accept_params end-program !-----------------------------------------------------------------------! ! Function: ! Description: This procedure !-----------------------------------------------------------------------! begin-procedure accept_params #debug show '===>' #debug show $num print $num (1) center end-procedure Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 04:36:23 2005 From: "Syed Husain" Subject: RE: [sqr-users] sqr command line parameters not being accepted Date: Wed, 20 Jul 2005 15:04:10 +0530 Hi Amol, Try the code below.I think this should work fine. begin-setup Declare-Variable ! default-numeric = Decimal(12) Text $num End-Declare ask number end-setup begin-program let $num = {number} print $num (1) center do accept_params end-program !-----------------------------------------------------------------------! ! Function: ! Description: This procedure !-----------------------------------------------------------------------! begin-procedure accept_params #debug show '===>' #debug show $num print $num (1) center end-procedure -----Original Message----- From: sqr-users-bounces+syed.husain=patni.com@sqrug.org [mailto:sqr-users-bounces+syed.husain=patni.com@sqrug.org]On Behalf Of Amol Gokhale Sent: Wednesday, July 20, 2005 12:26 PM To: sqr-users@sqrug.org Subject: [sqr-users] sqr command line parameters not being accepted Hi, I am trying to accept parameters in an SQR file from the command line and unfortunately the parameters are not being accepted. I have given a print command on the parameter and it is not being printed.. I've posted my program below. I dont know whats wrong. begin-setup Declare-Variable ! default-numeric = Decimal(12) Text $num End-Declare ask $num !random number end-setup begin-program print $num (1) center do accept_params end-program !-----------------------------------------------------------------------! ! Function: ! Description: This procedure !-----------------------------------------------------------------------! begin-procedure accept_params #debug show '===>' #debug show $num print $num (1) center end-procedure Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 06:45:13 2005 Subject: RE: [sqr-users] sqr command line parameters not being accepted From: Amol Gokhale Date: Wed, 20 Jul 2005 17:14:33 +0530 -----sqr-users-bounces+amol.gokhale=mindcraftsoftware.com@sqrug.org wrote: ----- > >Hi Amol, > >Try the code below.I think this should work fine. > >begin-setup >Declare-Variable >! default-numeric = Decimal(12) > Text $num >End-Declare > ask number > >end-setup >begin-program > > let $num = {number} > print $num (1) center > do accept_params > >end-program >!-------------------------------------------------------------------- >---! >! Function: >! Description: This procedure >!-------------------------------------------------------------------- >---! >begin-procedure accept_params > #debug show '===>' > #debug show $num > print $num (1) center >end-procedure > Nope did not work. Gave the following error. What say??? Error on line 11: (SQR 4008) Unknown function or variable in expression: amol let $num = amol Bye, Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 06:49:05 2005 Subject: RE: [sqr-users] sqr command line parameters not being accepted From: Amol Gokhale Date: Wed, 20 Jul 2005 17:16:16 +0530 -----sqr-users-bounces+amol.gokhale=mindcraftsoftware.com@sqrug.org wrote: ----- >Hi Amol, > >Try the code below.I think this should work fine. > >begin-setup >Declare-Variable >! default-numeric = Decimal(12) > Text $num >End-Declare > ask number > >end-setup >begin-program > > let $num = {number} > print $num (1) center > do accept_params > >end-program >!-------------------------------------------------------------------- >---! >! Function: >! Description: This procedure >!-------------------------------------------------------------------- >---! >begin-procedure accept_params > #debug show '===>' > #debug show $num > print $num (1) center >end-procedure Nope gave the following error Error on line 11: (SQR 4008) Unknown function or variable in expression: amol let $num = amol Any ideas???? Bye, Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 21 01:20:24 2005 From: "Syed Husain" Subject: RE: [sqr-users] sqr command line parameters not being accepted Date: Thu, 21 Jul 2005 11:49:25 +0530 Amol, Give the input parameter ('amol') in quotes if you are using 'ask' command. If you want to enter a number then you can enter 1,2,3 etc without quotes. Other option is use Input command in the program section itself. Syed -----Original Message----- From: sqr-users-bounces+syed.husain=patni.com@sqrug.org [mailto:sqr-users-bounces+syed.husain=patni.com@sqrug.org]On Behalf Of Amol Gokhale Sent: Wednesday, July 20, 2005 5:16 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] sqr command line parameters not being accepted -----sqr-users-bounces+amol.gokhale=mindcraftsoftware.com@sqrug.org wrote: ----- >Hi Amol, > >Try the code below.I think this should work fine. > >begin-setup >Declare-Variable >! default-numeric = Decimal(12) > Text $num >End-Declare > ask number > >end-setup >begin-program > > let $num = {number} > print $num (1) center > do accept_params > >end-program >!-------------------------------------------------------------------- >---! >! Function: >! Description: This procedure >!-------------------------------------------------------------------- >---! >begin-procedure accept_params > #debug show '===>' > #debug show $num > print $num (1) center >end-procedure Nope gave the following error Error on line 11: (SQR 4008) Unknown function or variable in expression: amol let $num = amol Any ideas???? Bye, Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 08:35:09 2005 From: "Steve Cavill" Subject: RE: [sqr-users] sqr command line parameters not being accepted Date: Wed, 20 Jul 2005 23:33:57 +1000 Change your ASK to INPUT, and move it to the main part of the program (not the setup section) Unless you really need a substitution variable. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of Amol Gokhale Sent: Wednesday, 20 July 2005 4:56 PM To: sqr-users@sqrug.org Subject: [sqr-users] sqr command line parameters not being accepted Hi, I am trying to accept parameters in an SQR file from the command line and unfortunately the parameters are not being accepted. I have given a print command on the parameter and it is not being printed.. I've posted my program below. I dont know whats wrong. begin-setup Declare-Variable ! default-numeric = Decimal(12) Text $num End-Declare ask $num !random number end-setup begin-program print $num (1) center do accept_params end-program !-----------------------------------------------------------------------! ! Function: ! Description: This procedure !-----------------------------------------------------------------------! begin-procedure accept_params #debug show '===>' #debug show $num print $num (1) center end-procedure Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ 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 Jul 21 00:09:56 2005 Subject: RE: [sqr-users] sqr command line parameters not being accepted From: Amol Gokhale Date: Thu, 21 Jul 2005 10:39:28 +0530 >From: "Steve Cavill" >Change your ASK to INPUT, and move it to the main part of the program >(not the setup section) >Unless you really need a substitution variable. >Steve. I made those changes and it worked. I am pasting the working program below. begin-setup Declare-Variable Text $num End-Declare end-setup begin-program input $num print $num (1) center do accept_params end-program !-----------------------------------------------------------------------! ! Function: ! Description: This procedure !-----------------------------------------------------------------------! begin-procedure accept_params #debug show '===>' #debug show $num print $num (1) center end-procedure Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 03:37:45 2005 Date: Wed, 20 Jul 2005 14:05:20 +0530 From: "Manas Ranjan Nayak" Subject: [sqr-users] list Box and Drop Down for filter condition in Hyperion SQR Hi I have earlier worked with Brio Query 6.5, Brio Insight (web version of the same), On Demand Server and Broadcast server. I will be working on BRIO SQR in my present assignment for 4 weeks. I have gone through the user manual of 'Hyperion SQR Developer'. I need the following clarification from the group. =0D 1. I have the understanding that Brio SQR is a scale down version of Brio Reports. Brio report has EIS section, Dashboard, VB Scripting etc. Is my assumption correct?=0D 2. We can use the Wizard Based SQR Report Developer or simply write the report code in a note pad and save it as .sqr extension file. Are both these facilities are available with the package?=0D 3. Users want to filter the where condition using list box and drop down box. (i.e. List of all employees can be shown and user can have the option of selecting one or many from it). I have read about prompts at the run time, where the user can key in a particular value. However not sure if a list box to select one or multiple values can be provided (This is possible in EIS Section of Brio Query). =0D =0D Thanks & Regards, Manas=0D =0D =0D **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solel= y for the use of the addressee(s). If you are not the intended recipient, p= lease notify the sender by e-mail and delete the original message. Further,= you are not to copy, disclose, or distribute this e-mail or its contents t= o any other person and any such actions are unlawful. This e-mail may conta= in viruses. Infosys has taken every reasonable precaution to minimize this = risk, but is not liable for any damage you may sustain as a result of any v= irus in this e-mail. You should carry out your own virus checks before open= ing the e-mail or attachment. Infosys reserves the right to monitor and rev= iew the content of all messages sent to or from this e-mail address. Messag= es sent to or from this e-mail address may be stored on the Infosys e-mail = system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 12:41:38 2005 From: "Marc Taquoi" Date: Wed, 20 Jul 2005 19:41:03 +0200 Subject: [sqr-users] Error during execution with NewGraphic Hello, I use SQR 8.2.0 with NewGraphic. During the execution I have this error : FAiled to start the Java Virtual Machine . Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. I have verify my SQR.INI. The [JRE] section is correct. I have the good programs at the good place. I don't understand. Do you have an idee ? Please advice. Thank you M.T. Technologies Marc TAQUOI marc.taquoi@bluewin.ch T=E9l=E9phone : +41 (0)21 624 21 27 Mobile : +41 (0)79 818 52 35 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 14:10:31 2005 Subject: RE: [sqr-users] Error during execution with NewGraphic Date: Wed, 20 Jul 2005 14:09:59 -0500 From: "Knapp, Richard" Are you able to run any java code on your machine? Are you using SQRW? Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 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 Marc Taquoi Sent: Wednesday, July 20, 2005 12:41 PM To: sqr-users@sqrug.org Subject: [sqr-users] Error during execution with NewGraphic Hello, I use SQR 8.2.0 with NewGraphic. During the execution I have this error : FAiled to start the Java Virtual Machine . Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. I have verify my SQR.INI. The [JRE] section is correct. I have the good programs at the good place. I don't understand. Do you have an idee ? Please advice. Thank you M.T. Technologies Marc TAQUOI marc.taquoi@bluewin.ch T=E9l=E9phone : +41 (0)21 624 21 27 Mobile : +41 (0)79 818 52 35 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 16:09:56 2005 From: "Marc Taquoi" Subject: RE: [sqr-users] Error during execution with NewGraphic Date: Wed, 20 Jul 2005 23:09:20 +0200 Yes, I use SQRW -----Message d'origine----- De : sqr-users-bounces+marc.taquoi=3Dbluewin.ch@sqrug.org [mailto:sqr-users-bounces+marc.taquoi=3Dbluewin.ch@sqrug.org]De la part de Knapp, Richard Envoy=E9 : mercredi 20 juillet 2005 21:10 =C0 : This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Objet : RE: [sqr-users] Error during execution with NewGraphic Are you able to run any java code on your machine? Are you using SQRW? Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 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 Marc Taquoi Sent: Wednesday, July 20, 2005 12:41 PM To: sqr-users@sqrug.org Subject: [sqr-users] Error during execution with NewGraphic Hello, I use SQR 8.2.0 with NewGraphic. During the execution I have this error : FAiled to start the Java Virtual Machine . Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. I have verify my SQR.INI. The [JRE] section is correct. I have the good programs at the good place. I don't understand. Do you have an idee ? Please advice. Thank you M.T. Technologies Marc TAQUOI marc.taquoi@bluewin.ch T=E9l=E9phone : +41 (0)21 624 21 27 Mobile : +41 (0)79 818 52 35 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 20 22:07:15 2005 From: "Victor Loghin" Date: Wed, 20 Jul 2005 23:06:08 -0400 Subject: [sqr-users] DB2 timing report of SQL statements in a SQR program Fellow Listers, I have developed a program to produce a timing report of the SQL statements in a SQR programs run on DB2 for z/OS. I have been using it for a while and have found it very useful in identifying SQL performance problems. I have made it available for download on my web site. I call this tool the SQL Timor. It is used in conjunction with another tool called the Formator. The Formator reads in a SQR program and insert calls to the SQL Timor for all SQL statements. The modified code is run and the timing report is displayed at the end of the program. Even though it is written specifically for DB2 on z/OS, it should work with DB2 UDB on Linux, UNIX and Windows. The only call to the database is to get the current timestamp from SYSIBM.SYSDUMMY1 and my understanding it is supported on UDB. If anyone tries it on DB2 UDB, please let me know if it works. Documentation for can be found at SQLTimor and Formator. Both can be downloaded from http://www.vgl.ca/Download/_main.htm. Victor Loghin VGL Consulting Inc. VictorLoghin@vgl.ca www.vgl.ca _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 21 08:10:50 2005 From: Amol Gokhale Date: Thu, 21 Jul 2005 18:40:24 +0530 Subject: [sqr-users] A bit Off Topic Hi, Is there a list for Application Designer as well?? This forum is not the right one to solve my problems on those issues. Lemme know if anybody knows of anything Amol Gokhale Consultant MindCraft Software Pvt. Ltd. 'Building excellence, delivering value..' www.mcsil.com Tel :+91-22-5692-6200/ 5699-6200 Fax:+91-22-5693-9730 DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorized. Any use, distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. DISCLAIMER The information in this email is confidential and intended solely for the addressee. Access to this email by anyone else is unauthorised. Any use,distribution, copying or disclosure by any other person is strictly prohibited and may be illegal. If you received this in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of MindCraft shall be understood to be neither given nor endorsed by MindCraft. When addressed to our clients the contents in this email are subject to the terms and conditions expressed in the governing client engagement policy. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 21 16:12:39 2005 From: "radhika reddy" Date: Thu, 21 Jul 2005 16:11:33 -0500 Subject: [sqr-users] SPF Hi, My program generates a PDF format error report. But when the program abends it generated an SPF format. What is the reason for this to happen? and can i view this file. Documentation says that i can view using SPF viewer. Does this come with the SQR? I am running through Process Scheduler. Thanks. Any input would be great. _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 22 07:23:34 2005 Subject: Re: [sqr-users] SPF From: Ramzi_Salameh@daveandbusters.com Date: Fri, 22 Jul 2005 07:20:39 -0500 --===============1892972139== Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 WWVzLCB0aGUgZXhlY3V0YWJsZSBpcyBjYWxsZWQgc3Fyd3YuZXhlLiAgRGVw ZW5kaW5nIG9uIHdoaWNoIHZlcnNpb24gb2YgDQpQZW9wbGVUb29scyB5b3Un cmUgcnVubmluZywgaXQgd2lsbCByZXNpZGUgaW4gdmFyaW91cyBsb2NhdGlv bnMsIGJ1dCB3aWxsIA0KYmUgc29tZXRoaW5nIGxpa2UgW1BTX0hPTUVdXGJp blxzcXJcTVNTXEJJTldcLg0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KUmFtemkgU2FsYW1laA0K U2VuaW9yIFRlY2huaWNhbCBBbmFseXN0DQooMjE0KSA5MDQtMjU1MA0KDQpE YXZlIGFuZCBCdXN0ZXIncywgSW5jLg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KDQoNCg0KInJh ZGhpa2EgcmVkZHkiIDxyYWRoaWthXzA1QGhvdG1haWwuY29tPg0KU2VudCBi eTogc3FyLXVzZXJzLWJvdW5jZXMrcmFtemlfc2FsYW1laD1kYXZlYW5kYnVz dGVycy5jb21Ac3FydWcub3JnDQowNy8yMS8yMDA1IDA0OjExIFBNDQpQbGVh c2UgcmVzcG9uZCB0byAiVGhpcyBsaXN0IGlzIGZvciBkaXNjdXNzaW9uIGFi b3V0IHRoZSBTUVIgZGF0YWJhc2UgDQpyZXBvcnRpbmcgICAgICAgbGFuZ3Vh Z2UgZnJvbSBIeXBlcmlvbiBTb2x1dGlvbnMuIg0KIA0KICAgICAgICBUbzog ICAgIHNxci11c2Vyc0BzcXJ1Zy5vcmcNCiAgICAgICAgY2M6IA0KICAgICAg ICBTdWJqZWN0OiAgICAgICAgW3Nxci11c2Vyc10gU1BGDQoNCg0KSGksDQoN CiAgIE15IHByb2dyYW0gZ2VuZXJhdGVzIGEgUERGIGZvcm1hdCBlcnJvciBy ZXBvcnQuIEJ1dCB3aGVuIHRoZSBwcm9ncmFtIA0KYWJlbmRzIGl0IGdlbmVy YXRlZCBhbiBTUEYgZm9ybWF0LiBXaGF0IGlzIHRoZSByZWFzb24gZm9yIHRo aXMgdG8gaGFwcGVuPyANCmFuZCBjYW4gaSB2aWV3IHRoaXMgZmlsZS4gRG9j dW1lbnRhdGlvbiBzYXlzIHRoYXQgaSBjYW4gdmlldyB1c2luZyBTUEYgDQp2 aWV3ZXIuIERvZXMgdGhpcyBjb21lIHdpdGggdGhlIFNRUj8NCg0KSSBhbSBy dW5uaW5nIHRocm91Z2ggUHJvY2VzcyBTY2hlZHVsZXIuDQoNClRoYW5rcy4g QW55IGlucHV0IHdvdWxkIGJlIGdyZWF0Lg0KDQpfX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXw0KRlJFRSBwb3AtdXAgYmxvY2tpbmcgd2l0aCB0aGUgbmV3IE1TTiBU b29sYmFyIOKAkyBnZXQgaXQgbm93ISANCmh0dHA6Ly90b29sYmFyLm1zbi5j bGljay11cmwuY29tL2dvL29ubTAwMjAwNDE1YXZlL2RpcmVjdC8wMS8NCg0K DQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXw0Kc3FyLXVzZXJzIG1haWxpbmcgbGlzdA0Kc3FyLXVzZXJ