From sqr-users-bounces@sqrug.org Thu Apr 01 06:20:23 2004 Subject: RE: [sqr-users] SQR211A1 Package was not found Date: Thu, 1 Apr 2004 11:08:28 +0530 From: "Narayanaswamy Murugesan (Cognizant)" This is a multi-part message in MIME format... ------=_NextPartTM-000-b6624062-61b1-4772-9e29-c9fe1657cdf5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks. This is very good solution. -----Original Message----- From: sqr-users-bounces+nmuruges=3Dchn.cognizant.com@sqrug.org [mailto:sqr-users-bounces+nmuruges=3Dchn.cognizant.com@sqrug.org]On Behalf Of Peter Burton Sent: Wednesday, March 31, 2004 9:23 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] SQR211A1 Package was not found Murugesan, Have somebody with DBA privileges on the database in question run an SQR program against the database in order for SQR to create the proper packages for it to run. Or the DBA can issue the following command if they do not want to run an SQR program: db2 connect to {database} [user {username} using {password}] db2 bind $SQRDIR/dbcalls.bnd grant public sqlwarn no collection sqr db2 terminate After this is done anybody can run a report against that database. Peter > _____________________________________________=20 > From: > sqr-users-bounces+peter_burton=3Dhyperion.com@sqrug.org@HYPERION On Beh= alf > Of "Narayanaswamy Murugesan (Cognizant)" > Sent: Wednesday, March 31, 2004 1:10 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] SQR211A1 Package was not found >=20 > Hi, >=20 > I tried to run an SQR program which has a embedded sql in it.I have used > DB2 UDB 8.1.0 Database.It throws following error >=20 > (SQR 5528) DB2 SQL PREPARE/DECLARE error -805 in cursor 20: > SQL0805N Package "SQR.SQR211A1 0X4941734345644B52" was not found. > SQLSTATE=3D51002 >=20 > Can anyone tell me that what could cause this issue ? >=20 > Thanks and Regards > Murugesh > - InterScan_Disclaimer.txt << File: InterScan_Disclaimer.txt >>=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > =20 >=20 ------=_NextPartTM-000-b6624062-61b1-4772-9e29-c9fe1657cdf5 Content-Type: text/plain; name="InterScan_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="InterScan_Disclaimer.txt" This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com ------=_NextPartTM-000-b6624062-61b1-4772-9e29-c9fe1657cdf5 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------=_NextPartTM-000-b6624062-61b1-4772-9e29-c9fe1657cdf5-- From sqr-users-bounces@sqrug.org Thu Apr 01 06:26:25 2004 Date: Thu, 1 Apr 2004 00:00:02 -0500 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.21 $ $Date: 2004-03-04 02:47:15-05 $ This document gathers in one location information about the sqr-users mail list. It includes instructions for changing your subscription settings (including unsubscribing), as well are guidelines for using the list. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Interacting with the list server 3.1 Subscribing to the list 3.2 Unsubscribing from the list 3.3 When your email address changes 3.4 Digests 3.5 Obtaining your password 3.6 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2003/11/01: o Update subscribe/unsubscribe instructions for new version of list server software. o New URL for "brio-l" mailing list. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Hyperion (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. On October 16, 2003, Hyperion acquired Brio Software. SQR and related applications have also been called "Brio.Report" and "Brio Reports". The mailing list is provided as a service of Ray Ontko & Co. A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.org/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is Copyright (C) 1999-2004 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. BrioSQRReport : Brio SQR Report List for discussion of SQR and SQR Developer (formerly called Brio.Report and Report Builder). To join, follow the link above, or send any message to "BrioSQRReport- subscribe@yahoogroups.com". rm-users : Report- Mart Users List for discussion of Brio Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the Mailman list server package. All of the Mailman functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. If you use digests, you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed to you. You will also be e-mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the Mailman software. 3.6. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list as other subscribers' mail systems repond....) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fuel to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQR product name and version number (see notes below) o Operating system name and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio/Hyperion's, so it's very important to mention whether you are using Hyperion's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Apr 01 15:13:22 2004 Date: Thu, 1 Apr 2004 11:58:50 -0700 From: "Jon Alsager" Subject: [sqr-users] SQR error 7715 Hello gurus! =20 We have a couple of sqr's which are outputting html (-printer:eh), but are now giving us the following error: =20 (SQR 7715) Failed to start the Java Virtual Machine (JVM) Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. =20 We are running version 8.0.2 on HP-Unix 11.22, Oracle 9.2.0.4.0 =20 Thanks for any direction anyone can provide! =20 Jon _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Apr 01 16:09:41 2004 Subject: RE: [sqr-users] SQR error 7715 Date: Thu, 1 Apr 2004 14:18:46 -0600 From: "Knapp, Richard" Check the classpath first. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org]On Behalf Of Jon Alsager Sent: Thursday, April 01, 2004 12:59 PM To: sqr-users@sqrug.org Subject: [sqr-users] SQR error 7715 Hello gurus! =20 We have a couple of sqr's which are outputting html (-printer:eh), but are now giving us the following error: =20 (SQR 7715) Failed to start the Java Virtual Machine (JVM) Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. =20 We are running version 8.0.2 on HP-Unix 11.22, Oracle 9.2.0.4.0 =20 Thanks for any direction anyone can provide! =20 Jon _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Apr 01 16:12:22 2004 From: "the dragon" Subject: RE: [sqr-users] SQR error 7715 Date: Thu, 01 Apr 2004 14:27:07 -0600 Hey, good luck with that. 0) make sure your path environment variables are set up correctly in the config files/.profiles if executing from the command line. 1) make certain that you have enough disk space available for log files. 2) If you have an environment where it works, find your jre directory and do a ls -alr > blob1.lis for the good env and the bad env ls -alr > blob1.lis - and then run a compare on the output in unix using the diff command, or import the output into excell, or use examdiff on a pc against the files. In either case, you may need to sort the output files first so they'll match up. That will tell you if you're missing any files. 3) Have your sys admin watch the system resources while you try to run those sqrs. hope these ideas help. peace clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello gurus! We have a couple of sqr's which are outputting html (-printer:eh), but are now giving us the following error: (SQR 7715) Failed to start the Java Virtual Machine (JVM) Possible causes are: missing or invalid jre files, incorrect CLASSPATH, or insufficient resources. We are running version 8.0.2 on HP-Unix 11.22, Oracle 9.2.0.4.0 Thanks for any direction anyone can provide! Jon _________________________________________________________________ Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2 months! http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 00:12:49 2004 Date: Thu, 1 Apr 2004 15:55:44 -0800 (PST) From: Clara Carter Subject: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:00:53 2004 Date: Fri, 2 Apr 2004 10:01:11 +0200 From: "Martin, Annerose" Subject: [sqr-users] to buy SQR independent of a Peoplesoft-Installation Hello, =20 do you know, whether we can install SQR independent of a Peoplesoft-Install= ation and whom I can contact for getting more informations how much a licence is. =20 Is there any trial-version of SQR ? =20 thank you very much for your answer ! =20 kind regards =20 Annerose Martin =20 =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:04:22 2004 Date: Fri, 2 Apr 2004 13:46:44 +0530 From: "Deva Anbu Daniel" Subject: [sqr-users] Dynamic SQL problem Begin-SQL INSERT INTO PS_WORK_TABLE SELECT NAME,SEX,BIRTHDATE,[$Cur_Date] FROM PS_PERSONAL_DATE WHERE ........ =20 End-SQL =20 instead of [$Cur_Date] I tried=20 =20 $temp =3D ''''||$Cur_Date||'''' and used $temp instead of $Cur_Date. =20 It always give me Invalid Column error. =20 Is this possible in SQR? =20 thanks, daniel =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:07:38 2004 From: "the dragon" Subject: RE: [sqr-users] Medical or HMO using SQR? Date: Fri, 02 Apr 2004 04:33:40 -0600 Clara, I am not certain what the business focus has to do with sqr. It's a language that can be used with any relational database, regardless of the application or the focus of the business. But I know of at least 2 hospitals which use both the HRMS and FIN side of PeopleSoft and use SQR. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara _________________________________________________________________ Check out MSN PC Safety & Security to help ensure your PC is protected and safe. http://specials.msn.com/msn/security.asp _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:10:43 2004 Subject: Re: [sqr-users] Medical or HMO using SQR? From: "Richard C Spoth" Date: Fri, 2 Apr 2004 08:26:19 -0500 Yes. We use if as part of PeopleSoft and a have a full stand alone version to do home grown data loads and reports. Rick Clara Carter Sent by: sqr-users-bounces+spoth.richard=healthnow.org@sqrug.org 04/01/2004 06:55 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: sqr-users@sqrug.org cc: Subject: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:13:51 2004 Subject: RE: [sqr-users] Medical or HMO using SQR? Date: Fri, 2 Apr 2004 13:21:49 +0800 From: mark.a.o.pabilona@accenture.com Hello, I was able to develop an SQR for our HMO a year back. Mark A. O. Pabilo=C3=B1a -----Original Message----- From: sqr-users-bounces+mark.a.o.pabilona=3Daccenture.com@sqrug.org [mailto= :sqr-users-bounces+mark.a.o.pabilona=3Daccenture.com@sqrug.org] On Behalf O= f Clara Carter Sent: Friday, April 02, 2004 7:56 AM To: sqr-users@sqrug.org Subject: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway=20 http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users This message is for the designated recipient only and may contain privilege= d, proprietary, or otherwise private information. If you have received it = in error, please notify the sender immediately and delete the original. An= y other use of the email by you is prohibited. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 09:17:01 2004 Date: Fri, 2 Apr 2004 11:07:04 +0530 From: Subject: [sqr-users] unable to FTP through PIA --===============0202258689== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 DQoNCkhpLCANCg0KDQpJIGFtIHVuYWJsZSB0byBleGVjdXRlIHRoZSBGVFAg Y29tbWFuZCB0aHJ1IHRoZSBQSWEgaGVyZSBhcyAgaSBjYW4gIEZUUCBpdCB0 aHJ1IFNRUlcNCg0KVGhlIGNvZGUgbG9va3MgbGlrZQ0KDQoNCkJlZ2luLXBy b2dyYW0NCg0KbGV0ICRmdHBfZmlsZT0ndGVzdDEudHh0Jw0KDQogIGxldCAk c3lzY21kID0gJ0ZUUCAtczonIHx8ICRmdHBfZmlsZQ0KDQogQ0FMTCBTWVNU RU0gVVNJTkcgJHN5c2NtZCAjc3RhdCBXQUlUDQogIA0KICAgaWYgI3N0YXQg PSAwIA0KICBsZXQgJGRpc3AgPSAnRlRQIHN1Y2Nlc3NmdWwuLi4nDQogICBk aXNwbGF5ICRkaXNwDQogIGVsc2UNCiAgIGxldCAkZGlzcCA9ICdFcnJvciAn IHx8IHRvX2NoYXIoI3N0YXQpIHx8ICcgYXR0ZW1wdGluZyBGVFAuLi4nDQog ICAgZGlzcGxheSAkZGlzcA0KICBlbmQtaWYNCg0KZW5kLXByb2dyYW0NCg0K DQpjb3VsZCBhbnkgYm9keSBoZWxwDQoNCg0KSSBoYXZlIGdvbmUgdGhydSB0 aGlzIGFydGljbGUgYW5kIHRyaWVkIGV2ZXJ5dGhpbmcgIGFzc29jaWF0ZWQg d2l0aCB0aGlzIGFydGljbGUNCg0KIFtzcXItdXNlcnNdIFVzaW5nIENhbGwg U3lzdGVtIHRvIEZUUCBvbiBmaWxlIG9uIFdJTk5ULWFuZCBQZW9wbGVTb2Z0 DQoNCm5vdGhpbmcgaGVscHMNCg0KIA0KDQpSZWdhcmRzDQoNCk1heA0KDQog DQoNCg0KQ29uZmlkZW50aWFsaXR5IE5vdGljZSANCg0KVGhlIGluZm9ybWF0 aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGVsZWN0cm9uaWMgbWVzc2FnZSBhbmQg YW55IGF0dGFjaG1lbnRzIHRvIHRoaXMgbWVzc2FnZSBhcmUgaW50ZW5kZWQN CmZvciB0aGUgZXhjbHVzaXZlIHVzZSBvZiB0aGUgYWRkcmVzc2VlKHMpIGFu ZCBtYXkgY29udGFpbiBjb25maWRlbnRpYWwgb3IgcHJpdmlsZWdlZCBpbmZv cm1hdGlvbi4gSWYNCnlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGll bnQsIHBsZWFzZSBub3RpZnkgdGhlIHNlbmRlciBhdCBXaXBybyBvciBNYWls YWRtaW5Ad2lwcm8uY29tIGltbWVkaWF0ZWx5DQphbmQgZGVzdHJveSBhbGwg Y29waWVzIG9mIHRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnRzLg0K --===============0202258689== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --===============0202258689==-- From sqr-users-bounces@sqrug.org Fri Apr 02 09:20:07 2004 Subject: RE: [sqr-users] Medical or HMO using SQR? Date: Fri, 2 Apr 2004 08:46:31 -0500 From: "Beller, Jay" I believe that HIP (New York) is a PeopleSoft client, so likely they're usi= ng SQR. Sorry, no contact info to pass along. -----Original Message----- From: Clara Carter [mailto:kevs_pitbabe@yahoo.com] Sent: Thursday, April 01, 2004 6:56 PM To: sqr-users@sqrug.org Subject: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway=20 http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 10:48:52 2004 Subject: RE: [sqr-users] unable to FTP through PIA Date: Fri, 2 Apr 2004 08:29:14 -0600 From: "Knapp, Richard" --===============0035984263== Content-class: urn:content-classes:message Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 DQpXaGF0IGlzIHRoZSBlcnJvciByZXR1cm5lZD8gIFdoYXQgYXBwbGljYXRp b24gc3VwcGxpZXMgeW91ciBGVFA/ICBDYW4geW91IGV4ZWN1dGUgdGhhdCBj b21tYW5kIGZyb20gdGhlIGNvbW1hbmQgbGluZSBzdWNjZXNzZnVsbHk/DQoN ClJpY2hhcmQgS25hcHANCkRhdGFiYXNlIFByb2dyYW1tZXIvQW5hbHlzdA0K SW5zdGl0dXRpb25hbCBSZXNlYXJjaCBhbmQgUGxhbm5pbmcNClVuaXZlcnNp dHkgb2YgTWlzc291cmkgU3lzdGVtDQo1NzMtODgyLTg4NTYNCmtuYXBwckB1 bXN5c3RlbS5lZHUNCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0K RnJvbTogc3FyLXVzZXJzLWJvdW5jZXMra25hcHByPXVtc3lzdGVtLmVkdUBz cXJ1Zy5vcmcNClttYWlsdG86c3FyLXVzZXJzLWJvdW5jZXMra25hcHByPXVt c3lzdGVtLmVkdUBzcXJ1Zy5vcmddT24gQmVoYWxmIE9mDQptYXlhbmsuYmFr aHJ1QHdpcHJvLmNvbQ0KU2VudDogVGh1cnNkYXksIEFwcmlsIDAxLCAyMDA0 IDExOjM3IFBNDQpUbzogc3FyLXVzZXJzQHNxcnVnLm9yZw0KU3ViamVjdDog W3Nxci11c2Vyc10gdW5hYmxlIHRvIEZUUCB0aHJvdWdoIFBJQQ0KDQoNCg0K DQpIaSwgDQoNCg0KSSBhbSB1bmFibGUgdG8gZXhlY3V0ZSB0aGUgRlRQIGNv bW1hbmQgdGhydSB0aGUgUElhIGhlcmUgYXMgIGkgY2FuICBGVFAgaXQgdGhy dSBTUVJXDQoNClRoZSBjb2RlIGxvb2tzIGxpa2UNCg0KDQpCZWdpbi1wcm9n cmFtDQoNCmxldCAkZnRwX2ZpbGU9J3Rlc3QxLnR4dCcNCg0KICBsZXQgJHN5 c2NtZCA9ICdGVFAgLXM6JyB8fCAkZnRwX2ZpbGUNCg0KIENBTEwgU1lTVEVN IFVTSU5HICRzeXNjbWQgI3N0YXQgV0FJVA0KICANCiAgIGlmICNzdGF0ID0g MCANCiAgbGV0ICRkaXNwID0gJ0ZUUCBzdWNjZXNzZnVsLi4uJw0KICAgZGlz cGxheSAkZGlzcA0KICBlbHNlDQogICBsZXQgJGRpc3AgPSAnRXJyb3IgJyB8 fCB0b19jaGFyKCNzdGF0KSB8fCAnIGF0dGVtcHRpbmcgRlRQLi4uJw0KICAg IGRpc3BsYXkgJGRpc3ANCiAgZW5kLWlmDQoNCmVuZC1wcm9ncmFtDQoNCg0K Y291bGQgYW55IGJvZHkgaGVscA0KDQoNCkkgaGF2ZSBnb25lIHRocnUgdGhp cyBhcnRpY2xlIGFuZCB0cmllZCBldmVyeXRoaW5nICBhc3NvY2lhdGVkIHdp dGggdGhpcyBhcnRpY2xlDQoNCiBbc3FyLXVzZXJzXSBVc2luZyBDYWxsIFN5 c3RlbSB0byBGVFAgb24gZmlsZSBvbiBXSU5OVC1hbmQgUGVvcGxlU29mdA0K DQpub3RoaW5nIGhlbHBzDQoNCiANCg0KUmVnYXJkcw0KDQpNYXgNCg0KIA0K DQoNCkNvbmZpZGVudGlhbGl0eSBOb3RpY2UgDQoNClRoZSBpbmZvcm1hdGlv biBjb250YWluZWQgaW4gdGhpcyBlbGVjdHJvbmljIG1lc3NhZ2UgYW5kIGFu eSBhdHRhY2htZW50cyB0byB0aGlzIG1lc3NhZ2UgYXJlIGludGVuZGVkDQpm b3IgdGhlIGV4Y2x1c2l2ZSB1c2Ugb2YgdGhlIGFkZHJlc3NlZShzKSBhbmQg bWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIG9yIHByaXZpbGVnZWQgaW5mb3Jt YXRpb24uIElmDQp5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50 LCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgYXQgV2lwcm8gb3IgTWFpbGFk bWluQHdpcHJvLmNvbSBpbW1lZGlhdGVseQ0KYW5kIGRlc3Ryb3kgYWxsIGNv cGllcyBvZiB0aGlzIG1lc3NhZ2UgYW5kIGFueSBhdHRhY2htZW50cy4NCg== --===============0035984263== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --===============0035984263==-- From sqr-users-bounces@sqrug.org Fri Apr 02 10:52:03 2004 Date: Fri, 02 Apr 2004 08:19:55 -0600 From: "Harry R Harris" Subject: RE: [sqr-users] Medical or HMO using SQR? Hello from Omaha. I have used SQR here at Alegent Health for the last 6 years.=20 >>> mark.a.o.pabilona@accenture.com 04/01/04 11:21PM >>> Hello, I was able to develop an SQR for our HMO a year back. Mark A. O. Pabilo=F1a -----Original Message----- From: sqr-users-bounces+mark.a.o.pabilona=3Daccenture.com@sqrug.org [mailto:sqr-users-bounces+mark.a.o.pabilona=3Daccenture.com@sqrug.org] On Behalf Of Clara Carter Sent: Friday, April 02, 2004 7:56 AM To: sqr-users@sqrug.org=20 Subject: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway=20 http://promotions.yahoo.com/design_giveaway/=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users=20 This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 10:54:55 2004 Subject: RE: [sqr-users] Dynamic SQL problem Date: Fri, 2 Apr 2004 08:31:29 -0600 From: "Knapp, Richard" What's the layout of the work table? Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org]On Behalf Of Deva Anbu Daniel Sent: Friday, April 02, 2004 2:17 AM To: sqr-users@sqrug.org Subject: [sqr-users] Dynamic SQL problem=20 Begin-SQL INSERT INTO PS_WORK_TABLE SELECT NAME,SEX,BIRTHDATE,[$Cur_Date] FROM PS_PERSONAL_DATE WHERE ........ =20 End-SQL =20 instead of [$Cur_Date] I tried=20 =20 $temp =3D ''''||$Cur_Date||'''' and used $temp instead of $Cur_Date. =20 It always give me Invalid Column error. =20 Is this possible in SQR? =20 thanks, daniel =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 10:57:32 2004 Date: Fri, 02 Apr 2004 17:23:27 +0200 From: LEBLANC Philippe FTC Subject: =?ISO-8859-1?Q?R=E9p.=20:=20[sqr-users]=20to=20buy=20SQR=20indep?==?ISO-8859-1?Q?endent=20of=20a=20Peoplesoft-Installation?= We don't use PeopleSoft, only Brio.Report Builder v6.2.1=20 client-Windows/server-Unix on unix Oracle Databases=20 (accessed via ODBC on windows). See Hyperion for more informations. Regards, P.LEBLANC. France T=E9l=E9com C=E2ble Direction Informatique Cellule Finances & Statistiques Assistance centralis=E9e: 01.55.58.36.00 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 11:00:09 2004 From: "Hood Louise (app1lxh)" Date: Fri, 2 Apr 2004 10:22:20 -0500 Subject: [sqr-users] Compatibility Is anyone aware of any known/reported compatibility issues between certain versions of SQR (particularly 6 and above) and Oracle 9i? I've been looking through the archives but haven't found anything yet. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 11:02:42 2004 Date: Fri, 2 Apr 2004 07:34:46 -0800 (PST) From: Clara Carter Subject: RE: [sqr-users] Medical or HMO using SQR? It has to do with an HMO client just wants to know if any other HMO is using SQR. Thats all. Thank you all for responding, I will pass this on. Clara --- the dragon wrote: > Clara, > > I am not certain what the business focus has to do > with sqr. It's a > language that can be used with any relational > database, regardless of the > application or the focus of the business. But I > know of at least 2 > hospitals which use both the HRMS and FIN side of > PeopleSoft and use SQR. > > peace, > > clark 'the dragon' willis > > > > PSA: Salary <> Slavery. If you earn a salary, your > employer is renting your > services for 40 hours a week, not purchasing your > soul. Your time is the > only real finite asset that you have, and once used > it can never be > recovered, so don't waste it by giving it away. > > "Time is the coin of your life. It is the only coin > you have, and only you > can determine how it will be spent. Be careful lest > you let other people > spend it for you." > > Carl Sandburg > (1878 - 1967) > > > ----Original Message Follows---- > Hi, > > Any Medical or HMO companies out there using SQR? > > I don't need contact just a ref. > We have a client that would like to know if anyone > else has been using it. > > Thanks, > Clara > > _________________________________________________________________ > Check out MSN PC Safety & Security to help ensure > your PC is protected and > safe. http://specials.msn.com/msn/security.asp > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 11:05:13 2004 Date: Fri, 2 Apr 2004 07:40:18 -0800 (PST) From: Clara Carter Subject: Re: [sqr-users] to buy SQR independent of a Peoplesoft-Installation Hi, Yes you can. Plus if you want to use SQR for any other application with the sqr delivered with peoplesoft you will can get into trouble. (just check your contract). Send me your contact information off line (kevs_pitbabe@yahoo.com) and I can get you a rep. to call you. Clara --- "Martin, Annerose" wrote: > Hello, > > do you know, whether we can install SQR independent > of a Peoplesoft-Installation > and whom I can contact for getting more informations > how much a licence is. > > Is there any trial-version of SQR ? > > thank you very much for your answer ! > > kind regards > > Annerose Martin > > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 11:07:42 2004 From: "the dragon" Subject: RE: [sqr-users] to buy SQR independent of a Peoplesoft-Installation Date: Fri, 02 Apr 2004 09:40:25 -0600 http://www.hyperion.com/news_events/brio/ try that site for a list of sales people or VARs. PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello, do you know, whether we can install SQR independent of a Peoplesoft-Installation and whom I can contact for getting more informations how much a licence is. Is there any trial-version of SQR ? thank you very much for your answer ! kind regards Annerose Martin _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2 months! http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 11:10:21 2004 Date: Fri, 2 Apr 2004 09:42:43 -0600 From: "Turner, Ivan" Subject: [sqr-users] EBCIDIC to ASCII Hi all, I receiving a mainframe file to hp UNIX. Does sqr have a function to translate EBCIDIC to ASCII? This If not, Any other suggestions? _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 13:01:36 2004 Date: Fri, 2 Apr 2004 12:09:55 -0500 (EST) From: Don Mellen Subject: Re: [sqr-users] EBCIDIC to ASCII If you have SQR version 6.1.3 or higher, you can set the value "UseUnicodeInternal = TRUE" in the Default-Settings section of your sqr.ini file. If you want to keep your original sqr.ini pristine, you can make an alternate .ini file and use the -ZIF command line flag. When you issue your open command, use the "ENCODING=" option. On Fri, 2 Apr 2004, Turner, Ivan wrote: > Hi all, > > I receiving a mainframe file to hp UNIX. Does sqr have a function to > translate EBCIDIC to ASCII? This If not, Any other suggestions? > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 13:04:19 2004 From: "Alexander, Steve" Subject: RE: [sqr-users] Compatibility Date: Fri, 2 Apr 2004 09:26:52 -0800 Yes, you may get this error message when reading numeric fields: (SQR 6806) String2Em: String to Decimal Object Conversion Error -----Original Message----- From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com] Sent: Friday, April 02, 2004 7:22 AM To: 'sqr-users@sqrug.org' Subject: [sqr-users] Compatibility Is anyone aware of any known/reported compatibility issues between certain versions of SQR (particularly 6 and above) and Oracle 9i? I've been looking through the archives but haven't found anything yet. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 13:06:50 2004 Subject: RE: [sqr-users] EBCIDIC to ASCII Date: Fri, 2 Apr 2004 11:47:50 -0600 From: "Knapp, Richard" The mainframe application that created the file may be able to produce ASCI= I output. Your file transfer application may be able to translate. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org]On Behalf Of Turner, Ivan Sent: Friday, April 02, 2004 9:43 AM To: sqr-users@sqrug.org Subject: [sqr-users] EBCIDIC to ASCII Hi all, I receiving a mainframe file to hp UNIX. Does sqr have a function to translate EBCIDIC to ASCII? This If not, Any other suggestions? _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 23:39:57 2004 From: "the dragon" Subject: RE: [sqr-users] EBCIDIC to ASCII Date: Fri, 02 Apr 2004 15:52:52 -0600 Ivan, If you cfan wait until Monday when I get back to work, I think I have a couple of procesudres I could send you that might help. Send me an e-mail Monday morning to remind me., clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hi all, I receiving a mainframe file to hp UNIX. Does sqr have a function to translate EBCIDIC to ASCII? This If not, Any other suggestions? _________________________________________________________________ Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Fri Apr 02 23:42:33 2004 From: "Edmundo Reyes Cuellar" Subject: RE: [sqr-users] Medical or HMO using SQR? Date: Fri, 2 Apr 2004 17:47:30 -0600 the IMSS Mexican institud of social security are using it. Edmundo Reyes -----Mensaje original----- De: Clara Carter [mailto:kevs_pitbabe@yahoo.com] Enviado el: Thursday, April 01, 2004 5:56 PM Para: sqr-users@sqrug.org Asunto: [sqr-users] Medical or HMO using SQR? Hi, Any Medical or HMO companies out there using SQR? I don't need contact just a ref. We have a client that would like to know if anyone else has been using it. Thanks, Clara __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 00:19:14 2004 From: "Bryson, Steven" Date: Mon, 5 Apr 2004 15:51:42 -0400 Subject: [sqr-users] Calculating Business Days Has anyone ever calculated this with datediff and subtracted holidays? Just throwing the question out there. "The sender believes that this E-mail and any attachments were free of any harmful and malicious code or defects when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action regarding the code or such defects. The sender is not liable for any loss or damage arising in any way from this message or its attachments." _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 00:21:54 2004 Date: Mon, 05 Apr 2004 17:05:19 -0400 From: Jae Lee Subject: [sqr-users] How do I use a variable file path for flat files? Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=================================+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall | ==== // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236| =( _____| (_________| +=================================+ .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:00:21 2004 Date: Tue, 6 Apr 2004 07:45:20 +0200 From: "R Gumbo" Subject: [sqr-users] Linked Tables In access I have an MS Access Database in which I have a linked table which is linked= to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a = question of permissions Please help !! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:03:50 2004 Date: Tue, 6 Apr 2004 07:52:55 +0200 From: "R Gumbo" Subject: [sqr-users] Oracle Error I am getting the following error when running an sqr report against an Orac= le 8i database Page buffer must be < 65536 PC SQR 65536 is double the value in the parameter file for buffers i have tried to increase this parameter but no solution What do I need to do=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:07:50 2004 Date: Tue, 6 Apr 2004 08:24:58 +0200 From: "Martin, Annerose" Subject: [sqr-users] FW: compare array-field with a string =20 =20=20=20 Hello,=20 =20 I've following (urgent) problem: =20 I have created an array, loaded with the values (put)(within a while-loop) = and then accessed the array with get (within a while-loop) for comparing the field descriptio= n with a fixed string (variable: 'Hugo'). Although I see the correct value of this array-field with DISPLAY, but the= IF-comparison is not true. What is the problem ? In a next step, I delimited the description-field with let ... =3D substr= ($bewdata_descr,1,4) and compared with 'Hugo' , but I had again no success !! =20 Many thanks for your help !!! =20 =20 =20 CREATE-ARRAY name=3Dbewdata size=3D{max_entries_bewdata}=20=20=20=20 field=3Ddescription:char field=3Dreport-type:char field=3Dexcl-code:char field=3Dfirmnr:char field=3Dpay-element:char:2 field=3Delement-code:char:3 =20 =20 ....=20 =20 put $description $report_type $exclusion_code $firmnr $pay_element1 $= pay_element2 $element_code1 $element_code2 $element_code3 into bewdata(#j) description report-type excl-code firmnr pay-element(0) pay-el= ement(1) element-code(0) element-code(1) element-code(2) =20 =20 .... =20 get $bewdata_descr $bewdata_report-type $bewdata_excl $bewdata_firmnr=20 from bewdata(#i) description report-type excl-code firmnr=20 =20 if $bewdata_descr =3D 'Hugo' !is always wrong =20 =20 many thanks=20=20 =20 Annerose =20=20 =20 Annerose Martin=20 Hewlett-Packard Boeblingen (Germany) EMEA Payroll and Time Tracking IT Team Office: phone.: +49 (0)7031 14-7059 Home Office: phone: +49 (0) 711 79 467 51 (8a.m. - 12 a.m.)=20 Fax: +49 (0) 711 78 232 67=20 mailto:annerose.martin@hp.com =20=20 =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:11:53 2004 From: Franck Masson Date: Tue, 6 Apr 2004 00:58:39 -0700 Subject: RE: [sqr-users] How do I use a variable file path for flat files? Hi, you can either pass your path as a parameters of your sqr program or retreive this path from Unix shell variable look to the ask command for Input parameters and look to getenv()function to retreive a value of Unix variable Franck, -----Original Message----- From: sqr-users-bounces+franck.masson=brio.com@sqrug.org [mailto:sqr-users-bounces+franck.masson=brio.com@sqrug.org]On Behalf Of Jae Lee Sent: lundi 5 avril 2004 23:05 To: sqr-users@sqrug.org Subject: [sqr-users] How do I use a variable file path for flat files? Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=================================+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall | ==== // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236| =( _____| (_________| +=================================+ .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ************************************************************************ If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion. For more information about Hyperion, please visit our Web site at www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:15:52 2004 From: "Vijay Tripathi" Subject: RE: [sqr-users] Calculating Business Days Date: Tue, 6 Apr 2004 13:42:45 +0530 Can you highlight the problem please?? -----Original Message----- From: sqr-users-bounces+vijay.tripathi=patni.com@sqrug.org [mailto:sqr-users-bounces+vijay.tripathi=patni.com@sqrug.org]On Behalf Of Bryson, Steven Sent: Tuesday, April 06, 2004 1:22 AM To: 'sqr-users@sqrug.org' Subject: [sqr-users] Calculating Business Days Has anyone ever calculated this with datediff and subtracted holidays? Just throwing the question out there. "The sender believes that this E-mail and any attachments were free of any harmful and malicious code or defects when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action regarding the code or such defects. The sender is not liable for any loss or damage arising in any way from this message or its attachments." _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:19:19 2004 From: "the dragon" Subject: RE: [sqr-users] How do I use a variable file path for flat files? Date: Tue, 06 Apr 2004 05:03:52 -0500 I think the sytax is getenv(ORACLE_SID), or something like that. I am at home and my BOOK is at work. I also have an example there I'll send you. clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae _________________________________________________________________ Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:22:43 2004 From: "the dragon" Subject: RE: [sqr-users] Calculating Business Days Date: Tue, 06 Apr 2004 05:05:45 -0500 you need a holiday calendar, or work week calendar to do this, since 'holiday' is an arbitrary variable depending on country, company, etc. clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Has anyone ever calculated this with datediff and subtracted holidays? Just throwing the question out there. _________________________________________________________________ Free up your inbox with MSN Hotmail Extra Storage! Multiple plans available. http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:25:43 2004 Subject: Re: [sqr-users] Calculating Business Days From: "Richard C Spoth" Date: Tue, 6 Apr 2004 06:49:13 -0400 I've done it in VB, however you should be able to take the concept and use it in SQR. You will first need a table of Holidays. Then you need to count the number of holidays that fall between the 2 dates in question. You have a few options, I loaded them into an array and compared the dates. You could also easily just use a count(*) where the dates fall between your target dates. Then you can calculate business days as CVB_BUSD_NumOfBusinessDays = DateDiff("d", pdtBeginDate, pdtEndDate) - (DateDiff("ww", pdtBeginDate, pdtEndDate) * 2) - liNumOfHolidays The code above is VB, just convert it to an SQR statement. The big concept you need is to subtract out the weekends which is simply the number of weeks times 2. Rick Spoth "Bryson, Steven" Sent by: sqr-users-bounces+spoth.richard=healthnow.org@sqrug.org 04/05/2004 03:51 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "'sqr-users@sqrug.org'" cc: Subject: [sqr-users] Calculating Business Days Has anyone ever calculated this with datediff and subtracted holidays? Just throwing the question out there. "The sender believes that this E-mail and any attachments were free of any harmful and malicious code or defects when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action regarding the code or such defects. The sender is not liable for any loss or damage arising in any way from this message or its attachments." _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:29:26 2004 From: Pamela Lantzy Subject: RE: [sqr-users] How do I use a variable file path for flat files? Date: Tue, 6 Apr 2004 08:07:17 -0400 We have an environment variable set for us for each unix machine and then we reference that in our programs. echo $UA_INPUTDIR /av01/app/devl/uainput/ !**************************************************** ! Get-Input-Dir !**************************************************** begin-procedure Get-Input-Dir(:$input_dir) let $input_dir = getenv('UA_INPUTDIR') end-procedure Get-Input-Dir Sample source: let $input_dir = {NULL} do Get-Input-Dir($input_dir) let $Ua_Usernames_File = $input_dir || 'uaupccid.dat' We have use a common function sqc that has these procedures in case we need to add, change or delete environment varables we dont have to change alot of sqrs. Pam -----Original Message----- From: Jae Lee [mailto:leejc@appstate.edu] Sent: Monday, April 05, 2004 5:05 PM To: sqr-users@sqrug.org Subject: [sqr-users] How do I use a variable file path for flat files? Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=================================+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall | ==== // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236| =( _____| (_________| +=================================+ .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:45:47 2004 Date: Tue, 06 Apr 2004 09:06:09 -0400 From: "Anderson, Paul S" Subject: RE: [sqr-users] Linked Tables In access When you created the link did you specify the unique key to the table? Its not required for read only but I don't think it allows update w/o it. -----Original Message----- From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 1:45 AM To: sqr-users@sqrug.org Subject: [sqr-users] Linked Tables In access I have an MS Access Database in which I have a linked table which is linked to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a question of permissions Please help !! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:48:55 2004 Subject: FW: [sqr-users] How do I use a variable file path for flat files? Date: Tue, 6 Apr 2004 08:07:12 -0500 From: "O'Neil, Tara" In this code I check which instance I am in and assign the appropriate file. Otherwise you could create a run control to insert the file name. Thanks. Tara let $DatabaseName =3D '*unknown*' #ifdef ORACLE begin-SELECT loops=3D1=20 DBNAME &DBNAME let $DatabaseName =3D &DBNAME FROM PSDBOWNER end-SELECT #else begin-SELECT loops=3D1=20 DBNAME &DBNAME let $DatabaseName =3D &DBNAME FROM PSPRCSRQST end-SELECT #end-if show 'Data Base Name =3D ' $DatabaseName=09=20=20=20=20=20=20=20=20 show 'unix or nt?'=20 #ifdef UNIX show 'unix -' #else #ifdef NT show 'nt -' #end-if #end-if if $prcs_process_instance =3D ''=20 let $output-file1 =3D 'c:\tmp\oir_newst_aid.txt' let $output-file2 =3D 'c:\tmp\oir_newst.txt' let $output-file3 =3D 'c:\tmp\oir_renewst_aid.txt' let $output-file4 =3D 'c:\tmp\oir_renewst.txt' else if $DatabaseName =3D 'SATST' or $DatabaseName =3D 'SADEV' or $DatabaseName =3D 'SACONV'=20 or $DatabaseName =3D 'SAPROD' or $DatabaseName =3D 'SATRN' or $DatabaseName =3D 'SAPRO' !show 'unix or nt?'=20 #ifdef UNIX !show 'unix -' let $output-file1 =3D '/psoft/data/finaid/outbound/oir_newst_aid.txt'=20 let $output-file2 =3D '/psoft/data/finaid/outbound/oir_newst.txt' let $output-file3 =3D '/psoft/data/finaid/outbound/oir_renewst_aid.txt'=20 let $output-file4 =3D '/psoft/data/finaid/outbound/oir_renewst.txt'=20 #else #ifdef NT if $DatabaseName =3D 'SATST' let $output-file1 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_newst_aid.txt'=20 let $output-file2 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_newst.txt'=20 let $output-file3 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_renewst_aid.txt'=20 let $output-file4 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_renewst.txt'=20 end-if if $DatabaseName =3D 'SADEV' let $output-file1 =3D 'P:\psoft\mu\DEV\DATA\finaid\outbound\oir_newst_aid.txt'=20 let $output-file2 =3D 'P:\psoft\mu\DEV\DATA\finaid\outbound\oir_newst.txt'=20 let $output-file3 =3D 'P:\psoft\mu\DEV\DATA\finaid\outbound\oir_renewst_aid.txt'=20 let $output-file4 =3D 'P:\psoft\mu\DEV\DATA\finaid\outbound\oir_renewst.txt'=20 end-if if $DatabaseName =3D 'SAPROD' let $output-file1 =3D 'P:\psoft\mu\PROD\DATA\finaid\outbound\oir_newst_aid.txt'=20 let $output-file2 =3D 'P:\psoft\mu\PROD\DATA\finaid\outbound\oir_newst.txt'=20 let $output-file3 =3D 'P:\psoft\mu\PROD\DATA\finaid\outbound\oir_renewst_aid.txt'=20 let $output-file4 =3D 'P:\psoft\mu\PROD\DATA\finaid\outbound\oir_renewst.txt'=20 end-if if $DatabaseName =3D 'SACONV' or $DatabaseName =3D 'SATRN' or $DatabaseName =3D 'SAPRO' !show 'nt -' let $output-file1 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_newst_aid.txt'=20 let $output-file2 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_newst.txt'=20 let $output-file3 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_renewst_aid.txt'=20 let $output-file4 =3D 'P:\psoft\mu\TST\DATA\finaid\outbound\oir_renewst.txt'=20 end-if #end-if #end-if end-if=20=20=20 end-if=20=20 -----Original Message----- From: sqr-users-bounces+tara.oneil=3Dmarquette.edu@sqrug.org [mailto:sqr-users-bounces+tara.oneil=3Dmarquette.edu@sqrug.org] On Behalf Of Jae Lee Sent: Monday, April 05, 2004 4:05 PM To: sqr-users@sqrug.org Subject: [sqr-users] How do I use a variable file path for flat files? Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file=20 names when I read from or write to flat files. (for ex. let=20 $outfilename =3D '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously=20 not a desirable solution... When I move my SQR programs from TEST to=20 PROD, the DBA has to change the file path in the program... If I can=20 define the file path and name for flat files just like the report files=20 in the UNIX shell script that runs SQR program, it would be great! Can=20 I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=3D$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=3D$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=3D$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01=20 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID=20 environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle=20 and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall |=20=20=20 =3D=3D=3D=3D // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236|=20=20 =3D( _____| (_________| +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D+ =09=09=09=20 .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:52:13 2004 From: Pamela Lantzy Subject: FW: [sqr-users] How do I use a variable file path for flat files? Date: Tue, 6 Apr 2004 09:27:05 -0400 We have an environment variable set for us for each unix machine and then we reference that in our programs. echo $UA_INPUTDIR /av01/app/devl/uainput/ !**************************************************** ! Get-Input-Dir !**************************************************** begin-procedure Get-Input-Dir(:$input_dir) let $input_dir = getenv('UA_INPUTDIR') end-procedure Get-Input-Dir Sample source: let $input_dir = {NULL} do Get-Input-Dir($input_dir) let $Ua_Usernames_File = $input_dir || 'uaupccid.dat' We have use a common function sqc that has these procedures in case we need to add, change or delete environment varables we dont have to change alot of sqrs. Pam -----Original Message----- From: Jae Lee [mailto:leejc@appstate.edu] Sent: Monday, April 05, 2004 5:05 PM To: sqr-users@sqrug.org Subject: [sqr-users] How do I use a variable file path for flat files? Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=================================+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall | ==== // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236| =( _____| (_________| +=================================+ .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:55:34 2004 From: "the dragon" Subject: RE: [sqr-users] FW: compare array-field with a string Date: Tue, 06 Apr 2004 08:27:23 -0500 Annerose, Make certain the value you are comparing is always the same *format*... My guess is you're comparing something with extra spaces against something without spaces. Use a show statement before your compare that looks like this... #debugv show 'The array value for [whatever] = |' $bewdata_descr '|' I bet you'll see some extra spaces. If you just do a regular show, such as #debugv show 'The array value for [whatever] = ' $bewdata_descr you'll never see the extra spaces, so [Hugo ] will *look* like [Hugo], but the comparrison will fail. After you see that you have extra spaces, you'll need to remove them with an rtrim and/or ltrim let $bewdata_descr = ltrim(rtrim($bewdata_descr, ' '), ' ') before you do your compare.... Hope this helps, Peace clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello, I've following (urgent) problem: I have created an array, loaded with the values (put)(within a while-loop) and then accessed the array with get (within a while-loop) for comparing the field description with a fixed string (variable: 'Hugo'). Although I see the correct value of this array-field with DISPLAY, but the IF-comparison is not true. What is the problem ? In a next step, I delimited the description-field with let ... = substr($bewdata_descr,1,4) and compared with 'Hugo' , but I had again no success !! Many thanks for your help !!! CREATE-ARRAY name=bewdata size={max_entries_bewdata} field=description:char field=report-type:char field=excl-code:char field=firmnr:char field=pay-element:char:2 field=element-code:char:3 .... put $description $report_type $exclusion_code $firmnr $pay_element1 $pay_element2 $element_code1 $element_code2 $element_code3 into bewdata(#j) description report-type excl-code firmnr pay-element(0) pay-element(1) element-code(0) element-code(1) element-code(2) .... get $bewdata_descr $bewdata_report-type $bewdata_excl $bewdata_firmnr from bewdata(#i) description report-type excl-code firmnr if $bewdata_descr = 'Hugo' !is always wrong many thanks Annerose Annerose Martin Hewlett-Packard Boeblingen (Germany) EMEA Payroll and Time Tracking IT Team _________________________________________________________________ Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2 months! http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 08:58:55 2004 From: "the dragon" Subject: RE: [sqr-users] Linked Tables In access Date: Tue, 06 Apr 2004 08:32:40 -0500 It sounds to me like a permissions issue on the Oracle side. I may be wrong about this, since I don't know much about crappy Micro$haft junk like Access, but since the table is linked to Oracle, and you're trying to insert into the table, it's trying to carry that insert back to Oracle, and the Access user doesn't have permissions to insert (Which is a very good thing). I assume, if you want to insert into that table you'll need to unlink it from Oracle. hope this helps, peace clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- I have an MS Access Database in which I have a linked table which is linked to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a question of permissions Please help !! _________________________________________________________________ Check out MSN PC Safety & Security to help ensure your PC is protected and safe. http://specials.msn.com/msn/security.asp _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 10:32:57 2004 Date: Tue, 6 Apr 2004 06:46:05 -0700 (PDT) From: Dattatraya Shetty Subject: Re: [sqr-users] FW: compare array-field with a string Did you Try and Display the Value just before the If condition? Try show '|' $bewdata_descr '|' and see if there are space or may be the Value is Null ? HTH Datta. --- "Martin, Annerose" wrote: > > > > Hello, > > I've following (urgent) problem: > > I have created an array, loaded with the values (put)(within a > while-loop) and then accessed > the array with get (within a while-loop) for comparing the field > description with a fixed > string (variable: 'Hugo'). > Although I see the correct value of this array-field with DISPLAY, > but the IF-comparison > is not true. > What is the problem ? > In a next step, I delimited the description-field with let ... = > substr($bewdata_descr,1,4) > and compared with 'Hugo' , but I had again no success !! > > Many thanks for your help !!! > > > > CREATE-ARRAY name=bewdata size={max_entries_bewdata} > field=description:char > field=report-type:char > field=excl-code:char > field=firmnr:char > field=pay-element:char:2 > field=element-code:char:3 > > > .... > > put $description $report_type $exclusion_code $firmnr > $pay_element1 $pay_element2 > $element_code1 $element_code2 $element_code3 into > bewdata(#j) > description report-type excl-code firmnr pay-element(0) > pay-element(1) > element-code(0) element-code(1) element-code(2) > > > .... > > get $bewdata_descr $bewdata_report-type $bewdata_excl > $bewdata_firmnr > from bewdata(#i) description report-type excl-code firmnr > > if $bewdata_descr = 'Hugo' !is always wrong > > > many thanks > > Annerose > > > > > Annerose Martin > Hewlett-Packard Boeblingen (Germany) > EMEA Payroll and Time Tracking IT Team > > Office: phone.: +49 (0)7031 14-7059 > > Home Office: phone: +49 (0) 711 79 467 51 (8a.m. - 12 a.m.) > > Fax: +49 (0) 711 78 232 67 > > mailto:annerose.martin@hp.com > > > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 11:02:19 2004 Subject: RE: [sqr-users] Linked Tables In access Date: Tue, 6 Apr 2004 17:58:40 +0200 From: "R Gumbo" Yes , I created a unique key -----Original Message----- From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com] Sent: 06 April 2004 03:06 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Linked Tables In access When you created the link did you specify the unique key to the table? Its not required for read only but I don't think it allows update w/o it. -----Original Message----- From: sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 1:45 AM To: sqr-users@sqrug.org Subject: [sqr-users] Linked Tables In access I have an MS Access Database in which I have a linked table which is linked to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a question of permissions Please help !! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 12:16:23 2004 From: Rebecca.Barilleaux@Anthem.com Date: Tue, 6 Apr 2004 13:13:08 -0400 Subject: [sqr-users] Re: sqr-users Digest, Vol 2, Issue 4 Jae, I use getenv to get environment variables from UNIX in my SQR program. The following lines in SQR should create the same file names as your shell script: let $DD_PRNTO1 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) || '.lis' let $DD_PRNTO2 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) || '_01.log' let $DD_PRNTO3 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) || '_02.lis' open $DD_PRNTO1 as 1 for-writing record=150:vary status=#openstatus1 open $DD_PRNTO2 as 2 for-writing record=250:vary status=#openstatus2 open $DD_PRNTO3 as 3 for-writing record=150:vary status=#openstatus3 - Rebecca Date: Mon, 05 Apr 2004 17:05:19 -0400 From: Jae Lee Subject: [sqr-users] How do I use a variable file path for flat files? To: sqr-users@sqrug.org Message-ID: <4071CA0F.5070802@appstate.edu> Content-Type: text/plain; format=flowed; charset=us-ascii Hi, In my SQR(v. 6.2) programs I've been hard-coding the directory and file names when I read from or write to flat files. (for ex. let $outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt' open $outfilename as 1 for-writing...) We have Oracle 8.x db that runs on a UNIX machine. This is obviously not a desirable solution... When I move my SQR programs from TEST to PROD, the DBA has to change the file path in the program... If I can define the file path and name for flat files just like the report files in the UNIX shell script that runs SQR program, it would be great! Can I do this, and if I can, how? Below is how I name the report files in a shell script: # # Define files # DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01 DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02 DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03 .... # # Run the program # $SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 -F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE but I know this -F argument is for report files only.... As an alternative, If I can somehow pass our ban$ORACLE_SID environmental variable to the SQR program, that will work! I'd appreciate any help I can get on this.... I am new to UNIX, Oracle and SQR... Thank you folks! -- jae .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. +=================================+ ,-~~-.___. | Jae S. Lee | / | ' \ | Applications Analyst | ( ) 0 | Information Technology Services | \_/-, ,----' | Room 1109 Raley Hall | ==== // | Appalachian State University | / \-'~; /~~~(O) | Boone, NC 28608 | / __/~| / | |Ph. 828/262-6283 Fax 828/262-2236| =( _____| (_________| +=================================+ .:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:. ------------------------------ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 12:51:08 2004 Date: Tue, 06 Apr 2004 13:50:02 -0400 From: "Anderson, Paul S" Subject: RE: [sqr-users] Linked Tables In access I had bumped into that.. Its probably the accounts Oracle privileges then. -----Original Message----- From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 11:59 AM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Linked Tables In access Yes , I created a unique key -----Original Message----- From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com] Sent: 06 April 2004 03:06 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Linked Tables In access When you created the link did you specify the unique key to the table? Its not required for read only but I don't think it allows update w/o it. -----Original Message----- From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 1:45 AM To: sqr-users@sqrug.org Subject: [sqr-users] Linked Tables In access I have an MS Access Database in which I have a linked table which is linked to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a question of permissions Please help !! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 12:59:44 2004 From: Joe_Johnson@adp.com Date: Tue, 6 Apr 2004 12:53:16 -0500 Subject: [sqr-users] Is it possible - or advisable - to set a sql commit to 1? Greetings, We have an interface that inserts rows of data into PS_JOB. We have been asked to change the logic so when an insert error occurs, the rest of the input file data can be inserted rather than have the process stop with the insert error. I'm thinking the only way to do this is to commit the insert after each row. 1) Can this be done? I am using begin-sql for the insert statement. 2) What are the risks with this approach, besides, large overhead as each row is committed? Thanks, Joe Johnson Programmer Analyst ADP ESG - Technical Services Group _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 13:04:27 2004 Date: Tue, 06 Apr 2004 14:03:47 -0400 From: "Larry Roux" Subject: Re: [sqr-users] Is it possible - or advisable - to set a sql commit to1? What RDBMS are you on? I have done this in oracle just by having 2 begin-sql statements begin-sql insert into blah end-sql begin-sql commit end-sql ****************************** Larry Roux Syracuse University lroux@syr.edu ******************************* >>> Joe_Johnson@adp.com 04/06/04 01:53PM >>> Greetings, We have an interface that inserts rows of data into PS_JOB. We have been asked to change the logic so when an insert error occurs, the = rest of the input file data can be inserted rather than have the process stop with the insert error. I'm thinking the only way to do this is to commit the insert after each row. 1) Can this be done? I am using begin-sql for the insert statement. 2) What are the risks with this approach, besides, large overhead as each = row is committed? Thanks, Joe Johnson Programmer Analyst ADP ESG - Technical Services Group _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 13:13:24 2004 Date: Tue, 06 Apr 2004 14:12:30 -0400 From: "Anderson, Paul S" Subject: RE: [sqr-users] Is it possible - or advisable - to set a sql comm it to 1? You shouldn't need commits... The following would execute 2-2-1-Insert-Error on an insert error due to constraints etc.. and return for additional processing. begin-SQL on-error=2-2-1-Insert-Error INSERT INTO PS_JOB ( -----Original Message----- From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf Of Joe_Johnson@adp.com Sent: Tuesday, April 06, 2004 1:53 PM To: sqr-users@sqrug.org Subject: [sqr-users] Is it possible - or advisable - to set a sql commit to 1? Greetings, We have an interface that inserts rows of data into PS_JOB. We have been asked to change the logic so when an insert error occurs, the rest of the input file data can be inserted rather than have the process stop with the insert error. I'm thinking the only way to do this is to commit the insert after each row. 1) Can this be done? I am using begin-sql for the insert statement. 2) What are the risks with this approach, besides, large overhead as each row is committed? Thanks, Joe Johnson Programmer Analyst ADP ESG - Technical Services Group _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 14:08:40 2004 From: "Alexander, Steve" Subject: RE: [sqr-users] Is it possible - or advisable - to set a sql commi tto 1? Date: Tue, 6 Apr 2004 12:07:03 -0700 Also, if you do a commit, SQR documentation strongly recommends that you use the SQR command "commit" rather than the SQL command in a begin-sql paragraph. -----Original Message----- From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com] Sent: Tuesday, April 06, 2004 11:13 AM To: 'This list is for discussion about the SQR database reporting languagef rom Hyperion Solutions.' Subject: RE: [sqr-users] Is it possible - or advisable - to set a sql comm i tto 1? You shouldn't need commits... The following would execute 2-2-1-Insert-Error on an insert error due to constraints etc.. and return for additional processing. begin-SQL on-error=2-2-1-Insert-Error INSERT INTO PS_JOB ( -----Original Message----- From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf Of Joe_Johnson@adp.com Sent: Tuesday, April 06, 2004 1:53 PM To: sqr-users@sqrug.org Subject: [sqr-users] Is it possible - or advisable - to set a sql commit to 1? Greetings, We have an interface that inserts rows of data into PS_JOB. We have been asked to change the logic so when an insert error occurs, the rest of the input file data can be inserted rather than have the process stop with the insert error. I'm thinking the only way to do this is to commit the insert after each row. 1) Can this be done? I am using begin-sql for the insert statement. 2) What are the risks with this approach, besides, large overhead as each row is committed? Thanks, Joe Johnson Programmer Analyst ADP ESG - Technical Services Group _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Apr 06 20:38:29 2004 From: Al H Subject: Re: [sqr-users] Is it possible - or advisable - to set a sql commit to 1? Date: Tue, 06 Apr 2004 18:33:27 -0700 Use on-error to execute a paragraph that checks the error code to see if the error is a duplicate row. The error code is platform specific, so you'll have to find the code for your database. If the error is a duplicate, don't do anything in the error paragraph. If it's not a duplicate error, you probably want to show the error and terminate. Note: This won't work if you are using INSERT (...) SELECT FROM.... It only works if you are selecting and then inserting one row at a time. begin-sql on-error=3Dcheck-for-duplicates INSERT .... end-sql begin-procedure check-for-duplicates if #sql-error <>-9 !this code is platform specific end-if end-procedure On Tue, 6 Apr 2004 12:53:16 -0500, you wrote: > >Greetings, > >We have an interface that inserts rows of data into PS_JOB. > >We have been asked to change the logic so when an insert error occurs, the= rest of the input file data can be inserted rather than >have the process stop with the insert error. > >I'm thinking the only way to do this is to commit the insert after each ro= w. > >1) Can this be done? I am using begin-sql for the insert statement. > >2) What are the risks with this approach, besides, large overhead as each= row is committed? > >Thanks, > >Joe Johnson >Programmer Analyst >ADP ESG - Technical Services Group > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 01:30:50 2004 Subject: RE: [sqr-users] FW: compare array-field with a string Date: Wed, 7 Apr 2004 08:29:16 +0200 From: "Martin, Annerose" Hello ! Many thanks: this was the solution !! I always did a DISPLAY instead of your special SHOW and didn't saw the spaces... kind regards Annerose -----Original Message----- From: sqr-users-bounces+annerose.martin=3Dhp.com@sqrug.org [mailto:sqr-users-bounces+annerose.martin=3Dhp.com@sqrug.org]On Behalf Of the dragon Sent: Tuesday, April 06, 2004 15:27 To: sqr-users@sqrug.org Cc: annerose.martin@hp.co Subject: RE: [sqr-users] FW: compare array-field with a string Annerose, Make certain the value you are comparing is always the same *format*... My= =20 guess is you're comparing something with extra spaces against something=20 without spaces. Use a show statement before your compare that looks like= =20 this... #debugv show 'The array value for [whatever] =3D |' $bewdata_descr '|' I bet you'll see some extra spaces. If you just do a regular show, such as #debugv show 'The array value for [whatever] =3D ' $bewdata_descr you'll never see the extra spaces, so [Hugo ] will *look* like [Hugo],= =20 but the comparrison will fail. After you see that you have extra spaces, you'll need to remove them with a= n=20 rtrim and/or ltrim let $bewdata_descr =3D ltrim(rtrim($bewdata_descr, ' '), ' ') before you do your compare.... Hope this helps, Peace clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting you= r=20 services for 40 hours a week, not purchasing your soul. Your time is the= =20 only real finite asset that you have, and once used it can never be=20 recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you= =20 can determine how it will be spent. Be careful lest you let other people= =20 spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello, I've following (urgent) problem: I have created an array, loaded with the values (put)(within a while-loop)= =20 and then accessed the array with get (within a while-loop) for comparing the field descriptio= n=20 with a fixed string (variable: 'Hugo'). Although I see the correct value of this array-field with DISPLAY, but the= =20 IF-comparison is not true. What is the problem ? In a next step, I delimited the description-field with let ... =3D=20 substr($bewdata_descr,1,4) and compared with 'Hugo' , but I had again no success !! Many thanks for your help !!! CREATE-ARRAY name=3Dbewdata size=3D{max_entries_bewdata} field=3Ddescription:char field=3Dreport-type:char field=3Dexcl-code:char field=3Dfirmnr:char field=3Dpay-element:char:2 field=3Delement-code:char:3 .... put $description $report_type $exclusion_code $firmnr $pay_element1= =20 $pay_element2 $element_code1 $element_code2 $element_code3 into bewdata(#j) description report-type excl-code firmnr pay-element(0)=20 pay-element(1) element-code(0) element-code(1) element-code(2) .... get $bewdata_descr $bewdata_report-type $bewdata_excl $bewdata_firmnr from bewdata(#i) description report-type excl-code firmnr if $bewdata_descr =3D 'Hugo' !is always wrong many thanks Annerose Annerose Martin Hewlett-Packard Boeblingen (Germany) EMEA Payroll and Time Tracking IT Team _________________________________________________________________ Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2= =20 months!=20 http://join.msn.com/?page=3Ddept/dialup&pgmarket=3Den-us&ST=3D1/go/onm00200= 361ave/direct/01/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 03:05:28 2004 Subject: RE: [sqr-users] Linked Tables In access Date: Wed, 7 Apr 2004 10:01:43 +0200 From: "R Gumbo" Thanks Anderson. I had tried to create the unique index from Access side=20 and had not realized that it was not saving them. I create the key on the Oracle table and it worked Thanks again -----Original Message----- From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com] Sent: 06 April 2004 07:50 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Linked Tables In access I had bumped into that.. Its probably the accounts Oracle privileges then. -----Original Message----- From: sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 11:59 AM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: RE: [sqr-users] Linked Tables In access Yes , I created a unique key -----Original Message----- From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com] Sent: 06 April 2004 03:06 PM To: 'This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions.' Subject: RE: [sqr-users] Linked Tables In access When you created the link did you specify the unique key to the table? Its not required for read only but I don't think it allows update w/o it. -----Original Message----- From: sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org [mailto:sqr-users-bounces+paul.anderson=3Dusa.xerox.com@sqrug.org] On Behalf Of R Gumbo Sent: Tuesday, April 06, 2004 1:45 AM To: sqr-users@sqrug.org Subject: [sqr-users] Linked Tables In access I have an MS Access Database in which I have a linked table which is linked to a table in Oracle 8 i database I am unable to go into insert mode, when i open the access database My access application ca also not insert data into this linked table What do I need to do to be able to create records in this table or is it a question of permissions Please help !! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 07:34:43 2004 Date: Wed, 7 Apr 2004 08:33:28 -0400 (EDT) From: "Kevin Laroche" Subject: [sqr-users] intermittent OCI server attach error when running Brio 6 Hi to all: We are running Oracle 8 on Linux with Brio 6 on the clients. Recently we have had intermittent problems where any one of the hundreds of brio reports we have fails to run with with errors: SQR 5528 ORACLE OCIServerAttach error 12500 in cursor 0 TNS listener failed to start a dedicated server process Cannot log on to database Has anyone had any problems with Brio not releasing a file handle on the server, particularly if too many dynamic where's are used? It appears that the problems arises if too many reports have been run in a day. I know this is probably not a brio problem as the same report will run with no problems the next day but I wondered if any of the database gurus had any suggestions. Kevin LaRoche Oracle Forms Developer Ottawa, Ontario _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 13:48:30 2004 Date: Wed, 7 Apr 2004 12:47:23 -0600 From: "Lance Munger" Subject: [sqr-users] Unknown error when posting to SQR platform We are in the process of converting our reports from Brio 6.5 over to SQR ver 8.2, currently I have a report that is giving me an error of 1300307. Nothing else is listed, it doesn't say that one of my variables is wrong, or that one of the include files has an error or anything to indicate where I should look for this error or how to fix it. I have searched the Hyperion site, IBM (we are running on DB2), MSDN and this site, but have not found any reference to what this error might be related to. If anyone has seen this error or might have any idea of where I should look it would be greatly appreciated. =20 Thank you in advance, =20 Lance D. Munger =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 14:13:53 2004 From: "the dragon" Subject: RE: [sqr-users] Unknown error when posting to SQR platform Date: Wed, 07 Apr 2004 14:12:51 -0500 Please post the entire error message. Also, are you getting this with SQRW or how is it being generated? My guess is the goofballs at PSoft screwed something up. clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- We are in the process of converting our reports from Brio 6.5 over to SQR ver 8.2, currently I have a report that is giving me an error of 1300307. Nothing else is listed, it doesn't say that one of my variables is wrong, or that one of the include files has an error or anything to indicate where I should look for this error or how to fix it. I have searched the Hyperion site, IBM (we are running on DB2), MSDN and this site, but have not found any reference to what this error might be related to. If anyone has seen this error or might have any idea of where I should look it would be greatly appreciated. Thank you in advance, Lance D. Munger _________________________________________________________________ Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 14:34:08 2004 Subject: RE: [sqr-users] Unknown error when posting to SQR platform Date: Wed, 7 Apr 2004 13:33:02 -0600 From: "Lance Munger" Turns out it was a simple error, I had a space in the name of the report. Thanks for your help. Lance -----Original Message----- From: sqr-users-bounces+lance.munger=3Dnavigant.com@sqrug.org [mailto:sqr-users-bounces+lance.munger=3Dnavigant.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, April 07, 2004 1:13 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Unknown error when posting to SQR platform Please post the entire error message. Also, are you getting this with SQRW=20 or how is it being generated? My guess is the goofballs at PSoft screwed=20 something up. clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your=20 services for 40 hours a week, not purchasing your soul. Your time is the=20 only real finite asset that you have, and once used it can never be=20 recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you=20 can determine how it will be spent. Be careful lest you let other people=20 spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- We are in the process of converting our reports from Brio 6.5 over to SQR ver 8.2, currently I have a report that is giving me an error of 1300307. Nothing else is listed, it doesn't say that one of my variables is wrong, or that one of the include files has an error or anything to indicate where I should look for this error or how to fix it. I have searched the Hyperion site, IBM (we are running on DB2), MSDN and this site, but have not found any reference to what this error might be related to. If anyone has seen this error or might have any idea of where I should look it would be greatly appreciated. Thank you in advance, Lance D. Munger _________________________________________________________________ Is your PC infected? Get a FREE online computer virus scan from McAfee(r)=20 Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3D3963 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 15:29:40 2004 From: Joe_Johnson@adp.com Date: Wed, 7 Apr 2004 15:09:04 -0500 Subject: [sqr-users] Is it possible - or advisable - to set a sql commit to 1? Greets, Thanks for the help, everyone. Looks like I'll deal with this in the on-error procedure. Joe Johnson Programmer Analyst ADP ESG - Technical Services Group email: joe_johnson@adp.com ----- Forwarded by Joe Johnson/ESG/NAD on 04/07/2004 03:08 PM ----- Joe Johnson To: sqr-users@sqrug.org 04/06/2004 12:53 cc: PM Subject: Is it possible - or advisable - to set a sql commit to 1?(Document link: Joe Johnson) Greetings, We have an interface that inserts rows of data into PS_JOB. We have been asked to change the logic so when an insert error occurs, the rest of the input file data can be inserted rather than have the process stop with the insert error. I'm thinking the only way to do this is to commit the insert after each row. 1) Can this be done? I am using begin-sql for the insert statement. 2) What are the risks with this approach, besides, large overhead as each row is committed? Thanks, Joe Johnson Programmer Analyst ADP ESG - Technical Services Group _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 16:53:15 2004 Date: Wed, 7 Apr 2004 14:52:07 -0700 (PDT) From: Yuri Lakef Subject: [sqr-users] Recursion in SQR Greetings, Will SQR allow calling the same function (procedure) recursively? I'd like to process a tree and print data to flat file. I only want to call procedures to print record once I'm at the bottom-most level (i.e., no rows found where Parent_Node_Num is equal to a particular Tree_Node). The particular tree I'm processing has up to 10 levels (call same procedure for each level for different TREE_NODE). Thanks in advance! --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Apr 07 17:15:03 2004 Subject: Re: [sqr-users] Recursion in SQR Date: Wed, 7 Apr 2004 22:14:19 -0000 From: Hi, you can get tail recursion by using a stack adt that I wrote and provided to the sqrug. (see http://www.dssltd.com |clients only|sqrug sqrug) The stack limit is preset at 100 but recompiling will allow you to go as deep as your cpu's memory. John Willson Yuri Lakef said: > Greetings, > > Will SQR allow calling the same function (procedure) recursively? > > I'd like to process a tree and print data to flat file. I only want to call procedures to print record once I'm at the bottom-most level (i.e., no rows found where Parent_Node_Num is equal to a particular Tree_Node). The particular tree I'm processing has up to 10 levels (call same procedure for each level for different TREE_NODE). > > Thanks in advance! > > > --------------------------------- > Do you Yahoo!? > Yahoo! Small Business $15K Web Design Giveaway - Enter today > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > -- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Apr 08 05:12:13 2004 Date: Thu, 8 Apr 2004 12:10:31 +0200 From: "Martin, Annerose" Subject: [sqr-users] access to KSAM-file Hello, =20 is there any possibility to access a KSAM (key sequenced/index) file, a very big file on a fast kind of way: I have to check the validity of an employee-number against a very big personal-file and it takes very long =20 many thanks =20 Annerose Martin =20 =20 =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Apr 08 06:19:39 2004 From: "the dragon" Subject: RE: [sqr-users] access to KSAM-file Date: Thu, 08 Apr 2004 06:18:14 -0500 Annerose, I am not certain what a KSAM file is, but if it can be extracted into a flat file, you can process that through SQR, or dump it into a table in a relationaly database and then use the RDBMS to do the processing. hope this helps, peace clark 'they dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hello, is there any possibility to access a KSAM (key sequenced/index) file, a very big file on a fast kind of way: I have to check the validity of an employee-number against a very big personal-file and it takes very long many thanks Annerose Martin _________________________________________________________________ Get rid of annoying pop-up ads with the new MSN Toolbar – FREE! http://toolbar.msn.com/go/onm00200414ave/direct/01/ ___________________________________