From sqr-users-admin@sqrug.org Tue Jul 1 00:02:31 2003 Date: Tue, 1 Jul 2003 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.14 $ $Date: 2002-11-13 12:55:07-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 Digests 3.4 Obtaining your password 3.5 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 2002/04/17: o Reflect the new location of the list and the new list server software being used. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Software (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. 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-2002 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, and click the "Edit Options" button. In the page that comes up, there will be an "Unsubscribing from sqr-users" section; simply enter your password in the box there and click the "Unsubscribe" button. Assuming you enter the correct password, you will recieve a message stating "You have been unsubscribed." and the removal will take effect immediately (there is no need to send in a confirmation e-mail message). (If you have forgotton your password, see the instructions below.) 3.3. 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, enter your address in the "sqr-users Subscribers" section of the sqr-users List Info page and click the "Edit Options" button. At the bottom of the resulting page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option to "On", enter your subscription password in the box provided, and click the "Submit My Changes" button. (If you have forgotton your password, see the instructions below.) 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.4. Obtaining your password You will not be able to unsubscribe or change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the Edit Options page and your password will be e-mailed 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.5. 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). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) The list server will delete these special attachments from your message and send you a warning notice. 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 fule 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 Brio product and version number (see notes below) o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (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's, so it's very important to mention whether you are using Brio'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 version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include this infor- mation 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-admin@sqrug.org Wed Jul 2 00:14:01 2003 From: "Umesh R. Neeli" Subject: RE: [sqr-users] Installing one/administrator Date: Wed, 2 Jul 2003 10:45:42 +0530 Thank you Franck. Regards, Umesh R. Neeli -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Franck Masson Sent: Wednesday, June 25, 2003 7:13 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Installing one/administrator 1/ OneADmin You can install it either on windows or on Unix it does not matter. You may have an issue only if you customize the authentication server in this case install it on unix. I will recommand you to install it on both on the desktop you need lot of memory, if you have not this configuration use X11 server on windows to launch OneAdmin on the server. 2/Client There is 2 modules in OneAdministrator OnePublisher to administrate only the repository this module is available as a java applet OneAdministrator to manage repository, users, services This module is available as a desktop application but can be share on a file server. 3/ Installation I will recommand the Desktop application, it is faster as it do not have to download the applet every time you need it. 4/ Win98/ winNT Win 98 is not really a desktop for IT administrator or Developper Move to NT workstation or 2000 Franck, -----Original Message----- From: Umesh R. Neeli [mailto:umesh.neeli@patni.com] Sent: mercredi 25 juin 2003 15:19 To: sqr-users@sqrug.org Subject: [sqr-users] Installing one/administrator Hi, We have the following Brio installation setup 1. Brio One Webclient is installed on NT machine 2. Brio Portal services and repository are installed on Unix HP machine Now I want to install One/Administrator Can anyone kindly tell me if I need to install One/Administrator on unix server or on my development PC (windows 98, windows NT) If unix how can One/Administrator be accessed through the web browser If windows (98, NT) Then a. I do not think Brio.Portal repository also needs to be on NT. Please confirm. b. I was going through the instructions (Installing Brio Portal 7.0.3 on windows system), It says that Brio Portal can run on Windows NT 4.0 with Service pack 3 or Windows 2000. Does this mean that One/Administrator also cannot be installed on Windows 98, Is it OK if the operating system is Windows NT 4.0 with service pack 6. c. Should the desktop version be installed on individual developers PC or better to install browser version. Mostly only one person will be using the One/Administrator. Please advise Thanking you, Regards, Umesh R. Neeli _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.290 / Virus Database: 155 - Release Date: 23/10/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.290 / Virus Database: 155 - Release Date: 23/10/2001 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 00:18:05 2003 From: "Umesh R. Neeli" Date: Wed, 2 Jul 2003 10:49:14 +0530 Subject: [sqr-users] Error while executing Hi, I am trying to execute a simple SQR program suing sqrw. While executing it gives me the following error (SQR 5528) ORACLE OCIServerAttach error 12154 in cursor 0: ORA-12154: TNS:could not resolve service name (SQR 4701) Cannot logon to the database. SQR: Program Aborting. I am able to access the database through Toad. Through report builder I am able to connect to the database and create the report but while executing from Report Builder again it gives me the same error. The database entry does exist in the tnsnames.ora file. Please let me know how to solve this. Thanking you, Regards, Umesh R. Neeli _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 02:29:14 2003 Date: Wed, 02 Jul 2003 17:26:14 +1000 From: Steve Cavill Subject: RE: [sqr-users] Error while executing Report builder uses ODBC, whereas SQRW uses OCI so that could explain why one works and the other does not. I'm not sure how toad connects. Can you connect using the same connect string (host name) with SQL*plus? Can you also try tnsping? Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Umesh R. Neeli Sent: Wednesday, 2 July 2003 3:19 PM To: sqr-users@sqrug.org Subject: [sqr-users] Error while executing Hi, I am trying to execute a simple SQR program suing sqrw. While executing it gives me the following error (SQR 5528) ORACLE OCIServerAttach error 12154 in cursor 0: ORA-12154: TNS:could not resolve service name (SQR 4701) Cannot logon to the database. SQR: Program Aborting. I am able to access the database through Toad. Through report builder I am able to connect to the database and create the report but while executing from Report Builder again it gives me the same error. The database entry does exist in the tnsnames.ora file. Please let me know how to solve this. Thanking you, Regards, Umesh R. Neeli _______________________________________________ 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-admin@sqrug.org Wed Jul 2 02:32:09 2003 From: "Steve Cavill" Subject: RE: [sqr-users] Rendering an eps-file Date: Wed, 2 Jul 2003 17:31:31 +1000 According to the sqr reference, under declare-image: SOURCE – Specifies the name of a file containing the image. The file must be in the SQRDIR directory or you must specify the full path. Note: If the file is not in the SQRDIR directory, the full path or no path should be given. A relative path will not do since you need to know where you execute the file from. If you don't want to specify the path, it should also work if the source file is in the same directory that you are in when you execute the sqrw command. Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Parks, Sam Sent: Tuesday, 1 July 2003 4:18 AM To: 'sqr-users@sqrug.org' Subject: [sqr-users] Rendering an eps-file Subject: Rendering an eps-file When I try and render an eps-file I get a box and a diagonally line through it. Does anyone have any idea? The postscript file that gets created and the eps file are located in the same directory when I try to look at my document. Thanks begin-program do main end-program begin-setup declare printer type = postscript orientation = portrait left-margin = 1.0 declare-image orclogo type = eps-file source = 'orclogops.eps' image-size = (40,4) end-declare end-setup begin-procedure main print-image orclogo (5,5) end-procedure main Sam Parks 1-310-846-4218 email: sam.parks@orcinc.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 02:39:05 2003 Date: Wed, 02 Jul 2003 17:36:20 +1000 From: Steve Cavill Subject: RE: [sqr-users] Unable to Move or Del from CALL SYSTEM... It does look like the files are open. The difference between move and copy of course is that move attempts to delete the files after copying them, but copy does not. You could test by calling a bat file which issues a pause command instead of the move command, then try to move the files manually in a cod window. If the manual move fails then you can work try to work out why the files cannot be deleted. Of course if the manual move DOES work then I have no idea :-) Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Ross, Steven Sent: Saturday, 28 June 2003 4:49 AM To: 'sqr-users@sqrug.org' Subject: RE: [sqr-users] Unable to Move or Del from CALL SYSTEM... The program closes all files prior to trying to move them. Also, 'copy' works for us; it's 'move' that doesn't work...go figure. Again, any help would be appreciated. TIA, Steven Ross Applications Developer/Analyst sross@kcm.org -----Original Message----- From: Stephen Ratliff [mailto:stephenratliff@hotmail.com] Sent: Wednesday, June 25, 2003 6:08 PM To: sross@kcm.org Subject: Re: [sqr-users] Unable to Move or Del from CALL SYSTEM... Try this. ALSO BE SURE THE FILE(S) YOU ARE MOVING ARE CLOSED. I have made that mistake many times. You cannot move/delete/rename opened files. (IMPORTPREFIX is #define'd and referenced to SETENV.sqc for the UNC path for files) $File_complete is the filename. You should be able to put *.* in its place. let $ofile1 = '{IMPORTPREFIX}' || '\Procard\Archive\' let $ifile1 = '{IMPORTPREFIX}' || '\Procard\Input\' let $rcp1 = 'cmd /c copy ' let $copy-command = $rcp1 || $ifile1 || $file_complete || ' ' || $ofile1 CALL SYSTEM using $copy-command #command-status WAIT Stephen Ratliff -The problem with democracy is that it counts the number of heads not their content. ----Original Message Follows---- From: "Ross, Steven" To: "'sqr-users@sqrug.org'" Subject: [sqr-users] Unable to Move or Del from CALL SYSTEM... Date: Wed, 25 Jun 2003 16:57:34 -0500 Hello, We have a process which backs up output files, and another one that moves output files. Both use the CALL SYSTEM syntax to perform a system command. However the 'move' routine fails, while the 'backup' routine succeeds. I've worked with our LAN people, and have eliminated Permissions as a cause. Here are the particulars: OS: Windows 2000 Server Backup command: C:\WINNT\system32\cmd.exe /c xcopy /y "\\kcmfp1\FDEV\operations\USA\Step2_Out\SPECIAL\*.*" "\\kcmfp1\FDEV\operations\USA\Step2_Out\SPECIAL\20030625_976690\" Move command: C:\WINNT\system32\cmd.exe /c move /y "\\kcmfp1\FDEV\operations\USA\Step2_Out\SPECIAL\*.*" "\\kcmfp1\FDEV\operations\USA\Step2_Out\SPECIAL\Completed" These commands are both called in the same way: CALL SYSTEM USING $kc_cmd #ReturnValue WAIT Where $kc_cmd is the command line(s) above. The #ReturnValue = 1, which Win2K says is: "Incorrect function." Any help would be GREATLY appreciated, Thanks, Steven Ross Applications Developer/Analyst IT Mailings Coordinator Kenneth Copeland Ministries sross@kcm.org 817-252-2844 _______________________________________________ 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-admin@sqrug.org Wed Jul 2 07:59:13 2003 From: "Ashish Bhatt" Date: Wed, 2 Jul 2003 07:57:44 -0500 Subject: [sqr-users] Running SQRs in Mainframe with DB2 database Hi All, I hope you are doing fine today. Is anyone of you running SQRs in Mainframe with DB2 as the backend database ? If yes, please share with me your experiences. I have worked on SQRs in UNIX with Oracle as the backend database. I used to have TOAD as the tool to view Oracle data. Is there any similar tool like TOAD for DB2 on Mainframe to view the DB2 data ? Please reply. Thanks in advance. Have a nice day and great week. Regards. Ashish Bhatt. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 08:19:07 2003 From: EricRection@aol.com Date: Wed, 2 Jul 2003 09:18:03 EDT Subject: Re: [sqr-users] Running SQRs in Mainframe with DB2 database There's a mainframe thing called SPUFI for executing SQL. Remember to change those square brackets to double slashes... The three most useless things in the world: 1. A nun's tits 2. The Pope's balls 3. DB2 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 10:28:20 2003 Subject: RE: [sqr-users] Running SQRs in Mainframe with DB2 database Date: Wed, 2 Jul 2003 10:27:41 -0500 From: "Knapp, Richard" Ahhh... the burdens we all must bear. Interesting association - IBM and The Catholic Church. Richard (Papa) Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: EricRection@aol.com [mailto:EricRection@aol.com] Sent: Wednesday, July 02, 2003 8:18 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] Running SQRs in Mainframe with DB2 database There's a mainframe thing called SPUFI for executing SQL. Remember to change those square brackets to double slashes... The three most useless things in the world: 1. A nun's tits 2. The Pope's balls 3. DB2 _______________________________________________ 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-admin@sqrug.org Wed Jul 2 10:35:05 2003 Subject: RE: [sqr-users] Error while executing Date: Wed, 2 Jul 2003 10:34:45 -0500 From: "Knapp, Richard" Toad uses SQLNet but uses a different tnsnames file than SQRW (by default). Toad uses the tnsnames file on your local machine and SQRW probably will use a networked orahome. Make sure both tnsnames files contain the same stuff and you will be fine. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au] Sent: Wednesday, July 02, 2003 2:26 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Error while executing Report builder uses ODBC, whereas SQRW uses OCI so that could explain why one works and the other does not. I'm not sure how toad connects. Can you connect using the same connect string (host name) with SQL*plus? Can you also try tnsping? Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Umesh R. Neeli Sent: Wednesday, 2 July 2003 3:19 PM To: sqr-users@sqrug.org Subject: [sqr-users] Error while executing Hi, I am trying to execute a simple SQR program suing sqrw. While executing it gives me the following error (SQR 5528) ORACLE OCIServerAttach error 12154 in cursor 0: ORA-12154: TNS:could not resolve service name (SQR 4701) Cannot logon to the database. SQR: Program Aborting. I am able to access the database through Toad. Through report builder I am able to connect to the database and create the report but while executing from Report Builder again it gives me the same error. The database entry does exist in the tnsnames.ora file. Please let me know how to solve this. Thanking you, Regards, Umesh R. Neeli _______________________________________________ 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-admin@sqrug.org Wed Jul 2 11:12:50 2003 From: PSFTPROGRAMMER@aol.com Date: Wed, 2 Jul 2003 12:11:11 EDT Subject: Re: [sqr-users] Error while executing I use Toad, and is uses my same log-in and password as SQRW. This is different than my typical username/password when accessing the database using my front-end software. This is something that had to be set up for us by the DBA. Hope this helps, Denise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 12:23:18 2003 Date: 2 Jul 2003 17:19:50 -0000 From: "Chandra Yarlagadda" Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 12:27:05 2003 Subject: RE: [sqr-users] Want to know the database name Date: Wed, 2 Jul 2003 12:26:34 -0500 From: "Knapp, Richard" If it's a PeopleSoft db, you can query psdbowner. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com] Sent: Wednesday, July 02, 2003 12:20 PM To: sqr-users@sqrug.org Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 12:38:06 2003 Subject: RE: [sqr-users] Want to know the database name Date: Wed, 2 Jul 2003 13:37:30 -0400 From: "Wright, Rodney" The following will do the trick if you're running in SQL Server: Begin-Select DB_NAME() &DBName Show 'Running in ' &DBName End-Select Rod Wright Senior Applications Specialist The Rouse Company 410-992-6307 -----Original Message----- From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com] Sent: Wednesday, July 02, 2003 1:20 PM To: sqr-users@sqrug.org Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users The information contained in this transmission is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this communication is strictly prohibited. If you have received this e-mail in error, please contact the sender by reply e-mail and destroy all paper and electronic copies of the original message. ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙쪿î±ę왨ĄŠx%ŠËlŞżî±ęěţĘ«şč®m¶ź˙˙ 0ţĘ«şč®ćj)fjĺŠËbťú?˛Ş˙şÇ« From sqr-users-admin@sqrug.org Wed Jul 2 12:47:05 2003 Subject: RE: [sqr-users] Want to know the database name Date: Wed, 2 Jul 2003 13:45:53 -0400 From: "Wright, Rodney" I don't know if my previous reply made it through, but if you're using SQL Server, this will do the trick: Begin-Select DB_NAME() &DBName Show 'Running in ' &DBName End-Select Rod Wright Senior Applications Specialist The Rouse Company 410-992-6307 -----Original Message----- From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com] Sent: Wednesday, July 02, 2003 1:20 PM To: sqr-users@sqrug.org Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users The information contained in this transmission is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this communication is strictly prohibited. If you have received this e-mail in error, please contact the sender by reply e-mail and destroy all paper and electronic copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 12:49:06 2003 From: "Alexander, Steve" Subject: RE: [sqr-users] Want to know the database name Date: Wed, 2 Jul 2003 10:53:25 -0700 When I'm running from the Peoplesoft process scheduler in version 8, its command line includes the database name. The Stdapi-Init procedure calls the Get-Run-Control-Parms procedure, which puts that value in $database_name. I don't know about other versions of Peoplesoft. -----Original Message----- From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com] Sent: Wednesday, July 02, 2003 10:20 AM To: sqr-users@sqrug.org Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 12:58:05 2003 Date: Wed, 02 Jul 2003 19:51:11 +0200 From: LEBLANC Philippe FTC Subject: [sqr-users] =?ISO-8859-1?Q?R=E9p.=20:=20RE:=20[sqr-users]=20Want=20to=20know?==?ISO-8859-1?Q?=20the=20database=20name?= With Oracle try this select command within Sqr: SELECT name &BASENAME FROM v$database Philippe LEBLANC France Télécom Câble _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 13:00:07 2003 Subject: RE: [sqr-users] Want to know the database name From: apthornton@nisource.com Date: Wed, 2 Jul 2003 13:59:05 -0400 If you want to, you can select the database name from the database, but I'm fairly sure that the exact syntax is DB-dependant. On Oracle, you can use this: BEGIN-SELECT VS.NAME Move &VS.Name to $name FROM V$DATABASE VS END-SELECT I think other databases have similar ways of doing this. Allen Thornton "Alexander, Steve" To: "'sqr-users@sqrug.org'" Subject: RE: [sqr-users] Want to know the database name Sent by: sqr-users-admin@ sqrug.org 07/02/2003 01:53 PM Please respond to sqr-users When I'm running from the Peoplesoft process scheduler in version 8, its command line includes the database name. The Stdapi-Init procedure calls the Get-Run-Control-Parms procedure, which puts that value in $database_name. I don't know about other versions of Peoplesoft. -----Original Message----- From: Chandra Yarlagadda [mailto:yarlagaddacs@rediffmail.com] Sent: Wednesday, July 02, 2003 10:20 AM To: sqr-users@sqrug.org Subject: [sqr-users] Want to know the database name Hi I want to find out what database the user has logged in when launching the SQR. Any help is appreciated. Thanks, Chandra ___________________________________________________ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http://www.mpkdh.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 15:17:21 2003 From: RHudgins@genencor.com Date: Wed, 2 Jul 2003 16:15:23 -0400 Subject: [sqr-users] sqr and pdf file Has any one had trouble with misc. characters appearing in the pdf file that is created by doing -printer:pd? The spf file looks fine, but the pdf seems to throw in font names and other characters in a random fashion for me. Thanks! Rhonda Hudgins @}---'----,---- Genencor International, Inc 585/256-5266 rhudgins@genencor.com -------------------------------------------------------------------------- This message (including any attachments) may contain information which is confidential or privileged. Use, dissemination, distribution, or reproduction of this message by unintended recipients is not authorized and may be unlawful. If you are not the intended recipient, please advise the sender immediately by reply e-mail and delete this message and any attachments without retaining a copy. -------------------------------------------------------------------------- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 16:14:08 2003 Date: Wed, 2 Jul 2003 14:13:16 -0700 (PDT) From: Clara Carter Subject: Re: [sqr-users] sqr and pdf file Yes, we had to go to V6.2 to take care of that problem. I still get it once in a while in the windows version but is completely gone in the unix version. Clara --- RHudgins@genencor.com wrote: > Has any one had trouble with misc. characters > appearing in the pdf file > that is created by doing -printer:pd? > > The spf file looks fine, but the pdf seems to throw > in font names and > other characters in a random fashion for me. > > Thanks! > > Rhonda Hudgins > @}---'----,---- > Genencor International, Inc > 585/256-5266 > rhudgins@genencor.com > > -------------------------------------------------------------------------- > This message (including any attachments) may contain > information > which is confidential or privileged. Use, > dissemination, distribution, > or reproduction of this message by unintended > recipients is not > authorized and may be unlawful. If you are not the > intended > recipient, please advise the sender immediately by > reply e-mail and > delete this message and any attachments without > retaining a copy. > -------------------------------------------------------------------------- > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Jul 2 18:08:20 2003 From: "Paul Hoyte" Subject: RE: [sqr-users] Running SQRs in Mainframe with DB2 database Date: Wed, 2 Jul 2003 19:07:14 -0400 You might want to check out Quest for DB2 - it's a great tool for the DB2 environment. Paul Hoyte (248) 752-6970 Cell (248) 559-6868 Office (248) 559-6875 Fax paul.hoyte@sharidionne.com (Email) www.sharidionne.com (Web Site) -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf Of Ashish Bhatt Sent: Wednesday, July 02, 2003 8:58 AM To: sqr-users@sqrug.org Subject: [sqr-users] Running SQRs in Mainframe with DB2 database Hi All, I hope you are doing fine today. Is anyone of you running SQRs in Mainframe with DB2 as the backend database ? If yes, please share with me your experiences. I have worked on SQRs in UNIX with Oracle as the backend database. I used to have TOAD as the tool to view Oracle data. Is there any similar tool like TOAD for DB2 on Mainframe to view the DB2 data ? Please reply. Thanks in advance. Have a nice day and great week. Regards. Ashish Bhatt. _______________________________________________ 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-admin@sqrug.org Thu Jul 3 09:03:42 2003 From: "Ashish Bhatt" Subject: Re: [sqr-users] Running SQRs in Mainframe with DB2 database Date: Thu, 3 Jul 2003 09:02:28 -0500 Paul, have you ever worked on SQRs on mainframe ? ----- Original Message ----- From: "Paul Hoyte" To: Sent: Wednesday, July 02, 2003 6:07 PM Subject: RE: [sqr-users] Running SQRs in Mainframe with DB2 database > You might want to check out Quest for DB2 - it's a great tool for the DB2 > environment. > > Paul Hoyte > (248) 752-6970 Cell > (248) 559-6868 Office > (248) 559-6875 Fax > paul.hoyte@sharidionne.com (Email) > www.sharidionne.com (Web Site) > > > -----Original Message----- > From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf > Of Ashish Bhatt > Sent: Wednesday, July 02, 2003 8:58 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Running SQRs in Mainframe with DB2 database > > > Hi All, > > I hope you are doing fine today. > > Is anyone of you running SQRs in Mainframe with DB2 as the backend database > ? If yes, please share with me your experiences. > > I have worked on SQRs in UNIX with Oracle as the backend database. I used to > have TOAD as the tool to view Oracle data. > > Is there any similar tool like TOAD for DB2 on Mainframe to view the DB2 > data ? > > Please reply. > > Thanks in advance. > > Have a nice day and great week. > > Regards. > > Ashish Bhatt. > > > > _______________________________________________ > 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-admin@sqrug.org Thu Jul 3 09:14:06 2003 Subject: RE: [sqr-users] Running SQRs in Mainframe with DB2 database Date: Thu, 3 Jul 2003 09:12:51 -0500 From: "Sengupta, Rajib (CAG-CC-Contractor)" Ashish, We run SQR V 4 in IBM Mainframe(OS/390) with DB2 database for Peoplesoft Financial. Let me know what exactly you want? Thanks, Rajib Rajib Sengupta Systems Analyst and Team Lead Peoplesoft Financial Consultant Conagra Business Systems Phone: 402-595-5749 -----Original Message----- From: Ashish Bhatt [mailto:ashish_bhatt@hotmail.com] Sent: Thursday, July 03, 2003 9:02 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] Running SQRs in Mainframe with DB2 database Paul, have you ever worked on SQRs on mainframe ? ----- Original Message ----- From: "Paul Hoyte" To: Sent: Wednesday, July 02, 2003 6:07 PM Subject: RE: [sqr-users] Running SQRs in Mainframe with DB2 database > You might want to check out Quest for DB2 - it's a great tool for the DB2 > environment. > > Paul Hoyte > (248) 752-6970 Cell > (248) 559-6868 Office > (248) 559-6875 Fax > paul.hoyte@sharidionne.com (Email) > www.sharidionne.com (Web Site) > > > -----Original Message----- > From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf > Of Ashish Bhatt > Sent: Wednesday, July 02, 2003 8:58 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Running SQRs in Mainframe with DB2 database > > > Hi All, > > I hope you are doing fine today. > > Is anyone of you running SQRs in Mainframe with DB2 as the backend database > ? If yes, please share with me your experiences. > > I have worked on SQRs in UNIX with Oracle as the backend database. I used to > have TOAD as the tool to view Oracle data. > > Is there any similar tool like TOAD for DB2 on Mainframe to view the DB2 > data ? > > Please reply. > > Thanks in advance. > > Have a nice day and great week. > > Regards. > > Ashish Bhatt. > > > > _______________________________________________ > 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-admin@sqrug.org Sun Jul 6 02:40:39 2003 From: "Serene Yeo" Date: Sun, 06 Jul 2003 15:36:00 +0800 Subject: [sqr-users] Re: [sqr-users]Rendering an eps-file Hi Sam, I have encountered this problem before, think it's due to ur conversion of your image. You can check the contents of the image file by opening with a text editor. It should be a postscript file. You can use software such as ImageMagic K to convert Regards, Serene _________________________________________________________________ Keep track of Singapore stock prices. http://www.msn.com.sg/money/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sun Jul 6 11:47:34 2003 From: RVas157927@aol.com Date: Sun, 6 Jul 2003 12:45:06 EDT Subject: [sqr-users] Re:PeopleSoft Recruitment Letters Hello all, We are in the process of upgrading to Psoft 8.3. I am a novice in SQR and have modified the delivered SQR for the recruitment letters, but am having a problem with pulling data for applicants that do not exist in the interview_schedule tables. Can anyone help? Thanks _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sun Jul 6 11:56:17 2003 From: EricRection@aol.com Date: Sun, 6 Jul 2003 12:54:45 EDT Subject: Re: [sqr-users] Re:PeopleSoft Recruitment Letters Umm... How about you do an SQR based on a query along the lines of SELECT stuff FROM whereever WHERE EMPLID NOT IN interview_schedule tables? Hope my bullshit isn't too transparent. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sun Jul 6 12:26:09 2003 From: EricRection@aol.com Date: Sun, 6 Jul 2003 13:24:53 EDT Subject: Re: [sqr-users] Re:PeopleSoft Recruitment Letters OK, so specifically it would be SELECT stuff FROM whereever WHERE NOT EXISTS (SELECT 'X' FROM interview_tables WHERE whereever.EMPLID=interview_tables.EMPLID). _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Jul 7 12:53:04 2003 From: "David Thorburn" Subject: Re: [sqr-users] Re:PeopleSoft Recruitment Letters Date: Mon, 7 Jul 2003 10:50:21 -0700 Do you require the services of an SQR consultant? ---------------------------------------------------------------------------- ----------------- David Thorburn (916) 712-2272 thorburn@conl.net www.geocities.com\david_thorburn ---------------------------------------------------------------------------- ----------------- ----- Original Message ----- From: To: Sent: Sunday, July 06, 2003 9:45 AM Subject: [sqr-users] Re:PeopleSoft Recruitment Letters > Hello all, > > We are in the process of upgrading to Psoft 8.3. I am a novice in SQR and > have modified the delivered SQR for the recruitment letters, but am having a > problem with pulling data for applicants that do not exist in the > interview_schedule tables. Can anyone help? > > Thanks > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 8 03:00:47 2003 From: "Serene Yeo" Date: Tue, 08 Jul 2003 15:55:56 +0800 Subject: [sqr-users] Print footer on last page of letter Hi all, I have a few set of letters that is required to print footer on every pages but a different footer on last page of letter. All footer printed are coded in the begin-footing section. I have searched through the forum and find out the after-report=fin-report. But the thing is how can I code in order for this to point to the begin-footing 100 name=footerlastPg. Because if I print the details in the fin-report procedure. it seems it is printed in the detail section and is not aligned with all other pages. I need to standardised all. The following is my code: Begin-Setup Declare-Layout Default Orientation = Portrait Paper-Size = (A4) Top-Margin = 0.591 Bottom-Margin = 0.591 Left-Margin = 0.591 Right-Margin = 0.591 Line-Height = 1 Char-Width = 1 End-Declare declare-procedure after-report=fin_report end-declare End-Setup begin-footing 50 Print 'This is the footing' (10,20) end-footing begin-footing 100 name=footerlastPg Print 'This is the footing on last page' (20,20) end-footing !******** This procedure does not have effect in the footing section on last page********** begin-procedure fin_report alter-report footing=footerlastPg end-procedure Will appreciate all of your help. Thanks. Regards, Serene _________________________________________________________________ Get 10mb of inbox space with MSN Hotmail Extra Storage http://join.msn.com/?pgmarket=en-sg at only S$36 including GST _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 8 04:46:24 2003 Date: Tue, 08 Jul 2003 19:43:18 +1000 From: Steve Cavill Subject: RE: [sqr-users] Print footer on last page of letter Hi Serene, you're nearly there. Unfortunately, the alter-printer command takes effect on the next page to be printed, so as you are already on the last page it will never take effect. But you can still use the after-report syntax, and use a flag to indicate in the footing section to print something different on the last page. e.g. Begin-Setup declare-procedure after-report=fin_report end-declare End-Setup begin-program while #count < 200 print #count (1,1) next-listing add 1 to #count end-while end-program begin-footing 5 if #last_page=1 Print 'This is the footing on last page' (1,20) else Print 'This is the footing' (1,20) end-if end-footing begin-procedure fin_report let #last_page=1 end-procedure Cheers, Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Serene Yeo Sent: Tuesday, 8 July 2003 5:56 PM To: sqr-users@sqrug.org Subject: [sqr-users] Print footer on last page of letter Hi all, I have a few set of letters that is required to print footer on every pages but a different footer on last page of letter. All footer printed are coded in the begin-footing section. I have searched through the forum and find out the after-report=fin-report. But the thing is how can I code in order for this to point to the begin-footing 100 name=footerlastPg. Because if I print the details in the fin-report procedure. it seems it is printed in the detail section and is not aligned with all other pages. I need to standardised all. The following is my code: Begin-Setup Declare-Layout Default Orientation = Portrait Paper-Size = (A4) Top-Margin = 0.591 Bottom-Margin = 0.591 Left-Margin = 0.591 Right-Margin = 0.591 Line-Height = 1 Char-Width = 1 End-Declare declare-procedure after-report=fin_report end-declare End-Setup begin-footing 50 Print 'This is the footing' (10,20) end-footing begin-footing 100 name=footerlastPg Print 'This is the footing on last page' (20,20) end-footing !******** This procedure does not have effect in the footing section on last page********** begin-procedure fin_report alter-report footing=footerlastPg end-procedure Will appreciate all of your help. Thanks. Regards, Serene _________________________________________________________________ Get 10mb of inbox space with MSN Hotmail Extra Storage http://join.msn.com/?pgmarket=en-sg at only S$36 including GST _______________________________________________ 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-admin@sqrug.org Tue Jul 8 11:51:57 2003 From: "Mezzullo, Paul" Date: Tue, 8 Jul 2003 12:55:57 -0400 Subject: [sqr-users] CALL SYSTEM COMMAND Hi, I'm using the following code (below) to print a file from an SQR running on a Windows2000 machine and it works fine. However, when I run the same SQR code on a Windows98 machine, it does not work?? I understand there's no 'CMD' on Windows98 and instead 'COMMAND', I tried that modification and it still does not work, does anyone know how to modify the CALL SYSTEM COMMAND for Windows98? Thanks for your help ... !** printing an SQR lis file from Windows2000 ** let $command_str_3 = 'cmd /c copy c:\temp\abs_main.lis lpt5' CALL SYSTEM USING $Command_str_3 #return_status NOWAIT - Paul M. Mezzullo Pmezzull@esboces.org _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 8 14:20:41 2003 Subject: RE: [sqr-users] CALL SYSTEM COMMAND Date: Tue, 8 Jul 2003 14:17:49 -0500 From: "Knapp, Richard" You just have to figure out how to invoke the command interperter - maybe it has a different name and/or needs the full path. Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu -----Original Message----- From: Mezzullo, Paul [mailto:pmezzull@esboces.org] Sent: Tuesday, July 08, 2003 11:56 AM To: SQR RUG (E-mail) Subject: [sqr-users] CALL SYSTEM COMMAND Hi, I'm using the following code (below) to print a file from an SQR running on a Windows2000 machine and it works fine. However, when I run the same SQR code on a Windows98 machine, it does not work?? I understand there's no 'CMD' on Windows98 and instead 'COMMAND', I tried that modification and it still does not work, does anyone know how to modify the CALL SYSTEM COMMAND for Windows98? Thanks for your help ... !** printing an SQR lis file from Windows2000 ** let $command_str_3 = 'cmd /c copy c:\temp\abs_main.lis lpt5' CALL SYSTEM USING $Command_str_3 #return_status NOWAIT - Paul M. Mezzullo Pmezzull@esboces.org _______________________________________________ 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-admin@sqrug.org Wed Jul 9 13:46:37 2003 From: "Mark Hall" Date: Wed, 09 Jul 2003 13:43:17 -0500 Subject: [sqr-users] PDFLib Error (9): Page size must be positive We are upgrading from PSoft HR 7.5 to Psoft HR 8.8. When I run a certain report with the output type of Web and the Format PDF I get the following error: "PDFLib Error (9): Page size must be positive." Has anyone encountered this problem before? If so how did you fix it? Mark Hall IS Analyst ERP Team 260-373-8796 mark.hall@parkview.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Jul 10 03:57:23 2003 From: Kajal Somaiya Subject: RE: [sqr-users] CALL SYSTEM COMMAND Date: Thu, 10 Jul 2003 14:20:35 +0530 please try using this command "cmd /c type c:\temp\abs_main.lis > prn" this will work only if the printer driver for dos has been installed. regds kajal -----Original Message----- From: Mezzullo, Paul [mailto:pmezzull@esboces.org] Sent: Tuesday, July 08, 2003 10:26 PM To: SQR RUG (E-mail) Subject: [sqr-users] CALL SYSTEM COMMAND Hi, I'm using the following code (below) to print a file from an SQR running on a Windows2000 machine and it works fine. However, when I run the same SQR code on a Windows98 machine, it does not work?? I understand there's no 'CMD' on Windows98 and instead 'COMMAND', I tried that modification and it still does not work, does anyone know how to modify the CALL SYSTEM COMMAND for Windows98? Thanks for your help ... !** printing an SQR lis file from Windows2000 ** let $command_str_3 = 'cmd /c copy c:\temp\abs_main.lis lpt5' CALL SYSTEM USING $Command_str_3 #return_status NOWAIT - Paul M. Mezzullo Pmezzull@esboces.org _______________________________________________ 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-admin@sqrug.org Thu Jul 10 08:39:58 2003 From: "Mezzullo, Paul" Date: Thu, 10 Jul 2003 09:45:29 -0400 Subject: [sqr-users] CALL SYSTEM COMMAND Thanks for your help everyone. I've included my CALL SYSTEM COMMANDs below for future reference. All three are functioning perfectly .... !******* Set printer paths ******* let $command_str_1 = 'net use lpt5 \\printer\path ' CALL SYSTEM USING $Command_str_1 #return_status NOWAIT !**** Windows98 Environment **** let $command_str_2 = GETENV('COMSPEC') || ' /c copy c:\abs_main.lis lpt5 ' CALL SYSTEM USING $Command_str_2 #return_status NOWAIT !**** Windows2000 Environment **** let $command_str_3 = 'cmd /c copy c:\abs_main.lis lpt5' CALL SYSTEM USING $Command_str_3 #return_status NOWAIT Paul M. Mezzullo pmezzull@esboces.org _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Jul 10 14:20:41 2003 From: "Cumberbatch, Keith R" Date: Thu, 10 Jul 2003 15:18:02 -0400 Subject: [sqr-users] spaces and -F command line option I'm using SQRW 4.3.2.1 on Windows2000. Is there a way to get the -F option to recognize directories and/or files with spaces. The only workaround I found was to use the DOS short names. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Jul 10 14:32:06 2003 Subject: Re: [sqr-users] spaces and -F command line option From: Ramzi_Salameh@daveandbusters.com Date: Thu, 10 Jul 2003 14:31:05 -0500 I'm not sure if this would work in the -F on the SQR command line, but you can use the windows long name at the command prompt if you wrap the path/filename in quotes. i.e. "C:\Program Files\Microsoft Office\........." You might try that and see if it works. HTH ------------------------------------------------ Ramzi Salameh PeopleSoft Technical Analyst Dave & Busters, Inc. Voice (214) 904-2550 Fax (214) 350-0941 ------------------------------------------------ "Cumberbatch, Keith R" To: "'sqr-users@sqrug.org'" Subject: [sqr-users] spaces and -F command line option Sent by: sqr-users-admin@sqru g.org 07/10/03 02:18 PM Please respond to sqr-users I'm using SQRW 4.3.2.1 on Windows2000. Is there a way to get the -F option to recognize directories and/or files with spaces. The only workaround I found was to use the DOS short names. _______________________________________________ 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-admin@sqrug.org Fri Jul 11 08:11:25 2003 Subject: RE: [sqr-users] PDFLib Error (9): Page size must be positive Date: Fri, 11 Jul 2003 09:09:12 -0400 From: "Wright, Rodney" If I remember correctly, this is caused by having what SQR considers "old" printer commands (for example DECLARE PRINTER rather than DECLARE-PRINTER, or PAGE-SIZE rather than MAX-LINES in DECLARE-LAYOUT). You can get rid of the error message by replacing all of the old printer commands with their newer counterparts. Rod Wright Senior Applications Specialist The Rouse Company 410-992-6307 -----Original Message----- From: Mark Hall [mailto:Mark.Hall@parkview.com] Sent: Wednesday, July 09, 2003 2:43 PM To: sqr-users@sqrug.org Subject: [sqr-users] PDFLib Error (9): Page size must be positive We are upgrading from PSoft HR 7.5 to Psoft HR 8.8. When I run a certain report with the output type of Web and the Format PDF I get the following error: "PDFLib Error (9): Page size must be positive." Has anyone encountered this problem before? If so how did you fix it? Mark Hall IS Analyst ERP Team 260-373-8796 mark.hall@parkview.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users The information contained in this transmission is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this communication is strictly prohibited. If you have received this e-mail in error, please contact the sender by reply e-mail and destroy all paper and electronic copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Jul 11 09:14:14 2003 From: "Cumberbatch, Keith R" Date: Fri, 11 Jul 2003 10:13:30 -0400 Subject: [sqr-users] RE: spaces and -F command line option Wrapping the path in quotes does not work. The only solution appears to be to use the Short file name, so I updated my program to get the short file name and send it to SQRW. Message: 3 Subject: Re: [sqr-users] spaces and -F command line option To: sqr-users@sqrug.org Message-ID: From: Ramzi_Salameh@daveandbusters.com Date: Thu, 10 Jul 2003 14:31:05 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Sender: sqr-users-admin@sqrug.org Precedence: bulk Reply-To: sqr-users@sqrug.org List-Help: List-Post: List-Subscribe: , List-Id: This list is for discussion about the SQR database reporting language from Brio Software. List-Unsubscribe: , I'm not sure if this would work in the -F on the SQR command line, but you can use the windows long name at the command prompt if you wrap the path/filename in quotes. i.e. "C:\Program Files\Microsoft Office\........." You might try that and see if it works. HTH ------------------------------------------------ Ramzi Salameh PeopleSoft Technical Analyst Dave & Busters, Inc. Voice (214) 904-2550 Fax (214) 350-0941 ------------------------------------------------ "Cumberbatch, Keith R" To: "'sqr-users@sqrug.org'" Subject: [sqr-users] spaces and -F command line option Sent by: sqr-users-admin@sqru g.org 07/10/03 02:18 PM Please respond to sqr-users I'm using SQRW 4.3.2.1 on Windows2000. Is there a way to get the -F option to recognize directories and/or files with spaces. The only workaround I found was to use the DOS short names. _______________________________________________ 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-admin@sqrug.org Fri Jul 11 09:45:07 2003 Date: Fri, 11 Jul 2003 10:43:57 -0400 From: Wendy Biggs Subject: [sqr-users] is there a limt to ARRAY Extents available using SQR 8.x >SQR 8.x allows you to set up incremental extents to the base array size >with an optional "extent= " parameter. I can't find documentation >anywhere that says *how many* extents it will grant tho... are extents >unlimited? does anyone know? or know where I might find out? > >there MUST be a limit... either number of extents or total memory available... > >I set up a little test array (below) and built a loop to see if I could >figure it out myself... so far I've pushed the number of extents to 1200 >so it seems to me that the limit must be memory size if one exists. > >create-array name=t_array size={T_ArrayMax} extent=5 > field=a:char > field=b:char > field=c:char > >any ideas? > >--wb _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Jul 11 10:04:07 2003 From: Peter Burton Subject: RE: [sqr-users] is there a limt to ARRAY Extents available using SQR 8.x Date: Fri, 11 Jul 2003 11:03:27 -0400 Wendy, The EXTENT keyword takes a value from 0 to 2GB. There is no limit as to how many times the array is extended. Of course the underlying limit is how much memory the process can acquire from the system. Peter -----Original Message----- From: Wendy Biggs [mailto:biggswl@vt.edu] Sent: Friday, July 11, 2003 10:44 AM To: sqr-users@sqrug.org Subject: [sqr-users] is there a limt to ARRAY Extents available using SQR 8.x >SQR 8.x allows you to set up incremental extents to the base array size >with an optional "extent= " parameter. I can't find documentation >anywhere that says *how many* extents it will grant tho... are extents >unlimited? does anyone know? or know where I might find out? > >there MUST be a limit... either number of extents or total memory available... > >I set up a little test array (below) and built a loop to see if I could >figure it out myself... so far I've pushed the number of extents to 1200 >so it seems to me that the limit must be memory size if one exists. > >create-array name=t_array size={T_ArrayMax} extent=5 > field=a:char > field=b:char > field=c:char > >any ideas? > >--wb _______________________________________________ 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-admin@sqrug.org Fri Jul 11 10:17:30 2003 Date: Fri, 11 Jul 2003 11:16:41 -0400 From: Wendy Biggs Subject: RE: [sqr-users] is there a limt to ARRAY Extents available using SQR 8.x OK... Thanks Peter! so I won't worry about running out of array space... (I'll just have to worry about running out of space for the rest of my program to squeeze through ) out of curiosity, how do you know these things? is there somewhere I should be looking? --wb At 11:03 AM 7/11/2003, you wrote: >Wendy, > >The EXTENT keyword takes a value from 0 to 2GB. There is no limit as to how >many times the array is extended. Of course the underlying limit is how >much memory the process can acquire from the system. > >Peter > > >-----Original Message----- >From: Wendy Biggs [mailto:biggswl@vt.edu] >Sent: Friday, July 11, 2003 10:44 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] is there a limt to ARRAY Extents available using >SQR 8.x > > > > >SQR 8.x allows you to set up incremental extents to the base array size > >with an optional "extent= " parameter. I can't find documentation > >anywhere that says *how many* extents it will grant tho... are extents > >unlimited? does anyone know? or know where I might find out? > > > >there MUST be a limit... either number of extents or total memory >available... > > > >I set up a little test array (below) and built a loop to see if I could > >figure it out myself... so far I've pushed the number of extents to 1200 > >so it seems to me that the limit must be memory size if one exists. > > > >create-array name=t_array size={T_ArrayMax} extent=5 > > field=a:char > > field=b:char > > field=c:char > > > >any ideas? > > > >--wb > >_______________________________________________ >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-admin@sqrug.org Fri Jul 11 14:46:41 2003 From: "Raul Sanchez Estrada" Date: Fri, 11 Jul 2003 14:43:16 -0500 Subject: [sqr-users] update my version of SQR I need to update my version of SQR 3.5, to latest version, somebody can sell the SQR in latest completes version. Please contact via email. Metropolitan Autonoma University Raul Sanchez Estrada Mexico DF TEL (55) 5483-4115 ------------------------------------------------------------------------------------------------------------------------------------------- Necesito actualizar mi version de SQR 3, a la ultima version, alguien puede vender el SQR ultima version. Por favor contacteme via email. Universidad Autonoma Metropolitana Raul Sánchez Estrada México DF TEL (55) 5483-4115 _________________________________________________________________ Únete al mayor servicio mundial de correo electrónico: http://www.hotmail.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Jul 11 15:01:38 2003 From: "Shishir Singh" Date: Fri, 11 Jul 2003 16:05:24 -0400 Subject: [sqr-users] Using Windows authentication when running SQR from Command Line Hi All, I am running an SQR using SQRW.exe. I used to connect to the database by using Sql Server authentication Server/User_id/Pwd. With this connection I am able to connect to that database but now I have to use the Windows authentication instead. Exp : sqrw test_trusted_Con.sqr $Server/$User/$Pwd -XCB -oprog.log -A I am not sure what option should I use for windows authentication. Any insight will be greatly appreciated. Shishir _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sat Jul 12 00:42:28 2003 Date: Sat, 12 Jul 2003 15:41:15 +1000 From: Steve Cavill Subject: RE: [sqr-users] update my version of SQR Raul, try http://www.brio.com/company/contact/rep_form.html Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Raul Sanchez Estrada Sent: Saturday, 12 July 2003 5:43 AM To: sqr-users@sqrug.org Subject: [sqr-users] update my version of SQR I need to update my version of SQR 3.5, to latest version, somebody can sell the SQR in latest completes version. Please contact via email. Metropolitan Autonoma University Raul Sanchez Estrada Mexico DF TEL (55) 5483-4115 ---------------------------------------------------------------------------- --------------------------------------------------------------- Necesito actualizar mi version de SQR 3, a la ultima version, alguien puede vender el SQR ultima version. Por favor contacteme via email. Universidad Autonoma Metropolitana Raul Sánchez Estrada México DF TEL (55) 5483-4115 _________________________________________________________________ Únete al mayor servicio mundial de correo electrónico: http://www.hotmail.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Jul 14 15:02:24 2003 From: "rachel fuller" Subject: Re: [sqr-users] Running SQRs in Mainframe with DB2 database Date: Mon, 14 Jul 2003 15:58:57 -0400 My last project, I worked with DB2. If you are looking for a windows based sql tool, try WINSQL. >From: "Ashish Bhatt" >Reply-To: sqr-users@sqrug.org >To: >Subject: [sqr-users] Running SQRs in Mainframe with DB2 database >Date: Wed, 2 Jul 2003 07:57:44 -0500 > >Hi All, > >I hope you are doing fine today. > >Is anyone of you running SQRs in Mainframe with DB2 as the backend database >? If yes, please share with me your experiences. > >I have worked on SQRs in UNIX with Oracle as the backend database. I used >to have TOAD as the tool to view Oracle data. > >Is there any similar tool like TOAD for DB2 on Mainframe to view the DB2 >data ? > >Please reply. > >Thanks in advance. > >Have a nice day and great week. > >Regards. > >Ashish Bhatt. > > > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Jul 14 20:29:05 2003 From: mark.a.o.pabilona@accenture.com Date: Tue, 15 Jul 2003 09:22:07 +0800 Subject: [sqr-users] SQR books Hello, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! Mark A. O. Pabilona Alliance Utilization,CIO-SD Accenture 9th floor 6750 Bldg Ayala Ave., Makati City Philippines 1200 Phone: +632 841-0111 loc.4315 Octel: 632/4315 E-mail:mark.a.o.pabilona@accenture.com 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 http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 07:06:29 2003 From: "the dragon" Subject: Re: [sqr-users] SQR books Date: Tue, 15 Jul 2003 07:04:38 -0500 The best book is the free one that comes with sqribe. But, there are some additional excellant resources. go to http://www.amazon.com and search on sqr. I recommend : sqr in peoplesoft and other applications by landres sqr programming language reference by mellon peoplesoft sqr cheatsheet. clark 'the dragon' willis dragon enterprises, consulting services 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, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 09:55:18 2003 From: "Wunsche, Kathy" Subject: RE: [sqr-users] SQR books Date: Tue, 15 Jul 2003 11:01:28 -0400 Hi: Could you please tell me how to get the free book that comes with sqribe? We don't have it. Thank you. Kathy -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Tuesday, July 15, 2003 8:05 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] SQR books The best book is the free one that comes with sqribe. But, there are some additional excellant resources. go to http://www.amazon.com and search on sqr. I recommend : sqr in peoplesoft and other applications by landres sqr programming language reference by mellon peoplesoft sqr cheatsheet. clark 'the dragon' willis dragon enterprises, consulting services 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, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:14:59 2003 From: "Paul Hoyte" Subject: RE: [sqr-users] SQR books Date: Tue, 15 Jul 2003 11:13:00 -0400 Kathy: The books come with the product. If you are interested in getting more copies, just contact Brio and order directly from them (for a fee of course).... Paul Hoyte (248) 752-6970 Cell (248) 559-6868 Office (586) 421-9640 Fax paul.hoyte@sharidionne.com (Email) www.sharidionne.com (Web Site) -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf Of Wunsche, Kathy Sent: Tuesday, July 15, 2003 11:01 AM To: 'sqr-users@sqrug.org' Subject: RE: [sqr-users] SQR books Hi: Could you please tell me how to get the free book that comes with sqribe? We don't have it. Thank you. Kathy -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Tuesday, July 15, 2003 8:05 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] SQR books The best book is the free one that comes with sqribe. But, there are some additional excellant resources. go to http://www.amazon.com and search on sqr. I recommend : sqr in peoplesoft and other applications by landres sqr programming language reference by mellon peoplesoft sqr cheatsheet. clark 'the dragon' willis dragon enterprises, consulting services 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, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:18:05 2003 From: "Wunsche, Kathy" Subject: RE: [sqr-users] SQR books Date: Tue, 15 Jul 2003 11:24:34 -0400 HI Paul Hoyte: Thanks for getting back to me. I will pursue that. Kathy -----Original Message----- From: Paul Hoyte [mailto:Paul.Hoyte@sharidionne.com] Sent: Tuesday, July 15, 2003 11:13 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR books Kathy: The books come with the product. If you are interested in getting more copies, just contact Brio and order directly from them (for a fee of course).... Paul Hoyte (248) 752-6970 Cell (248) 559-6868 Office (586) 421-9640 Fax paul.hoyte@sharidionne.com (Email) www.sharidionne.com (Web Site) -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf Of Wunsche, Kathy Sent: Tuesday, July 15, 2003 11:01 AM To: 'sqr-users@sqrug.org' Subject: RE: [sqr-users] SQR books Hi: Could you please tell me how to get the free book that comes with sqribe? We don't have it. Thank you. Kathy -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Tuesday, July 15, 2003 8:05 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] SQR books The best book is the free one that comes with sqribe. But, there are some additional excellant resources. go to http://www.amazon.com and search on sqr. I recommend : sqr in peoplesoft and other applications by landres sqr programming language reference by mellon peoplesoft sqr cheatsheet. clark 'the dragon' willis dragon enterprises, consulting services 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, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:33:07 2003 From: "Ben Anderson" Date: Tue, 15 Jul 2003 11:32:18 -0400 Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 10:44:07 2003 From: "John Willson" Date: Tue, 15 Jul 2003 09:43:57 +0700 Subject: RE: [sqr-users] SQR books Hi Kathy, try http://www.sqrevangelism.com/ Darrin's book is the best independent of Peoplesoft SQR; however, it also has lots of applicable code for Peoplesoft and how to's. I use it as a first approach and always when managing a suite of SQRs. John Willson -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Wunsche, Kathy Sent: Tuesday, July 15, 2003 9:25 AM To: 'sqr-users@sqrug.org' Subject: RE: [sqr-users] SQR books HI Paul Hoyte: Thanks for getting back to me. I will pursue that. Kathy -----Original Message----- From: Paul Hoyte [mailto:Paul.Hoyte@sharidionne.com] Sent: Tuesday, July 15, 2003 11:13 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR books Kathy: The books come with the product. If you are interested in getting more copies, just contact Brio and order directly from them (for a fee of course).... Paul Hoyte (248) 752-6970 Cell (248) 559-6868 Office (586) 421-9640 Fax paul.hoyte@sharidionne.com (Email) www.sharidionne.com (Web Site) -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf Of Wunsche, Kathy Sent: Tuesday, July 15, 2003 11:01 AM To: 'sqr-users@sqrug.org' Subject: RE: [sqr-users] SQR books Hi: Could you please tell me how to get the free book that comes with sqribe? We don't have it. Thank you. Kathy -----Original Message----- From: the dragon [mailto:ceprn@hotmail.com] Sent: Tuesday, July 15, 2003 8:05 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] SQR books The best book is the free one that comes with sqribe. But, there are some additional excellant resources. go to http://www.amazon.com and search on sqr. I recommend : sqr in peoplesoft and other applications by landres sqr programming language reference by mellon peoplesoft sqr cheatsheet. clark 'the dragon' willis dragon enterprises, consulting services 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, We are in the process of purchasing SQR resources. I'd like to ask your expert advices on what books we should purchase for SQR? We'd like to get the most informative resource possible, that is why I'm asking your help. Thanks on any help on this. Have a great day! _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ 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 http://netwinsite.com/dbabble/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 10:45:05 2003 From: "Mezzullo, Paul" Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 11:51:41 -0400 Ben, Try placing an error condition in your 'file opening code' to verify the files status, I've included my working example code below for you --> !****************************************** ! PROCEDURE: open_File ((Procedure)) !****************************************** ! open file for writing !****************************************** begin-procedure open_File open 'c:\file.txt' as 10 for-writing ! len was 73 record=150:Fixed status = #open1 if #open1 = -1 display 'Open File Error' stop quiet end-if end-procedure open_File -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, July 15, 2003 11:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:47:06 2003 Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 10:46:16 -0500 From: "Sengupta, Rajib (CAG-CC-Contractor)" do some trimming and display: let $full_name = RTRIM($full_name, ' ') display $full_name open $full_name as 2 for-writing record=900:vary status=#filestatus Then put: if #filestatus != 0 display "error message" else process... by this way you will be sure that while opening the file it is erroring out.. then go back to check the file . Check whether file already exits or not etc..depending on O/s it might overwrite or might cause open error. rajib Rajib Sengupta Systems Analyst and Team Lead Peoplesoft Financial Consultant Conagra Business Systems Phone: 402-595-5749 -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, July 15, 2003 10:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:47:22 2003 From: "the dragon" Subject: Re: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 10:46:22 -0500 place it in it's own procedure like this, and then call it from the begin-program: (this is a generic section in my code; modify as needed) ! ------*-*-----------------------&---------(--,----)------------*-*---+ ! - OPEN THE FILES - | ! - this procedure opens any flat files needed for - | ! - processing. [CW] - | ! - desc : - | ! - proc : 6 - | ! - from : 0 - | ! - 14-Dec-1999 [CW] - | ! ------*-*-----------------------&---------(--,----)------------*-*---+ begin-procedure open_the_files show 'Entering OPEN THE FILES : proc 6 ' let $file_name = 'racsreplen.dat' let $environment = getenv('ORACLE_SID') show 'Environment = |' $environment '|' let $source_file = '/data/' || $country_code || lower($environment) || '/OM/export/' let $source_file = $source_file || {name} || '_' || $prcs_process_instance || '.txt' evaluate $environment when = 'ERPDEV' ! let $source_file = '/data/' || $country_code || lower($environment) || '/OM/export/' ! let $source_file = $source_file || {name} || '_' || $prcs_process_instance || '.txt' ! break when = 'ERPQA' ! let $source_file = '/data/' || $country_code || lower($environment) || '/OM/export/' ! let $source_file = $source_file || {name} || '_' || $prcs_process_instance || '.txt' ! break when = 'ERPPROD' ! let $source_file = '/data/' || $country_code || lower($environment) || '/OM/export/' ! let $source_file = $source_file || {name} || '_' || $prcs_process_instance || '.txt' break when-other show 'What environment are you running this program in?' stop quiet end-evaluate ! evaluate $environment ! when = 'ERPDEV' ! let $source_file = '/data/RA/erpdev/PO/import/racsreplen.dat' ! let $success_path = '/data/RA/erpdev/PO/import/.processed/' ! let $reject_path = '/data/RA/erpdev/PO/import/.rejects/' ! break ! when = 'ERPQA' ! let $source_file = '/data/RA/erpqa/PO/import/racsreplen.dat' ! let $success_path = '/data/RA/erpqa/PO/import/.processed/' ! let $reject_path = '/data/RA/erpqa/PO/import/.rejects/' ! break ! when = 'ERPPROD' ! let $source_file = '/data/RA/erpprod/PO/import/racsreplen.dat' ! let $success_path = '/data/RA/erpprod/PO/import/.processed/' ! let $reject_path = '/data/RA/erpprod/PO/import/.rejects/' ! break ! when-other ! show 'What environment are you running this program in?' ! stop quiet ! end-evaluate ! let $source_file = '/data/RA/erpdev/PO/import/brian1.dat' ! let $source_file = '/data/RA/erpqa/PO/import/brian1.dat' ! let $source_file = '/data/RA/erpprod/PO/import/brian1.dat' open $Source_File as 1 for-reading record=640:vary status=#File_1_Status if ( #File_1_Status <> 0 ) show 'Could not open input file: ' $Source_File show ' ' show 'SQR Halted.' stop quiet else show 'Input file 1 successfully found and opened.' ! [CW] end-if open $Source_File as 2 for-writing record=640:vary status=#File_2_Status if ( #File_2_Status <> 0 ) show 'Could not open output file: ' $Source_File show ' ' show 'SQR Halted.' stop quiet else show 'Output file 1 successfully found and opened.' ! [CW] end-if show 'Exiting OPEN THE FILES' end-procedure ! OPEN THE FILES Those of you at Strong, tell Geoff the dragon says 'high' :-P clark 'the dragon' willis dragon enterprises, consulting services 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'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 10:48:06 2003 From: "Alexander, Steve" Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 08:52:41 -0700 Don't put an open statement in the HEADING unless you want it to execute at the beginning of every page you print. I'm not sure what happens when you try to open a file that's already open. Maybe nothing, or maybe it deletes whatever you've written before and starts over. Add a "status=#open_status" clause to the open statement and test the value of #open_status. If it isn't 0, then your attempt to open the file didn't work. Why? You might not be logged in to that drive, or the path in $full_name might not exist, or you might not have write-access to it, or there might already be a read-only file with that name. -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, July 15, 2003 8:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:50:09 2003 Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 10:49:26 -0500 From: "Sengupta, Rajib (CAG-CC-Contractor)" one more point while using vary: make sure that you are not writing any binary data(only display charecters) Rajib Sengupta Systems Analyst and Team Lead Peoplesoft Financial Consultant Conagra Business Systems Phone: 402-595-5749 -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, July 15, 2003 10:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:53:05 2003 Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 11:52:36 -0400 From: "Weaver, Judith R" Ben - Change begin-report back to begin-program - this is the proper format and has nothing to do with your problem. - It appears that you're opening file as 2 but writing to file 1...should be "write 2 from $1" Judy -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Ben Anderson Sent: Tuesday, July 15, 2003 11:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 10:56:12 2003 From: "Hood Louise (app1lxh)" Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 11:55:28 -0400 Ben, The body of the report is created first with the heading and footer being entered only after a page is "done". Therefore, you should place your open file (and close file) in the main program stream, i.e., between BEGIN-PROGRAM and END-PROGRAM. HTH, Louise -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, July 15, 2003 11:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 11:00:05 2003 Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 10:59:05 -0500 From: "Sengupta, Rajib (CAG-CC-Contractor)" i guess thats the answer- i haven't noticed it at all- it should be write 2 Rajib Sengupta Systems Analyst and Team Lead Peoplesoft Financial Consultant Conagra Business Systems Phone: 402-595-5749 -----Original Message----- From: Weaver, Judith R [mailto:Judith.R.Weaver@usa-spaceops.com] Sent: Tuesday, July 15, 2003 10:53 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] write 1 from $1 -> in header Ben - Change begin-report back to begin-program - this is the proper format and has nothing to do with your problem. - It appears that you're opening file as 2 but writing to file 1...should be "write 2 from $1" Judy -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Ben Anderson Sent: Tuesday, July 15, 2003 11:32 AM To: sqr-users@sqrug.org Subject: [sqr-users] write 1 from $1 -> in header I'm writing to a flat file and getting this error when I try to write in the BEGIN-HEADING section: (SQR 3202) Specified file number not opened for writing. I've tried putting this: open $full_name as 2 for-writing record=900:vary in the HEADING and at the very beginning of BEGIN-REPORT, but it just errors on different line numbers. I also tried switching BEGIN-REPORT to BEGIN-PROGRAM. Any guidance? Thanks, Ben Anderson _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ 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-admin@sqrug.org Tue Jul 15 11:19:06 2003 From: "the dragon" Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 11:18:23 -0500 Also, putting an open statement in the heading would never get executed unless print output was created - and print output may be created long after you try writing to a flat file that you wanted open. clark 'the dragon' willis dragon enterprises, consulting services 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---- Don't put an open statement in the HEADING unless you want it to execute at the beginning of every page you print. I'm not sure what happens when you try to open a file that's already open. Maybe nothing, or maybe it deletes whatever you've written before and starts over. Add a "status=#open_status" clause to the open statement and test the value of #open_status. If it isn't 0, then your attempt to open the file didn't work. Why? You might not be logged in to that drive, or the path in $full_name might not exist, or you might not have write-access to it, or there might already be a read-only file with that name. _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 11:38:07 2003 Date: Tue, 15 Jul 2003 09:37:48 -0700 From: Jim Engebretson Subject: [sqr-users] SQR Code needed to convert employee name from upper case to mixed case Have you seen any SQR code which converts names from upper case into mixed case? _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 11:54:06 2003 From: EricRection@aol.com Date: Tue, 15 Jul 2003 12:53:38 EDT Subject: Re: [sqr-users] SQR Code needed to convert employee name from upper case to m... My effort is below. It correctly converts the following: Old Surname New Surname DE BASTO de Basto DE LOS ANGELES de los Angeles MCDONALD McDonald O'REILLY O'Reilly DUNCAN-SMITH Duncan-Smith TWOO WORDS Twoo Words (I can't think of a real life example, but it happens) HO LING Ho Ling MORRIS EL Morris El (this name came up in a newspaper recently) SMITH Smith Caveats: 1. To properly do Chinese names, you need an ethnic code, $ethnic, to identify your Orientals. UK PeopleSoft has such a thing, global PeopleSoft doesn't. Without a specific code, HO LING becomes Ho ling. 2. The procedure works on the kind of names you find in Europe - you'd have to hard-code any 'funnies' you get in your locality. It's a heuristic, i.e. it usually gives a good answer, but if you want to be perfect, you have to use the Mark I Eyeball. 3. Please note that Eric Rection is a pseudonym (E.Rection - geddit? Maturity is for cheeses). Credit me, huh? 4. The procedure works on the PeopleSoft demo DB but I admit I haven't tried it on a huge quantity of data. 5. The spacing looks nice on PFE but not here. Bummer. begin-procedure capitalise($name,$ethnic,:$capitalised) let $capitalised = '' let #len = length($name) let #current_char = 1 let #new_word = 1 let $old_char = ' ' while #current_char <= #len let #found_space = instr($name,' ',#current_char) let $current_char = substr($name,#current_char,1) if ! de Basto, de los Angeles but not two word surnames ( ( instr($name,' ',#current_char) > 0 and $ethnic <> '8' and not ($old_char = ' ' and instr($name,' ',#current_char) > #current_char+3) ) or ! exempt Chinese surnames from the above rule - requires a specific Chinese ethnic group code ( $ethnic = '8' and $old_char <> ' ' ) or ! Conventional surnames ( instr($name,' ',#current_char) = 0 and $old_char <> ' ' ) ) and ! McDonald, O'Leary not ( #current_char = 3 and ( substr($name,1,2) = 'MC' or substr($name,1,2) = 'O''' ) ) and ! Duncan-Smith $old_char <> '-' let $current_char = lower($current_char) else let $current_char = upper($current_char) end-if #ifdef debugx show $current_char ' ' #current_char ' new word ' #new_word ' 1st spc ' #found_space #endif if $current_char = ' ' let #new_word = #current_char end-if let $capitalised = $capitalised || $current_char let #current_char = #current_char + 1 let $old_char = $current_char end-while end-procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 12:00:13 2003 From: EricRection@aol.com Date: Tue, 15 Jul 2003 12:59:01 EDT Subject: Re: [sqr-users] SQR Code needed to convert employee name from upper case to m... Oops! Forgot to put my name in it for advertising purposes. Let's have a cigarette and try again... begin-procedure capitalise($name,$ethnic,:$capitalised) ! by Timothy Chilman, email: ephedrasa@hotmail.com let $capitalised = '' let #len = length($name) let #current_char = 1 let #new_word = 1 let $old_char = ' ' while #current_char <= #len let #found_space = instr($name,' ',#current_char) let $current_char = substr($name,#current_char,1) if ! de Basto, de los Angeles but not two word surnames ( ( instr($name,' ',#current_char) > 0 and $ethnic <> '8' and not ($old_char = ' ' and instr($name,' ',#current_char) > #current_char+3) ) or ! exempt Chinese surnames from the above rule - requires a specific Chinese ethnic group code ( $ethnic = '8' and $old_char <> ' ' ) or ! Conventional surnames ( instr($name,' ',#current_char) = 0 and $old_char <> ' ' ) ) and ! McDonald, O'Leary not ( #current_char = 3 and ( substr($name,1,2) = 'MC' or substr($name,1,2) = 'O''' ) ) and ! Duncan-Smith $old_char <> '-' let $current_char = lower($current_char) else let $current_char = upper($current_char) end-if #ifdef debugx show $current_char ' ' #current_char ' new word ' #new_word ' 1st spc ' #found_space #endif if $current_char = ' ' let #new_word = #current_char end-if let $capitalised = $capitalised || $current_char let #current_char = #current_char + 1 let $old_char = $current_char end-while end-procedure _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 12:04:06 2003 From: "the dragon" Subject: Re: [sqr-users] SQR Code needed to convert employee name from upper case to mixed case Date: Tue, 15 Jul 2003 12:03:41 -0500 If you're using PeopleSoft, I think there is a delivered sqc. I think it's one of the Rotname series. clark 'the dragon' willis dragon enterprises, consulting services 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---- Have you seen any SQR code which converts names from upper case into mixed case? _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Jul 15 12:48:07 2003 From: "Ben Anderson" Subject: RE: [sqr-users] write 1 from $1 -> in header Date: Tue, 15 Jul 2003 13:47:12 -0400 ok, all your replies made sense, but it's still not working. It's pretty weird. I have the file being opened in BEGIN-PROGRAM. The file is being opened and written to. Then when it tries the write in the header - that's when I get the error. I'm not closing the file until right before END-PROGRAM. It errors out and then I'm left with the first page of data with no header. Any ideas? TIA, Ben >From: "the dragon" >Reply-To: sqr-users@sqrug.org >To: sqr-users@sqrug.org >Subject: RE: [sqr-users] write 1 from $1 -> in header >Date: Tue, 15 Jul 2003 11:18:23 -0500 > >Also, putting an open statement in the heading would never get executed >unless print output was created - and print output may be created long >after you try writing to a flat file that you wanted open. > >clark 'the dragon' willis >dragon enterprises, consulting services > > > >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---- > >Don't put an open statement in the HEADING unless you want it to execute at >the beginning of every page you print. I'm not sure what happens when you >try to open a file that's already open. Maybe nothing, or maybe it deletes >whatever you've written before and starts over. > >Add a "status=#open_status" clause to the open statement and test the value >of #open_status. If it isn't 0, then your attempt to open the file didn't >work. Why? You might not be logged in to that drive, or the path in >$full_name might not exist, or you might not have write-access to it, or >there might already be a read-only file with that name. > >_________________________________________________________________ >The new MSN 8: advanced junk mail protection and 2 months FREE* >http://join.msn.com/?page=features/junkmail > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.