From owner-sqr-users@list.iex.net Sat Apr 1 00:42:48 2000 Date: Sat, 1 Apr 2000 00:00:01 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.5 $ $Date: 1999-08-31 18:59:00-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ 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. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 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 1999/04/30: o Reflected the takeover of SQRIBE Technologies by Brio Technology and the resulting new product names (throughout document). o Added additional hints to the "Posting to the sqr-users List" section. 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 Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The Brio website has more information on the merger. 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.com/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 (C)Copyright 1999 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 psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). To join, follow the link above, or send any message to "psusers-subscribe@egroups.com" . rm-users : ReportMart 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.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests 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. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 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 in reply from other subscribers.) 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.) 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. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". 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 Brio product and version number o Operating system 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. To find out your version 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 version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 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.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements SQR-related job announcements are currently allowed on the list, subject to the following restrictions: o The subject line must begin with the words "JOB ANNOUNCEMENT:". o The message should be very short (fewer than 20 lines), giving brief details of the job and a way for those interested to get more information directly (i.e. web page or phone number). o The message should specifically remind people interested in the job to respond directly to the message author (and not to use their mailer's "reply" function, since that would send the reply out on the list). o Post job announcements as infrequently as possible. From owner-sqr-users@list.iex.net Sat Apr 1 16:49:56 2000 Date: Sat, 1 Apr 2000 21:08:16 GMT From: Manoj Chainani Subject: Re: Job Announcement: US-CA-San Diego (Med Data HCS) This is a multi-part message in MIME format. ------=_NextPart_000_39d3ccb9_3a38f635$27b0fcef Content-Type: text/plain; format=flowed Hi Dennis, With reference to your requirement of SQR developer, I would like to apply for the position. Please find my resume which I have attached to this mail. As can be seen, I have about 2 years of PeopleSoft experience as Technical consultant. I have been mainly involved in SQR development along with other PeopleTools. Hope all information provided by me are sufficient though I will be glad to furnish more if required. Thanking you, Sincerely, Manoj Chainani. (Tel : 817 685 2253 / 703 786 7253) >From: Dennis Bartlett >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Job Announcement: US-CA-San Diego (Med Data HCS) >Date: Fri, 31 Mar 2000 17:14:04 -0800 > >Med Data Healthcare Services Inc. >San Diego, CA > >Immediate, full-time position for a Database SW Developer with 1-3 years >experience report writing in SQR. We provide monthly and quarterly >reporting >packages to our direct customers. We also do customer and ad hoc >programming >for both internal and external customers. For our external customers, these >reports help the Plan Pharmacy Manager manage their pharmaceutical end of >their business. For our internal customers, these reports help us to sell >potential customers on our products and services, as well as other reports >that help us to manage our own business needs. These reports are written in >Scribe's SQR product. The databases are Oracle versions 7 and 8. > >If you are interested in learning more about the position please contact >Dennis Bartlett at (858) 790-62226 or email resume to >dennisb@medimpact.com. >(Reminder - people interested in the job must respond directly to the >message author and not to use their mailer's "reply" function, since that >would send the reply out on the list) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------=_NextPart_000_39d3ccb9_3a38f635$27b0fcef Content-Type: application/msword; name="ManojChainani.doc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="ManojChainani.doc" 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAAB AAAAOwAAAAAAAAAAEAAAPQAAAAEAAAD+////AAAAADoAAAD///////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ///////////////////////spcEAcQAJBAAAABK/AAAAAAAAEAAAAAAABAAA syMAAA4AYmpianQrdCsAAAAAAAAAAAAAAAAAAAAAAAAJBBYAMDoAABZBAQAW QQEASR8AAAAAAABpAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAAAAAA AAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAF0AAAAAAOAJAAAA AAAA4AkAAOAJAAAAAAAA4AkAAAAAAADgCQAAAAAAAOAJAAAAAAAA4AkAABQA AAAAAAAAAAAAAPQJAAAAAAAA9AkAAAAAAAD0CQAAAAAAAPQJAAA4AAAALAoA ABQAAABACgAANAAAAPQJAAAAAAAANBMAALYAAACICgAAAAAAAIgKAAAWAAAA ngoAAAAAAACeCgAAAAAAAJ4KAAAAAAAAngoAAAAAAACeCgAAAAAAAJ4KAAAA AAAA+RIAAAIAAAD7EgAAAAAAAPsSAAAAAAAA+xIAAAAAAAD7EgAAAAAAAPsS AAAAAAAA+xIAACQAAADqEwAA9AEAAN4VAACGAAAAHxMAABUAAAAAAAAAAAAA AAAAAAAAAAAA4AkAAAAAAACeCgAAAAAAAAAAAAAAAAAAAAAAAAAAAACeCgAA AAAAAJ4KAAAAAAAAngoAAAAAAACeCgAAAAAAAB8TAAAAAAAA6gsAAAAAAADg CQAAAAAAAOAJAAAAAAAAngoAAAAAAAAAAAAAAAAAAJ4KAAAAAAAAiAoAAAAA AADqCwAAAAAAAOoLAAAAAAAA6gsAAAAAAACeCgAA4gAAAOAJAAAAAAAAngoA AAAAAADgCQAAAAAAAJ4KAAAAAAAA+RIAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 9AkAAAAAAAD0CQAAAAAAAOAJAAAAAAAA4AkAAAAAAADgCQAAAAAAAOAJAAAA AAAAngoAAAAAAAD5EgAAAAAAAOoLAADQAwAA6gsAAAAAAAC6DwAAxgAAAFUS AACQAAAA4AkAAAAAAADgCQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA+RIAAAAAAACeCgAA AAAAAHQKAAAUAAAA4M8n2xycvwH0CQAAAAAAAPQJAAAAAAAAgAsAAGoAAADl EgAAFAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAATWFub2ogQ2hhaW5hbmkNMTQzMDAgU3RhdGxlciBCbHZkLiwgQXB0 IDYxOCwNRm9ydCBXb3J0aCwgVHguLCA3NjE1NS4NVGVsIE5vLiA6ICg3MDMp IDc4NiA3MjUzDUVtYWlsIElkLiA6IG1jaGFpbmFuaUBob3RtYWlsLmNvbQ0N U1VNTUFSWToNRXh0ZW5zaXZlIGV4cGVyaWVuY2UgaW4gZGV2ZWxvcGluZyBz b2Z0d2FyZSBhcHBsaWNhdGlvbnMgdXNpbmcgUGVvcGxlU29mdCA3LjUsIFBv d2VyQnVpbGRlciA0LngsIE9yYWNsZSA3LjMgYW5kIFNRTCBTZXJ2ZXIgNy4g UmUeZGVzaWduZWQgYW5kIGRldmVsb3BlZCBuZXcgcmVwb3J0cyBiYXNlZCBv biB0aGUgdXNlciByZXF1aXJlbWVudHMgYW5kIGV4aXN0aW5nIHJlcG9ydHMg dXRpbGl6aW5nIFBlb3BsZSBUb29scywgYW5kIFNRUpJzLiBNb2RpZmllZCBI UiwgUGF5cm9sbCBhbmQgQmVuZWZpdHMgbW9kdWxlcyB1dGlsaXppbmcgQURQ IENTUyAoQ2xpZW50IFNlcnZlciBTZXJpZXMpIEhSaXpvbiBQZW9wbGVUb29s cy4gQ3JlYXRlZCByZXBvcnRzIHV0aWxpemluZyBTUVIsIFNRTCBxdWVyaWVz IGFuZCBSZXBvcnRTbWl0aCBpbiBQYXlyb2xsLCBCZW5lZml0IGFuZCBFbXBs b3llZSBSZWxhdGlvbnNoaXAgbW9kdWxlcy4gVHJhbnNmZXJyZWQgZGF0YSBi ZXR3ZWVuIExlZ2FjeSBzeXN0ZW1zIGluIGRpZmZlcmVudCBwbGF0Zm9ybXMg KGluY2x1ZGluZyBtYWluZnJhbWUpIGF0IHJlZ3VsYXIgaW50ZXJ2YWxzIGku ZS4gQmked2Vla2x5LCBNb250aGx5IGV0Yy4gIE1vZGlmaWVkIGFuZCBDdXN0 b21pemVkIEJvbnVzIG1vZHVsZSB0byBjcmVhdGUgdGhlIEJvbnVzIENhbGN1 bGF0aW9uIHJlcG9ydCBmb3IgdmFyaW91cyBkaXZpc2lvbnMuICBVcGdyYWRl ZCBzeXN0ZW0gaW4gdGhlIFBheXJvbGwsIEhSLCBhbmQgQmVuZWZpdCBtb2R1 bGVzIGluIG9yZGVyIHRvIGNyZWF0ZSBuZXcgU1FSIHJlcG9ydHMuICBXcm90 ZSBhcHByb3hpbWF0ZWx5IGVpZ2h0IFNRTCBxdWVyaWVzIHRvIHVwbG9hZCBk YXRhIGludG8gdGhlIG5ldyBzeXN0ZW0uIEV4cGVyaWVuY2UgaW4gZGVzaWdu LCBkZXZlbG9wbWVudCwgdGVzdGluZyBhbmQgc3VjY2Vzc2Z1bCBpbXBsZW1l bnRhdGlvbiBvZiBwcm9maXQgJiBsb3NzIGFuZCBCYWxhbmNlIFNoZWV0LCBN YXJrZXRpbmcsIFByb2R1Y3Rpb24gYW5kIFdhcmVob3VzZSBtb2R1bGVzIGFu ZCBpdCdzIGludGVncmF0aW9uIHdpdGggb3RoZXIgbW9kdWxlcyB1c2luZyBQ b3dlckJ1aWxkZXIgNC54IGFuZCBPcmFjbGUgNy54LiBJbXBsZW1lbnRhdGlv biBhbmQgbWFpbnRlbmFuY2Ugb2YgdGhlIGFib3ZlIG1lbnRpb25lZCBtb2R1 bGVzIGluY2x1ZGVkIGludGVyYWN0aW9uIHdpdGggdXNlcnMgYXQgZGlmZmVy ZW50IGxldmVscyBmb3IgZ2F0aGVyaW5nIHRoZSByZXF1aXJlZCBzcGVjaWZp Y2F0aW9ucy4gRXhwZXJpZW5jZSBvZiBpbXBsZW1lbnRpbmcgVmFsdWVXaXNl My4xIChhbiBJUlAgdG9vbCwgYSBwcm9kdWN0IG9mIE1haW5Db250cm9sIElu Yy4pIHVuZGVyIFNRTCBTZXJ2ZXIgZW52aXJvbm1lbnQgd2hpY2ggY29uc2lz dHMgb2YgZGF0YSBtaWdyYXRpb24gYmV0d2VlbiBkaWZmZXJlbnQgYXBwbGlj YXRpb25zIGludG8gVmFsdWVXaXNlLCBjb25maWd1cmluZyBlbnZpcm9ubWVu dCBmb3IgZGlmZmVyZW50IHR5cGVzIG9mIHVzZXJzLCBpZGVudGlmeWluZyB2 YXJpb3VzIHR5cGVzIG9mIHByb2Nlc3NlcyBpbnZvbHZlZCBhbmQgY29udmVy dGluZyB0aGUgdXNlciBpbnB1dHMgaW50byByZXF1aXJlZCBWYWx1ZVdpc2Ug Zm9ybWF0Lg0NU0tJTExTOg1Tb2Z0d2FyZQcHB0hhcmR3YXJlBwdXaW5kb3dz IE5UDVdpbmRvd3MgOTUNVU5JWA1Ob3ZlbCBOZXRXYXJlB1NRUiwgU1FMLA1K YXZhLCANQywgQysrLCAHUGVvcGxlU29mdCA3LjUoSFIsIFBheXJvbGwsIEJl bmVmaXRzKQ1QZW9wbGVUb29scywgQXBwbGljYXRpb24gRGVzaWduZXIsIFBl b3BsZUNvZGUNQ3J5c3RhbCBSZXBvcnRzLCBuVmlzaW9uLCBQU1F1ZXJ5LCBS ZXBvcnRTbWl0aCwgDVBvd2VyQnVpbGRlciA0LngsIFZhbHVlV2lzZSAzLjEN T3JhY2xlIDcueCwgU1FMIFNlcnZlciA3LngsIFN5YmFzZSAxMS41B0lCTSBQ Q5JzDVVOSVgNVU5JU1lTBwcNRURVQ0FUSU9OOg1CLlMuIEVuZ2luZWVyaW5n IB4gQ29tcHV0ZXIgU2NpZW5jZSAoVi5FLlMuSS5ULCBCb21iYXkgVW5pdmVy c2l0eSkNDVNQRUNJQUxJWkVEIFRSQUlOSU5HIEFUVEVOREVEOg1KQVZBDVBl b3BsZVNvZnQgKFBlb3BsZVRvb2xzLCBTUVIsIEZ1bmN0aW9uYWwgY291cnNl IGZvciBQYXlyb2xsLCBIUiwgQmVuZWZpdHMpDVBvd2VyQnVpbGRlciB1bmRl ciBPcmFjbGUgcGxhdGZvcm0NT3JhY2xlIGFuZCBTeWJhc2UNQy9DKysNDA1Q Uk9GRVNTSU9OQUwgRVhQRVJJRU5DRQ1Qcm9ncmFtbWVyL0FuYWx5c3QtT3B0 aW1vcywgSW5jLCBDaGFudGlsbHksIFZBDShKYW4gMjAwMCAgliBQcmVzZW50 KQ0NVW5kZXJ3ZW50IHRyYWluaW5nIG9mIGltcGxlbWVudGluZyBWYWx1ZVdp c2UzLjEgdW5kZXIgU1FMIFNlcnZlciBlbnZpcm9ubWVudCB3aGljaCBjb25z aXN0cyBvZiA6DURhdGEgY29udmVyc2lvbiBhbmQgbWlncmF0aW9uIGJldHdl ZW4gZGlmZmVyZW50IGFwcGxpY2F0aW9ucyBpbnRvIGZvcm1hdCBhY2NlcHRh YmxlIGJ5IFZhbHVlV2lzZSwgDUNvbmZpZ3VyaW5nIGVudmlyb25tZW50IGZv ciBkaWZmZXJlbnQgdHlwZXMgb2YgdXNlcnMgZGVwZW5kaW5nIG9uIHRoZSBs ZXZlbCBvZiBzZWN1cml0eSByZXF1aXJlZCwgDUlkZW50aWZ5aW5nIHZhcmlv dXMgdHlwZXMgb2YgcHJvY2Vzc2VzIGludm9sdmVkIGFuZCBjb252ZXJ0aW5n IHRoZSB1c2VyIGlucHV0cyBpbnRvIHJlcXVpcmVkIFZhbHVlV2lzZSBmb3Jt YXQuDUltcGxlbWVudGF0aW9uIG9mIFZhbHVlV2lzZSBmb3IgdGhlIFByb2N1 cmVtZW50LCBJVCBGaXhlZCBBc3NldHMgYW5kIEVzY2FsYXRpb24gbW9kdWxl cy4NDVNvZnR3YXJlOiBWYWx1ZVdpc2UgMy4xIChhIHByb2R1Y3Qgb2YgTWFp bkNvbnRyb2wgSW5jLiksIFNRTCBTZXJ2ZXIgNy4wDQ1MZWFkIChUZWNobmlj YWwpLUJ1c2luZXNzIEluZm9ybWF0aW9uIFRlY2hub2xvZ3kgDShBdWcgOTkg liBEZWMgOTkpDQ1SZXNwb25zaWJsZSBmb3IgdGhlIFBlb3BsZVNvZnQgSFJN UywgQmVuLiBBZG1pbi4gcHJvamVjdHMgdXNpbmcgdGhlIGZvbGxvd2luZzoN SW50ZXJhY3Rpb24gd2l0aCB0aGUgZnVuY3Rpb25hbCBjb25zdWx0YW50cyBm b3IgZGV2ZWxvcG1lbnQgYW5kIGltcGxlbWVudGF0aW9uIG9mIHJlcG9ydHMg YW5kIHByb2Nlc3NlcyB1c2luZyBTUVIuIFRoaXMgaW5jbHVkZWQgOiANRG9j dW1lbnRpbmcgcHJvZ3JhbSBzcGVjaWZpY2F0aW9ucyANRGVzaWduaW5nIGFu ZCBkZXZlbG9waW5nIHJlcG9ydHMgdXNpbmcgU1FSLCBiYXNlZCBvbiB0aGUg dXNlciByZXF1aXJlbWVudHMgYW5kIHNwZWNpZmljYXRpb25zIHByb3ZpZGVk IGZvciB0aGUgcmVwb3J0cy4NRm9sbG93LXVwIHdpdGggdGhlIHVzZXJzIGZv ciB0ZXN0aW5nIGFuZCB0YWtpbmcgY2FyZSBvZiB0aGUgY2hhbmdlcyByZXF1 aXJlZCwgdGlsbCB0aGUgdXNlcnMgZm9yIHRoZSByZXBvcnRzIGdhdmUgdGhl IGZpbmFsIGFwcHJvdmFsLiANDVNvZnR3YXJlOiBQZW9wbGVTb2Z0IDcuNSAo SFJNUywgUGF5cm9sbCBhbmQgQmVuZWZpdCBBZG1pbmlzdHJhdGlvbiBtb2R1 bGVzKSwgUGVvcGxlVG9vbHMsIFNRUiBhbmQgT3JhY2xlIDcuMy4NDVByb2dy YW1tZXIvQW5hbHlzdC1CaXJsYSBDb25zdWx0YW5jeQ0oQXByIDk5IJYgQXVn IDk5KQ0NVGVhbSBMZWFkZXIgLSBEYWwtVGlsZSwgRGFsbGFzLCBUWCANUGVy Zm9ybWVkIHN5c3RlbSBzdHVkeSBvZiB0aGUgcmVxdWlyZW1lbnRzIGZvciB0 aW1lIGVzdGltYXRpb24gdG8gY29udmVydCB0aGVpciBleGlzdGluZyByZXBv cnRzIGludG8gUGVvcGxlVG9vbHMgKFNRUiwgUmVwb3J0U21pdGgpIGZvciB0 aGUgSFIsIFBheXJvbGwgYW5kIEJlbmVmaXRzIEFkbWluLiBtb2R1bGVzIGZy b20gdGhlaXIgcHJldmlvdXMgc3lzdGVtLiBUaGlzIHJlcXVpcmVkIHN0dWR5 IG9mIHRoZSBleGlzdGluZyByZXBvcnRzIGFuZCBpbnRlcmFjdGlvbiB3aXRo IHRoZSB1c2VycyBmb3IgcHJvZ3JhbSBzcGVjaWZpY2F0aW9ucy4gDVRhc2tz IHBlcmZvcm1lZDoNTGVhZCBhIHRlYW0gb2YgdHdvIHNvZnR3YXJlIHByb2Zl c3Npb25hbHMgdG93YXJkcyBzdWNjZXNzZnVsIGltcGxlbWVudGF0aW9uIG9m IHJlcG9ydHMgdXNpbmcgUGVvcGxlIFRvb2xzIChTUVIsIFJlcG9ydFNtaXRo KS4gVGhpcyBpbmNsdWRlZDogDURpc2N1c3Npb25zIHdpdGggdGhlIHVzZXJz IGF0IGRpZmZlcmVudCBsZXZlbHMgZm9yIHJlcG9ydCBzcGVjaWZpY2F0aW9u cywgDVdyaXRpbmcgcHJvZ3JhbSBzcGVjaWZpY2F0aW9ucyBmb3IgdGhlIHBy b2dyYW1tZXJzIGFuZCBkaXN0cmlidXRpbmcgdGFza3MgYmV0d2VlbiB0aGVt LCANRm9sbG93LXVwIHdpdGggdGhlIHVzZXJzIGZvciB0ZXN0aW5nIGFuZCB0 YWtpbmcgY2FyZSBvZiB0aGUgY2hhbmdlcyByZXF1aXJlZCwgdGlsbCB0aGUg dXNlcnMgZm9yIHRoZSByZXBvcnRzIGdhdmUgdGhlIGZpbmFsIGFwcHJvdmFs LiANUmUeZGVzaWduaW5nIGFuZCBkZXZlbG9waW5nIG5ldyByZXBvcnRzIHVz aW5nIFNRUiwgYmFzZWQgb24gdGhlIHVzZXIgcmVxdWlyZW1lbnRzIGFuZCBl eGlzdGluZyByZXBvcnRzLiAoUmVzdWx0aW5nIGluIGFwcHJveGltYXRlbHkg MjUgU1FSIHJlcG9ydHMgYW5kIDEyIFJlcG9ydFNtaXRoIFJlcG9ydHMpLg1U cmFuc2ZlcnJpbmcgZGF0YSBiZXR3ZWVuIHN5c3RlbXMgYnkgd3JpdGluZyBT UVJzIGFuZCBTUUwgcXVlcmllcyBmcm9tIHRoZSBiYWNrLWVuZC4gDVNvZnR3 YXJlOiBQZW9wbGUgVG9vbHMgKEhSTVMsIFBheXJvbGwgQmVuLiBBZG1pbi4g TW9kdWxlcyksIFNRUi9TUUwsIE9yYWNsZSA3LjMNDUNvbnN1bHRhbnQtIFph bGVzIENvcnBvcmF0aW9uLCBEYWxsYXMsIFRYDShPY3QgOTcgHiBBcHIgOTkp DQ1FdmFsdWF0ZWQgdGhlIFBheXJvbGwgcHJvY2VzcyBmb3IgYXBwcm94aW1h dGVseSA0LDAwMCBlbXBsb3llZXMsIHdoaWNoIGludm9sdmVkIHRocmVlIGN5 Y2xlcy4gUHJvdmlkZWQgdGVjaG5pY2FsIHN1cHBvcnQgZm9yIGdlbmVyYXRp bmcgdGhlc2UgcGF5cm9sbCBwcm9jZXNzIHJlcG9ydHMuICBXcm90ZSBTUVIg cmVwb3J0cyB0byBnZW5lcmF0ZSBkYXRhIGZpbGVzIGluIG9yZGVyIHRvIGdl bmVyYXRlIHBheXJvbGwuIE1vZGlmaWVkIGFuZCBjdXN0b21pemVkIHRoZSBQ YXlyb2xsLCBIUiwgYW5kIEJlbmVmaXQgbW9kdWxlcyB1dGlsaXppbmcgQ1NT IFBlb3BsZVRvb2xzLiAgQ3JlYXRlZCBhZGRpdGlvbmFsIHJlcG9ydHMgdXNp bmcgU1FSLCBTUUwgcXVlcmllcyBhbmQgUmVwb3J0U21pdGggaW4gUGF5cm9s bCwgQmVuZWZpdCBhbmQgRW1wbG95ZWUgUmVsYXRpb25zaGlwIG1vZHVsZXMg d2hpY2ggaW52b2x2ZWQgdHJhbnNmZXJyaW5nIGRhdGEgYmV0d2VlbiB2YXJp b3VzIHN5c3RlbXMgaW4gZGlmZmVyZW50IHBsYXRmb3JtcyAoaW5jbHVkaW5n IG1haW5mcmFtZSkgYXQgcmVndWxhciBpbnRlcnZhbHMgaS5lLiBCaR53ZWVr bHksIE1vbnRobHkgZXRjLiBNb2RpZmllZCBhbmQgQ3VzdG9taXplZCBCb251 cyBtb2R1bGUgdG8gY3JlYXRlIHRoZSBCb251cyBDYWxjdWxhdGlvbiByZXBv cnQgZm9yIHZhcmlvdXMgZGl2aXNpb25zLiAgVXBncmFkZWQgdGhlIFBheXJv bGwsIEhSIGFuZCBCZW5lZml0IG1vZHVsZXMgd2hpY2ggaW52b2x2ZWQ6IA1J bnRlcmFjdGlvbiB3aXRoIHRoZSBmdW5jdGlvbmFsIGNvbnN1bHRhbnRzIGFu ZCB1c2VycyBmb3IgcHJvZ3JhbSBzcGVjaWZpY2F0aW9uLCANQ3JlYXRpb24g b2YgbmV3IHJlcG9ydHMgcmVxdWlyZWQgYnkgdGhlIHVzZXJzIHVzaW5nIFNR UiwgDVdyaXRpbmcgU1FMIHF1ZXJpZXMgdG8gdHJhbnNmZXIgZGF0YSBpbnRv IHRoZSBuZXcgc3lzdGVtLg1Tb2Z0d2FyZTogUGVvcGxlIFRvb2xzIChIUk1T LCBQYXlyb2xsIEJlbi4gQWRtaW4uIE1vZHVsZXMpLCBTUVIvU1FMLCBPcmFj bGUgNy4zDQ1Qcm9ncmFtbWVyL0FuYWx5c3QtIEFsZXhhbmRyaWEgQ2FyYm9u LCBBbGV4YW5kcmlhLCBFZ3lwdA0oTWF5IDk2IJYgT2N0IDk3KQ0NUmVzcG9u c2libGUgZm9yIGdhdGhlcmluZyBhbmQgYW5hbHlzaXMgb2YgdGhlIGV4aXN0 aW5nIEZpbmFuY2lhbCBBY2NvdW50aW5nIFN5c3RlbS4gDUxlYWQgYSB0ZWFt IG9mIDIgZGV2ZWxvcGVycyBmb3IgdGhlIGRlc2lnbiwgZGV2ZWxvcG1lbnQs IHRlc3RpbmcgYW5kIGltcGxlbWVudGF0aW9uIG9mIHByb2ZpdCAmIGxvc3Mg YW5kIEJhbGFuY2UgU2hlZXQgbW9kdWxlIGFuZCBpdCdzIGludGVncmF0aW9u IHdpdGggb3RoZXIgbW9kdWxlcyBvZiB0aGUgZXhpc3RpbmcgU3lzdGVtLg1E ZXZlbG9wZWQgdGhlIG1hcmtldGluZywgbGFib3JhdG9yeSwgcHJvZHVjdGlv biBhbmQgd2FyZWhvdXNlIG1vZHVsZXMgYmFzZWQgb24gdGhlIGRlc2lnbiBw cm92aWRlZC4gV2FzIGFsc28gaW52b2x2ZWQgaW4gZGVzaWduaW5nIGxldmVs LiBUaGUgcHJvY2Vzc2VzIGludm9sdmVkIHdlcmUgdmVyeSBjb21wbGV4IGFu ZCByZXF1aXJlZCB0aWdodCBpbnRlZ3JhdGlvbiBiZXR3ZWVuIHRoZSBtb2R1 bGVzLiBXcm90ZSBTUUwgcXVlcmllcyBhbmQgc3RvcmVkIHByb2NlZHVyZXMg YXQgdGhlIGJhY2sgZW5kIHRvIHRyYW5zZmVyIGRhdGEgYmV0d2VlbiB0aGUg bW9kdWxlcy4NQWxzbyBpbnRlcmZhY2VkIHRoZSBhY2NvdW50aW5nIGVudHJ5 IGdlbmVyYXRpb24gcHJvY2VzcyBiZXR3ZWVuIG1hcmtldGluZyBhbmQgcmVs YXRlZCBhY2NvdW50aW5nIG1vZHVsZS4gDVByZXBhcmVkIHVzZXIgbGV2ZWwg YW5kIHN5c3RlbSBsZXZlbCBkb2N1bWVudHMgYW5kIHByb3ZpZGVkIHVzZXIg dHJhaW5pbmcgZm9yIHRoZSBhYm92ZS1tZW50aW9uZWQgbW9kdWxlcy4NU29m dHdhcmU6IFBvd2VyIEJ1aWxkZXIgNC54LCBPcmFjbGUgNw0NUHJvZ3JhbW1l ci1Jbh5ob3VzZSBQcm9qZWN0L1RlYW0gTWVtYmVyIA0oTWFyIDk2IB4gTWF5 IDk2KQ0NRGV2ZWxvcGVkIGEgcHJvamVjdCBtYW5hZ2VtZW50IHRvb2wgZm9y IHRpbWUgc2hlZXQgbWFpbnRlbmFuY2UgYW5kIG1vbml0b3JpbmcuDVNvZnR3 YXJlOiBQb3dlciBCdWlsZGVyIDQueCwgRm94IFBybw0MDVNvZnR3YXJlIEVu Z2luZWVyLSBDb21wdR5UYWN0IFNvZnR3YXJlIA0oQXByIDkyIJYgTWFyIDk2 KQ0NSW52b2x2ZWQgaW4gZGVzaWduIGFuZCBkZXZlbG9wbWVudCBvZiB0aGUg YmVsb3cgbWVudGlvbmVkIG1vZHVsZXM6DUpvYiBDb3N0aW5nIFN5c3RlbSwg QmFjayBPZmZpY2UgU3lzdGVtIGZvciBTdG9jayBFeGNoYW5nZSBCcm9rZXIs IFRoZSBXYXJlaG91c2luZyBzeXN0ZW0sIEludmVudG9yeSBtYW5hZ2VtZW50 IHN5c3RlbSwgUXVhbGl0eSBDb250cm9sLCBGaW5hbmNpYWwgQWNjb3VudGlu ZyBTeXN0ZW0gYW5kIFBheXJvbGwgU3lzdGVtDQ1CdXNpbmVzcyBQcm9jZXNz ZXMNSFIsIFBheXJvbGwsIEJlbmVmaXRzLCBGaW5hbmNpYWwgQWNjb3VudGlu ZyAoUCZMIGFuZCBCYWxhbmNlIFNoZWV0IEFjY291bnRpbmcpLCBKb2IgQ29z dGluZyBQcm9kdWN0aW9uIHN5c3RlbSwgTWFya2V0aW5nLCBXYXJlaG91c2lu ZywgU2hhcmVzIGFuZCBTdG9ja3MNDVR5cGUgb2YgV29yaw1Qcm92aWRpbmcg Y29uc3VsdGFuY3kgdG8gdGhlIGNsaWVudCBmb3IgdGhlIGltcGxlbWVudGF0 aW9uIG9mIFBlb3BsZSBUb29scyAeIEVmZm9ydHMgZXN0aW1hdGlvbiAeIERl ZmluaW5nIGRldmVsb3BtZW50LCB0ZXN0aW5nIGFuZCBpbXBsZW1lbnRhdGlv biBzdGFuZGFyZHMgHiBSZXF1aXJlbWVudHMgY29sbGVjdGlvbiBhbmQgYW5h bHlzaXMgHiBNYXBwaW5nIG9mIHJlcXVpcmVtZW50cyBhbmQgc3lzdGVtIGRl c2lnbiAeIFByZXNlbnRhdGlvbiB0byB0aGUgY2xpZW50IG9uIGZ1bmN0aW9u YWxpdHkgb2YgdmFyaW91cyBtb2R1bGVzIB4gRGVzaWduLCBEZXZlbG9wbWVu dCBhbmQgdGVzdGluZyAeIEltcGxlbWVudGF0aW9uIB4gT3B0aW1pemF0aW9u IG9mIHByb2Nlc3NlcyAeIFByb3ZpZGVkIHRyYWluaW5nIHRvIHRoZSB1c2Vy cy4NDQ1NYW5vaiBDaGFpbmFuaQ0NDSAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIBMgUEFHRSAUMxUNDQ0NAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAACKBAAAyQQAAOoEAADrBAAA BwUAAGwFAACDBQAAjgUAAKYFAAC5BQAA3gUAAN8FAADqBQAABgYAAA4GAAAq BgAAMgYAADMGAAA6BgAAPwYAAFQGAAC4CAAA2QgAAJEJAACdCQAAogkAAKUJ AADRCQAA2wkAANwKAADdCgAA7woAAPEKAAD6CgAAJAsAAAoMAAAhDAAALQwA AHEMAACQDAAAHQ0AAGQNAAB6DQAAag8AALMPAAC0DwAA5g8AAPcPAAD5DwAA 7xEAAPARAABeEgAAXxIAAIQSAACWEgAAlxIAAPQTAAAFFAAAFBcAABUXAAA/ FwAAUBcAABIbAACcGwAArhsAAK8bAADCHAAA3B4AAAIfAAAsHwAAPh8AAD8f AACOHwAAsx8AALUfAADdHwAA7x8AAPAfAAAzIAAA6yAAAP4gAACYIQAApSEA AEkjAABZIwAApSMAAPcA9QD1APUA9QD1APUA9QD1APUA9QD1APUA9QD1APUA 7gDu9+4A7uvuAPfuAO4A9+4A9QDu6ffuAPUA7un37gD37gDu99/37gD37gD3 7vfuAO4A7vcAAAAAAAAAAAAAAAAAEjUIgT4qAUNKFgBPSgAAUUoAAAADPioB BENKFgAADENKFgBPSgAAUUoAAAADNQiBDzUIgUNKFgBPSgAAUUoAAABWAAQA AA8EAAAtBAAARQQAAF4EAACABAAAgQQAAIoEAADdCgAA3goAAOYKAADvCgAA 8AoAAPEKAAD6CgAA+woAAAYLAAARCwAAFgsAACQLAAAuCwAANQsAAPwAAAAA AAAAAAAAAAD8AAAAAAAAAAAAAAAA/AAAAAAAAAAAAAAAAPwAAAAAAAAAAAAA AAD8AAAAAAAAAAAAAAAA/AAAAAAAAAAAAAAAAPwAAAAAAAAAAAAAAAD6AAAA AAAAAAAAAAAA+AAAAAAAAAAAAAAAAPgAAAAAAAAAAAAAAAD1AAAAAAAAAAAA AAAA8AAAAAAAAAAAAAAAAPAAAAAAAAAAAAAAAAD1AAAAAAAAAAAAAAAAupgE AAAAAAAAAAAAAPAAAAAAAAAAAAAAAADwAAAAAAAAAAAAAAAA8AAAAAAAAAAA AAAAAPAAAAAAAAAAAAAAAAC3AAAAAAAAAAAAAAAAtwAAAAAAAAAAAAAAAAAA AAAAAwAAFiQBNgAAFiQBFyQBApZsAAjWXAAEAAAIBxAO4h2QJAAGCAcAAAAA AAAAAAAAAAAAAAAAAAYIBwAAAAAAAAAAAAAAAAAAAAAABtIPAAAAAAAAAAAA AAAAAAAAAAAGrgYAAAAAAAAAAAAAAAAAAAAAAAQAAAMkAxYkAQMCABYkAQAB KgAAASkAAwAAAyQDABUABAAADwQAAC0EAABFBAAAXgQAAIAEAACBBAAAigQA AN0KAADeCgAA5goAAO8KAADwCgAA8QoAAPoKAACQDAAAlQwAAOAMAAADDQAA FQ0AABsNAAAdDQAANQ0AAGQNAAB6DQAAew0AANwNAAA/DgAAog4AABEPAABq DwAAaw8AALMPAAC0DwAA5g8AAPgPAAD5DwAASBAAAMwQAADwEAAAaBEAAO8R AADwEQAAXhIAAF8SAACEEgAAlhIAAJcSAAC7EgAA9BMAAAUUAACTFAAA3hQA ADcVAAC+FQAAbhYAAMQWAAAUFwAAFRcAAD8XAABRFwAAUhcAAEwaAACeGgAA 2BoAABIbAABiGwAAYxsAAJwbAACuGwAArxsAAAQcAADCHAAABx4AAHEeAADc HgAAAh8AAAMfAAAsHwAAPh8AAD8fAAAAAAAAAAAA/fv79/T09/Lv7+/v7wDs 6QAAAObm5uYA4wDpAAD73t7Z3vv7AOwAAOz9/d7e3t7Z2ewA7AAAANbW1uzT 0wAAzs7Ly8sAAAAAAAAABQgBAAkBCAIpAAgBAAkBAAUCAgAFAQUIBAAJAQgC KQAIAgAJAQAIAikACAMACQEABQIFAAUEBQgHAAkBBQIEAAUDBQIBAAUABQgF AAkBAgEBAAQDAQUKAAcCAgADAQUKAwIqAAMCKQAAUDULAAA+CwAAZAsAAJIL AADDCwAA4wsAAAsMAAAUDAAAGQwAACAMAAAhDAAAIgwAAC0MAABwDAAAcQwA AJAMAACVDAAA4AwAAAMNAAAVDQAA/AAAAAAAAAAAAAAAAPwAAAAAAAAAAAAA AAD8AAAAAAAAAAAAAAAA/AAAAAAAAAAAAAAAAPwAAAAAAAAAAAAAAAD8AAAA AAAAAAAAAAAA9wAAAAAAAAAAAAAAAPcAAAAAAAAAAAAAAAD3AAAAAAAAAAAA AAAAwQAAAAAAAAAAAAAAAL8AAAAAAAAAAAAAAAC9AAAAAAAAAAAAAAAAugAA AAAAAAAAAAAAALoAAAAAAAAAAAAAAAC3AAAAAAAAAAAAAAAAqgAAAAAAAAAA AAAAAKoAAAAAAAAAAAAAAACqAAAAAAAAAAAAAAAAqgAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAADAAACiYAC0YFAA6E5P0NxggAAgwhrCYAAAMDAAMkAAMA AAMkAwABAQAAAQAANgAAFiQBFyQBApZsAAjWXAAEAAAIBxAO4h2QJAAGCAcA AAAAAAAAAAAAAAAAAAAAAAYIBwAAAAAAAAAAAAAAAAAAAAAABtIPAAAAAAAA AAAAAAAAAAAAAAAGrgYAAAAAAAAAAAAAAAAAAAAAAAQAAAMkAxYkAQMAABYk AQATFQ0AABsNAAAdDQAANQ0AAGQNAAB6DQAAew0AANwNAAA/DgAAog4AABEP AABqDwAAaw8AALMPAAC0DwAA5g8AAPgPAAD5DwAASBAAAMwQAADwEAAAaBEA AO8RAADyAAAAAAAAAAAAAAAA7wAAAAAAAAAAAAAAAO0AAAAAAAAAAAAAAADr AAAAAAAAAAAAAAAA6QAAAAAAAAAAAAAAAOkAAAAAAAAAAAAAAADpAAAAAAAA AAAAAAAA5AAAAAAAAAAAAAAAAOQAAAAAAAAAAAAAAADkAAAAAAAAAAAAAAAA 5AAAAAAAAAAAAAAAAOkAAAAAAAAAAAAAAADdAAAAAAAAAAAAAAAA6QAAAAAA AAAAAAAAAOsAAAAAAAAAAAAAAADvAAAAAAAAAAAAAAAA7wAAAAAAAAAAAAAA ANsAAAAAAAAAAAAAAADWAAAAAAAAAAAAAAAAzwAAAAAAAAAAAAAAAMMAAAAA AAAAAAAAAADPAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADCkACiYAC0YCAA+E 0AINxgcBaAEB0AIGBykACiYAC0YDAA+E0AIFKQAKJgALRgMAAAEqAAcFAA3G CAPcCOoJTCEABQAACiYAC0YHAAABAAAAAQQAAAEBAAMAAAMkAwAMAAAKJgAL RgUADoTk/Q3GCAACDCGsJgAAABbvEQAA8BEAAF4SAABfEgAAhBIAAJYSAACX EgAAuxIAAPQTAAAFFAAAkxQAAN4UAAA3FQAAvhUAAG4WAADEFgAAFBcAABUX AAA/FwAAURcAAFIXAABMGgAAnhoAANgaAAASGwAA/QAAAAAAAAAAAAAAAPcA AAAAAAAAAAAAAAD1AAAAAAAAAAAAAAAA8wAAAAAAAAAAAAAAAPAAAAAAAAAA AAAAAAD1AAAAAAAAAAAAAAAA8wAAAAAAAAAAAAAAAO4AAAAAAAAAAAAAAADu AAAAAAAAAAAAAAAA6QAAAAAAAAAAAAAAAOIAAAAAAAAAAAAAAADiAAAAAAAA AAAAAAAA4gAAAAAAAAAAAAAAAN0AAAAAAAAAAAAAAADdAAAAAAAAAAAAAAAA 8wAAAAAAAAAAAAAAAPAAAAAAAAAAAAAAAADzAAAAAAAAAAAAAAAA8AAAAAAA AAAAAAAAAPAAAAAAAAAAAAAAAADwAAAAAAAAAAAAAAAA1gAAAAAAAAAAAAAA ANYAAAAAAAAAAAAAAADWAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAG AAADJAMKJgALRgQABSkACiYAC0YCAAcpAAomAAtGAwAPhNACBSkACiYAC0YD AAABKQADAAADJAMAAQEAAAEAAAAFKgAPhDgEEYTI+wABKgAAGBIbAABiGwAA YxsAAJwbAACuGwAArxsAAAQcAADCHAAABx4AAHEeAADcHgAAAh8AAAMfAAAs HwAAPh8AAD8fAACOHwAAsx8AALUfAADdHwAA7x8AAPAfAAAzIAAA6iAAAOsg AAD+IAAAlyEAAJghAAD9AAAAAAAAAAAAAAAA+wAAAAAAAAAAAAAAAPsAAAAA AAAAAAAAAAD4AAAAAAAAAAAAAAAA+AAAAAAAAAAAAAAAAPMAAAAAAAAAAAAA AADzAAAAAAAAAAAAAAAA7AAAAAAAAAAAAAAAAOwAAAAAAAAAAAAAAADsAAAA AAAAAAAAAAAA+AAAAAAAAAAAAAAAAPgAAAAAAAAAAAAAAAD4AAAAAAAAAAAA AAAA+AAAAAAAAAAAAAAAAPgAAAAAAAAAAAAAAADqAAAAAAAAAAAAAAAA+AAA AAAAAAAAAAAAAPgAAAAAAAAAAAAAAAD7AAAAAAAAAAAAAAAA+AAAAAAAAAAA AAAAAPgAAAAAAAAAAAAAAAD4AAAAAAAAAAAAAAAA+AAAAAAAAAAAAAAAAPgA AAAAAAAAAAAAAAD9AAAAAAAAAAAAAAAA+AAAAAAAAAAAAAAAAPgAAAAAAAAA AAAAAAAAAAAAAAABKQAABgAAAyQDCiYAC0YBAAUpAAomAAtGAQADAAADJAMA AQIAAAEBAAAbPx8AAI4fAACzHwAAtR8AAN0fAADvHwAA8B8AADMgAADqIAAA 6yAAAP4gAACXIQAAmCEAAKUhAABHIwAASCMAAEkjAACtIwAAsCMAALEjAACy IwAAsyMAAP0AAPoAAAAAAPcAAPcAAAD18vX1AAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUC JwANAQIBAQAFAgEABQAFAgIABQEDAikAABWYIQAApSEAAEcjAABIIwAASSMA AFgjAABZIwAAWiMAALAjAACxIwAAsiMAALMjAAD9AAAAAAAAAAAAAAAA+gAA AAAAAAAAAAAAAPoAAAAAAAAAAAAAAAD6AAAAAAAAAAAAAAAA9wAAAAAAAAAA AAAAAPUAAAAAAAAAAAAAAADzAAAAAAAAAAAAAAAA8QAAAAAAAAAAAAAAAPMA AAAAAAAAAAAAAADzAAAAAAAAAAAAAAAA+gAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAABJwAAAQAAAAEmAAMAAAMkAQMAAAMkAwABAQAAC6Uj AACmIwAArCMAAK0jAACuIwAAryMAALAjAACyIwAAsyMAAPHn8dvx0wDMAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAxDShYAT0oAAFFKAAAADzUIgUNKFgBPSgAAUUoAABcwSigANQiBQ0oWAE9K AABRSgAAbUgABBMwSigANQiBQ0oWAE9KAABRSgAAHANqAAAAADBKKAA1CIFD ShYAT0oAAFFKAABVCAEILgAJMAASMAAcUAEAH7DQLyCw4D0hsKAFIrCgBSOQ oAUkkKAFJbAAABewoAUYsKAFAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAASACsACgABAFsADwAC AAAAAAAAAEQAAEDx/wIARAAMAAYATgBvAHIAbQBhAGwAAAAFAAAAMSQAAB8A Q0oYAE9KAgBRSgIAX0gBBGgIAG1ICQRzSAkEdEgJBABCAAFAAQACAEIADAAJ AEgAZQBhAGQAaQBuAGcAIAAxAAAADgABAAMkAwYkAUAmAGEkAw8ANQiBQ0oW AE9KAABRSgAAAEQAAkABAAIARAAMAAkASABlAGEAZABpAG4AZwAgADIAAAAO AAIAAyQDBiQBQCYBYSQDEgA1CIE+KgFDShYAT0oAAFFKAABaAANAAQACAFoA DAAJAEgAZQBhAGQAaQBuAGcAIAAzAAAAJAADAAMkAQYkAQ3GCAACDCGsJgAA DoTk/TEkAUAmAl2E5P1hJAERADUIgU9KAABRSgAAaAgBdQgAAD4ABEABAAIA PgAMAAkASABlAGEAZABpAG4AZwAgADQAAAAIAAQABiQBQCYDEgA1CIE+KgFD ShYAT0oAAFFKAABKAAVAAQACAEoADAAJAEgAZQBhAGQAaQBuAGcAIAA1AAAA FgAFAAYkAQ3GCwAD3AjqCUwhAAAAQCYEDwA1CIFDShYAT0oAAFFKAAAAAAAA AAAAAAA8AEFA8v+hADwADAAWAEQAZQBmAGEAdQBsAHQAIABQAGEAcgBhAGcA cgBhAHAAaAAgAEYAbwBuAHQAAAAAAAAAAAAAAAAARgD+DwEA8gBGAAwACwBP AG0AbgBpAFAAYQBnAGUAIAAjADEAAAAdAA8ADcYIAAKEABoVAAIOhBgSD4SE AF2EGBJehIQAAAAARgD+DwEAAgFGAAwACwBPAG0AbgBpAFAAYQBnAGUAIAAj ADIAAAAdABAADcYIAAKAAC0FAAIOhAUiD4SAAF2EBSJehIAAAAAAVAD+DwEA EgFUAAwACwBPAG0AbgBpAFAAYQBnAGUAIAAjADMAAAArABEAAyQDDcYIAAJk AEADAAAOhGQAD4RkABGE3AJdhGQAXoRkAGCE3AJhJAMAAABGAP4PAQAiAUYA DAALAE8AbQBuAGkAUABhAGcAZQAgACMANAAAAB0AEgANxggAAn8AvQoAAg6E dRwPhH8AXYR1HF6EfwAAAABGAP4PAQAyAUYADAALAE8AbQBuAGkAUABhAGcA ZQAgACMANQAAAB0AEwANxggAAnsA6h4AAg6ESAgPhHsAXYRICF6EewAAAABM AP4PAQBCAUwADAALAE8AbQBuAGkAUABhAGcAZQAgACMANgAAACMAFAANxg4A BHoAIwY/FCUZAAAAAg6EDQ4PhHoAXYQNDl6EegAAAABCAP4PAQBSAUIADAAL AE8AbQBuAGkAUABhAGcAZQAgACMANwAAABoAFQANxgUAAUEDAA6EbwAPhEED XYRvAF6EQQMAAEwA/g8BAGIBTAAMAAsATwBtAG4AaQBQAGEAZwBlACAAIwA4 AAAAIwAWAA3GDgAEewAlBkMU4RgAAAACDoRRDg+EewBdhFEOXoR7AAAAAEwA /g8BAHIBTAAMAAsATwBtAG4AaQBQAGEAZwBlACAAIwA5AAAAIwAXAA3GDgAE eQAhBjgUGiEAAAACDoQYBg+EeQBdhBgGXoR5AAAAAEoA/g8BAIIBSgAMAAwA TwBtAG4AaQBQAGEAZwBlACAAIwAxADAAAAAgABgADcYLAAN1ACQG4A8AAAIO hFIXD4R1AF2EUhdehHUAAABOAP4PAQCSAU4ADAAMAE8AbQBuAGkAUABhAGcA ZQAgACMAMQAyAAAAIwAZAA3GDgAEcwAXBjUURiIAAAACDoTsBA+EcwBdhOwE XoRzAAAAAE4A/g8BAKIBTgAMAAwATwBtAG4AaQBQAGEAZwBlACAAIwAxADQA AAAjABoADcYOAAR4ABIGMBQsIwAAAAIOhAYED4R4AF2EBgRehHgAAAAASgD+ DwEA8gBKAAwADQBPAG0AbgBpAFAAYQBnAGUAIAAjADIANQA3AAAAHQAbAA3G CAACZAAHAgACDoQUKA+EKQNdhBQoXoQpAwAAAFAA/g8BAAIBUAAMAA0ATwBt AG4AaQBQAGEAZwBlACAAIwAyADUAOAAAACMAHAANxg4ABDMGDwofGN8oAAAA Ag6EPAEPhKYCXYQ8AV6EpgIAAABMAP4PAQASAUwADAANAE8AbQBuAGkAUABh AGcAZQAgACMAMgA1ADkAAAAgAB0ADcYLAAMuBg8KShYAAAIOhNETD4ShAl2E 0RNehKECAABGAP4PAQAiAUYADAANAE8AbQBuAGkAUABhAGcAZQAgACMAMgA2 ADAAAAAaAB4ADcYFAAH2CAAOhGQAD4RpBV2EZABehGkFAABQAP4PAQAyAVAA DAANAE8AbQBuAGkAUABhAGcAZQAgACMAMgA2ADEAAAAjAB8ADcYOAAQsBgQK Ihi3KQAAAAIOhGQAD4SfAl2EZABehJ8CAAAARgD+DwEAQgFGAAwADQBPAG0A bgBpAFAAYQBnAGUAIAAjADIANgA0AAAAGgAgAA3GBQABJQYADoSPGw+EmAJd hI8bXoSYAgAARgD+DwEAUgFGAAwADQBPAG0AbgBpAFAAYQBnAGUAIAAjADIA NgA1AAAAGgAhAA3GBQABIgYADoTNGQ+ElQJdhM0ZXoSVAgAARgD+DwEAYgFG AAwADQBPAG0AbgBpAFAAYQBnAGUAIAAjADIANgA2AAAAGgAiAA3GBQAB+AgA DoSBDg+EawVdhIEOXoRrBQAARgD+DwEAcgFGAAwADQBPAG0AbgBpAFAAYQBn AGUAIAAjADIANgA5AAAAGgAjAA3GBQABMAYADoSxHg+EowJdhLEeXoSjAgAA RgD+DwEAggFGAAwADQBPAG0AbgBpAFAAYQBnAGUAIAAjADIANwAxAAAAGgAk AA3GBQABGAYADoRNIA+EiwJdhE0gXoSLAgAARgD+DwEAkgFGAAwADQBPAG0A bgBpAFAAYQBnAGUAIAAjADIANwAyAAAAGgAlAA3GBQAB8AgADoTQCw+EYwVd hNALXoRjBQAALAAfQAEAYgIsAAwABgBIAGUAYQBkAGUAcgAAAA0AJgANxggA AuAQwCEBAgAAACwAIEABAHICLAAMAAYARgBvAG8AdABlAHIAAAANACcADcYI AALgEMAhAQIAAAAmAClAogCBAiYADAALAFAAYQBnAGUAIABOAHUAbQBiAGUA cgAAAAAAOABCQAEAkgI4AAwACQBCAG8AZAB5ACAAVABlAHgAdAAAAAgAKQAD JANhJAMMAENKFgBPSgAAUUoAAEAAUEABAKICQAAMAAsAQgBvAGQAeQAgAFQA ZQB4AHQAIAAyAAAACAAqAAMkA2EkAw8ANQiBQ0oWAE9KAABRSgAAAAAAAACz HwAABAAAOgAAAAD/////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAARAAAAEQAAAGgAAABoAAAAaAAAAGsAAAAABAAApSMAALMjAAATAAAAHAAA AAAEAAA1CwAAFQ0AAO8RAAASGwAAmCEAALMjAAAUAAAAFgAAABcAAAAYAAAA GQAAABsAAAAABAAAPx8AALMjAAAVAAAAGgAAAFwAAABjAAAAZQAAAGsAAAAT IfT/lYAAAAAABQAAAAYAAAAOAAAAFQAAABwAAAA5AAAAOwAAANgBAADeAQAA 3wEAAOoBAACHBwAAkQcAAKMHAACqBwAArAcAALMHAAC1BwAAwAcAAMMHAADP BwAAlQgAAJ8IAAClDgAAqA4AACETAAAmEwAAHBcAACIXAADIGwAAzRsAAEkf AABOHwAATx8AAFcfAACxHwAAtB8AABwABwAcAAcAHAAHABwABwAcAAcAHAAH ABwABwAcAAcAHAAHABwABwAcAAcAHAAHABwABwAcAAcABAAHABwABwAcAAcA HAAHAAIAAAAAAEsAAABOAAAAZgAAAGkAAADXCQAA2wkAAPkLAAAiDAAAKgwA ADIMAABoDwAAbw8AABIXAAA9FwAASR8AALEfAAC0HwAABwAaAAcAGgAHABoA BwAaAAcAGgAHABoABwAEAAcABwACAP//FAAAAAcAUgBhAHYAaQByAGEAagAh AE8AOgBcAFIAZQBzAHUAbQBlAHMAXABBAEQASQBcAE0AYQBuAG8AagAgAEMA aABhAGkAbgBhAG4AaQAuAGQAbwBjAA0AQQBkAG0AaQBuAGkAcwB0AHIAYQB0 AG8AcgAyAEMAOgBcAFQARQBNAFAAXABBAHUAdABvAFIAZQBjAG8AdgBlAHIA eQAgAHMAYQB2AGUAIABvAGYAIABNAGEAbgBvAGoAQwBoAGEAaQBuAGEAbgBp AHIAYQB2AGkALgBhAHMAZAANAEEAZABtAGkAbgBpAHMAdAByAGEAdABvAHIA KwBDADoAXABtAGMAaABhAGkAbgBhAG4AaQBcAEEAZABpAFwAcgBhAHYAaQBc AE0AYQBuAG8AagBDAGgAYQBpAG4AYQBuAGkAcgBhAHYAaQAuAGQAbwBjAA0A QQBkAG0AaQBuAGkAcwB0AHIAYQB0AG8AcgAzAEMAOgBcAFQARQBNAFAAXABB AHUAdABvAFIAZQBjAG8AdgBlAHIAeQAgAHMAYQB2AGUAIABvAGYAIABNAGEA bgBvAGoAQwBoAGEAaQBuAGEAbgBpAHIAYQB2AGkAXwAuAGEAcwBkAA0AQQBk AG0AaQBuAGkAcwB0AHIAYQB0AG8AcgArAEMAOgBcAG0AYwBoAGEAaQBuAGEA bgBpAFwAQQBkAGkAXAByAGEAdgBpAFwATQBhAG4AbwBqAEMAaABhAGkAbgBh AG4AaQByAGEAdgBpAC4AZABvAGMADQBTAHUAbgBlAGUAbAAgAFMAYQB3AGEA bgB0AB4AQwA6AFwAbQBjAGgAYQBpAG4AYQBuAGkAXABNAGEAbgBvAGoAQwBo AGEAaQBuAGEAbgBpAC4ARABPAEMADQBTAHUAbgBlAGUAbAAgAFMAYQB3AGEA bgB0ABQAQQA6AFwATQBhAG4AbwBqAEMAaABhAGkAbgBhAG4AaQAuAEQATwBD AA0AUwB1AG4AZQBlAGwAIABTAGEAdwBhAG4AdAAUAEEAOgBcAE0AYQBuAG8A agBDAGgAYQBpAG4AYQBuAGkALgBEAE8AQwANAFMAdQBuAGUAZQBsACAAUwBh AHcAYQBuAHQAFABBADoAXABNAGEAbgBvAGoAQwBoAGEAaQBuAGEAbgBpAC4A RABPAEMAEQBFAG0AZQByAGEAbABkACAAUwBvAGwAdQB0AGkAbwBuAHMAGwBD ADoAXABtAGMAaABhAGkAbgBcAE0AYQBuAG8AagBDAGgAYQBpAG4AYQBuAGkA LgBkAG8AYwAHAIsujhUBAAkE/w8AAAAAAAAAAAAAAAAAAAAAAQBFPUNRAQAJ BP8PAAAAAAAAAAAAAAAAAAAAAAEAdgwRUgEACQT/DwAAAAAAAAAAAAAAAAAA AAABAHtH6FYBAAkE/w8AAAAAAAAAAAAAAAAAAAAAAQC/M71bAQAJBP8PAAAA AAAAAAAAAAAAAAAAAAEAtE+EewEACQT/DwAAAAAAAAAAAAAAAAAAAAABAFMC /n8BAAkE/w8AAAAAAAAAAAAAAAAAAAAAAQABAAAAFwAAAAAAAAAAAAAAAAAA AAAAAAALGAAAD4RoARGEmP4VxgUAAWgBBl6EaAFghJj+T0oBAFFKAQBvKAAB ALfwAQAAABcAAAAAAAAAAAAAAAAAAAAAAAAACxgAAA+EaAERhJj+FcYFAAFo AQZehGgBYISY/k9KAQBRSgEAbygAAQC38AEAAAAXAAAAAAAAAAAAAAAAAAAA AAAAAAsYAAAPhGgBEYSY/hXGBQABaAEGXoRoAWCEmP5PSgEAUUoBAG8oAAEA t/ABAAAAFwAAAAAAAAAAAAAAAAAAAAAAAAALGAAAD4RoARGEmP4VxgUAAWgB Bl6EaAFghJj+T0oBAFFKAQBvKAABALfwAQAAABcAAAAAAAAAAAAAAAAAAAAA AAAACxgAAA+EaAERhJj+FcYFAAFoAQZehGgBYISY/k9KAQBRSgEAbygAAQC3 8AEAAAAXAAAAAAAAAAAAAAAAAAAAAAAAAAsYAAAPhGgBEYSY/hXGBQABaAEG XoRoAWCEmP5PSgEAUUoBAG8oAAEAt/ABAAAAFwAAAAAAAAAAAAAAAAAAAAAA AAALGAAAD4RoARGEmP4VxgUAAWgBBl6EaAFghJj+T0oBAFFKAQBvKAABALfw BwAAAIsujhUAAAAAAAAAAAAAAABTAv5/AAAAAAAAAAAAAAAAdgwRUgAAAAAA AAAAAAAAAL8zvVsAAAAAAAAAAAAAAAC0T4R7AAAAAAAAAAAAAAAAe0foVgAA AAAAAAAAAAAAAEU9Q1EAAAAAAAAAAAAAAAD///////////////////////// //////////////8HAAAAAAAAAAAAAAAAAAAAAAD/QAOAAQAcFwAAHBcAABS+ cwABAAEAHBcAAAAAAAAcFwAAAAAAAAIQAAAAAAAAALMfAABAAAAIAEAAAAMA AABHFpABAAACAgYDBQQFAgMEhzoAAAAAAAAAAAAAAAAAAP8AAAAAAAAAVABp AG0AZQBzACAATgBlAHcAIABSAG8AbQBhAG4AAAA1FpABAgAFBQECAQcGAgUH AAAAAAAAABAAAAAAAAAAAAAAAIAAAAAAUwB5AG0AYgBvAGwAAAAzJpABAAAC CwYEAgICAgIEhzoAAAAAAAAAAAAAAAAAAP8AAAAAAAAAQQByAGkAYQBsAAAA IgAEAEEAqBgA8NACAABoAQAAAACqC0TGuQtExqkbQ6YEAAUAAACGBAAAzBkA AAEADQAAAAQAAwA3AAAAAAAAAAAAAAABAAEAAAABAAAAAAAAACEDAPAQAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAyAAAAEAAZAGQAAAAZAAAArh8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC AAAAAAD//xIAAAAAAAAAFwBQAFIATwBGAEUAUwBTAEkATwBOAEEATAAgAEUA WABQAEUAUgBJAEUATgBDAEUAAAAAAAAABgBrAGsAdQBtAGEAcgARAEUAbQBl AHIAYQBsAGQAIABTAG8AbAB1AHQAaQBvAG4AcwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAD+/wAABAoCAAAAAAAAAAAAAAAAAAAAAAABAAAA4IWf8vlP aBCrkQgAKyez2TAAAACIAQAAEQAAAAEAAACQAAAAAgAAAJgAAAADAAAAuAAA AAQAAADEAAAABQAAANQAAAAHAAAA4AAAAAgAAAD0AAAACQAAABABAAASAAAA HAEAAAoAAAA4AQAACwAAAEQBAAAMAAAAUAEAAA0AAABcAQAADgAAAGgBAAAP AAAAcAEAABAAAAB4AQAAEwAAAIABAAACAAAA5AQAAB4AAAAYAAAAUFJPRkVT U0lPTkFMIEVYUEVSSUVOQ0UAHgAAAAEAAAAAUk9GHgAAAAcAAABra3VtYXIA SR4AAAABAAAAAGt1bR4AAAALAAAATm9ybWFsLmRvdABMHgAAABIAAABFbWVy YWxkIFNvbHV0aW9ucwBJRR4AAAACAAAANABlch4AAAATAAAATWljcm9zb2Z0 IFdvcmQgOC4wAEVAAAAAAF7QsgAAAABAAAAAABaoyFCFvwFAAAAAABxmuhqc vwFAAAAAADbX0hycvwEDAAAAAQAAAAMAAACGBAAAAwAAAMwZAAADAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAA/v8AAAQKAgAAAAAAAAAAAAAAAAAAAAAAAgAAAALVzdWc LhsQk5cIACss+a5EAAAABdXN1ZwuGxCTlwgAKyz5rmgBAAAkAQAADAAAAAEA AABoAAAADwAAAHAAAAAFAAAAoAAAAAYAAACoAAAAEQAAALAAAAAXAAAAuAAA AAsAAADAAAAAEAAAAMgAAAATAAAA0AAAABYAAADYAAAADQAAAOAAAAAMAAAA BAEAAAIAAADkBAAAHgAAACUAAABBdGxhbnRpYyBEdW5jYW5zIEludGVybmF0 aW9uYWwsIEluYy4AAAAAAwAAADcAAAADAAAADQAAAAMAAACuHwAAAwAAADEV CAALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAALAAAAAAAAAB4QAAABAAAAGAAA AFBST0ZFU1NJT05BTCBFWFBFUklFTkNFAAwQAAACAAAAHgAAAAYAAABUaXRs ZQADAAAAAQAAAAAAmAAAAAMAAAAAAAAAIAAAAAEAAAA2AAAAAgAAAD4AAAAB AAAAAgAAAAoAAABfUElEX0dVSUQAAgAAAOQEAABBAAAATgAAAHsAOQBEAEIA RQAxADcANgAwAC0AMAA3AEQAQgAtADEAMQBEADQALQBBADUARABGAC0AMAAw AEEAMABDADkAQgBCAEEAQgBCAEUAfQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAEAAAACAAAAAwAAAAQAAAAFAAAABgAAAAcAAAAIAAAA CQAAAAoAAAALAAAADAAAAA0AAAAOAAAADwAAABAAAAARAAAAEgAAABMAAAAU AAAAFQAAABYAAAAXAAAAGAAAABkAAAAaAAAAGwAAABwAAAAdAAAA/v///x8A AAAgAAAAIQAAACIAAAAjAAAAJAAAACUAAAAmAAAAJwAAACgAAAApAAAA/v// /ysAAAAsAAAALQAAAC4AAAAvAAAAMAAAADEAAAD+////MwAAADQAAAA1AAAA NgAAADcAAAA4AAAAOQAAAP7////9////PAAAAP7////+/////v////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////////////////////////////UgBvAG8AdAAgAEUAbgB0 AHIAeQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAABYABQH//////////wMAAAAGCQIAAAAAAMAAAAAAAABGAAAAAMCZs88a nL8BoPcw2xycvwE+AAAAgAAAAAAAAAAxAFQAYQBiAGwAZQAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADgAC AP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAB4AAABkFgAAAAAAAFcAbwByAGQARABvAGMAdQBtAGUAbgB0AAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAaAAIBBQAAAP// ////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA ADA6AAAAAAAABQBTAHUAbQBtAGEAcgB5AEkAbgBmAG8AcgBtAGEAdABpAG8A bgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACgAAgECAAAABAAAAP////8A AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAqAAAAABAAAAAA AAAFAEQAbwBjAHUAbQBlAG4AdABTAHUAbQBtAGEAcgB5AEkAbgBmAG8AcgBt AGEAdABpAG8AbgAAAAAAAAAAAAAAOAACAf///////////////wAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADIAAAAAEAAAAAAAAAEAQwBv AG0AcABPAGIAagAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAASAAIBAQAAAAYAAAD/////AAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGoAAAAAAAAATwBiAGoAZQBjAHQA UABvAG8AbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAABYAAQD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAKD3 MNscnL8BoPcw2xycvwEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAEAAAD+//////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////////////////////////////////////AQD+/wMKAAD/ ////BgkCAAAAAADAAAAAAAAARhgAAABNaWNyb3NvZnQgV29yZCBEb2N1bWVu dAAKAAAATVNXb3JkRG9jABAAAABXb3JkLkRvY3VtZW50LjgA9DmycQAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAA= ------=_NextPart_000_39d3ccb9_3a38f635$27b0fcef-- From owner-sqr-users@list.iex.net Mon Apr 3 02:36:35 2000 Date: Mon, 3 Apr 2000 16:57:38 +1000 From: Pietersz Mark x8938 Subject: Oracle Hints Folks, Thanks for all your responses. Seems that the problem that I am experiencing is related to SQR having problems with using substitution variables in the FROM part of a BEGIN-SELECT statement. They just vapourize !!! This in turn has caused the statement to be incorrectly formatted Regards Mark Pietersz ( stranger things happen at sea ) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This email message has been swept for the presence of computer viruses. CitiPower Pty ACN 064 651 056 ********************************************************************** From owner-sqr-users@list.iex.net Mon Apr 3 03:01:37 2000 Date: Mon, 3 Apr 2000 09:21:52 +0200 From: Philippe DAVID Subject: Another problem with CSV Hello all I have an other problem using EH_CSV flag I used it with a SQR programm which generating a report and it works fine. Then, I added some lines to my program and the .SPF remain fine but the .CSV file is empty. Can someone help me??? Thanks Philippe DAVID Editions GLENAT 6 rue Lt Chanaron 38000 GRENOBLE 33 (0)4 76 88 75 92 From owner-sqr-users@list.iex.net Mon Apr 3 17:55:14 2000 Date: Mon, 3 Apr 2000 13:34:35 +0200 From: Tony Moodley This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D60.7EE39FB2 Content-Type: text/plain unsubscribe ------_=_NextPart_001_01BF9D60.7EE39FB2 Content-Type: text/html

    unsubscribe

------_=_NextPart_001_01BF9D60.7EE39FB2-- From owner-sqr-users@list.iex.net Mon Apr 3 07:14:49 2000 Date: Mon, 3 Apr 2000 12:41:38 +0100 From: "Slattery, Chad" Subject: Re: Performance issue on large select. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D61.92E0AE50 Content-Type: text/plain; charset="iso-8859-1" Guys, Thanks for all the helpful suggestions with my performance question, I created an index (my first one,yaaay) and using my original code structure it increased the speed about 50 fold. We had'nt had any performance problems before so indexing was never an issue. thanks again, Chad. -----Original Message----- From: Bob Buford-Abba Systems [mailto:bbuford@GALEIND.COM] Sent: Thursday, March 30, 2000 7:50 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Performance issue on large select. but that still has a different select cursor for each number - isn't that a major contributor to the overhead? perhaps something more like this? begin-select field1 &f1 field2 &f2 ... ... field250 &250 do write_file from table2 where number in (select number from table1) order by table2.number end-select -----Original Message----- From: Arnon Oppenheimer [ mailto:arnono@SEMECH.CO.IL ] Sent: Thursday, March 30, 2000 11:57 AM To: SQR-USERS@list.iex.net Subject: Re: Performance issue on large select. The benefit of the subquery is saving tempspace process. If you do have (good) index on table2.num, you can try this : (let me know in case it helps and you want to know why....) begin-procedure get_fields move &num to $num edit 999999999 ! prepare dynamic value. begin-select field1 &f1 field2 &f2 ... ... field250 &250 do write_file from table2 where number = [$num] ! dynamic SQL end-select end-procedure get_fields Regards, Arnon Oppenheimer ------------------------------------------------------------------- SEMECH SOFTWARE MARKETING LTD. TEL : (972) - 3 - 5333144 FAX : (972) - 3 - 5333132 Email: arnono@semech.co.il ------------------------------------------------------------------- ----- Original Message ----- From: Steven Calvert To: Sent: Thursday, March 30, 2000 5:25 PM Subject: Re: Performance issue on large select. > My .02: > > IMHO a single select should help (depends on the server configuration). Also, you > should try creating an index on the "num" fields in both tables if doing the table > join (only in table2 if doing the nested select). Finally, try dropping and > re-creating the index(es) ... Oracle indexes sometimes become "unbalanced" (or > even "invalid"), which decreases performance. > > And keep your fingers crossed! > > Steve > > Ray Ontko wrote: > > > Chad, > > > > Is there a reason you can't join the two tables and do > > one select? > > > > begin-select > > field1 &f1 > > field2 &f2 > > ... > > field250 &250 > > do write_file > > from table1 , table2 > > where table1.num = table2.num > > end-select > > > > Ray > > > > [Charset iso-8859-1 unsupported, filtering to ASCII...] > > > hi all, > > > any help would be appreciated with the following problem. Im running a > > > large sqr ver 4.3 against Oracle 8 on an Nt machine and its taking 3 hours > > > to run. Ill have to run this frequently and could do with better > > > performance. Heres what Im doing. > > > Im selecting 250 fields from a table 6500 times and then writing the record > > > out to a file. Ive tried to select all the fields in one procedure and have > > > also tried 250 different begin and end selects within one procedure. Its > > > slower the second way. I know the issue is with the selecting and not with > > > writing out as I tested commenting the write procedure. Anyone got any > > > suggestions for performance on such a large select. > > > Below is the basics of what Im doing. > > > > > > Tia and fingers crossed coz its running at the moment. > > > Chad > > > > > > begin-procedure get_num > > > begin-select > > > number &num ! There are 6500 numbers > > > do get_fields > > > from table1 > > > end-select > > > end-procedure get_num > > > > > > begin-procedure get_fields > > > begin-select > > > field1 &f1 > > > field2 &f2 > > > ... > > > ... > > > field250 &250 > > > do write_file > > > from table2 > > > where number = &num > > > end-select > > > end-procedure get_fields > > > > > > begin_procedure write_file > > > string &f1 &f2 .... &f250 by ',' into $rec > > > write 1 from $rec > > > end-procedure write_file > > > > ---------------------------------------------------------------------- > > Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 > > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > -- > Steven Calvert > calvert@uleth.ca > University of Lethbridge > (403)329-2071 ------_=_NextPart_001_01BF9D61.92E0AE50 Content-Type: text/html; charset="iso-8859-1" RE: Performance issue on large select.
Guys,
Thanks for all the helpful suggestions with my performance question,  I created an index (my first one,yaaay) and  using my original code structure it increased the speed about 50 fold. We had'nt had any performance problems before so indexing was never an issue.
 
thanks again,
Chad. 
 
 
 -----Original Message-----
From: Bob Buford-Abba Systems [mailto:bbuford@GALEIND.COM]
Sent: Thursday, March 30, 2000 7:50 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Performance issue on large select.

but that still has a different select cursor for each number - isn't that a major contributor to the overhead?

perhaps something more like this?

 begin-select
 field1  &f1
 field2  &f2
 ...
 ...
field250 &250
   do write_file
 from table2
 where number in (select number from table1)
order by table2.number
end-select



-----Original Message-----
From: Arnon Oppenheimer [mailto:arnono@SEMECH.CO.IL]
Sent: Thursday, March 30, 2000 11:57 AM
To: SQR-USERS@list.iex.net
Subject: Re: Performance issue on large select.


The benefit of the subquery is saving tempspace process.
If you do have (good) index on table2.num, you can try this :
(let me know in case it helps and you want to know why....)

 begin-procedure get_fields
move &num to $num edit 999999999 ! prepare dynamic value.
 begin-select
 field1  &f1
 field2  &f2
 ...
 ...
field250 &250
   do write_file
 from table2
 where number = [$num]                       ! dynamic SQL
end-select
end-procedure get_fields


Regards,
Arnon Oppenheimer
 -------------------------------------------------------------------
 SEMECH SOFTWARE MARKETING LTD.
 TEL : (972) - 3 - 5333144
 FAX : (972) - 3 - 5333132
 Email: arnono@semech.co.il
 -------------------------------------------------------------------
----- Original Message -----
From: Steven Calvert <calvert@ULETH.CA>
To: <SQR-USERS@list.iex.net>
Sent: Thursday, March 30, 2000 5:25 PM
Subject: Re: Performance issue on large select.


> My .02:
>
> IMHO a single select should help (depends on the server configuration).
Also, you
> should try creating an index on the "num" fields in both tables if doing
the table
> join (only in table2 if doing the nested select). Finally, try dropping
and
> re-creating the index(es) ... Oracle indexes sometimes become "unbalanced"
(or
> even "invalid"), which decreases performance.
>
> And keep your fingers crossed! <grin>
>
> Steve
>
> Ray Ontko wrote:
>
> > Chad,
> >
> > Is there a reason you can't join the two tables and do
> > one select?
> >
> > begin-select
> > field1   &f1
> > field2   &f2
> > ...
> > field250 &250
> >    do write_file
> > from table1 , table2
> > where table1.num = table2.num
> > end-select
> >
> > Ray
> >
> > [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > > hi all,
> > > any help would be appreciated with the following problem.  Im running
a
> > > large sqr ver 4.3 against Oracle 8 on an Nt machine and its taking 3
hours
> > > to run.  Ill have to run this frequently and could do with better
> > > performance.  Heres what Im doing.
> > > Im selecting 250 fields from a table 6500 times and then writing the
record
> > > out to a file.  Ive tried to select all the fields in one procedure
and have
> > > also tried 250 different begin and end selects within one procedure.
Its
> > > slower the second way.  I know the issue is with the selecting and not
with
> > > writing out as I tested commenting the write procedure.  Anyone got
any
> > > suggestions for performance on such a large select.
> > > Below is the basics of what Im doing.
> > >
> > > Tia and fingers crossed coz its running at the moment.
> > > Chad
> > >
> > > begin-procedure get_num
> > > begin-select
> > > number  &num   ! There are 6500 numbers
> > >  do get_fields
> > > from table1
> > > end-select
> > > end-procedure get_num
> > >
> > > begin-procedure get_fields
> > > begin-select
> > > field1  &f1
> > > field2  &f2
> > > ...
> > > ...
> > > field250 &250
> > >  do write_file
> > > from table2
> > > where number = &num
> > > end-select
> > > end-procedure get_fields
> > >
> > > begin_procedure write_file
> > >  string &f1 &f2 .... &f250 by ',' into $rec
> > >  write 1 from $rec
> > > end-procedure write_file
> >
> > ----------------------------------------------------------------------
> > Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> > Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>
> --
> Steven Calvert
> calvert@uleth.ca
> University of Lethbridge
> (403)329-2071

------_=_NextPart_001_01BF9D61.92E0AE50-- From owner-sqr-users@list.iex.net Mon Apr 3 09:08:23 2000 Date: Mon, 3 Apr 2000 13:30:54 GMT From: Madav V Subject: Deleting rows in flatfile Iam writing an SQR for filtering a flatfile. It is posting bad rows into suspend file and remaining into output file. The records in suspend file will be used after corrections. I have to delete completely some bad rows from flatfile(should not even send it to suspend file). I know how to delete a file. But problem is with deleting rows. Can anybody help me... Regards, Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Apr 3 09:30:25 2000 Date: Mon, 3 Apr 2000 13:43:23 +0000 From: Steve Greenwood Hello, Has anyone had any luck right-justifying a column of text using a proportional font? My users want to see a report formatted as follows: ORDER: 12345 LINE NO: 2 ORDER DATE: 04/01/2000 where the end of the labels line up. Unfortunately, I haven't been able to accomplish this using a proportional font (which, of course, is what they want to use for the report). I am using SQR version 4.3.2.1. Thanks in advance, Steve Greenwood From owner-sqr-users@list.iex.net Mon Apr 3 09:34:47 2000 Date: Mon, 3 Apr 2000 15:47:39 +0200 From: Tony Moodley This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D73.1613F10E Content-Type: text/plain unsubscribe ------_=_NextPart_001_01BF9D73.1613F10E Content-Type: text/html

unsubscribe

------_=_NextPart_001_01BF9D73.1613F10E-- From owner-sqr-users@list.iex.net Mon Apr 3 09:28:14 2000 Date: Mon, 3 Apr 2000 14:55:45 +0100 From: "Slattery, Chad" Subject: Re: Deleting rows in flatfile This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D74.4F3521B4 Content-Type: text/plain; charset="iso-8859-1" Madav, Id try something like reading the flat file with the bad rows, then outputting the row to another file unless its bad. Use an 'if' statement on parsing the row. Of course the bad rows would have to have a unique identifier of some sort to let you know that they are bad. If it doesnt than how do you know which are which? hth, Chad. ps (you could try sending them to bed without dinner!) :) -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, April 03, 2000 2:31 PM To: SQR-USERS@LIST.IEX.NET Subject: Deleting rows in flatfile Iam writing an SQR for filtering a flatfile. It is posting bad rows into suspend file and remaining into output file. The records in suspend file will be used after corrections. I have to delete completely some bad rows from flatfile(should not even send it to suspend file). I know how to delete a file. But problem is with deleting rows. Can anybody help me... Regards, Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------_=_NextPart_001_01BF9D74.4F3521B4 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Deleting rows in flatfile

Madav,
Id try something like reading the flat file with the = bad rows, then outputting the row to another file unless its bad.  = Use an 'if' statement on parsing the row.

 Of course the bad rows would have to have a = unique identifier of some sort to let you know that they are bad.  = If it doesnt than how do you know which are which?

hth,
Chad.
ps (you could try sending them to bed without = dinner!) :)

-----Original Message-----
From: Madav V [mailto:vmadav@HOTMAIL.COM]=
Sent: Monday, April 03, 2000 2:31 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Deleting rows in flatfile


  Iam writing an SQR for filtering a flatfile. = It is posting bad rows into
suspend file and remaining into output file. The = records in suspend file
will be used after corrections.
  I have to delete completely some bad rows = from flatfile(should not even
send it to suspend file).
  I know how to delete a file. But problem is = with deleting rows.
  Can anybody help me...

Regards,
Madav
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

------_=_NextPart_001_01BF9D74.4F3521B4-- From owner-sqr-users@list.iex.net Mon Apr 3 09:34:22 2000 Date: Mon, 3 Apr 2000 06:57:07 -0700 From: "Lynds,Rick" Subject: Re: Deleting rows in flatfile Madav, Depending on what you are doing: 1. If you are detecting the bad row while you are creating the flat file, then simply don't write the row. 2. If you are detecting the row while processing the flat file as input, then you need to expand your program to create a new flat file (without the bad rows). There is no way to directly delete a bad row from a flat file, so you need to copy the file row by row and skip the bad rows. The simplest way to do this is to write out each row into another flat file while you are processing the input file. Of course, this could be a lot of overhead if there are no bad rows at all, but that is one of the inherent inefficiencies of flat-file processing. Good Luck - send me a note if you need additional help or sample code. Rick Lynds Metropolitan Water District -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, April 03, 2000 6:31 AM To: SQR-USERS@list.iex.net Subject: Deleting rows in flatfile Iam writing an SQR for filtering a flatfile. It is posting bad rows into suspend file and remaining into output file. The records in suspend file will be used after corrections. I have to delete completely some bad rows from flatfile(should not even send it to suspend file). I know how to delete a file. But problem is with deleting rows. Can anybody help me... Regards, Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Apr 3 09:36:20 2000 Date: Mon, 3 Apr 2000 09:58:31 -0400 From: Ted Houghton Subject: Re: Deleting rows in flatfile Madav, I haven't worked much with flat files in SQR, but I would imagine that you could accomplish this by reading the file into a procedure, filter the data by excluding the 'BAD' records, and write the 'GOOD' (or bad) records to a new flat file. Hope this helps..... -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, April 03, 2000 9:31 AM To: SQR-USERS@list.iex.net Subject: Deleting rows in flatfile Iam writing an SQR for filtering a flatfile. It is posting bad rows into suspend file and remaining into output file. The records in suspend file will be used after corrections. I have to delete completely some bad rows from flatfile(should not even send it to suspend file). I know how to delete a file. But problem is with deleting rows. Can anybody help me... Regards, Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com *************************** N O T I C E ************************************** This message and any attachments is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorized use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by it's intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately and destroy the message and all copies in your possession. This message has been scanned for viruses by Norton Antivirus. From owner-sqr-users@list.iex.net Mon Apr 3 09:36:51 2000 Date: Mon, 3 Apr 2000 09:00:53 -0500 From: Ray Ontko Subject: Re: your mail Steve, The short answer is "there's no easy way". SQR doesn't "know" anything about the widths of characters in proportional fonts, so it doesn't support centering, wrapping, or right justifying which requires knowledge of individual character widths. For more background on the topic, search the archives for "proportional font" at: http://www.sqrug.com/sqr-users/ If you MUST do it, there are a few routines that I and others have written that do some of what you want (wrapping and truncation, in particular). You may be able to adapt them. One is on the library pages at www.sqrug.com, the other is at: http://www.ontko.com/sqr/hp.html Ray > Hello, > > Has anyone had any luck right-justifying a column of > text using a proportional font? My users want to see a > report formatted as follows: > > ORDER: 12345 > LINE NO: 2 > ORDER DATE: 04/01/2000 > > where the end of the labels line up. Unfortunately, I > haven't been able to accomplish this using a > proportional font (which, of course, is what they want > to use for the report). > > I am using SQR version 4.3.2.1. > > Thanks in advance, > Steve Greenwood > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Mon Apr 3 09:41:15 2000 Date: Mon, 3 Apr 2000 09:05:28 -0500 From: "Wendel, Robbi" Subject: Re: Deleting rows in flatfile Upon reading the first file write to two new files - one for good records the other for bad. If the bad file has to have the same name as original then at the end of processing close and dleete old file and rename the file containing the bad records to the original files name HTH, Robbi -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, April 03, 2000 8:31 AM To: SQR-USERS@list.iex.net Subject: Deleting rows in flatfile Iam writing an SQR for filtering a flatfile. It is posting bad rows into suspend file and remaining into output file. The records in suspend file will be used after corrections. I have to delete completely some bad rows from flatfile(should not even send it to suspend file). I know how to delete a file. But problem is with deleting rows. Can anybody help me... Regards, Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Apr 3 10:29:38 2000 Date: Mon, 3 Apr 2000 16:50:28 +0200 From: byron.hall@CIBAVISION.NOVARTIS.COM Subject: print / wrap question SQR Users, Why is the following wrap function erroring out? I seems to be correct from a syntax standpoint. The numeric literal is present (10, 3). Any help would be greatly appreciated. SQR Version 4.3 in PeopleSoft 7.5 BEGIN-PROCEDURE get-product-group-description begin-select B.DESCR &prod_grp_desc from PS_CV_PRDCL_TBL A, PS_CV_PRDCH_TBL B WHERE A.SETID = B.SETID AND A.PRODUCT_GROUP = B.PRODUCT_GROUP end-select let #number_lines=wrapdepth(&prod_grp_desc, 10, 2, '<13>', '/\@-' ) display 'The number of lines are...' display #number_lines print &prod_grp_desc (4,1,30) Wrap 10, 3 END-PROCEDURE ERROR Error on line 293: (SQR 5304) Qualifier 'wrap' requires a numeric literal, variable, or column. print &prod_grp_desc (4,1,30) Wrap 10, 3 Errors were found in the program file. Byron Hall CIBAVISION CORPORATION 11460 Johns Creek Parkway Duluth, GA. 30097-1556 Phone: 678-415-3359 Fax: 678-415-3710 From owner-sqr-users@list.iex.net Mon Apr 3 10:33:50 2000 Date: Mon, 3 Apr 2000 14:57:05 GMT From: Madav V Subject: Re: Deleting rows in flatfile This SQR is sending rows into suspendfile or output file by evaluating ID(that are in first two characters of a row). Iam planning to send(write) bad rows(which i want to delete completely) into a file example..C:\temp\Delete_File. Then after processing all rows, i will delete that file. Is it a goodway to do?? I appreciate your input upto this point. Madav... >From: "Wendel, Robbi" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Deleting rows in flatfile >Date: Mon, 3 Apr 2000 09:05:28 -0500 > >Upon reading the first file write to two new files - one for good records >the other for bad. If the bad file has to have the same name as original >then at the end of processing close and dleete old file and rename the file >containing the bad records to the original files name > >HTH, >Robbi > >-----Original Message----- >From: Madav V [mailto:vmadav@HOTMAIL.COM] >Sent: Monday, April 03, 2000 8:31 AM >To: SQR-USERS@list.iex.net >Subject: Deleting rows in flatfile > > > Iam writing an SQR for filtering a flatfile. It is posting bad rows into >suspend file and remaining into output file. The records in suspend file >will be used after corrections. > I have to delete completely some bad rows from flatfile(should not even >send it to suspend file). > I know how to delete a file. But problem is with deleting rows. > Can anybody help me... > >Regards, >Madav >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Apr 3 10:41:06 2000 Date: Mon, 3 Apr 2000 16:06:38 +0100 From: "Slattery, Chad" Subject: Re: Deleting rows in flatfile This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D7E.35F5D36A Content-Type: text/plain; charset="iso-8859-1" Madav, Sounds about right, check your count of rows in the bad row file to check if the right amount went out(against the original file). If you dont want to do this then you dont even have to write out to the bad row file, just write out the good rows. Chad. -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, April 03, 2000 3:57 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Deleting rows in flatfile This SQR is sending rows into suspendfile or output file by evaluating ID(that are in first two characters of a row). Iam planning to send(write) bad rows(which i want to delete completely) into a file example..C:\temp\Delete_File. Then after processing all rows, i will delete that file. Is it a goodway to do?? I appreciate your input upto this point. Madav... >From: "Wendel, Robbi" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Deleting rows in flatfile >Date: Mon, 3 Apr 2000 09:05:28 -0500 > >Upon reading the first file write to two new files - one for good records >the other for bad. If the bad file has to have the same name as original >then at the end of processing close and dleete old file and rename the file >containing the bad records to the original files name > >HTH, >Robbi > >-----Original Message----- >From: Madav V [mailto:vmadav@HOTMAIL.COM] >Sent: Monday, April 03, 2000 8:31 AM >To: SQR-USERS@list.iex.net >Subject: Deleting rows in flatfile > > > Iam writing an SQR for filtering a flatfile. It is posting bad rows into >suspend file and remaining into output file. The records in suspend file >will be used after corrections. > I have to delete completely some bad rows from flatfile(should not even >send it to suspend file). > I know how to delete a file. But problem is with deleting rows. > Can anybody help me... > >Regards, >Madav >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------_=_NextPart_001_01BF9D7E.35F5D36A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Deleting rows in flatfile

Madav,
Sounds about right, check your count of rows in the = bad row file to check if the right amount went out(against the original = file).

If you dont want to do this then you dont even have = to write out to the bad row file, just write out the good rows.

Chad.

-----Original Message-----
From: Madav V [mailto:vmadav@HOTMAIL.COM]=
Sent: Monday, April 03, 2000 3:57 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Deleting rows in flatfile


   This SQR is sending rows into = suspendfile or output file by evaluating
ID(that are in first two characters of a = row).

   Iam planning to send(write) bad = rows(which i want to delete completely)
into a file example..C:\temp\Delete_File. Then after = processing all rows, i
will delete that file.
   Is it a goodway to do??

I appreciate your input upto this point.

Madav...




>From: "Wendel, Robbi" = <rwendel@NESPOWER.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Deleting rows in flatfile
>Date: Mon, 3 Apr 2000 09:05:28 -0500
>
>Upon reading the first file write to two new = files - one for good records
>the other for bad. If the bad file has to have = the same name as original
>then at the end of processing close and dleete = old file and rename the file
>containing the bad records to the original files = name
>
>HTH,
>Robbi
>
>-----Original Message-----
>From: Madav V [mailto:vmadav@HOTMAIL.COM]=
>Sent: Monday, April 03, 2000 8:31 AM
>To: SQR-USERS@list.iex.net
>Subject: Deleting rows in flatfile
>
>
>   Iam writing an SQR for filtering a = flatfile. It is posting bad rows into
>suspend file and remaining into output file. The = records in suspend file
>will be used after corrections.
>   I have to delete completely some = bad rows from flatfile(should not even
>send it to suspend file).
>   I know how to delete a file. But = problem is with deleting rows.
>   Can anybody help me...
>
>Regards,
>Madav
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

------_=_NextPart_001_01BF9D7E.35F5D36A-- From owner-sqr-users@list.iex.net Mon Apr 3 10:46:50 2000 Date: Mon, 3 Apr 2000 16:12:17 +0100 From: "Slattery, Chad" Subject: Re: print / wrap question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF9D7F.0009E39E Content-Type: text/plain; charset="iso-8859-1" Byron Use 'wrap 10 3' you have 'wrap 10, 3' dont use the comma hth, Chad. -----Original Message----- From: byron.hall@CIBAVISION.NOVARTIS.COM [mailto:byron.hall@CIBAVISION.NOVARTIS.COM] Sent: Monday, April 03, 2000 3:50 PM To: SQR-USERS@LIST.IEX.NET Subject: print / wrap question SQR Users, Why is the following wrap function erroring out? I seems to be correct from a syntax standpoint. The numeric literal is present (10, 3). Any help would be greatly appreciated. SQR Version 4.3 in PeopleSoft 7.5 BEGIN-PROCEDURE get-product-group-description begin-select B.DESCR &prod_grp_desc from PS_CV_PRDCL_TBL A, PS_CV_PRDCH_TBL B WHERE A.SETID = B.SETID AND A.PRODUCT_GROUP = B.PRODUCT_GROUP end-select let #number_lines=wrapdepth(&prod_grp_desc, 10, 2, '<13>', '/\@-' ) display 'The number of lines are...' display #number_lines print &prod_grp_desc (4,1,30) Wrap 10, 3 END-PROCEDURE ERROR Error on line 293: (SQR 5304) Qualifier 'wrap' requires a numeric literal, variable, or column. print &prod_grp_desc (4,1,30) Wrap 10, 3 Errors were found in the program file. Byron Hall CIBAVISION CORPORATION 11460 Johns Creek Parkway Duluth, GA. 30097-1556 Phone: 678-415-3359 Fax: 678-415-3710 ------_=_NextPart_001_01BF9D7F.0009E39E Content-Type: text/html; charset="iso-8859-1" RE: print / wrap question

Byron
Use 'wrap 10 3'
you have 'wrap 10, 3'
dont use the comma

hth,
Chad.
-----Original Message-----
From: byron.hall@CIBAVISION.NOVARTIS.COM
[mailto:byron.hall@CIBAVISION.NOVARTIS.COM]
Sent: Monday, April 03, 2000 3:50 PM
To: SQR-USERS@LIST.IEX.NET
Subject: print / wrap question


SQR Users,

Why is the following wrap function erroring out?  I seems to be correct from
a syntax standpoint.
The numeric literal is present (10, 3).  Any help would be greatly
appreciated.

SQR Version 4.3 in PeopleSoft 7.5

BEGIN-PROCEDURE get-product-group-description

begin-select
B.DESCR &prod_grp_desc
from PS_CV_PRDCL_TBL A,
     PS_CV_PRDCH_TBL B
WHERE A.SETID = B.SETID
AND A.PRODUCT_GROUP = B.PRODUCT_GROUP
end-select
let #number_lines=wrapdepth(&prod_grp_desc, 10, 2, '<13>', '/\@-' )
display 'The number of lines are...'
display #number_lines
print &prod_grp_desc    (4,1,30) Wrap 10, 3
END-PROCEDURE


ERROR

Error on line 293:
   (SQR 5304) Qualifier 'wrap' requires a numeric literal, variable, or
column.
print &prod_grp_desc (4,1,30) Wrap 10, 3

Errors were found in the program file.

Byron Hall
CIBAVISION CORPORATION
11460 Johns Creek Parkway
Duluth, GA. 30097-1556
Phone: 678-415-3359
Fax: 678-415-3710

------_=_NextPart_001_01BF9D7F.0009E39E-- From owner-sqr-users@list.iex.net Mon Apr 3 10:49:43 2000 Date: Mon, 3 Apr 2000 08:14:30 -0700 From: richard.mitchell@GSA.GOV Subject: Re: Oracle Hints Mark, This may have been mentioned previously but I don't have the thread. When I use substitution variables, I often get lost in the detail of what is getting sent in the Select. What I do is add a capital X to the end of the Select to see how SQR is putting it together. Usually I get ......where LOCATION = :1 X when I actually want .....where LOCATION = 'MY LOCATION' X which means I left the [ ] off the substitution variable again. I put the [ ] in again and run the program with the X on the end until I see the Select I want, then remove it to run the code. Sure would be nice if SQR would give a 'debug' option to view the Select. Hint, hint... Hope this helps, Rick --------------------------------- Reply ------------------------------- Folks, Thanks for all your responses. Seems that the problem that I am experiencing is related to SQR having problems with using substitution variables in the FROM part of a BEGIN-SELECT statement. They just vapourize !!! This in turn has caused the statement to be incorrectly formatted Regards Mark Pietersz From owner-sqr-users@list.iex.net Mon Apr 3 11:04:46 2000 Date: Mon, 3 Apr 2000 17:22:50 +0200 From: byron.hall@CIBAVISION.NOVARTIS.COM Subject: Re: print / wrap question Thanks! It worked great Byron Hall CIBAVISION CORPORATION 11460 Johns Creek Parkway Duluth, GA. 30097-1556 Phone: 678-415-3359 Fax: 678-415-3710 > -----Original Message----- > From: Slattery, Chad [SMTP:Chad.Slattery@CSCLAC.IRLGOV.IE] > Sent: Monday, April 03, 2000 11:12 AM > To: SQR-USERS@list.iex.net > Subject: Re: print / wrap question > > Byron > Use 'wrap 10 3' > you have 'wrap 10, 3' > dont use the comma > > hth, > Chad. > -----Original Message----- > From: byron.hall@CIBAVISION.NOVARTIS.COM > [ ] > Sent: Monday, April 03, 2000 3:50 PM > To: SQR-USERS@LIST.IEX.NET > Subject: print / wrap question > > > SQR Users, > > Why is the following wrap function erroring out? I seems to be correct > from > a syntax standpoint. > The numeric literal is present (10, 3). Any help would be greatly > appreciated. > > SQR Version 4.3 in PeopleSoft 7.5 > > BEGIN-PROCEDURE get-product-group-description > > begin-select > B.DESCR &prod_grp_desc > from PS_CV_PRDCL_TBL A, > PS_CV_PRDCH_TBL B > WHERE A.SETID = B.SETID > AND A.PRODUCT_GROUP = B.PRODUCT_GROUP > end-select > let #number_lines=wrapdepth(&prod_grp_desc, 10, 2, '<13>', '/\@-' ) > display 'The number of lines are...' > display #number_lines > print &prod_grp_desc (4,1,30) Wrap 10, 3 > END-PROCEDURE > > > ERROR > > Error on line 293: > (SQR 5304) Qualifier 'wrap' requires a numeric literal, variable, or > column. > print &prod_grp_desc (4,1,30) Wrap 10, 3 > > Errors were found in the program file. > > Byron Hall > CIBAVISION CORPORATION > 11460 Johns Creek Parkway > Duluth, GA. 30097-1556 > Phone: 678-415-3359 > Fax: 678-415-3710 > From owner-sqr-users@list.iex.net Mon Apr 3 12:48:18 2000 Date: Mon, 3 Apr 2000 13:07:39 -0400 From: Ted Houghton Subject: Printing a .GIF in a Letter I am attempting unsuccessfully to print a logo at the top of a letter. This is the first time I've had to imbed an image........ Currently I declare-image in the setup: begin-setup #Include 'setup05A.sqc' !Printer and page-size initialization declare-image logo type=gif-file source='g:\logos\logo1.gif' image-size=(10,5) end-declare end-setup Then I call the print-image in the Main Section: BEGIN-SELECT p.orig_hire_dt let $hire_dt = &p.orig_hire_dt j.file_nbr move &j.file_nbr to $file_nbr j.empl_status move &j.empl_status to $empl_status .............. DO logo DO letter new-page FROM ps_job j, PS_PERSONAL_DATA P ..... END-SELECT Then print the logo: BEGIN-PROCEDURE logo print-image urslogo (1,10) end-procedure Finally, I print the letter: BEGIN-PROCEDURE letter Begin-document (15,1) .b .b Text letter End-Document The logo will not print. Any assistance would be greatly appreciated! *************************** N O T I C E ************************************** This message and any attachments is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorized use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by it's intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately and destroy the message and all copies in your possession. This message has been scanned for viruses by Norton Antivirus. From owner-sqr-users@list.iex.net Mon Apr 3 13:13:13 2000 Date: Mon, 3 Apr 2000 13:35:39 -0400 From: paresh.j.patel@BELLATLANTIC.COM Subject: Re: SQR Verison Thanks you for your suggestions and help. I believe the max # of records is about 500, so I will look into the bubble sort. "Ray Ontko" on 03/31/2000 03:10:09 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: PARESH J. PATEL/EMPL/MD/Bell-Atl) Subject: Re: SQR Verison Dan, Yes, I've done a fair amount of research on sorting SQR arrays. Somewhere, I've got bubble, insertion, selection, shell, and quick sort routines, including improvements on the one published in the SQR Users Guide. Which algorithm you choose depends on your exact circumstances, but for small arrays, bubble or insertion sorts are fine, and shell or quick work well on large arrays (>>1000 records). It all depends on how out-of-order the list is, and how many fields there are in each record, and how much data the fields contain. The original inquirer, Paresh Patel, is interested in doing sorts using multiple field keys. This simply involves a slightly more complex bit of comparison code. Instead of asking: if $key_left < $key you ask: if $key_left_1 < $key_1 OR ( $key_left_1 = $key_1 AND $key_left_2 < $key_2 ) Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > I'm not sure what Sam means when he says that you cannot sort an > array as far as I know there are a variety of ways to sort an array. In the > long run you would be better off spending some time writing a heap sort, > merge sort, or selection sort. These algorithms have a worst case time > complexity of nLogn whereas bubble sort has an every case time complexity of > n^2 (n squared). However, a bubble sort is easy to write and I suspect that > with SQR arrays it will much, much easier to write. I suspect that Ray Ontko > and Tony DeLia (sorry if I spelled that wrong) may have some sorting > procedures available on their sites. These guys are the masters and even if > you can't use one of their algorithms you might get some ideas from them. > > Good Luck, > Dan > > -----Original Message----- > From: Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM] > Sent: Friday, March 31, 2000 1:36 PM > To: SQR-USERS@list.iex.net > Subject: Re: SQR Verison > > Generally speaking, you cannot sort an array but you can do a > "bubble sort". Check out www.sqrtools.com. It really goes in depth about > sorting arrays. > HTH, > Sam > >>> 03/31 12:59 PM >>> > I am working on an SQR report in which I need to use an array. Is > there a way > to sort the array by multiple [character] fields? Is so, can anyone > provide me > an example? Any help would be greatly appreciated. Thank you. > > SQR Version: SQR/4.2.3/PC/Windows NT 4.0/ODBC Level1/Apr 22 1998 > > =============================================================== > "In the beginning, there was something which exploded...yet, they > find nothing." > > Sam Spritzer > sam.spritzer@ctg.com > www.ctg.com > > Please see my personal web page at > home.adelphia.net/~spritzer/aboutme.html > for important information about contacting me. > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Mon Apr 3 19:55:56 2000 Date: Mon, 3 Apr 2000 19:17:51 -0500 From: Ray Ontko Subject: Re: Printing a .GIF in a Letter Ted, GIF files only work with HTML and PDF output. BMP files must be used when working with -printer:WP (printing directly from windows). EPS (encapsulated postscript) must be used when working with -printer:PS. HPGL files must be used when working with -printer:HP. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > I am attempting unsuccessfully to print a logo at the top of a letter. This > is the first time I've had to imbed an image........ > > Currently I declare-image in the setup: > > begin-setup > #Include 'setup05A.sqc' !Printer and page-size initialization > declare-image logo > type=gif-file > source='g:\logos\logo1.gif' > image-size=(10,5) > end-declare > end-setup > > Then I call the print-image in the Main Section: > > BEGIN-SELECT > p.orig_hire_dt > let $hire_dt = &p.orig_hire_dt > j.file_nbr > move &j.file_nbr to $file_nbr > j.empl_status > move &j.empl_status to $empl_status > .............. > DO logo > DO letter > new-page > > FROM ps_job j, PS_PERSONAL_DATA P ..... > END-SELECT > > Then print the logo: > > BEGIN-PROCEDURE logo > print-image urslogo (1,10) > end-procedure > > Finally, I print the letter: > > BEGIN-PROCEDURE letter > Begin-document (15,1) > .b > .b > Text letter > End-Document > > The logo will not print. Any assistance would be greatly appreciated! > > > > > > > *************************** N O T I C E ************************************** > > This message and any attachments is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorized use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by it's intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately and destroy the message and all copies in your possession. > > This message has been scanned for viruses by Norton Antivirus. > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ From owner-sqr-users@list.iex.net Mon Apr 3 20:30:00 2000 Date: Tue, 4 Apr 2000 08:53:11 +0800 From: "Ivory, Wayne" Subject: Re: Deleting rows in flatfile Madav, You didn't say what operating system you are running over, or exactly what your rules are for determining what is a 'bad' row, but if you are running over Unix then I would try doing a 'Call System' to perform a Unix 'grep' command - both to extract the good rows into one file and to extract the bad rows into another. No need to write a routine if the Operating System can do it for you. Wayne Ivory Information Services Iluka Resources Limited -----Original Message----- From: Madav V [mailto:vmadav@HOTMAIL.COM] Sent: Monday, 3 April 2000 22:57 To: SQR-USERS@list.iex.net Subject: Re: Deleting rows in flatfile This SQR is sending rows into suspendfile or output file by evaluating ID(that are in first two characters of a row). Iam planning to send(write) bad rows(which i want to delete completely) into a file example..C:\temp\Delete_File. Then after processing all rows, i will delete that file. Is it a goodway to do?? I appreciate your input upto this point. Madav... >From: "Wendel, Robbi" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Deleting rows in flatfile >Date: Mon, 3 Apr 2000 09:05:28 -0500 > >Upon reading the first file write to two new files - one for good records >the other for bad. If the bad file has to have the same name as original >then at the end of processing close and dleete old file and rename the file >containing the bad records to the original files name > >HTH, >Robbi > >-----Original Message----- >From: Madav V [mailto:vmadav@HOTMAIL.COM] >Sent: Monday, April 03, 2000 8:31 AM >To: SQR-USERS@list.iex.net >Subject: Deleting rows in flatfile > > > Iam writing an SQR for filtering a flatfile. It is posting bad rows into >suspend file and remaining into output file. The records in suspend file >will be used after corrections. > I have to delete completely some bad rows from flatfile(should not even >send it to suspend file). > I know how to delete a file. But problem is with deleting rows. > Can anybody help me... > >Regards, >Madav >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------------------------------------------------------------------------- From owner-sqr-users@list.iex.net Tue Apr 4 02:01:38 2000 Date: Tue, 4 Apr 2000 16:23:13 +1000 From: Pietersz Mark x8938 Subject: Substitution variables was Oracle Hints Richard, I changed FROM [$_msTempTLeafTable] TL, PS_product_TBL J,PS_LEDGER_BUDG L,PSTREELEAF LG,PSTREENODE TN [$_Sort_Type_Recname] to FROM PS_LEDGER_BUDG L, PS_product_TBL J,[$_msTempTLeafTable] TL,PSTREELEAF LG,PSTREENODE TN [$_Sort_Type_Recname] I had to have the tables in this order because I am using the oracle ordered hint. When I did this all the tables after PS_product_TBL J disappeared from the 'FROM' section, that is SQR did not see [$_msTempTLeafTable] TL,PSTREELEAF LG,PSTREENODE TN [$_Sort_Type_Recname] so my select went totally up the creek. I had to concatenate all the table names into a single string variable and then use FROM [$TableNames] instead I have spoken to a couple of other consultants in the meantime who have confirmed this behaviour. (We think it 'mazing) Regards Mark Pietersz -----Original Message----- From: richard.mitchell@GSA.GOV [mailto:richard.mitchell@GSA.GOV] Sent: Tuesday, 4 April 2000 1:15 Subject: Re: Oracle Hints Mark, This may have been mentioned previously but I don't have the thread. When I use substitution variables, I often get lost in the detail of what is getting sent in the Select. What I do is add a capital X to the end of the Select to see how SQR is putting it together. Usually I get ......where LOCATION = :1 X when I actually want .....where LOCATION = 'MY LOCATION' X which means I left the [ ] off the substitution variable again. I put the [ ] in again and run the program with the X on the end until I see the Select I want, then remove it to run the code. Sure would be nice if SQR would give a 'debug' option to view the Select. Hint, hint... Hope this helps, Rick ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This email message has been swept for the presence of computer viruses. CitiPower Pty ACN 064 651 056 ********************************************************************** From owner-sqr-users@list.iex.net Tue Apr 4 06:13:38 2000 Date: Tue, 4 Apr 2000 20:32:23 +1000 From: Pietersz Mark x8938 Subject: Oracle hints - still !!! Arnon I have looked hi and low for the faq.txt and can't find it. Is it in the reserved area for those on a maintenance contract ? We are licensed for SQR through PeopleSoft and therefore don't have a direct support arrangement with Brio. Could you please send me a copy Also the syntax that you have provided does not appear to work eg begin-SELECT DISTINCT /* +ordered */ account from ps_gl_account_tbl end-select Produced the error SQL expression not ended, perhaps missing &name. from ps_gl_account_tbl Whereas the following syntax does run. begin-SELECT DISTINCT /*+ ordered */ account from ps_gl_account_tbl end-select However the log file ( using -S parameter for SQR ) is producing this select distinct /*+ ordered */account from ps_gl_account_tbl When I really want this select /*+ ordered */ distinct account from ps_gl_account_tbl When I use the syntax begin-SELECT /*+ ordered */ etc etc on my problem query the execution time is quick - about 2sec When using begin-SELECT DISTINCT /*+ ordered */ etc etc The execution time is slow - about 8.5 minutes - indicating that the hint is being ignored as the hint is placed in the wrong area of the select. Execution of the statements in straight SQL verifies these results and that the addition of the distinct does not impact upon the performance of the query to this extent. For those who are still with me this is the SQR statement that I am using begin-SELECT DISTINCT ON-ERROR=SQL-Error /*+ ordered */ L.STATISTICS_CODE SUM(L.POSTED_TOTAL_AMT) &Sum_Posted_Total_Amt from [$TableNames] WHERE L.STATISTICS_CODE [$_Stats_Clause] [$_gsTreeDtlFldNameWhere] AND L.LEDGER = $Ledger AND L.Scenario = $Scenario AND J.product = L.product AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_product_TBL J2 WHERE J2.EFFDT <= $_Rqst_AsOfDate AND J.product = J2.product) [$_Group_Where] [$_Type_Where] [$Timespan] AND [$_Sort_Type_Fieldname] = $_Sort_Type_Field AND [$_Sort_Group_Fieldname] = $_Sort_Group_Field [$Chartfield_And] [$_Prcs_Business_Unit_Where] [$_Rqst_Cp_Job_Where] [$_Rqst_Cp_Project_Id_Where] [$_Rqst_Cp_Function_Cd_Where] [$_Rqst_Cp_Job_Exp_Cd_Where] GROUP BY L.STATISTICS_CODE END-SELECT And this is the statement from the SQR.LOG file Cursor #22: SQL = select distinct /*+ ordered */L.STATISTICS_CODE, SUM(L.POSTED_TOTAL_AMT) from [$lsSQLTemp] WHERE L.STATISTICS_CODE [$_Stats_Clause] [$_gsTreeDtlFldNameWhere] AND L.LEDGER = :1 AND L.Scenario = :2 AND J.product = L.product AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_product_TBL J2 WHERE J2.EFFDT <= :3 AND J.product = J2.product) [$_Group_Where] [$_Type_Where] [$Timespan] AND [$_Sort_Type_Fieldname] = :4 AND [$_Sort_Group_Fieldname] = :5 [$Chartfield_And] [$_Prcs_Business_Unit_Where] [$_Rqst_Cp_Job_Where] [$_Rqst_Cp_Project_Id_Where] [$_Rqst_Cp_Function_Cd_Where] [$_Rqst_Cp_Job_Exp_Cd_Where] GROUP BY L.STATISTICS_CODE Compiles = 3 Executes = 3 Rows = 3 Why does my hint appear to no work. Help !! Regards Mark Pietersz -----Original Message----- From: Arnon Oppenheimer [mailto:arnono@SEMECH.CO.IL] Sent: Friday, 31 March 2000 17:21 Subject: Re: Oracle hints Mark, Use: BEGIN-SELECT DISTINCT /* +ORDERED */ ! at column 1 - without blanks before the /* - like table column in sqr BTW, you can find this at /sqr/ora/readme/faq.txt from Brio ! Regards, Arnon Oppenheimer ------------------------------------------------------------------- SEMECH SOFTWARE MARKETING LTD. TEL : (972) - 3 - 5333144 FAX : (972) - 3 - 5333132 Email: arnono@semech.co.il ------------------------------------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This email message has been swept for the presence of computer viruses. CitiPower Pty ACN 064 651 056 ********************************************************************** From owner-sqr-users@list.iex.net Tue Apr 4 07:53:12 2000 Date: Tue, 4 Apr 2000 08:15:51 -0400 From: Ted Houghton Subject: Re: Printing a .GIF in a Letter Thanks Ray. I'll try converting to a BMP. Have a good day! -----Original Message----- From: Ray Ontko [mailto:rayo@ONTKO.COM] Sent: Monday, April 03, 2000 8:18 PM To: SQR-USERS@list.iex.net Subject: Re: Printing a .GIF in a Letter Ted, GIF files only work with HTML and PDF output. BMP files must be used when working with -printer:WP (printing directly from windows). EPS (encapsulated postscript) must be used when working with -printer:PS. HPGL files must be used when working with -printer:HP. Ray [Charset iso-8859-1 unsupported, filtering to ASCII...] > I am attempting unsuccessfully to print a logo at the top of a letter. This > is the first time I've had to imbed an image........ > > Currently I declare-image in the setup: > > begin-setup > #Include 'setup05A.sqc' !Printer and page-size initialization > declare-image logo > type=gif-file > source='g:\logos\logo1.gif' > image-size=(10,5) > end-declare > end-setup > > Then I call the print-image in the Main Section: > > BEGIN-SELECT > p.orig_hire_dt > let $hire_dt = &p.orig_hire_dt > j.file_nbr > move &j.file_nbr to $file_nbr > j.empl_status > move &j.empl_status to $empl_status > .............. > DO logo > DO letter > new-page > > FROM ps_job j, PS_PERSONAL_DATA P ..... > END-SELECT > > Then print the logo: > > BEGIN-PROCEDURE logo > print-image urslogo (1,10) > end-procedure > > Finally, I print the letter: > > BEGIN-PROCEDURE letter > Begin-document (15,1) > .b > .b > Text letter > End-Document > > The logo will not print. Any assistance would be greatly appreciated! > > > > > > > *************************** N O T I C E ************************************** > > This message and any attachments is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorized use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by it's intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately and destroy the message and all copies in your possession. > > This message has been scanned for viruses by Norton Antivirus. > ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ *************************** N O T I C E ************************************** This message and any attachments is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorized use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by it's intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately and destroy the message and all copies in your possession. This message has been scanned for viruses by Norton Antivirus. From owner-sqr-users@list.iex.net Tue Apr 4 08:25:55 2000 Date: Tue, 4 Apr 2000 08:49:37 EDT From: Manoj Gurjar Subject: Re: SQR Verison in one of the pdf file documentation there is a sample for sorting array using quick sort. hth, manoj >From: paresh.j.patel@BELLATLANTIC.COM >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: SQR Verison >Date: Fri, 31 Mar 2000 12:59:32 -0500 > >I am working on an SQR report in which I need to use an array. Is there a >way >to sort the array by multiple [character] fields? Is so, can anyone >provide me >an example? Any help would be greatly appreciated. Thank you. > >SQR Version: SQR/4.2.3/PC/Windows NT 4.0/ODBC Level1/Apr 22 1998 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Apr 4 08:40:24 2000 Date: Tue, 4 Apr 2000 09:03:50 EDT From: Manoj Gurjar Subject: Re: SQR Verison There is a sorint algorithm and believe me it is fast too, its bit difficult to understand but it is the QuickSort sample in one of the .pdf file we get with SQR documentation. If u don't have manual, let me know i will copy paste it. It works great. hth, Manoj >From: "Johnson, Dan" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: SQR Verison >Date: Fri, 31 Mar 2000 14:30:09 -0500 > > I'm not sure what Sam means when he says that you cannot sort an >array as far as I know there are a variety of ways to sort an array. In the >long run you would be better off spending some time writing a heap sort, >merge sort, or selection sort. These algorithms have a worst case time >complexity of nLogn whereas bubble sort has an every case time complexity >of >n^2 (n squared). However, a bubble sort is easy to write and I suspect that >with SQR arrays it will much, much easier to write. I suspect that Ray >Ontko >and Tony DeLia (sorry if I spelled that wrong) may have some sorting >procedures available on their sites. These guys are the masters and even if >you can't use one of their algorithms you might get some ideas from them. > >Good Luck, >Dan > > -----Original Message----- > From: Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM