From sqr-users-bounces@sqrug.org Sat Jul 01 00:02:11 2006 Date: Sat, 1 Jul 2006 00:00:02 -0400 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.22 $ $Date: 2005/08/19 05:12:40 $ This document gathers in one location information about the sqr-users mail list. It includes instructions for changing your subscription settings (including unsubscribing), as well are guidelines for using the list. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Interacting with the list server 3.1 Subscribing to the list 3.2 Unsubscribing from the list 3.3 When your email address changes 3.4 Digests 3.5 Obtaining your password 3.6 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2004/03/04: o New name and URL for "HyperionSQR" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.org/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2004 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. HyperionSQR : Hyperion- SQR List for discussion of SQR, SQR Developer (formerly called Brio.Report and Report Builder), and SQR iServer. To join, follow the link above, or send any message to "HyperionSQR- subscribe@yahoogroups.com". rm-users : Report- Mart Users List for discussion of Brio Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. If you use digests, you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list as other subscribers' mail systems repond....) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQR product name and version number (see notes below) o Operating system name and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 07 14:55:45 2006 Date: Fri, 7 Jul 2006 12:53:18 -0600 From: "Ackerson, Glenn" Subject: [sqr-users] Easy way to find count of delimiters in unstring? Hi all, Any suggestions on finding a count of the number of comma delimiters on a variable length, comma-separated (.csv) file I'm processing? I'm able to successfully parse values in each record no problem, using the unstring command. But, the situation I'm trying to determine options on is to find out how many comma delimiters exist on each record. Unfortunately, the vendor who created this file didn't consistently use commas in every case where a value doesn't exist. Any ideas anyone? If so, since I subscribe in digest mode, would you kindly respond to me directly? Thanks much. Cheers, Glenn ************************************************** Glenn Ackerson Phone: (970) 351-1460 Information Technology Professional III Fax: (970) 351-1650 Internet Address: Glenn.Ackerson@Unco.edu University of Northern Colorado Information Technology=20=20 Carter Hall Greeley, CO 80639 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 07 15:03:22 2006 Subject: RE: [sqr-users] Easy way to find count of delimiters in unstring? Date: Fri, 7 Jul 2006 14:01:22 -0500 From: "Knapp, Richard" Create a function to count 'em using pos and instr. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Ackerson, Glenn Sent: Friday, July 07, 2006 1:53 PM To: sqr-users@sqrug.org Subject: [sqr-users] Easy way to find count of delimiters in unstring? Hi all, Any suggestions on finding a count of the number of comma delimiters on a variable length, comma-separated (.csv) file I'm processing? I'm able to successfully parse values in each record no problem, using the unstring command. But, the situation I'm trying to determine options on is to find out how many comma delimiters exist on each record. Unfortunately, the vendor who created this file didn't consistently use commas in every case where a value doesn't exist. Any ideas anyone? If so, since I subscribe in digest mode, would you kindly respond to me directly? Thanks much. Cheers, Glenn ************************************************** Glenn Ackerson Phone: (970) 351-1460 Information Technology Professional III Fax: (970) 351-1650 Internet Address: Glenn.Ackerson@Unco.edu University of Northern Colorado Information Technology=20=20 Carter Hall Greeley, CO 80639 _______________________________________________ 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 07 15:14:32 2006 From: "Alexander, Steven" Subject: RE: [sqr-users] Easy way to find count of delimiters in unstring? Date: Fri, 7 Jul 2006 12:08:58 -0700 Use translate to replace all the commas with null, then subtract the length of the new string from the length of the original string. -----Original Message----- From: Knapp, Richard [mailto:KnappR@umsystem.edu] Sent: Friday, July 07, 2006 12:01 PM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Easy way to find count of delimiters in unstring? Create a function to count 'em using pos and instr. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of Ackerson, Glenn Sent: Friday, July 07, 2006 1:53 PM To: sqr-users@sqrug.org Subject: [sqr-users] Easy way to find count of delimiters in unstring? Hi all, Any suggestions on finding a count of the number of comma delimiters on a variable length, comma-separated (.csv) file I'm processing? I'm able to successfully parse values in each record no problem, using the unstring command. But, the situation I'm trying to determine options on is to find out how many comma delimiters exist on each record. Unfortunately, the vendor who created this file didn't consistently use commas in every case where a value doesn't exist. Any ideas anyone? If so, since I subscribe in digest mode, would you kindly respond to me directly? Thanks much. Cheers, Glenn ************************************************** Glenn Ackerson Phone: (970) 351-1460 Information Technology Professional III Fax: (970) 351-1650 Internet Address: Glenn.Ackerson@Unco.edu University of Northern Colorado Information Technology Carter Hall Greeley, CO 80639 _______________________________________________ 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 07 15:11:19 2006 Date: Fri, 07 Jul 2006 12:09:17 -0700 From: kevin.reschenberg@sparkpath.com Subject: RE: [sqr-users] Easy way to find count of delimiters in unstring? let #CommaCount = length($MyString) - length(replace($MyString, ',', '')) Kevin Reschenberg SparkPath Technologies, Inc. sparkpath.com | sqr-info.com -------- Original Message -------- Subject: [sqr-users] Easy way to find count of delimiters in unstring? From: "Ackerson, Glenn" Date: Fri, July 07, 2006 11:53 am To: Hi all, Any suggestions on finding a count of the number of comma delimiters on a variable length, comma-separated (.csv) file I'm processing? I'm able to successfully parse values in each record no problem, using the unstring command. But, the situation I'm trying to determine options on is to find out how many comma delimiters exist on each record. Unfortunately, the vendor who created this file didn't consistently use commas in every case where a value doesn't exist. Any ideas anyone? If so, since I subscribe in digest mode, would you kindly respond to me directly? Thanks much. Cheers, Glenn ************************************************** Glenn Ackerson Phone: (970) 351-1460 Information Technology Professional III Fax: (970) 351-1650 Internet Address: Glenn.Ackerson@Unco.edu University of Northern Colorado Information Technology Carter Hall Greeley, CO 80639 _______________________________________________ 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 13 10:08:08 2006 Date: Thu, 13 Jul 2006 10:05:55 -0400 From: "Laura Mayer" Subject: [sqr-users] Stuck in array He!! Morning, I inherited this code from a prior employee and from what I can discern it = creates an infinite loop that keeps iterating through all the records in a = text file over and over again. I can't seem to fix it. I've even made it so= there are only 9 records in the text file. Be advised it is the crudest code I have ever come across. What its suppose= d to do is read a text file into an array and process the data. It never se= ems to finish. Is there a better way to write this mess? Thanks for any and all help you can offer Laura !************************************************************************ Begin-Procedure Select_Records !************************************************************************ ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed=20 ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into arr= ay. !************************************************************************ Read 1 into $Input_Str:8 let #index=3D0 While not #End-File=09 let $InputEmplid =3D substr($Input_Str, 1, 8) let $EMPLID =3D $InputEmplid=20 =09 Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed=3D'N' ! not processed let IDPrinted.emplid(#Index) =3D $EMPLID !add id to array. ID proce= ssed add 1 to #index let $PrintFlag =3D 'Y' let $period =3D $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found=3D'Y' ! found row in perf table if $RoomMateFound=3D'N' ! but both rm1 and rm2 empty let $prType =3D 'S' else !Has rmts let $InputIdRM1=3D &A.UMH_PREF_ROOMMATE1 let $InputIdRM2=3D &A.UMH_PREF_ROOMMATE2 let $EMPLID=3D &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found=3D'Y'=20 Do Get_Mutual_Type=20=20 else !no perf in run period, may try another period !show 'not perf rmt1=3D ' $EMPLID=20 if $RunPeriod=3D'2' or $RunPeriod=3D'3' !105720 or 105730 Do Look_Next_Period=09=09=09=20=20=20=20=20=20=20 else ! run period is not 20 or 30 let $prType =3D 'N' let $PrintFlag =3D'Y'=20 end-if=20=20=20=20=20=09=09=09=09=09 end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while =20=20=20=20=20=20=20=09 Do Show_Array=20=20 =09 End-Procedure !**************************************************************************= *** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !**************************************************************************= *** let $ID_Printed =3D'N' Let #Start =3D 0 While (#Start <=3D #Index) and $ID_Printed =3D 'N' If IDPrinted.emplid(#Start) =3D $EMPLID let $ID_Printed =3D 'Y' add 1 to #Start end-if end-while=20=20 =20 End-Procedure=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 13 10:17:15 2006 Subject: RE: [sqr-users] Stuck in array He!! Date: Thu, 13 Jul 2006 09:14:47 -0500 From: "Knapp, Richard" Off the of me head -=20 The read needs to be inside the loop, no? Didn't go any farther with it. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Laura Mayer Sent: Thursday, July 13, 2006 9:06 AM To: sqr-users@sqrug.org Subject: [sqr-users] Stuck in array He!! Morning, I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. Is there a better way to write this mess? Thanks for any and all help you can offer Laura !*********************************************************************** * Begin-Procedure Select_Records !*********************************************************************** * ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed=20 ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !*********************************************************************** * Read 1 into $Input_Str:8 let #index=3D0 While not #End-File=09 let $InputEmplid =3D substr($Input_Str, 1, 8) let $EMPLID =3D $InputEmplid=20 =09 Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed=3D'N' ! not processed let IDPrinted.emplid(#Index) =3D $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag =3D 'Y' let $period =3D $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found=3D'Y' ! found row in perf table if $RoomMateFound=3D'N' ! but both rm1 and rm2 empty let $prType =3D 'S' else !Has rmts let $InputIdRM1=3D &A.UMH_PREF_ROOMMATE1 let $InputIdRM2=3D &A.UMH_PREF_ROOMMATE2 let $EMPLID=3D &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found=3D'Y'=20 Do Get_Mutual_Type=20=20 else !no perf in run period, may try another period !show 'not perf rmt1=3D ' $EMPLID=20 if $RunPeriod=3D'2' or $RunPeriod=3D'3' !105720 or 105730 Do Look_Next_Period=09=09=09=20=20=20=20=20=20=20 else ! run period is not 20 or 30 let $prType =3D 'N' let $PrintFlag =3D'Y'=20 end-if=20=20=20=20=20=09=09=09=09=09 end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while =20=20=20=20=20=20=20=09 Do Show_Array=20=20 =09 End-Procedure !*********************************************************************** ****** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*********************************************************************** ****** let $ID_Printed =3D'N' Let #Start =3D 0 While (#Start <=3D #Index) and $ID_Printed =3D 'N' If IDPrinted.emplid(#Start) =3D $EMPLID let $ID_Printed =3D 'Y' add 1 to #Start end-if end-while=20=20 =20 End-Procedure=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 Thu Jul 13 10:30:48 2006 Subject: RE: [sqr-users] Stuck in array He!! Date: Thu, 13 Jul 2006 19:58:06 +0530 From: "Karunakaran Perumbrayoor" Laura... =20 I guess, you should have the "Read" inside the while loop. So it is just iterating in the first line of the file. There would be an infinite loop if more than one record is present in a file. =20 Just try making the change!!! =20 Regards... Karun =20 -----Original Message----- From: Laura Mayer [mailto:lmayer@gw.housing.umass.edu]=20 Sent: Thursday, July 13, 2006 7:36 PM To: sqr-users@sqrug.org Subject: [sqr-users] Stuck in array He!! =20 Morning, =20 I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. =20 Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. =20 Is there a better way to write this mess? =20 Thanks for any and all help you can offer =20 Laura =20 !*********************************************************************** * Begin-Procedure Select_Records !*********************************************************************** * ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed=20 ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !*********************************************************************** * Read 1 into $Input_Str:8 let #index=3D0 While not #End-File=20=20=20=20=20 let $InputEmplid =3D substr($Input_Str, 1, 8) let $EMPLID =3D $InputEmplid=20 =20=20=20=20=20=20 Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed=3D'N' ! not processed let IDPrinted.emplid(#Index) =3D $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag =3D 'Y' let $period =3D $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found=3D'Y' ! found row in perf table if $RoomMateFound=3D'N' ! but both rm1 and rm2 empty let $prType =3D 'S' else !Has rmts let $InputIdRM1=3D &A.UMH_PREF_ROOMMATE1 let $InputIdRM2=3D &A.UMH_PREF_ROOMMATE2 let $EMPLID=3D &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found=3D'Y'=20 Do Get_Mutual_Type=20=20 else !no perf in run period, may try another period !show 'not perf rmt1=3D ' $EMPLID=20 if $RunPeriod=3D'2' or $RunPeriod=3D'3' !105720 or 105730 Do Look_Next_Period=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 else ! run period is not 20 or 30 let $prType =3D 'N' let $PrintFlag =3D'Y'=20 end-if=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20 end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while =20=20=20=20=20=20=20=20=20=20=20=20 Do Show_Array=20=20 =20=20=20=20=20=20 End-Procedure =20 =20 !*********************************************************************** ****** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*********************************************************************** ****** let $ID_Printed =3D'N' Let #Start =3D 0 =20 While (#Start <=3D #Index) and $ID_Printed =3D 'N' If IDPrinted.emplid(#Start) =3D $EMPLID let $ID_Printed =3D 'Y' add 1 to #Start end-if end-while=20=20 =20 End-Procedure=20 =20 =20 =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =20 ***************************************************************************= ************************************************ This e-mail communication and any attachments may be privileged and confide= ntial to Hexaware and are intended only for the=20 use of the recipients named above. If you are not the intended recipient, p= lease do not review, disclose, disseminate,=20 distribute or copy this e-mail and attachments. If you have received this e= mail in error, please delete the same alongwith=20 all attachments thereto and notify us immediately at mailadmin@hexaware.com= . ***************************************************************************= ************************************************ =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 13 10:34:30 2006 Date: Thu, 13 Jul 2006 10:31:30 -0400 From: "Laura Mayer" Subject: RE: [sqr-users] Stuck in array He!! Thanks I'll try that. >>> karunp@hexaware.com 7/13/2006 10:28 AM >>> Laura... =20 I guess, you should have the "Read" inside the while loop. So it is just iterating in the first line of the file. There would be an infinite loop if more than one record is present in a file. =20 Just try making the change!!! =20 Regards... Karun =20 -----Original Message----- From: Laura Mayer [mailto:lmayer@gw.housing.umass.edu]=20 Sent: Thursday, July 13, 2006 7:36 PM To: sqr-users@sqrug.org=20 Subject: [sqr-users] Stuck in array He!! =20 Morning, =20 I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. =20 Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. =20 Is there a better way to write this mess? =20 Thanks for any and all help you can offer =20 Laura =20 !*********************************************************************** * Begin-Procedure Select_Records !*********************************************************************** * ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed=20 ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !*********************************************************************** * Read 1 into $Input_Str:8 let #index=3D0 While not #End-File=20=20=20=20=20 let $InputEmplid =3D substr($Input_Str, 1, 8) let $EMPLID =3D $InputEmplid=20 =20=20=20=20=20=20 Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed=3D'N' ! not processed let IDPrinted.emplid(#Index) =3D $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag =3D 'Y' let $period =3D $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found=3D'Y' ! found row in perf table if $RoomMateFound=3D'N' ! but both rm1 and rm2 empty let $prType =3D 'S' else !Has rmts let $InputIdRM1=3D &A.UMH_PREF_ROOMMATE1 let $InputIdRM2=3D &A.UMH_PREF_ROOMMATE2 let $EMPLID=3D &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found=3D'Y'=20 Do Get_Mutual_Type=20=20 else !no perf in run period, may try another period !show 'not perf rmt1=3D ' $EMPLID=20 if $RunPeriod=3D'2' or $RunPeriod=3D'3' !105720 or 105730 Do Look_Next_Period=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 else ! run period is not 20 or 30 let $prType =3D 'N' let $PrintFlag =3D'Y'=20 end-if=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20 end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while =20=20=20=20=20=20=20=20=20=20=20=20 Do Show_Array=20=20 =20=20=20=20=20=20 End-Procedure =20 =20 !*********************************************************************** ****** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*********************************************************************** ****** let $ID_Printed =3D'N' Let #Start =3D 0 =20 While (#Start <=3D #Index) and $ID_Printed =3D 'N' If IDPrinted.emplid(#Start) =3D $EMPLID let $ID_Printed =3D 'Y' add 1 to #Start end-if end-while=20=20 =20 End-Procedure=20 =20 =20 =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 =20 ***************************************************************************= ************************************************ This e-mail communication and any attachments may be privileged and confide= ntial to Hexaware and are intended only for the=20 use of the recipients named above. If you are not the intended recipient, p= lease do not review, disclose, disseminate,=20 distribute or copy this e-mail and attachments. If you have received this e= mail in error, please delete the same alongwith=20 all attachments thereto and notify us immediately at mailadmin@hexaware.com= . ***************************************************************************= ************************************************ =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 Thu Jul 13 10:37:58 2006 From: "Don Duwe" Subject: RE: [sqr-users] Stuck in array He!! Date: Thu, 13 Jul 2006 10:33:29 -0400 WHILE 1 READ 1 into $DATA:? IF #END-FILE BREAK END-IF CODE------------------- END-WHILE -----Original Message----- From: sqr-users-bounces+dduwe=nookind.com@sqrug.org [mailto:sqr-users-bounces+dduwe=nookind.com@sqrug.org]On Behalf Of Laura Mayer Sent: Thursday, July 13, 2006 10:06 AM To: sqr-users@sqrug.org Subject: [sqr-users] Stuck in array He!! Morning, I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. Is there a better way to write this mess? Thanks for any and all help you can offer Laura !************************************************************************ Begin-Procedure Select_Records !************************************************************************ ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !************************************************************************ Read 1 into $Input_Str:8 let #index=0 While not #End-File let $InputEmplid = substr($Input_Str, 1, 8) let $EMPLID = $InputEmplid Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed='N' ! not processed let IDPrinted.emplid(#Index) = $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag = 'Y' let $period = $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found='Y' ! found row in perf table if $RoomMateFound='N' ! but both rm1 and rm2 empty let $prType = 'S' else !Has rmts let $InputIdRM1= &A.UMH_PREF_ROOMMATE1 let $InputIdRM2= &A.UMH_PREF_ROOMMATE2 let $EMPLID= &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found='Y' Do Get_Mutual_Type else !no perf in run period, may try another period !show 'not perf rmt1= ' $EMPLID if $RunPeriod='2' or $RunPeriod='3' !105720 or 105730 Do Look_Next_Period else ! run period is not 20 or 30 let $prType = 'N' let $PrintFlag ='Y' end-if end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while Do Show_Array End-Procedure !*************************************************************************** ** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*************************************************************************** ** let $ID_Printed ='N' Let #Start = 0 While (#Start <= #Index) and $ID_Printed = 'N' If IDPrinted.emplid(#Start) = $EMPLID let $ID_Printed = 'Y' add 1 to #Start end-if end-while End-Procedure _______________________________________________ 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 13 10:45:39 2006 Subject: RE: [sqr-users] Stuck in array He!! From: Roger.Harris@certegy.com Date: Thu, 13 Jul 2006 10:42:01 -0400 There is a read at the end of the While. I think that the problem is in While loop in the procedure Check_If_ID_Printed. The index in this loop, #Start, will only get incremented if the first time that If IDPrinted.emplid(#Start) = $EMPLID is test yields true so you keep testing the same value over and over in an endless loop. Try moving add 1 to #Start to after the end-if in that loop. Roger L. Harris Programmer Analyst Sr Product Development Certegy Check Services Fidelity National Information Services, Inc 11601 N. Roosevelt Blvd St Petersburg, FL 33716 (727) 227-5850 direct (800) 215-6280 x75850 toll free (727) 570-4917 Fax |---------+----------------------------------------------------> | | "Laura Mayer" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=certegy.co| | | m@sqrug.org | | | | | | | | | 07/13/2006 10:31 AM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> >---------------------------------------------------------------------------------------------| | | | To: karunp@hexaware.com, sqr-users@sqrug.org | | cc: | | Subject: RE: [sqr-users] Stuck in array He!! | >---------------------------------------------------------------------------------------------| Thanks I'll try that. >>> karunp@hexaware.com 7/13/2006 10:28 AM >>> Laura... I guess, you should have the "Read" inside the while loop. So it is just iterating in the first line of the file. There would be an infinite loop if more than one record is present in a file. Just try making the change!!! Regards... Karun -----Original Message----- From: Laura Mayer [mailto:lmayer@gw.housing.umass.edu] Sent: Thursday, July 13, 2006 7:36 PM To: sqr-users@sqrug.org Subject: [sqr-users] Stuck in array He!! Morning, I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. Is there a better way to write this mess? Thanks for any and all help you can offer Laura !*********************************************************************** * Begin-Procedure Select_Records !*********************************************************************** * ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !*********************************************************************** * Read 1 into $Input_Str:8 let #index=0 While not #End-File let $InputEmplid = substr($Input_Str, 1, 8) let $EMPLID = $InputEmplid Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed='N' ! not processed let IDPrinted.emplid(#Index) = $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag = 'Y' let $period = $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found='Y' ! found row in perf table if $RoomMateFound='N' ! but both rm1 and rm2 empty let $prType = 'S' else !Has rmts let $InputIdRM1= &A.UMH_PREF_ROOMMATE1 let $InputIdRM2= &A.UMH_PREF_ROOMMATE2 let $EMPLID= &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found='Y' Do Get_Mutual_Type else !no perf in run period, may try another period !show 'not perf rmt1= ' $EMPLID if $RunPeriod='2' or $RunPeriod='3' !105720 or 105730 Do Look_Next_Period else ! run period is not 20 or 30 let $prType = 'N' let $PrintFlag ='Y' end-if end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while Do Show_Array End-Procedure !*********************************************************************** ****** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*********************************************************************** ****** let $ID_Printed ='N' Let #Start = 0 While (#Start <= #Index) and $ID_Printed = 'N' If IDPrinted.emplid(#Start) = $EMPLID let $ID_Printed = 'Y' add 1 to #Start end-if end-while End-Procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users *************************************************************************************************************************** This e-mail communication and any attachments may be privileged and confidential to Hexaware and are intended only for the use of the recipients named above. If you are not the intended recipient, please do not review, disclose, disseminate, distribute or copy this e-mail and attachments. If you have received this email in error, please delete the same alongwith all attachments thereto and notify us immediately at mailadmin@hexaware.com . *************************************************************************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. ============================================================================== _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 13 11:26:28 2006 Date: Thu, 13 Jul 2006 11:23:55 -0400 From: "Laura Mayer" Subject: RE: [sqr-users] Stuck in array He!! Thanks for the help.=20 >>> Roger.Harris@certegy.com 7/13/2006 10:42:01 AM >>> There is a read at the end of the While. I think that the problem is in While loop in the procedure Check_If_ID_Printed. The index in this loop, #Start, will only get incremented if the first time that If IDPrinted.emplid(#Start) =3D $EMPLID is test yields true so you keep testing the same value over and over in an endless loop. Try moving add 1 to #Start to after the end-if in that loop. Roger L. Harris Programmer Analyst Sr Product Development Certegy Check Services Fidelity National Information Services, Inc 11601 N. Roosevelt Blvd St Petersburg, FL 33716 (727) 227-5850 direct (800) 215-6280 x75850 toll free (727) 570-4917 Fax |---------+----------------------------------------------------> | | "Laura Mayer" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=3Dcertegy.co| | | m@sqrug.org | | | | | | | | | 07/13/2006 10:31 AM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> >------------------------------------------------------------------------= ---------------------| | = | | To: karunp@hexaware.com, sqr-users@sqrug.org = | | cc: = | | Subject: RE: [sqr-users] Stuck in array He!! = | >------------------------------------------------------------------------= ---------------------| Thanks I'll try that. >>> karunp@hexaware.com 7/13/2006 10:28 AM >>> Laura... I guess, you should have the "Read" inside the while loop. So it is just iterating in the first line of the file. There would be an infinite loop if more than one record is present in a file. Just try making the change!!! Regards... Karun -----Original Message----- From: Laura Mayer [mailto:lmayer@gw.housing.umass.edu]=20 Sent: Thursday, July 13, 2006 7:36 PM To: sqr-users@sqrug.org=20 Subject: [sqr-users] Stuck in array He!! Morning, I inherited this code from a prior employee and from what I can discern it creates an infinite loop that keeps iterating through all the records in a text file over and over again. I can't seem to fix it. I've even made it so there are only 9 records in the text file. Be advised it is the crudest code I have ever come across. What its supposed to do is read a text file into an array and process the data. It never seems to finish. Is there a better way to write this mess? Thanks for any and all help you can offer Laura !*********************************************************************** * Begin-Procedure Select_Records !*********************************************************************** * ! Reads input file. Selects Roommate data from Preference file ! Searches Roommate1 Array and Roommate2 Array for Roommate Matches ! Decides if the record needs to be printed ! Decides which report the record should be placed in ! Write data to Array (Prefer) ! For each inputID, if it is not in proccessing id array, put it in array. ! Then find its roommates. If found (Match), put its roommate's id into array. !*********************************************************************** * Read 1 into $Input_Str:8 let #index=3D0 While not #End-File let $InputEmplid =3D substr($Input_Str, 1, 8) let $EMPLID =3D $InputEmplid Do Check_If_ID_Printed !if input Id has been proceed if $ID_Printed=3D'N' ! not processed let IDPrinted.emplid(#Index) =3D $EMPLID !add id to array. ID processed add 1 to #index let $PrintFlag =3D 'Y' let $period =3D $parm_proc_cd ! only run period Do Get_Roommate ! find input id's pref record (building if $Preference_Found=3D'Y' ! found row in perf table if $RoomMateFound=3D'N' ! but both rm1 and rm2 empty let $prType =3D 'S' else !Has rmts let $InputIdRM1=3D &A.UMH_PREF_ROOMMATE1 let $InputIdRM2=3D &A.UMH_PREF_ROOMMATE2 let $EMPLID=3D &A.UMH_PREF_ROOMMATE1 ! input id' roommate1 Do Get_Roommate !find rmt1'rmts for run period if $Preference_Found=3D'Y' Do Get_Mutual_Type else !no perf in run period, may try another period !show 'not perf rmt1=3D ' $EMPLID if $RunPeriod=3D'2' or $RunPeriod=3D'3' !105720 or 105730 Do Look_Next_Period else ! run period is not 20 or 30 let $prType =3D 'N' let $PrintFlag =3D'Y' end-if end-if end-if Do Fill_Array end-if end-if !end of no processed Read 1 into $Input_Str:8 end-while Do Show_Array End-Procedure !*********************************************************************** ****** ! Check arry to find if this id already processed. Begin-Procedure Check_If_ID_Printed !*********************************************************************** ****** let $ID_Printed =3D'N' Let #Start =3D 0 While (#Start <=3D #Index) and $ID_Printed =3D 'N' If IDPrinted.emplid(#Start) =3D $EMPLID let $ID_Printed =3D 'Y' add 1 to #Start end-if end-while End-Procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 ***************************************************************************= ************************************************ This e-mail communication and any attachments may be privileged and confidential to Hexaware and are intended only for the use of the recipients named above. If you are not the intended recipient, please do not review, disclose, disseminate, distribute or copy this e-mail and attachments. If you have received this email in error, please delete the same alongwith all attachments thereto and notify us immediately at mailadmin@hexaware.com= =20 =2E ***************************************************************************= ************************************************ _______________________________________________ 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=20 ---------------------------------------------------------------------------= --- This message contains information from Certegy, Inc which may be confidenti= al and privileged. If you are not an intended recipient, please refrain fr= om any disclosure, copying, distribution or use of this information and not= e that such actions are prohibited. If you have received this transmission= in error, please notify by e:mail postmaster@certegy.com. =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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 14:30:05 2006 Date: Fri, 14 Jul 2006 14:27:55 -0400 From: "Laura Mayer" Subject: [sqr-users] trying to create an array Afternoon, I cant seem to get this. Every time I run this it says:=20 Error on line 49: (SQR 3514) PUT and GET variables must match array field types.=20 I checked and they are the right types. I used the code from the manual but= no matter what I do I cant make this work. I cant find any good tutorials = out there either. Any help anyone can offer would be great. Thanks in advance=20 Laura !******************************************************** begin-setup !******************************************************** create-array=20 name=3Dpreference_array=20 size=3D16500 field=3DEMPLID:char=20=20=20 field=3DTOTAL:number field=3DUMH_PRIORITY_ORDER:number=20 end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter =3D 0=20 begin-select C.EMPLID (,1)=20 (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16)=20 position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A=20 WHERE C.STRM =3D '1067'=20 AND C.STRM =3D A.STRM=20 AND A.EFFDT =3D=20 (SELECT MAX(A_ED.EFFDT)=20 FROM PS_UM_H_PRC_PD_TBL A_ED=20 WHERE A.UMH_PROC_PD =3D A_ED.UMH_PROC_PD=20 AND A_ED.EFFDT <=3D SYSDATE)=20 AND A.UMH_PROC_PD =3D '106730'=20 ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i =3D 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 14:36:12 2006 Subject: RE: [sqr-users] trying to create an array Date: Fri, 14 Jul 2006 12:33:34 -0600 From: "Lance Munger" Check the datatypes on the the table, my guess would be that EMPLID is actually a number or UMH_PRIORITY_ORDER is actually a char. -----Original Message----- From: sqr-users-bounces+lance.munger=3Dtq3navigant.com@sqrug.org [mailto:sqr-users-bounces+lance.munger=3Dtq3navigant.com@sqrug.org] On Behalf Of Laura Mayer Sent: Friday, July 14, 2006 12:28 PM To: sqr-users@sqrug.org Subject: [sqr-users] trying to create an array Afternoon, I cant seem to get this. Every time I run this it says:=20 Error on line 49: (SQR 3514) PUT and GET variables must match array field types.=20 I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. Thanks in advance=20 Laura !******************************************************** begin-setup !******************************************************** create-array=20 name=3Dpreference_array=20 size=3D16500 field=3DEMPLID:char=20=20=20 field=3DTOTAL:number field=3DUMH_PRIORITY_ORDER:number=20 end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter =3D 0=20 begin-select C.EMPLID (,1)=20 (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16)=20 position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A=20 WHERE C.STRM =3D '1067'=20 AND C.STRM =3D A.STRM=20 AND A.EFFDT =3D=20 (SELECT MAX(A_ED.EFFDT)=20 FROM PS_UM_H_PRC_PD_TBL A_ED=20 WHERE A.UMH_PROC_PD =3D A_ED.UMH_PROC_PD=20 AND A_ED.EFFDT <=3D SYSDATE)=20 AND A.UMH_PROC_PD =3D '106730'=20 ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i =3D 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ 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 14 14:39:37 2006 Subject: RE: [sqr-users] trying to create an array Date: Fri, 14 Jul 2006 11:34:53 -0700 From: "Amit Kedia" Hi, Have you tried just putting and getting one element at a time to see which one is causing the error? amit -----Original Message----- From: sqr-users-bounces+a.kedia=3Dsurewest.com@sqrug.org [mailto:sqr-users-bounces+a.kedia=3Dsurewest.com@sqrug.org] On Behalf Of Laura Mayer Sent: Friday, July 14, 2006 11:28 AM To: sqr-users@sqrug.org Subject: [sqr-users] trying to create an array Afternoon, I cant seem to get this. Every time I run this it says:=20 Error on line 49: (SQR 3514) PUT and GET variables must match array field types.=20 I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. Thanks in advance=20 Laura !******************************************************** begin-setup !******************************************************** create-array=20 name=3Dpreference_array=20 size=3D16500 field=3DEMPLID:char=20=20=20 field=3DTOTAL:number field=3DUMH_PRIORITY_ORDER:number=20 end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter =3D 0=20 begin-select C.EMPLID (,1)=20 (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16)=20 position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A=20 WHERE C.STRM =3D '1067'=20 AND C.STRM =3D A.STRM=20 AND A.EFFDT =3D=20 (SELECT MAX(A_ED.EFFDT)=20 FROM PS_UM_H_PRC_PD_TBL A_ED=20 WHERE A.UMH_PROC_PD =3D A_ED.UMH_PROC_PD=20 AND A_ED.EFFDT <=3D SYSDATE)=20 AND A.UMH_PROC_PD =3D '106730'=20 ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i =3D 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ 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 14 14:47:27 2006 Subject: Re: [sqr-users] trying to create an array From: Roger.Harris@certegy.com Date: Fri, 14 Jul 2006 14:42:36 -0400 You are trying to GET number array fields into $String variables. get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) Also, probably is not good form to use the same names as column aliases. Roger L. Harris Programmer Analyst Sr Product Development Certegy Check Services Fidelity National Information Services, Inc 11601 N. Roosevelt Blvd St Petersburg, FL 33716 (727) 227-5850 direct (800) 215-6280 x75850 toll free (727) 570-4917 Fax |---------+----------------------------------------------------> | | "Laura Mayer" | | | | | | Sent by: | | | sqr-users-bounces+roger.harris=certegy.co| | | m@sqrug.org | | | | | | | | | 07/14/2006 02:27 PM | | | Please respond to "This list is for | | | discussion about the SQR database | | | reporting language from Hyperion | | | Solutions." | | | | |---------+----------------------------------------------------> >---------------------------------------------------------------------------------------------| | | | To: sqr-users@sqrug.org | | cc: | | Subject: [sqr-users] trying to create an array | >---------------------------------------------------------------------------------------------| Afternoon, I cant seem to get this. Every time I run this it says: Error on line 49: (SQR 3514) PUT and GET variables must match array field types. I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. Thanks in advance Laura !******************************************************** begin-setup !******************************************************** create-array name=preference_array size=16500 field=EMPLID:char field=TOTAL:number field=UMH_PRIORITY_ORDER:number end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter = 0 begin-select C.EMPLID (,1) (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16) position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A WHERE C.STRM = '1067' AND C.STRM = A.STRM AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_UM_H_PRC_PD_TBL A_ED WHERE A.UMH_PROC_PD = A_ED.UMH_PROC_PD AND A_ED.EFFDT <= SYSDATE) AND A.UMH_PROC_PD = '106730' ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i = 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------------------------------------------------------------------------------ This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@certegy.com. ============================================================================== _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 14:52:40 2006 From: "the dragon" Subject: RE: [sqr-users] trying to create an array Date: Fri, 14 Jul 2006 13:43:54 -0500 It's been a while since I messed around with arrays... or sqr for that matter... sigh. I miss the good olde days./ In any case, you're definin the array as follows: name=preference_array size=16500 field=EMPLID:char field=TOTAL:number field=UMH_PRIORITY_ORDER:number yet, in the get, they are all character variables... (line 49??) get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) I am not certain sqr allows implicit data conversion in that manner. 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---- Afternoon, I cant seem to get this. Every time I run this it says: Error on line 49: (SQR 3514) PUT and GET variables must match array field types. I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. Thanks in advance Laura !******************************************************** begin-setup !******************************************************** create-array name=preference_array size=16500 field=EMPLID:char field=TOTAL:number field=UMH_PRIORITY_ORDER:number end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter = 0 begin-select C.EMPLID (,1) (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16) position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A WHERE C.STRM = '1067' AND C.STRM = A.STRM AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_UM_H_PRC_PD_TBL A_ED WHERE A.UMH_PROC_PD = A_ED.UMH_PROC_PD AND A_ED.EFFDT <= SYSDATE) AND A.UMH_PROC_PD = '106730' ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i = 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 14:56:48 2006 From: "Wright, David L. II" Subject: RE: [sqr-users] trying to create an array Date: Fri, 14 Jul 2006 11:46:11 -0700 TOTAL is a variable and should be preceeded with either $ or # depending on the type of variable you want to use. In your SELECT statement, you've defined the total variable using an &. In the get array you are reading$total - not the same as &total. Dave -----Original Message----- From: sqr-users-bounces+david.l.wright.ii=saic.com@sqrug.org [mailto:sqr-users-bounces+david.l.wright.ii=saic.com@sqrug.org] On Behalf Of Laura Mayer Sent: Friday, July 14, 2006 11:28 AM To: sqr-users@sqrug.org Subject: [sqr-users] trying to create an array Afternoon, I cant seem to get this. Every time I run this it says: Error on line 49: (SQR 3514) PUT and GET variables must match array field types. I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. Thanks in advance Laura !******************************************************** begin-setup !******************************************************** create-array name=preference_array size=16500 field=EMPLID:char field=TOTAL:number field=UMH_PRIORITY_ORDER:number end-setup !******************************************************** begin-program !******************************************************** do select_data do print_array end-program !******************************************************** begin-procedure select_data !******************************************************** let #counter = 0 begin-select C.EMPLID (,1) (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16) position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counter) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A WHERE C.STRM = '1067' AND C.STRM = A.STRM AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_UM_H_PRC_PD_TBL A_ED WHERE A.UMH_PROC_PD = A_ED.UMH_PROC_PD AND A_ED.EFFDT <= SYSDATE) AND A.UMH_PROC_PD = '106730' ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data !******************************************************** begin-procedure print_array !******************************************************** let #i = 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while end-procedure _______________________________________________ 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 14 15:05:58 2006 Date: Fri, 14 Jul 2006 14:56:44 -0400 From: "Laura Mayer" Subject: Re: Fwd: [sqr-users] trying to create an array Thanks to all for the great help and suggestions. That did it.=20 Thanks again. >>> Amy Eldridge 7/14/2006 2:40 PM >>> If total and priority are numbers per your array, why are you feeding them= =20 into character variables ($TOTAL and $C.UMH_PRIORITY_ORDER)? Shouldn't that be #TOTAL and #C.UMH_PRIORITY_ORDER? A. >X-Mailer: Novell GroupWise Internet Agent 6.5.4 >Date: Fri, 14 Jul 2006 14:27:55 -0400 >From: "Laura Mayer" >To: >Subject: [sqr-users] trying to create an array >X-BeenThere: sqr-users@sqrug.org=20 >X-Mailman-Version: 2.1.5 >Reply-To: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Id: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." >List-Unsubscribe: , > >List-Post: >List-Help: >List-Subscribe: , > >Sender: sqr-users-bounces+emgeac=3Dmuohio.edu@sqrug.org=20 >X-Real-ConnectIP: 199.164.165.113 >X-Scanned-By: MIMEDefang 2.45 >X-Scanned-By: MIMEDefang 2.52 on 134.53.6.11 > >Afternoon, > >I cant seem to get this. Every time I run this it says: >Error on line 49: > (SQR 3514) PUT and GET variables must match array field types. > >I checked and they are the right types. I used the code from the manual=20 >but no matter what I do I cant make this work. I cant find any good=20 >tutorials out there either. Any help anyone can offer would be great. > >Thanks in advance > >Laura > >!******************************************************** >begin-setup >!******************************************************** > create-array >name=3Dpreference_array >size=3D16500 > field=3DEMPLID:char > field=3DTOTAL:number > field=3DUMH_PRIORITY_ORDER:number > >end-setup > >!******************************************************** >begin-program >!******************************************************** > do select_data > do print_array >end-program > >!******************************************************** >begin-procedure select_data >!******************************************************** >let #counter =3D 0 >begin-select >C.EMPLID (,1) >(C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) >C.UMH_PRIORITY_ORDER (,16) >position (+1) > put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#count= er) > add 1 to #counter >FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A >WHERE C.STRM =3D '1067' >AND C.STRM =3D A.STRM >AND A.EFFDT =3D > (SELECT MAX(A_ED.EFFDT) > FROM PS_UM_H_PRC_PD_TBL A_ED > WHERE A.UMH_PROC_PD =3D A_ED.UMH_PROC_PD > AND A_ED.EFFDT <=3D SYSDATE) >AND A.UMH_PROC_PD =3D '106730' >ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC >end-select >end-procedure ! select_data > >!******************************************************** >begin-procedure print_array >!******************************************************** >let #i =3D 0 >while #i < #counter > get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) > print $C.EMPLID (,1) > print $TOTAL (,7) > print $C.UMH_PRIORITY_ORDER (,24) > position (+1) > add 1 to #i >end-while > >end-procedure > > > >_______________________________________________ >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 http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 16:35:04 2006 Date: Fri, 14 Jul 2006 16:32:15 -0400 From: "Vaidyanathan, Ramakrishnan \(GE, Corporate, consultant\)" Subject: [sqr-users] SQR Executed thru Process Scheduler Hi, When a sqr is kicked off from a process scheduler, i see that its getti= ng executed as SYSADM user with SYSADM user privilege. If thats the case, t= hen any inserts/updates/deletes to the table should be possible. So If any = user (with only SELECT privilege) logs into the PIA page and kicks of the s= qr thru process scheduler, then will the SQR be able to perform the same in= serts/updates/deletes to the table? How will the OPRID come into picture? Thanks Ram _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 17:17:55 2006 From: "the dragon" Subject: RE: [sqr-users] SQR Executed thru Process Scheduler Date: Fri, 14 Jul 2006 15:43:19 -0500 If the sqr is executed through the process scheduler, regardless of who is executing it, it will run with the privs of sysadm. OPRID is a security construct of PeopleSoft which is used for access. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hi, When a sqr is kicked off from a process scheduler, i see that its getting executed as SYSADM user with SYSADM user privilege. If thats the case, then any inserts/updates/deletes to the table should be possible. So If any user (with only SELECT privilege) logs into the PIA page and kicks of the sqr thru process scheduler, then will the SQR be able to perform the same inserts/updates/deletes to the table? How will the OPRID come into picture? Thanks Ram _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Jul 14 17:58:26 2006 Date: Fri, 14 Jul 2006 16:56:32 -0500 From: "ViJaYaNaNd gMaiL" Subject: [sqr-users] Reading file into SQR Hi I have a text file that I am reading in through sqr. Now the format of the text file has changed and the file is not reading properly and not updating the tables. Do i need to modify the program. Any pointers would be of much helpful to me. Here is the piece of code: while 1 = 1 read 1 into $recorddata:1000 let $recorddata = upper($recorddata) EVALUATE $recorddata when = 'SSN:' read 1 into $recorddata:1000 LET $N_SSN = upper($recorddata) BREAK My text file previous was looking like this for SSN: SSN: 999-99-9999 But now my text file looks like this 999-99-9999 SSN: Similarly someother fields got rearranged like these. Need advice thnx cvijay _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sat Jul 15 15:44:13 2006 Subject: RE: [sqr-users] trying to create an array Date: Sun, 16 Jul 2006 01:11:28 +0530 From: "Karunakaran Perumbrayoor" Dave, You are perfectly right. SQR doesnt allow implicit data conversion an= d this error is surely due to the column variable being a number type and t= he other variable being a string. =20 Regards... Karun -----Original Message-----=20 From: Wright, David L. II [mailto:DAVID.L.WRIGHT.II@saic.com]=20 Sent: Sat 15-Jul-2006 12:16 AM=20 To: 'This list is for discussion about the SQR database reporting language= from Hyperion Solutions.'=20 Cc:=20 Subject: RE: [sqr-users] trying to create an array =09 =09 TOTAL is a variable and should be preceeded with either $ or # depending on the type of variable you want to use. In your SELECT statement, you've defined the total variable using an &. In the get array you are reading$total - not the same as &total. =09 Dave =09 =09 =09 -----Original Message----- From: sqr-users-bounces+david.l.wright.ii=3Dsaic.com@sqrug.org [mailto:sqr-users-bounces+david.l.wright.ii=3Dsaic.com@sqrug.org] On Behal= f Of Laura Mayer Sent: Friday, July 14, 2006 11:28 AM To: sqr-users@sqrug.org Subject: [sqr-users] trying to create an array =09 =09 Afternoon, =09 I cant seem to get this. Every time I run this it says: Error on line 49: (SQR 3514) PUT and GET variables must match array field types. =09 I checked and they are the right types. I used the code from the manual but no matter what I do I cant make this work. I cant find any good tutorials out there either. Any help anyone can offer would be great. =09 Thanks in advance =09 Laura =09 !******************************************************** begin-setup !******************************************************** create-array name=3Dpreference_array size=3D16500 field=3DEMPLID:char=20=20 field=3DTOTAL:number field=3DUMH_PRIORITY_ORDER:number =09 end-setup =09 !******************************************************** begin-program !******************************************************** do select_data do print_array end-program =09 !******************************************************** begin-procedure select_data !******************************************************** let #counter =3D 0 begin-select C.EMPLID (,1) (C.UMH_TRMS_IN_HS_PTS + C.UMH_OTHER_PTS) &TOTAL (,10) C.UMH_PRIORITY_ORDER (,16) position (+1) put &C.EMPLID &TOTAL &C.UMH_PRIORITY_ORDER into preference_array(#counte= r) add 1 to #counter FROM PS_UM_H_SNRTY C, PS_UM_H_PRC_PD_TBL A WHERE C.STRM =3D '1067' AND C.STRM =3D A.STRM AND A.EFFDT =3D (SELECT MAX(A_ED.EFFDT) FROM PS_UM_H_PRC_PD_TBL A_ED WHERE A.UMH_PROC_PD =3D A_ED.UMH_PROC_PD AND A_ED.EFFDT <=3D SYSDATE) AND A.UMH_PROC_PD =3D '106730' ORDER BY C.UMH_TRMS_IN_HS_PTS DESC, C.UMH_PRIORITY_ORDER DESC end-select end-procedure ! select_data =09 !******************************************************** begin-procedure print_array !******************************************************** let #i =3D 0 while #i < #counter get $C.EMPLID $TOTAL $C.UMH_PRIORITY_ORDER from preference_array(#i) print $C.EMPLID (,1) print $TOTAL (,7) print $C.UMH_PRIORITY_ORDER (,24) position (+1) add 1 to #i end-while =09 end-procedure =09 =09 =09 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =09 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =09 ***************************************************************************= ************************************************ This e-mail communication and any attachments may be privileged and confide= ntial to Hexaware and are intended only for the=20 use of the recipients named above. If you are not the intended recipient, p= lease do not review, disclose, disseminate,=20 distribute or copy this e-mail and attachments. If you have received this e= mail in error, please delete the same alongwith=20 all attachments thereto and notify us immediately at mailadmin@hexaware.com= . ***************************************************************************= ************************************************ =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 09:18:51 2006 Date: Mon, 17 Jul 2006 09:16:43 -0400 From: "White . Denise" Subject: [sqr-users] RE: Reading file into SQR I would say that you will have to do something like this: while 1 =3D 1 read 1 into $recorddata1:1000 read 1 into $recorddata2:1000 let $recorddata2 =3D upper($recorddata2) EVALUATE $recorddata2 when =3D 'SSN:' LET $N_SSN =3D upper($recorddata1) BREAK HTH, Denise M. White EBS Programmer/Analyst III Dynamics Research Corporation ------------------------------ Message: 10 Date: Fri, 14 Jul 2006 16:56:32 -0500 From: "ViJaYaNaNd gMaiL" Subject: [sqr-users] Reading file into SQR To: sqr-users@sqrug.org Message-ID: Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed Hi I have a text file that I am reading in through sqr. Now the format of the text file has changed and the file is not reading properly and not updating the tables. Do i need to modify the program. Any pointers would be of much helpful to me. Here is the piece of code: while 1 =3D 1 read 1 into $recorddata:1000 let $recorddata =3D upper($recorddata) EVALUATE $recorddata when =3D 'SSN:' read 1 into $recorddata:1000 LET $N_SSN =3D upper($recorddata) BREAK My text file previous was looking like this for SSN: SSN: 999-99-9999 But now my text file looks like this 999-99-9999 SSN: Similarly someother fields got rearranged like these. Need advice thnx cvijay _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 09:46:12 2006 Date: Mon, 17 Jul 2006 09:44:03 -0400 From: "Savage, David M" Subject: [sqr-users] SQR Tutorials Hi, I am a beginner to SQR and was wondering if anyone knew of any tutorials I could access via the internet. Thanks Dave S =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 09:53:05 2006 Subject: RE: [sqr-users] SQR Tutorials Date: Mon, 17 Jul 2006 09:50:27 -0400 From: "Eric Miller" Hi Dave, Here is where I started: http://dev.hyperion.com/resource_library/technical_documentation/sqr/sqr _8.cfm This page has a couple documents that will explain the basic syntax. Getting Started with SQR and SQR Language Reference were the most helpful to me. - Eric -----Original Message----- From: sqr-users-bounces+eric.miller=3Dcgifederal.com@sqrug.org [mailto:sqr-users-bounces+eric.miller=3Dcgifederal.com@sqrug.org] On Behalf Of Savage, David M Sent: Monday, July 17, 2006 9:44 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] SQR Tutorials Hi, I am a beginner to SQR and was wondering if anyone knew of any tutorials I could access via the internet. Thanks Dave S =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 09:56:57 2006 Date: Mon, 17 Jul 2006 09:53:30 -0400 From: "Moss, Mike " Subject: [sqr-users] Question about printing paychecks/advices I need to print some "mock" paychecks/advices. We would like to accomplish a few things * Suppress any signatures * Print "void", or "non-negotiable" on the checks/advices in the appropriate places Has anyone done this before? If so, can you point me in the right direction? Maybe send a copy of the modified SQR's? Thanks.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic 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 Mon Jul 17 10:27:05 2006 From: "Joe" Subject: RE: [sqr-users] SQR Tutorials Date: Mon, 17 Jul 2006 08:24:25 -0600 This group is the best source of education - excellent threads on just about every topic related to SQR. Also, get the eBook 'SQR in Peoplesoft and Other Applications' by Galina and Vlad Landres (Manning Publication) as an online reference to supplement the SQR help files. HTH, Joe J -----Original Message----- From: sqr-users-bounces+jej1216=hotmail.com@sqrug.org [mailto:sqr-users-bounces+jej1216=hotmail.com@sqrug.org] On Behalf Of Savage, David M Sent: Monday, July 17, 2006 7:44 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] SQR Tutorials Hi, I am a beginner to SQR and was wondering if anyone knew of any tutorials I could access via the internet. Thanks Dave S _______________________________________________ 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 17 10:43:27 2006 From: JOHN_HARRIS@qvc.com Date: Mon, 17 Jul 2006 10:41:02 -0400 Subject: [sqr-users] Unstring into an array I would like to UNSTRING $ATS_RECORDS into an array. I do not know how many records will be in the $ATS_RECORDS variable. There may be zero (0) or many. UNSTRING $ATS_RECORDS BY '^' INTO $FILLER $ATS1 $ATS2 $ATS3 $ATS4 $ATS5 $ATS6 $ATS7 $ATS8 $ATS9 $ATS10 AND SO ON..... Thank you. Regards, John John Harris Programmer/Analyst Application Development - Internal QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262 Telephone 484-701-3303 Fax 484-701-8689 e-mail jharris@qvc.com This message may contain information that is privileged or confidential. This message may contain information that is privileged or confidential. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 10:48:12 2006 From: "the dragon" Subject: RE: [sqr-users] SQR Tutorials Date: Mon, 17 Jul 2006 09:45:43 -0500 Joe, On the one hand I agree with your statement, but on the other hand I think there is an expectation that people will perform due dilligence in getting training elsewhere, as well as reviewing resources such as the book you referenced, or the SQR Language Reference manual from SQRibe/Brio/Hyperion before they come here and start asking "simple" questions that have solutions which are readily available elsewhere. Just my "humble" opinion. 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---- This group is the best source of education - excellent threads on just about every topic related to SQR. Also, get the eBook 'SQR in Peoplesoft and Other Applications' by Galina and Vlad Landres (Manning Publication) as an online reference to supplement the SQR help files. HTH, Joe J -----Original Message----- Hi, I am a beginner to SQR and was wondering if anyone knew of any tutorials I could access via the internet. Thanks Dave S _________________________________________________________________ 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 Mon Jul 17 11:23:46 2006 Date: Mon, 17 Jul 2006 09:20:44 -0600 From: Joe Johnson Subject: Re: [sqr-users] SQR Tutorials This is a multi-part message in MIME format... --------------010401090308050409040606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I agree - newbies should do whatever they can to read up and get up to nominal speed on SQR. As far as tutorials/training, I have never found any worthwhile tutorial or training offerings - the PeopleSoft SQR classes are pretty lame. JEJ the dragon wrote: > Joe, > > On the one hand I agree with your statement, but on the other hand I > think there is an expectation that people will perform due dilligence > in getting training elsewhere, as well as reviewing resources such as > the book you referenced, or the SQR Language Reference manual from > SQRibe/Brio/Hyperion before they come here and start asking "simple" > questions that have solutions which are readily available elsewhere. > > Just my "humble" opinion. > > 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---- > > This group is the best source of education - excellent threads on just > about > every topic related to SQR. > > Also, get the eBook 'SQR in Peoplesoft and Other Applications' by > Galina and > Vlad Landres (Manning Publication) as an online reference to > supplement the > SQR help files. > > HTH, > > Joe J > > -----Original Message----- > > Hi, > > I am a beginner to SQR and was wondering if anyone knew of any > tutorials I > could access via the internet. > > Thanks > Dave S > > _________________________________________________________________ > 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 > -- *----------------------------------------------* *Joe Johnson* Software Developer *Ernest Health, Inc.** * Office: (505) 798-6480 Ext: 206 *email: joejohnson@ernesthealth.com * --------------010401090308050409040606 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. --------------010401090308050409040606 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 --------------010401090308050409040606-- From sqr-users-bounces@sqrug.org Mon Jul 17 15:16:36 2006 Date: Mon, 17 Jul 2006 12:14:14 -0700 (PDT) From: John Czekaj Subject: [sqr-users] SQR V6 and SQL Server 2000 I have an SQR that changes the value of EMPLID in all tables where EMLPLID is a column from SSN to a sequentially assigned number. This program runs fine on Oracle, but on SQL Server 2000, it is a dog. It is doing a commit (commit transaction/begin transaction) after each employee is processed, but yet it takes longer and longer to process employees as the SQR runs. Does anyone have any suggestions as to how I can improve the performance of this program? Any assistance would be greatly appreciated. Thanks, John Czekaj, Consultant ADP Professional Services - National Accounts John Czekaj Consultant ADP National Accounts - Professional Services __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 15:23:16 2006 Subject: RE: [sqr-users] SQR V6 and SQL Server 2000 Date: Mon, 17 Jul 2006 14:21:09 -0500 From: "Knapp, Richard" Do you have some data structure that is increasing in size as the program runs? Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of John Czekaj Sent: Monday, July 17, 2006 2:14 PM To: sqr-users@sqrug.org Subject: [sqr-users] SQR V6 and SQL Server 2000 I have an SQR that changes the value of EMPLID in all tables where EMLPLID is a column from SSN to a sequentially assigned number. This program runs fine on Oracle, but on SQL Server 2000, it is a dog. It is doing a commit (commit transaction/begin transaction) after each employee is processed, but yet it takes longer and longer to process employees as the SQR runs. Does anyone have any suggestions as to how I can improve the performance of this program? Any assistance would be greatly appreciated. Thanks, John Czekaj, Consultant ADP Professional Services - National Accounts John Czekaj Consultant ADP National Accounts - Professional Services __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 15:33:39 2006 From: "Jeffrey Newton" Subject: RE: [sqr-users] SQR V6 and SQL Server 2000 Date: Mon, 17 Jul 2006 15:29:45 -0400 I encounterd a similar problem once - the problem turned out to be that the ODBC driver on the server where I ran the SQR was not up to date. When it ran, the initial updates went fairly quickly, but the longer it ran the longer it took to complete an update. >From: John Czekaj >Reply-To: "This list is for discussion about the SQR database >reportinglanguage from Hyperion Solutions." >To: sqr-users@sqrug.org >Subject: [sqr-users] SQR V6 and SQL Server 2000 >Date: Mon, 17 Jul 2006 12:14:14 -0700 (PDT) > >I have an SQR that changes the value of EMPLID in all >tables where EMLPLID is a column from SSN to a >sequentially assigned number. This program runs fine >on Oracle, but on SQL Server 2000, it is a dog. It is >doing a commit (commit transaction/begin transaction) >after each employee is processed, but yet it takes >longer and longer to process employees as the SQR >runs. Does anyone have any suggestions as to how I >can improve the performance of this program? Any >assistance would be greatly appreciated. > >Thanks, > >John Czekaj, Consultant >ADP Professional Services - National Accounts > >John Czekaj > Consultant > ADP National Accounts - Professional Services > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Jul 17 16:23:51 2006 Date: Mon, 17 Jul 2006 16:21:07 -0400 From: "Everett Carr" Subject: Re: [sqr-users] Question about printing paychecks/advices easy. modify sqr so that it will only print signature when running on your production environment. ie: encode '<27>(8U<27>(s1p180v0s-7b24623TVOID<27>(3@' into $TroyPrnVoid !............................................................................... begin-procedure hcchk-200-Get-Database-Instance-Name #debugs show $pgm_name '-debugs, hcchk-200-Get-Database-Instance-Name' BEGIN-SELECT ON-ERROR=SQL-Error NAME let $hc_instance_name = rtrim(&NAME, ' ') FROM V$DATABASE END-SELECT if instr($hc_instance_name, 'PROD',1) let $hc_Prod = '1' !true else let $hc_Prod = '0' !false end-if end-procedure Then later on if $hc_Prod = '0' print $TroyPrnVoid (80,15) end-if We let the signature print, but if not on production the above line causes rather LARGE "VOID" to print. Alternately you can use above test to cause sig not to print at all, but sooner or later you'll need to do so for alignment/verification before going to production >>> "Moss, Mike " 7/17/2006 9:53:30 AM >>> I need to print some "mock" paychecks/advices. We would like to accomplish a few things * Suppress any signatures * Print "void", or "non-negotiable" on the checks/advices in the appropriate places Has anyone done this before? If so, can you point me in the right direction? Maybe send a copy of the modified SQR's? Thanks. ==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. _______________________________________________ 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 18 14:44:32 2006 Date: Tue, 18 Jul 2006 14:42:07 -0400 From: "Laura Mayer" Subject: [sqr-users] Question about an array Afternoon, I have an array that loops to many times. It seems that when a student requ= ests one roommate its all happy when they request two roommates it loops th= rough twice for the three people.=20 Any thoughts or advise would be most appreciated. By the way this is code I= 've inherited and trying to make sense of. Thanks=20 Laura !******************************************************** Begin-Procedure Get_Preference !******************************************************** Begin-Select=20 !fields go here let $Emplid=3D$PriEMPLID Do Get_Assign Do Get_RAP Do Get_Name Do Get_Felony Do Get_Priority_Order=20 Do Get_Ferpa Do Get_AcaLevel let $PriName=3D$Name if $Type <> 'No Roommate' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE1 Let $InputIdRM1=3D&MA.UMH_PREF_ROOMMATE1 Do Get_Name if $Period <> $parm_proc_cd let $printPeriod=3D'('|| $Period || ')' else let $printPeriod=3D' ' end-if let $RoommateName1=3D$Name || ' ' || $printPeriod if isBlank(&MA.UMH_PREF_ROOMMATE2) or isnull(&MA.UMH_PREF_ROOMMATE2) else Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE2 let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Do Get_Name let $RoommateName2=3D$Name || ' ' || $printPeriod Do Print_Roommate_Name end-if else=20 Print 'No Roommate' (+1,1) Bold Print '=3D' (+1,1,140) fill end-if Do Print_Data FROM PS_UM_H_PREF MA WHERE MA.STRM =3D $ProcSTRM AND MA.UMH_PROC_PD =3D $parm_proc_cd=20 AND MA.EMPLID =3D $PriEMPLID =20=20=20=20 End-Select End-Procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 19 15:46:09 2006 Date: Wed, 19 Jul 2006 15:43:51 -0400 From: "Laura Mayer" Subject: [sqr-users] Trouble with an array Afternoon, I have an array that I am having a problem with. I only want to see the it = once for each person, what's happening is if the person has two roommates i= t repeats the iteration again so each person with two roommates gets listed= twice.=20 I've posted the if statement that drives it below if someone could offer so= me insight on how to fix this that would be great. Thanks in advance. Laura Do Print_Data if $Type <> 'No Roomate' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE1 let $InputIdRM1=3D&MA.UMH_PREF_ROOMMATE1 Do Get_Name_OfPerson if $Period <> $parm_proc_cd let $printPeriod=3D'('|| $Period || ')' else let $printPeriod=3D' ' end-if let $RoommateName1=3D$Name || ' ' || $printPeriod if isBlank(&MA.UMH_PREF_ROOMMATE2) or isnull(&MA.UMH_PREF_ROOMMATE2) let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Do Print_Roommate_Name else=20 Let $PriEMPLID =3D '' Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE2 let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Do Get_Name_OfPerson let $RoommateName2=3D$Name || ' ' || $printPeriod Do Print_Roommate_Name end-if else=20 Print 'No Roommate' (+1,1) Bold Print '=3D' (+1,1,140) fill end-if _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Jul 19 16:00:25 2006 From: "the dragon" Subject: RE: [sqr-users] Trouble with an array Date: Wed, 19 Jul 2006 14:57:57 -0500 I personally would need to see all your code - additionally, put some show statements inside debugs so you can see what is happening. 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---- Afternoon, I have an array that I am having a problem with. I only want to see the it once for each person, what's happening is if the person has two roommates it repeats the iteration again so each person with two roommates gets listed twice. I've posted the if statement that drives it below if someone could offer some insight on how to fix this that would be great. Thanks in advance. Laura Do Print_Data if $Type <> 'No Roomate' Let $PriEMPLID = &MA.UMH_PREF_ROOMMATE1 let $InputIdRM1=&MA.UMH_PREF_ROOMMATE1 Do Get_Name_OfPerson if $Period <> $parm_proc_cd let $printPeriod='('|| $Period || ')' else let $printPeriod=' ' end-if let $RoommateName1=$Name || ' ' || $printPeriod if isBlank(&MA.UMH_PREF_ROOMMATE2) or isnull(&MA.UMH_PREF_ROOMMATE2) let $InputIdRM2=&MA.UMH_PREF_ROOMMATE2 Let $InputIdRM2 = '' Let $RoommateName2 = '' Do Print_Roommate_Name else Let $PriEMPLID = '' Let $InputIdRM2 = '' Let $RoommateName2 = '' Let $PriEMPLID = &MA.UMH_PREF_ROOMMATE2 let $InputIdRM2=&MA.UMH_PREF_ROOMMATE2 Do Get_Name_OfPerson let $RoommateName2=$Name || ' ' || $printPeriod Do Print_Roommate_Name end-if else Print 'No Roommate' (+1,1) Bold Print '=' (+1,1,140) fill end-if _________________________________________________________________ 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 Wed Jul 19 16:14:00 2006 Subject: RE: [sqr-users] Trouble with an array Date: Wed, 19 Jul 2006 15:11:41 -0500 From: "Knapp, Richard" Laura, Here's a programming hint: use white space. For example: Do Print_Data if $Type <> 'No Roomate' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE1 let $InputIdRM1=3D&MA.UMH_PREF_ROOMMATE1 Do Get_Name_OfPerson if $Period <> $parm_proc_cd let $printPeriod=3D'('|| $Period || ')' else let $printPeriod=3D' ' end-if let $RoommateName1=3D$Name || ' ' || $printPeriod if isBlank(&MA.UMH_PREF_ROOMMATE2) or isnull(&MA.UMH_PREF_ROOMMATE2) !**ISBLANK includes nulls** let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Do Print_Roommate_Name else=20 Let $PriEMPLID =3D '' Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE2 let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Do Get_Name_OfPerson let $RoommateName2=3D$Name || ' ' || $printPeriod Do Print_Roommate_Name end-if else=20 Print 'No Roommate' (+1,1) Bold Print '=3D' (+1,1,140) fill end-if Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Laura Mayer Sent: Wednesday, July 19, 2006 2:44 PM To: sqr-users@sqrug.org Subject: [sqr-users] Trouble with an array Afternoon, I have an array that I am having a problem with. I only want to see the it once for each person, what's happening is if the person has two roommates it repeats the iteration again so each person with two roommates gets listed twice.=20 I've posted the if statement that drives it below if someone could offer some insight on how to fix this that would be great. Thanks in advance. Laura Do Print_Data if $Type <> 'No Roomate' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE1 let $InputIdRM1=3D&MA.UMH_PREF_ROOMMATE1 Do Get_Name_OfPerson if $Period <> $parm_proc_cd let $printPeriod=3D'('|| $Period || ')' else let $printPeriod=3D' ' end-if let $RoommateName1=3D$Name || ' ' || $printPeriod if isBlank(&MA.UMH_PREF_ROOMMATE2) or isnull(&MA.UMH_PREF_ROOMMATE2) let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Do Print_Roommate_Name else=20 Let $PriEMPLID =3D '' Let $InputIdRM2 =3D '' Let $RoommateName2 =3D '' Let $PriEMPLID =3D &MA.UMH_PREF_ROOMMATE2 let $InputIdRM2=3D&MA.UMH_PREF_ROOMMATE2 Do Get_Name_OfPerson let $RoommateName2=3D$Name || ' ' || $printPeriod Do Print_Roommate_Name end-if else=20 Print 'No Roommate' (+1,1) Bold Print '=3D' (+1,1,140) fill end-if _______________________________________________ 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 20 08:07:09 2006 Date: Thu, 20 Jul 2006 17:33:30 +0530 From: "Karunakaran Perumbrayoor" Subject: [sqr-users] SQR 1301: Forward references not permitted in select list bind variables Hi Everybody, =20 GREETINGS!!! I face a small problem while running an SQR report in Sybase. I am getting a compilation error "SQR 1301: Forward references not permitted in select list bind variables".=20 =20 When I have a look at the Peoplebooks, the solution is given as" Within the body of BEGIN-SQL paragraphs, forward references to &column names are not permitted. Move the BEGIN-SQL paragraph after the &column definition". I tried commenting all the Begin -SQL's (All Insert, Deletes which were happening) which I have in the program just for a check, and still I am met with the same error. =20 What could be the problem? Please let me know if you have any suggestions or solutions to offer. =20 Regards... Karun =20 =20 ***************************************************************************= ************************************************ This e-mail communication and any attachments may be privileged and confide= ntial to Hexaware and are intended only for the=20 use of the recipients named above. If you are not the intended recipient, p= lease do not review, disclose, disseminate,=20 distribute or copy this e-mail and attachments. If you have received this e= mail in error, please delete the same alongwith=20 all attachments thereto and notify us immediately at mailadmin@hexaware.com= . ***************************************************************************= ************************************************ =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 20 10:20:34 2006 Date: Thu, 20 Jul 2006 10:17:58 -0400 From: "Mingazov, Maya" Subject: [sqr-users] Environment variable SQRDIR Hello everyone, I am getting following error and don't know what that means. Maybe someone had similar error and remembers how to resolve it. Any suggestions will be helpful. ' root@sun04>more LSHAWWedJul1916:33:02EDT2006PLNR470.lis.o14852 Warning: no access to tty; thus no job control in this shell... Sun Microsystems Inc. SunOS 5.9 Generic May 2002 You have new mail. (SQR 14) The required environment variable SQRDIR has not been defined. ' Thank you very much, Maya=20 This message and its attachments may contain legally privileged or confiden= tial information. It is intended solely for the named addressee. If you a= re not the addressee indicated in this message (or responsible for delivery= of the message to the addressee), you may not copy or deliver this message= or its attachments to anyone. Rather, you should permanently delete this = message and its attachments and kindly notify the sender by reply e-mail. = Any content of this message and its attachments that does not relate to the= official business of News America Incorporated or its subsidiaries must be= taken not to have been sent or endorsed by any of them. No warranty is ma= de that the e-mail or attachment(s) are free from computer virus or other d= efect. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Jul 20 10:25:39 2006 Subject: RE: [sqr-users] Environment variable SQRDIR Date: Thu, 20 Jul 2006 09:23:45 -0500 From: "Knapp, Richard" Your initialization file (where SQRDIR will be defined) is not being run. Richard Knapp AITS - Reporting University of Missouri Locust Street Building Columbia, MO 65201 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of Mingazov, Maya Sent: Thursday, July 20, 2006 9:18 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: [sqr-users] Environment variable SQRDIR Hello everyone, I am getting following error and don't know what that means. Maybe someone had similar error and remembers how to resolve it. Any suggestions will be helpful. ' root@sun04>more LSHAWWedJul1916:33:02EDT2006PLNR470.lis.o14852 Warning: no access to tty; thus no job control in this shell... Sun Microsystems Inc. SunOS 5.9 Generic May 2002 You have new mail. (SQR 14) The required environment variable SQRDIR has not been defined. ' Thank you very much, Maya=20 This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message (or responsible for delivery of the message to the addressee), you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently dele