From owner-sqr-users@list.iex.net Wed Jul 1 01:29:33 1998 Date: Wed, 1 Jul 1998 08:09:16 +0200 From: Makhari T Subject: Printing in Landscape in Dot Matrix and Line printers. We are having some difficulty printing a report landscape from the Unix server on a dot matrix and a line printer. The orientation of the report in the begin-setup section does not seem to make any difference on the server (it always prints portrait). In windows it does print both portrait and landscape but not in Unix. Please try and give us some help in this regard. If you can test any report or have worked on such a problem mail us a solution we would be grateful. Thanks in advance, Tshenuwani Makhari. Systems Analyst - ISCOR Newcastle Work - Tel : 03431 - 4 8138 Home - Tel : 03431 - 81917 From owner-sqr-users@list.iex.net Wed Jul 1 07:02:32 1998 Date: Wed, 1 Jul 1998 07:48:49 -0400 From: "Kearns, Gary" Subject: Re: Where does PeopleCode get stored in PS Database ? FUNCLIBs are tables within PS that house common PeopleCode to be used by multiple tables. This allows for one place to maintain the code. For instance in Finance, FUNCLIB_JRNL_LN houses peoplecode that is referenced by multiple records in PS. You can locate all your FUNCLIB tables in Data Designer just like any other table. > -----Original Message----- > From: Pramod Bhavanam [SMTP:pramod_ps@HOTMAIL.COM] > Sent: Tuesday, June 30, 1998 8:09 PM > To: Multiple recipients of list SQR-USERS > Subject: Where does PeopleCode get stored in PS Database ? > > Hi, > > Can anyone tell me where the Peoplecode written in FUNCLIBs and else > where gets stored in the PS Database (in which table(s)) ? > > I will appreciate if anyone can help me out. > > Thanks. > Pramod. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 1 07:20:52 1998 Date: Wed, 1 Jul 1998 08:11:07 -0400 From: "Kearns, Gary" Subject: DOS Copy command Has anyone got the DOS "Copy" command to work using the call system command? I always get a return code of 2. Other DOS commands work but copy doesn't seem to work. Any help would be appreciated. Thanks, Gary Gary Kearns HSN PeopleSoft Implementation (813) 572-8585 x5070 kearnsg@hsn.net From owner-sqr-users@list.iex.net Wed Jul 1 08:19:48 1998 Date: Wed, 1 Jul 1998 08:04:29 -0500 From: Ray Ontko Subject: Re: Printing in Landscape in Dot Matrix and Line printers. Makhari, > We are having some difficulty printing a report landscape from the > Unix server on a dot matrix and a line printer. The orientation of > the report in the begin-setup section does not seem to make any > difference on the server (it always prints portrait). In windows it > does print both portrait and landscape but not in Unix. > > Please try and give us some help in this regard. If you can test any > report or have worked on such a problem mail us a solution we > would be grateful. Try this little test program. It works fine on my unix box: begin-setup declare-layout default orientation=landscape end-declare end-setup begin-program do main end-program begin-procedure main move 1 to #i while #i <= 90 print #i (1,1) edit 888 print '*' (1,99) next-listing add 1 to #i end-while end-procedure Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jul 1 08:20:20 1998 Date: Wed, 1 Jul 1998 09:08:48 -0400 From: "Mosley, Banessa" Subject: Re: Where does PeopleCode get stored in PS Database ? PeopleCode is stored in the following tables: PSPCMNAME (stores the program name and record name) PSPCMPROG (stores the program name and text) PSPROGNAME (stores the record name, field name, peoplecode type and program name) > -----Original Message----- > From: Pramod Bhavanam [SMTP:pramod_ps@HOTMAIL.COM] > Sent: Tuesday, June 30, 1998 8:09 PM > To: Multiple recipients of list SQR-USERS > Subject: Where does PeopleCode get stored in PS Database ? > > Hi, > > Can anyone tell me where the Peoplecode written in FUNCLIBs and else > where gets stored in the PS Database (in which table(s)) ? > > I will appreciate if anyone can help me out. > > Thanks. > Pramod. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 1 10:11:20 1998 Date: Wed, 1 Jul 1998 10:47:10 -0400 From: "Wanko, Christopher G, CFCTRCFFIN" Subject: Re: Performance of Large Arrays and QuickSort in SQR > Which of these two is faster will largely depend on your > database and operating system. The overhead for creating a > temporary table and then doing a sorted query is fairly > substantial, as is creating an operating system file and > running an operating system sort program. In any case, I > would expect SQR to perform the read/sort/write operation > very quickly. SQR would also be a more portable solution > (across databases and operating systems) if that's an issue. I suppose SQR would get an edge in portability if the database access was consistent across platforms (recompile for target machines), but in the case of any flat-file processing, I would suggest that sorting is best done by programs designed to sort. Anecdotal evidence: SyncSort can do pretty complex processing and sorting jobs in about a tenth of the time it would take an SQR program- any SQR program. While I would hesitate to add another step to your process, I would also hesitate to try to use SQR as the multipurpose tool for all my needs. You have need for very fast sorting and perhaps simple data validation. SyncSort would do it faster (and I'm not a rep for SyncSort, but it really does fit your situation), and the end result is a flatfile or flatfiles ready for loading. This is where your SQR program(s) would be more useful. In general, unless you don't have access to anything else, try to get the best tools for the job. In this case, flatfile processing through a program such as SyncSort will greatly simplify your SQR coding while improving your speed of execution. -Chris From owner-sqr-users@list.iex.net Wed Jul 1 10:34:51 1998 Date: Wed, 1 Jul 1998 11:11:07 -0400 From: Vikram Muratee Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 Pramod, I think your Peoplesoft specific queries will be better addressed at a peoplesoft mailing list. You can subscribe to one I am aware of, at http://www.ps-users.com/ Good luck . Vikram pramod_ps@HOTMAIL.COM on 06/30/98 08:05:13 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Vikram K Muratee/CCNI) Subject: Problem starting PS/nVision from PS 6 Single user under Windows95 Hi, I am working on Peoplesoft 6 HR Single User version with SQLBase as the database under Windows'95. I am getting an error when starting PS/nVision from Peopletools menu with the following message displayed. "PS/nVision was unable to load the DLL, PSNAM.DLL. (28,145)" Can anyone give / suggest a possible solution for the above problem. I will appreciate your help in this regard. Thank you. Pramod. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 1 10:51:53 1998 Date: Wed, 1 Jul 1998 09:32:17 -0600 From: Juan Alvarado Subject: Re: SyBase Numeric Conversions we are running in severlas installations with Sybase and MS SQL SERVER. And use the convertions with clause convert. How is your problem??? Can tell us more information?? Juan Manuel Alvarado CPS-DBA Sybase XI Gerencia & Sistemas Guatemala www.gyssa.com.gt > -----Original Message----- > From: Darwin Anderson [SMTP:dander03@AVIS.COM] > Sent: Tuesday, June 30, 1998 3:31 PM > To: Multiple recipients of list SQR-USERS > Subject: SyBase Numeric Conversions > > We are encountering "implicit numeric conversion" errors > when attempting to perform SQL Inserts. Has anyone > experienced this and, if so, have you come up with a cure to > the malady? > > We are running SyBase 11.0.2.1, EBF 6717, on a Sun > Solaris 2.6. > > I can provide SQR code, SQR error log, and input data file, if > required. > > All suggestions greatly appreciated. > > Thanks, > Darwin Anderson From owner-sqr-users@list.iex.net Wed Jul 1 12:33:05 1998 Date: Wed, 1 Jul 1998 09:54:02 -0700 From: Michael Lee Subject: Re: Where does PeopleCode get stored in PS Database ? Pramod, Banessa hit it right on the dot. What I wanted to add is that PeopleSoft offers a "Data Management Tools" class which does touch on PeopleTools tables. One thing that is also discussed in training is that you should not be touching the Tools tables through some SQL DB utility. You should let PeopleSoft update the tools tables. Once in a while, you will need to, but you really need to know what you are doing. Are you planning on updating the tools tables? Or was this strictly for knowledge. This is a good interview question hehe... Michael K. Lee Consultant AG Consulting, an ADP Company Banessa_Mosley@MAIL.CI.BALTIMORE.MD.US on 07/01/98 06:08:48 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Re: Where does PeopleCode get stored in PS Database ? PeopleCode is stored in the following tables: PSPCMNAME (stores the program name and record name) PSPCMPROG (stores the program name and text) PSPROGNAME (stores the record name, field name, peoplecode type and program name) > -----Original Message----- > From: Pramod Bhavanam [SMTP:pramod_ps@HOTMAIL.COM] > Sent: Tuesday, June 30, 1998 8:09 PM > To: Multiple recipients of list SQR-USERS > Subject: Where does PeopleCode get stored in PS Database ? > > Hi, > > Can anyone tell me where the Peoplecode written in FUNCLIBs and else > where gets stored in the PS Database (in which table(s)) ? > > I will appreciate if anyone can help me out. > > Thanks. > Pramod. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 1 15:18:24 1998 Date: Wed, 1 Jul 1998 12:35:03 PDT From: shibu joys Subject: Download SQR Hi Guys, I would like to know is there any site from where i can download SQR. Thanks Shibu ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 1 15:54:56 1998 Date: Wed, 1 Jul 1998 15:12:44 -0500 From: Ray Ontko Subject: Re: Download SQR Shibu, > I would like to know is there any site from where I can download SQR. SQR is a commercial product, which is available from SQRIBE and its authorized distributors. You can find more information about the product at: http://www.sqribe.com/ As far as I know, they do not have a trial copy online. If you're looking to download sample programs written in SQR, visit the SQR User Group site at: http://www.sqrug.com/ We also have a few sample programs at our site: http://www.ontko.com/sqr/sqrlib.html Hope this helps. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jul 1 15:55:17 1998 Date: Wed, 1 Jul 1998 16:09:56 EDT From: Greekanth Gunge Subject: Re: Download SQR visit www.sqrug.com Thanks vish From owner-sqr-users@list.iex.net Wed Jul 1 16:33:00 1998 Date: Wed, 1 Jul 1998 15:58:05 -0500 From: John Niedziela Subject: Re: Download SQR SQR is purchased from SQRIBE Technologies and the software is delivered on CD-ROM or floppy. The SQR website is www.sqribe.com. They may have some down load capabilities. Regards jjn At 12:35 PM 7/1/98 PDT, you wrote: >Hi Guys, > >I would like to know is there any site from where i can download SQR. > >Thanks > >Shibu > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > From owner-sqr-users@list.iex.net Wed Jul 1 16:56:57 1998 Date: Wed, 1 Jul 1998 14:28:04 -0700 From: Michael Lee Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 --0__=rDRAd0VfCMXcoyzCnOLTjR5YDhPZxh04ltNAPRjWaNEIgVMCA68sfEAa Content-type: text/plain; charset=US-ASCII In order to contact GSC, you need a site ID or some type of license number to receive technical support. To be quite honest, many of the PS Single User Copies are illegal copies that people have distributed. Make sure that you have a valid license before contacting PeopleSoft. I suggest you to check your environment... make sure that it is not your version of Office/Excel. Michael K. Lee Consultant AG Consulting, an ADP Company Stephanie_Moxley@PEOPLESOFT.COM on 07/01/98 01:53:13 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 Hello there. Contact the GSC at 1-800-PPL-SOFT. Without knowing your configuration environment, it's a little difficult to tell the exact problem you are having. I think that your problem would be resolved with the following resolution information, but you may want to establish a case with the GSC in case there are some more configuration issues that you may run into. Ask them about: Resolution Title: NV: Unable to find PSNAM.DLL Resolution ID: 18899 Good luck! -Stephanie (Embedded image moved Vikram Muratee to file: 07/01/98 11:11 AM pic31354.pcx) Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Stephanie Moxley) Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 Pramod, I think your Peoplesoft specific queries will be better addressed at a peoplesoft mailing list. You can subscribe to one I am aware of, at http://www.ps-users.com/ Good luck . Vikram pramod_ps@HOTMAIL.COM on 06/30/98 08:05:13 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Vikram K Muratee/CCNI) Subject: Problem starting PS/nVision from PS 6 Single user under Windows95 Hi, I am working on Peoplesoft 6 HR Single User version with SQLBase as the database under Windows'95. I am getting an error when starting PS/nVision from Peopletools menu with the following message displayed. "PS/nVision was unable to load the DLL, PSNAM.DLL. (28,145)" Can anyone give / suggest a possible solution for the above problem. I will appreciate your help in this regard. Thank you. Pramod. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com --0__=rDRAd0VfCMXcoyzCnOLTjR5YDhPZxh04ltNAPRjWaNEIgVMCA68sfEAa Content-type: application/octet-stream; name="pic31354.pcx" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=rDRAd0VfCMXcoyzCnOLTjR5YDhPZxh04ltNAPRjWaNEIgVMCA68sfEAa-- From owner-sqr-users@list.iex.net Wed Jul 1 17:42:31 1998 Date: Wed, 1 Jul 1998 16:53:13 -0400 From: Sephanie Moxley Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 --0__=bqTJT8GoxeFaLgV7bbn4iVYs0oYXEAteEckyGS3rT3Z0EWPM035shUra Content-type: text/plain; charset=us-ascii Content-Disposition: inline Hello there. Contact the GSC at 1-800-PPL-SOFT. Without knowing your configuration environment, it's a little difficult to tell the exact problem you are having. I think that your problem would be resolved with the following resolution information, but you may want to establish a case with the GSC in case there are some more configuration issues that you may run into. Ask them about: Resolution Title: NV: Unable to find PSNAM.DLL Resolution ID: 18899 Good luck! -Stephanie (Embedded image moved Vikram Muratee to file: 07/01/98 11:11 AM pic31354.pcx) Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Stephanie Moxley) Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windows95 Pramod, I think your Peoplesoft specific queries will be better addressed at a peoplesoft mailing list. You can subscribe to one I am aware of, at http://www.ps-users.com/ Good luck . Vikram pramod_ps@HOTMAIL.COM on 06/30/98 08:05:13 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Vikram K Muratee/CCNI) Subject: Problem starting PS/nVision from PS 6 Single user under Windows95 Hi, I am working on Peoplesoft 6 HR Single User version with SQLBase as the database under Windows'95. I am getting an error when starting PS/nVision from Peopletools menu with the following message displayed. "PS/nVision was unable to load the DLL, PSNAM.DLL. (28,145)" Can anyone give / suggest a possible solution for the above problem. I will appreciate your help in this regard. Thank you. Pramod. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com --0__=bqTJT8GoxeFaLgV7bbn4iVYs0oYXEAteEckyGS3rT3Z0EWPM035shUra Content-type: application/octet-stream; name="pic31354.pcx" Content-Disposition: attachment; filename="pic31354.pcx" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=bqTJT8GoxeFaLgV7bbn4iVYs0oYXEAteEckyGS3rT3Z0EWPM035shUra-- From owner-sqr-users@list.iex.net Wed Jul 1 22:36:24 1998 Date: Thu, 2 Jul 1998 15:22:39 +1200 From: Charles Thompson Subject: Re: Where does PeopleCode get stored in PS Database ? The text itself is stored in a blob field, PSPCMPROG.PROGTXT. Does anyone know how this data is encrypted (or more importantly, unencrypted) ? - Charles Thompson >>PeopleCode is stored in the following tables: >> >>PSPCMNAME (stores the program name and record name) >>PSPCMPROG (stores the program name and text) >>PSPROGNAME (stores the record name, field name, peoplecode type and >>program name) >> >>> -----Original Message----- >>> From: Pramod Bhavanam [SMTP:pramod_ps@HOTMAIL.COM] >>> Sent: Tuesday, June 30, 1998 8:09 PM >>> To: Multiple recipients of list SQR-USERS >>> Subject: Where does PeopleCode get stored in PS Database ? >>> >>> Hi, >>> >>> Can anyone tell me where the Peoplecode written in FUNCLIBs and else >>> where gets stored in the PS Database (in which table(s)) ? >>> >>> I will appreciate if anyone can help me out. >>> >>> Thanks. >>> Pramod. >>> >>> >>> ______________________________________________________ >>> Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jul 2 17:50:12 1998 Date: Thu, 2 Jul 1998 15:29:10 -0700 From: "Walcker, Paul" Subject: Local Variable Surprise Having a VB and C background, it is my preference in life to pass as many variables as possible as parameters between procedures. I have been working with an SQR that is calling multiple levels of procedures similar to the following: begin-procedure proc1 do Proc2 (#OK) if #OK = 1 ! do some processing here else ! Write error messages end-if end-procedure begin-procedure proc2(:#Valid) let #Valid = 1 ! setting this procedure to have a valid return code do Proc3(#Valid) ! expecting the value of #Valid to be 0 at this point show 'Proc2 = ' #Valid end-procedure begin-procedure proc3(:#Valid) let #Valid = 0 ! setting this procedure to have an invalid return code show 'Proc3 = ' #Valid end-procedure In this example I was expecting to perform error processing when finally getting back up to Proc1. I was quite surprised to find that Proc1 was acting like the return code (#OK) was valid. When checking the log I found the following: Proc3 = 0 Proc2 = 1 I was expecting the "Do Proc3(#Valid)" process to get a return value of 0 then pass that value to Proc1. This E-mail is meant to both share information and to request a reasonable explanation as to why this is happening? Thanks Paul From owner-sqr-users@list.iex.net Thu Jul 2 18:21:54 1998 Date: Thu, 2 Jul 1998 16:06:11 -0700 From: Joan Hudson Subject: Re: Local Variable Surprise That's wild! I ran your code and got 0 values for both procs. I added a show line for ok from my main procedure, and it too was the expected zero. My test was on sqr 3.0.7.3 for AIX. joan >Having a VB and C background, it is my preference in life to pass as >many variables as possible as parameters between procedures. I have >been working with an SQR that is calling multiple levels of procedures >similar to the following: > >begin-procedure proc1 > do Proc2 (#OK) > if #OK = 1 > ! do some processing here > else > ! Write error messages > end-if >end-procedure > >begin-procedure proc2(:#Valid) > let #Valid = 1 ! setting this procedure to have a valid return code > do Proc3(#Valid) > > ! expecting the value of #Valid to be 0 at this point > show 'Proc2 = ' #Valid >end-procedure > >begin-procedure proc3(:#Valid) > let #Valid = 0 ! setting this procedure to have an invalid return >code > show 'Proc3 = ' #Valid >end-procedure > >In this example I was expecting to perform error processing when finally >getting back up to Proc1. I was quite surprised to find that Proc1 was >acting like the return code (#OK) was valid. When checking the log I >found the following: > >Proc3 = 0 >Proc2 = 1 > >I was expecting the "Do Proc3(#Valid)" process to get a return value of >0 then pass that value to Proc1. > >This E-mail is meant to both share information and to request a >reasonable explanation as to why this is happening? > >Thanks > >Paul From owner-sqr-users@list.iex.net Fri Jul 3 15:18:33 1998 Date: Fri, 3 Jul 1998 15:55:36 -0400 From: jlwyant Subject: ORA-1013 All, Anyone ever gotten an ORA-1013 error? Text supplied is "user requested cancel of current operation". I'm passing this on for a friend so I don't have specific details. Any help is appreciated. Thanks, Jim From owner-sqr-users@list.iex.net Fri Jul 3 16:05:20 1998 Date: Fri, 3 Jul 1998 13:52:04 PDT From: Ram Venkat Subject: Re: ORA-1013 Hi Jim, Though I have n't come across this error in live situation, I can tell you that it occurs when you connect the server from the client thro SQL net. I believe , Oracle is sending a patch to fix this bug. An example I have heard is when u try to spool and if the file size exceeds 100 MB , the client is isolated from the server. Immediate work around could be invoking oracle from the server. Try and let me know by skipping the SQL Net. Contact Oracle for your patch. Would like to hear from you as how you solved it.... bye Ram Venkat >From owner-sqr-users@list.iex.net Fri Jul 3 13:08:04 1998 >Received: from list.iex.net (list.iex.net [192.156.196.15]) by list.iex.net (8.8.5/8.8.5) with SMTP id OAA02237; Fri, 3 Jul 1998 14:05:57 -0600 (MDT) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8b) with > spool id 5181056 for SQR-USERS@LIST.IEX.NET; Fri, 3 Jul 1998 14:05:37 > -0600 >Received: from darius.concentric.net (darius.concentric.net [207.155.184.79]) > by list.iex.net (8.8.5/8.8.5) with ESMTP id OAA02159 for > ; Fri, 3 Jul 1998 14:05:32 -0600 (MDT) >Received: from mcfeely.concentric.net (mcfeely.concentric.net [207.155.184.83]) > by darius.concentric.net (8.8.8/(98/04/23 5.10)) id QAA14611; Fri, 3 > Jul 1998 16:05:19 -0400 (EDT) [1-800-745-2747 The Concentric Network] >Errors-To: >Received: from gateway (ts003d07.mid-mi.concentric.net [206.173.103.115]) by > mcfeely.concentric.net (8.8.8) id QAA18152; Fri, 3 Jul 1998 16:05:18 > -0400 (EDT) >X-Mailer: Mozilla 3.0C (Win95; I) >MIME-Version: 1.0 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit >Message-ID: <359D3738.1FA0@acm.org> >Date: Fri, 3 Jul 1998 15:55:36 -0400 >Reply-To: SQR-USERS@USA.NET >Sender: "Discussion of SQR, > SQRiBE Technologies's database reporting language" > >From: jlwyant >Subject: ORA-1013 >To: Multiple recipients of list SQR-USERS > >All, > >Anyone ever gotten an ORA-1013 error? Text supplied is "user requested >cancel of current operation". I'm passing this on for a friend so I >don't have specific details. Any help is appreciated. > >Thanks, Jim > Ram ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Fri Jul 3 16:13:10 1998 Date: Fri, 3 Jul 1998 16:51:04 -0400 From: Elizabeth Raniszewski Subject: ORA-1013 -Reply The Message and Codes manual reads: ORA-01013 user requested cancel of current operation Cause: The user interrupted an Oracle operation by entering CTRL-C (ControlC) or another cancelling operation. This forces the current operation to end . This is an informational message only Action: continue with the next operation >>> jlwyant 07/03/98 01:55pm >>> All, Anyone ever gotten an ORA-1013 error? Text supplied is "user requested cancel of current operation". I'm passing this on for a friend so I don't have specific details. Any help is appreciated. Thanks, Jim From owner-sqr-users@list.iex.net Fri Jul 3 16:29:03 1998 Date: Fri, 3 Jul 1998 17:06:11 -0400 From: jlwyant Subject: More: ORA-01013, "user requested cancel of current operation" All, Thanks to everyone who has already responded. As I mentioned early I'm passing this message on for a friend... I have a few more details and now know that he did not press control-c or any other cancelling operation. I do know that he is loading flat files into Oracle. He has been able to load small tables with ten thousand records or less. It is the larger loads that appear to quit with the ORA-01013 error. He informs me that after running the same SQR multiple times it never errors in the same procedure or record count. I suggested as a wild guess that he try issuing a commit after say 500 hundred inserts. My thinking here is the possibility of a full rollback segment. Thanks for all your help. Jim From owner-sqr-users@list.iex.net Sun Jul 5 17:26:45 1998 Date: Sun, 5 Jul 1998 17:13:25 -0500 From: Eric Dimick Eastman Subject: Re: More: ORA-01013, "user requested cancel of current operation" Hello, I posted a message about this exact problem a while ago and have had it as an ongoing problem for the last year. I get it while loading flat files into Oracle. There doesn't seem to be any rhyme or reason to it. I have worked around this problem by making my load programs robust. I have a on-error clause on each begin-sql and begin-select that prints an error to a log file and puts the offending datafile lines in an error file to be re-run. I get that error about 1 record per 100,000. I will continue to work on this problem, and if find anything out I would love to hear it. Thanks, Eric On Fri, 3 Jul 1998, jlwyant wrote: > All, > > Thanks to everyone who has already responded. > > As I mentioned early I'm passing this message on for a friend... I have > a few more details and now know that he did not press control-c or any > other cancelling operation. I do know that he is loading flat files into > Oracle. He has been able to load small tables with ten thousand records > or less. It is the larger loads that appear to quit with the ORA-01013 > error. He informs me that after running the same SQR multiple times it > never errors in the same procedure or record count. I suggested as a > wild guess that he try issuing a commit after say 500 hundred inserts. > My thinking here is the possibility of a full rollback segment. > > Thanks for all your help. Jim > ------------------------------------------------------------------------ Eric Dimick Eastman |Ray Ontko & Co | This space for rent. erice@ontko.com |Richmond, IN | Your opinion here. http://www.ontko.com | | From owner-sqr-users@list.iex.net Mon Jul 6 08:54:37 1998 Date: Mon, 6 Jul 1998 09:34:54 -0500 From: Darwin Anderson Subject: Single select, multiple reports-sorts-headings I need to produce two reports from the same data selection. One report will be ordered by employee name while a second report will be ordered by employee name WITHIN company location. The headings of each need to specifically identify the sort order. Can I do these both in a single SQR with two selects (identical except for the 'order by' clauses) using text variables for the different headings? or do I have to run two independent reports (SQR files)? All advice greatly appreciated with apologies for my rookie status in using SQRW Darwin Anderson dander03@avis.com (516) 222-3064 From owner-sqr-users@list.iex.net Mon Jul 6 09:02:29 1998 Date: Mon, 6 Jul 1998 09:50:24 -0400 From: Paul Cruz Subject: Re: More: ORA-01013, "user requested cancel of current operation" Just adding my 2 cents.. This is a known bug in Oracle RDBMS ver 7.2 ( not sure if it also exist in 7.3). We encountered this same problem on a script (not written in SQR) that does the same thing, loading from a flat file. Oracle Support should be able to provide you a patch for it. -----Original Message----- From: Eric Dimick Eastman To: Multiple recipients of list SQR-USERS Date: Sunday, July 05, 1998 6:18 PM Subject: Re: More: ORA-01013, "user requested cancel of current operation" >Hello, > >I posted a message about this exact problem a while ago and have had it >as an ongoing problem for the last year. I get it while loading flat >files into Oracle. There doesn't seem to be any rhyme or reason to it. >I have worked around this problem by making my load programs robust. >I have a on-error clause on each begin-sql and begin-select that prints >an error to a log file and puts the offending datafile lines in an error >file to be re-run. I get that error about 1 record per 100,000. > >I will continue to work on this problem, and if find anything out I >would love to hear it. > >Thanks, >Eric > >On Fri, 3 Jul 1998, jlwyant wrote: > >> All, >> >> Thanks to everyone who has already responded. >> >> As I mentioned early I'm passing this message on for a friend... I have >> a few more details and now know that he did not press control-c or any >> other cancelling operation. I do know that he is loading flat files into >> Oracle. He has been able to load small tables with ten thousand records >> or less. It is the larger loads that appear to quit with the ORA-01013 >> error. He informs me that after running the same SQR multiple times it >> never errors in the same procedure or record count. I suggested as a >> wild guess that he try issuing a commit after say 500 hundred inserts. >> My thinking here is the possibility of a full rollback segment. >> >> Thanks for all your help. Jim >> > >------------------------------------------------------------------------ >Eric Dimick Eastman |Ray Ontko & Co | This space for rent. >erice@ontko.com |Richmond, IN | Your opinion here. >http://www.ontko.com | | From owner-sqr-users@list.iex.net Mon Jul 6 09:15:27 1998 Date: Mon, 6 Jul 1998 10:03:22 -0400 From: Mary Ellen Foster Subject: Re: Single select, multiple reports-sorts-headings You can print multiple reports in one SQR. I created an SQR that produces three reports from one select statement. Here is what I did: 1. Created a DECLARE-LAYOUT for the reports in the BEGIN-SETUP section. If the layout is the same for the three reports then you only need on DECLARE-LAYOUT otherwise you need a DECLARE-LAYOUT for each report. 2. Create a DECLARE-REPORT for each report you want to create using the layout you defined before. BEGIN-SETUP DECLARE-LAYOUT LAYOUT1 PAPER-SIZE = (14,11) FORMFEED = YES ORIENTATION = PORTRAIT LEFT-MARGIN = 0 TOP-MARGIN = 0 MAX-LINES = 99 MAX-COLUMNS = 132 END-DECLARE DECLARE-REPORT REPORT1 LAYOUT=LAYOUT1 END-DECLARE DECLARE-REPORT REPORT2 LAYOUT=LAYOUT1 END-DECLARE END-SETUP 3. To use the report type USE-REPORT REPORT1 code here USE-REPORT REPORT2 code here BEGIN-SELECT COLUMN1 &col1 COLUMN2 &col2 COLUMN3 &col3 COLUMN4 &col4 use-report REPORT1 print &col1 (1,2) print &col2 (2,2) use-report REPORT2 print &col1 (1,2) print &col2 (2,2) print &col3 (3,2) print &col4 (4,2) FROM TABLE END-SELECT Each report will have a different name like FILE1.LIS, FILE1.L02, FILE1.L03. Hope this helps. Mary Ellen From owner-sqr-users@list.iex.net Mon Jul 6 09:27:00 1998 Date: Mon, 6 Jul 1998 10:14:53 -0400 From: Jennifer Sieber Subject: Faxing Purchase Orders in PSoft Has anyone set up their PeopleSoft Purchasing SQR (POPO005.sqr) to be used with RightFAX (a fax software package)? Any help greatly appreciated... Thanks in advance, Jennifer From owner-sqr-users@list.iex.net Mon Jul 6 10:17:02 1998 Date: Mon, 6 Jul 1998 09:48:29 -0500 From: David Anderson Subject: Single select, multiple reports-sorts-headings -Reply You can use the same select but adjust your where clause using dynamic variables and substitutions as well as utilizing the new-report functionality of SQR... There have been a number of discussions on both subjects so please review the archives as well as the SQR manual from MITI(SQRIBE). Dave From owner-sqr-users@list.iex.net Mon Jul 6 10:40:19 1998 Date: Mon, 6 Jul 1998 07:26:15 PDT From: Ram Venkat Subject: Re: More: ORA-01013, an immediate workaround could be to connect directly to the server instead of going thro the SQL NET. (USERNAME / PASSWORD (without @connectstring or host string) Ram Venkat >From owner-sqr-users@list.iex.net Mon Jul 6 06:49:00 1998 >Received: from list.iex.net (list.iex.net [192.156.196.15]) by list.iex.net (8.8.5/8.8.5) with SMTP id HAA17038; Mon, 6 Jul 1998 07:48:35 -0600 (MDT) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8b) with > spool id 5170023 for SQR-USERS@LIST.IEX.NET; Mon, 6 Jul 1998 07:48:28 > +1800 >Received: from mail.iex.net (mail [192.156.196.5]) by list.iex.net > (8.8.5/8.8.5) with ESMTP id HAA17028 for ; > Mon, 6 Jul 1998 07:48:26 -0600 (MDT) >Received: from mx04.netaddress.usa.net (mx04.netaddress.usa.net > [204.68.24.141]) by mail.iex.net (8.8.5/8.7.5) with SMTP id HAA11254 > for ; Mon, 6 Jul 1998 07:45:00 -0600 (MDT) >Received: (qmail 11037 invoked by uid 0); 6 Jul 1998 13:47:54 -0000 >Received: from algoma.com [208.128.155.10] by mx04 via mtad (2.6) with ESMTP id > mx04-cgFNv20154; Mon, 06 Jul 1998 13:47:53 GMT >Received: by gateway.algoma.com id <27779>; Mon, 6 Jul 1998 09:49:19 -0400 >MIME-Version: 1.0 >Content-Type: text/plain; charset="iso-8859-1" >Content-Transfer-Encoding: 7bit >X-Priority: 3 >X-MSMail-Priority: Normal >X-Mailer: Microsoft Outlook Express 4.71.1712.3 >X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 >Message-ID: <98Jul6.094919edt.27779@gateway.algoma.com> >Date: Mon, 6 Jul 1998 09:50:24 -0400 >Reply-To: SQR-USERS@USA.NET >Sender: "Discussion of SQR, > SQRiBE Technologies's database reporting language" > >From: Paul Cruz >Subject: Re: More: ORA-01013, "user requested cancel of current operation" >X-To: SQR-USERS@usa.net >To: Multiple recipients of list SQR-USERS > >Just adding my 2 cents.. >This is a known bug in Oracle RDBMS ver 7.2 ( not sure if it also exist in >7.3). We encountered this same problem on a script (not written in SQR) that >does the same thing, loading from a flat file. Oracle Support should be able >to provide you a patch for it. > >-----Original Message----- >From: Eric Dimick Eastman >To: Multiple recipients of list SQR-USERS >Date: Sunday, July 05, 1998 6:18 PM >Subject: Re: More: ORA-01013, "user requested cancel of current operation" > > >>Hello, >> >>I posted a message about this exact problem a while ago and have had it >>as an ongoing problem for the last year. I get it while loading flat >>files into Oracle. There doesn't seem to be any rhyme or reason to it. >>I have worked around this problem by making my load programs robust. >>I have a on-error clause on each begin-sql and begin-select that prints >>an error to a log file and puts the offending datafile lines in an error >>file to be re-run. I get that error about 1 record per 100,000. >> >>I will continue to work on this problem, and if find anything out I >>would love to hear it. >> >>Thanks, >>Eric >> >>On Fri, 3 Jul 1998, jlwyant wrote: >> >>> All, >>> >>> Thanks to everyone who has already responded. >>> >>> As I mentioned early I'm passing this message on for a friend... I have >>> a few more details and now know that he did not press control-c or any >>> other cancelling operation. I do know that he is loading flat files into >>> Oracle. He has been able to load small tables with ten thousand records >>> or less. It is the larger loads that appear to quit with the ORA-01013 >>> error. He informs me that after running the same SQR multiple times it >>> never errors in the same procedure or record count. I suggested as a >>> wild guess that he try issuing a commit after say 500 hundred inserts. >>> My thinking here is the possibility of a full rollback segment. >>> >>> Thanks for all your help. Jim >>> >> >>------------------------------------------------------------------------ >>Eric Dimick Eastman |Ray Ontko & Co | This space for rent. >>erice@ontko.com |Richmond, IN | Your opinion here. >>http://www.ontko.com | | > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jul 6 11:39:03 1998 Date: Mon, 6 Jul 1998 18:17:52 +0100 From: Anders Eriksson Subject: SQR.INI Hello! I wonder were I can find documentation about the settings for Sqr.ini. Since I am not American I am especialy interested if I can use Sqr.ini for contery specific settings. I have tried to do that but where unable to make it to work. Have anybody else tied that out and maked it to work? I am using: Windows 95 and NT Clients SQR 3.0.13.2 for PC/Windows Oracle 7.3 Regards Anders Eriksson From owner-sqr-users@list.iex.net Mon Jul 6 11:51:55 1998 Date: Mon, 6 Jul 1998 18:11:42 +0100 From: Anders Eriksson Subject: Using the edit mask for date fields on Oracle Hello! I have a problem. I am tying to convert a large number of reports frm SQLBase to Oracle and I can't get the formating of date formats on Oracle to work. I have the folowing code: begin-select faildate (,10) edit 'yyyy-mm-dd hh:mi' ! Won't work statusdate print &statusdate (,27) edit 'yyyy-mm-dd hh:mi' ! Will not work either .... When executing this code on the Oracle database i get the edit string yyyy-mm-dd hh:mi insted of the formated date. Since I am going to convert a large number of reports I would like to avoid to rewrite every line where dates are formated to: to_char( faildate, {d_DateTimeMask} ) (,10) to_char( statusdate, {d_DateTimeMask} ) (,27) As far as I have understod it should be possible to use the edit comand for date fields for Oracle databases as well. I am using: Windows 95 and NT Clients SQR 3.0.13.2 for PC/Windows Oracle 7.3 Regards Anders Eriksson From owner-sqr-users@list.iex.net Mon Jul 6 12:37:17 1998 Date: Mon, 6 Jul 1998 12:58:27 -0400 From: Art DiRamio Subject: Re: SQR.INI Anders: I know the SQR.INI file works for SQR v4 for foreign language support, but not sure of v3 (don't think it works). The other thing is Oracle's default date format is 'DD-MON-YY'. To get them into a usable format in SQR v3, use the TO_CHAR command: TO_CHAR(Faildate,'yyyy-mm-dd hh:mi') &FailDate (,10) PS - SQRiBE built in some date functions in v4, but in v3, dates are strings - v3 doesn't understand dates. -- Art > -----Original Message----- > From: Anders Eriksson [SMTP:anders.eriksson@TELE2.SE] > Sent: Monday, July 06, 1998 1:18 PM > To: Multiple recipients of list SQR-USERS > Subject: SQR.INI > > Hello! > > I wonder were I can find documentation about the settings for Sqr.ini. > Since I am not American > I am especialy interested if I can use Sqr.ini for contery specific > settings. I have tried to do that > but where unable to make it to work. Have anybody else tied that out > and > maked it to work? > > I am using: > Windows 95 and NT Clients > SQR 3.0.13.2 for PC/Windows > Oracle 7.3 > > Regards > Anders Eriksson From owner-sqr-users@list.iex.net Mon Jul 6 14:19:12 1998 Date: Mon, 6 Jul 1998 14:34:44 -0400 From: John Walker Subject: Re: Using the edit mask for date fields on Oracle Anders, I went through this a few weeks ago. There should be quite a bit of correspondence in the archive. Unfortunately, the bottom line is that if you are using ver 3 then you are stuck with using to_char statements. I have been told that ver 4 fixes this problem. Sorry I couln't be of more help. John Walker. From owner-sqr-users@list.iex.net Mon Jul 6 15:23:59 1998 Date: Mon, 6 Jul 1998 12:51:19 -0700 From: "Walcker, Paul" Subject: Retraction...Oops I finally found the source of my local variables problems. It's funny how those typo's can look so right but be so wrong! Sorry about that...everything is working fine now. From owner-sqr-users@list.iex.net Mon Jul 6 16:34:18 1998 Date: Tue, 7 Jul 1998 09:10:07 +1200 From: Charles Thompson Subject: Re: More: ORA-01013, "user requested cancel of current Have you tried these various suggestions : 1. Set your program to commit at regular intervals, say every 50,000 lines. You may even want to exit SQR and rerun the program again after every 50,000 lines (skipping lines already processed). 2. Check your database engine's use of memory (SGA) -- a DBA should be able to help with this. A trace on the database while your program is executing should be informative. 3. Check the version of Oracle, and have your DBA double-check with Oracle Support on the current version. There may be a patch release that helps your program. 4. This may sound silly, but you should also check for any database constraints, such as tablespace quotas for your user. 5. Simplify your program so that all it does is open the file, read a line, insert into a single table. read the next line, etc. If this works for all your records, try again with a little bit more functionality, and keep going until it crashes again. I had a similar problem a few years ago. I ended up rewriting the program (giving me the chance to improve on it a little), and the problem went away. Good luck - Charles Thompson From owner-sqr-users@list.iex.net Mon Jul 6 19:46:58 1998 Date: Tue, 7 Jul 1998 08:20:37 +0800 From: Wayne Ivory Subject: Re: DOS Copy command I haven=27t tried it, but I suspect your problem comes about because COPY = is an intrinsic command, ie it=27s built in to the command processor and = doesn=27t exist as an actual file like COPY.EXE which the call system = command is probably looking for. I=27m assuming the other commands you = tried that worked do in fact exist as files. So, one way to get around your problem would be to create a GKCOPY.BAT = file that just says COPY %%1 %%2 and call GKCOPY from your SQR. Hope this helps. Wayne Ivory Information Services Westralian Sands Limited >>> =22Kearns, Gary=22 1/7/98 8:11:07 pm >>> Has anyone got the DOS =22Copy=22 command to work using the call system command? I always get a return code of 2. Other DOS commands work but copy doesn=27t seem to work. Any help would be appreciated. Thanks, Gary Gary Kearns HSN PeopleSoft Implementation (813) 572-8585 x5070 kearnsg=40hsn.net From owner-sqr-users@list.iex.net Mon Jul 6 19:53:34 1998 Date: Tue, 7 Jul 1998 08:01:08 +0800 From: Salina Fung Subject: default printer & sqr print OCX > Anyone have problem of using > the SQR print OCX with setting default printer using window > api > > In my script > I first set the default printer by changing the > win95 registry > and then send the window message to the window > letting it knows the default printer is changed > using > window's sendMessage with number 26 > > and then call the OCX's print function, but there is no print > out to the printer, and I cannot print anything > until I reboot the system. > > And then after playing with it for a while, I found > out if I don't do the default printer setup before > calling the OCX's print() function, then the print > works fine. > > Can anybody tells me what should I do, if I need > to set the default printer first in the script > before calling the print() > > thanks > salina > From owner-sqr-users@list.iex.net Mon Jul 6 19:53:57 1998 Date: Mon, 6 Jul 1998 20:35:23 EDT From: Ken Eister Subject: Re: Single select, multiple reports-sorts-headings Darwin, on occasions I've had to do what you need to do (create multiple reports in multiple orders with a single select). I do this by creating a flat file from the the single select .... Let the single select be ordered for one of the 2 reports. While you are generating the 1st report via the select, write to a flat file. At the end of the select (once all the data has been retrieved), sort the flat file in the order of the 2nd report (via a unix sort) and generate the 2nd report. Ken From owner-sqr-users@list.iex.net Mon Jul 6 19:59:38 1998 Date: Tue, 7 Jul 1998 08:44:47 +0800 From: Arthur Coniglio Subject: Re: Using the edit mask for date fields on Oracle Anders... I tried this a while ago. Date EDITing does not work with Oracle with the print statement. Refer to page 263 of SQR manual (we have version 3). The only work around was to use the To_Char function ie. begin-select to_char(Status_Date, 'yyyy-mm-dd hh24:mi:ss') &Print_Date ! or any equivalent format u require print &Print_Date (,27) Cheers Arthur Coniglio Education Departmen of Western Australia > -----Original Message----- > From: Anders Eriksson [SMTP:anders.eriksson@TELE2.SE] > Sent: Tuesday, July 07, 1998 1:12 AM > To: Multiple recipients of list SQR-USERS > Subject: Using the edit mask for date fields on Oracle > > Hello! > > I have a problem. I am tying to convert a large number of reports frm > SQLBase to Oracle > and I can't get the formating of date formats on Oracle to work. I > have the > folowing code: > > begin-select > faildate (,10) edit 'yyyy-mm-dd hh:mi' ! Won't work > statusdate > print &statusdate (,27) edit 'yyyy-mm-dd hh:mi' ! > Will > not work either > .... > > When executing this code on the Oracle database i get the edit string > yyyy-mm-dd hh:mi > insted of the formated date. Since I am going to convert a large > number > of reports I would like to avoid to rewrite every line where dates are > formated to: > > to_char( faildate, {d_DateTimeMask} ) (,10) > to_char( statusdate, {d_DateTimeMask} ) (,27) > > As far as I have understod it should be possible to use the edit > comand for > date fields for Oracle > databases as well. > > I am using: > Windows 95 and NT Clients > SQR 3.0.13.2 for PC/Windows > Oracle 7.3 > > Regards > Anders Eriksson From owner-sqr-users@list.iex.net Mon Jul 6 23:21:39 1998 Date: Tue, 7 Jul 1998 00:06:35 -0400 From: Kenneth Fraser Subject: Re: Single select, multiple reports-sorts-headings Darwin, Wait until I get in. The Real Ken -----Original Message----- From: Ken Eister To: Multiple recipients of list SQR-USERS Date: Monday, July 06, 1998 8:51 PM Subject: Re: Single select, multiple reports-sorts-headings >Darwin, on occasions I've had to do what you need to do (create multiple >reports in multiple orders with a single select). I do this by creating a >flat file from the the single select .... Let the single select be ordered >for one of the 2 reports. While you are generating the 1st report via the >select, write to a flat file. At the end of the select (once all the data has >been retrieved), sort the flat file in the order of the 2nd report (via a unix >sort) and generate the 2nd report. > >Ken From owner-sqr-users@list.iex.net Tue Jul 7 04:07:08 1998 Date: Tue, 7 Jul 1998 10:03:48 +0200 From: Frank Severinsson Subject: SV: Using the edit mask for date fields on Oracle Hi Anders, you have to convert the date in the select statement try this begin-select to_char(faildate,'yyyy-mm-dd hh:mi') (,10) to_char(statusdate,'yyyy-mm-dd hh:mi') print &statusdate (,27) If you are a MAXIMO user you could look at the standard reports. There you could find some useful hints when it comes to converting dates. Frank Severinsson PSDI Norden AB ---------- > Från: Anders Eriksson > Till: Multiple recipients of list SQR-USERS > Ämne: Using the edit mask for date fields on Oracle > Datum: den 6 juli 1998 19:11 > > Hello! > > I have a problem. I am tying to convert a large number of reports frm > SQLBase to Oracle > and I can't get the formating of date formats on Oracle to work. I have the > folowing code: > > begin-select > faildate (,10) edit 'yyyy-mm-dd hh:mi' ! Won't work > statusdate > print &statusdate (,27) edit 'yyyy-mm-dd hh:mi' ! Will > not work either > .... > > When executing this code on the Oracle database i get the edit string > yyyy-mm-dd hh:mi > insted of the formated date. Since I am going to convert a large number > of reports I would like to avoid to rewrite every line where dates are > formated to: > > to_char( faildate, {d_DateTimeMask} ) (,10) > to_char( statusdate, {d_DateTimeMask} ) (,27) > > As far as I have understod it should be possible to use the edit comand for > date fields for Oracle > databases as well. > > I am using: > Windows 95 and NT Clients > SQR 3.0.13.2 for PC/Windows > Oracle 7.3 > > Regards > Anders Eriksson From owner-sqr-users@list.iex.net Tue Jul 7 04:32:13 1998 Date: Tue, 7 Jul 1998 11:06:04 +0100 From: Anders Eriksson Subject: Re: SV: Using the edit mask for date fields on Oracle Tjena Frank! S=E5 du har ocks=E5 uppt=E4ckt den h=E4r diskusionsgruppen. Jag fick en= hint fr=E5n en annan anv=E4ndare att edit av datum kanske fungerar f=F6r SQR4. Tydl= igen skickar ni med SQR4 med MAXIMO4 (enligt Fredrik). Jag har st=E4llt fr=E5= gen till ert Stockholmskontor om vi skulle kunna f=E5 tillg=E5ng till versi= on 4 av SQR innan vi f=E5r version 4 av MAXIMO. Du har h=E4ndelsevis inte tillg=E5ng till version 4 av SQR s=E5 du kan = testa om edit fungerar f=F6r datum f=E4lt under Oracle? Tomas Andersson hos er h= ar nog tillg=E5ng till den annars. Han ska komma in i eftermiddag enligt Kjell= M. H=E4lsningar Anders Eriksson 0707 - 70 65 75 = From owner-sqr-users@list.iex.net Tue Jul 7 07:51:27 1998 Date: Tue, 7 Jul 1998 13:28:39 +0100 From: Duncan Berriman Subject: ORA-01453 SET TRANSACTION ERROR Duncan J Berriman 07/07/98 14:28 Hi, SQR code we've had running for ages has just started failing with ORA-01453 SET TRANSATION must be first statement of transation. The following code reproduces the problem, as you can see the SET TRANSACTION statement is the ONLY statement and therefore the first statement. Putting a ROLLBACK or COMMIT before the do get_rollback stops the error. The only thing I can think that can have caused this is turning on database auditing on the database (AUDIT_TRAIL=TRUE in INIT.ORA and AUDIT SESSION in SQLPLUS). This will be causing a record to be inserted into SYS.AUD$ on logon. This doesn't cause any problem with other products (such as SQL*PLUS). Has anyone come across this before ? Is it a bug/ known feature of SQR and is there a fix ? Removing the SET TRANSATION cures the problem. I am turning off auditing this evening to see if it stops the error occuring. Any info greatly appreciated Thanks Duncan Berriman begin-report do get_rollback end-report begin-procedure get_rollback begin-sql set transaction use rollback segment RBS1 end-sql end-procedure SQR: Structured Query Report Writer V3.0.7.0.2 Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. (SQR 5528) ORACLE OEXEC error -1453 in cursor 1: ORA-01453: SET TRANSACTION must be first statement of transaction Error on line 7: (SQR 3735) Couldn't execute SQL. SQR: Program Aborting. From owner-sqr-users@list.iex.net Tue Jul 7 08:23:44 1998 Date: Tue, 7 Jul 1998 08:38:22 -0500 From: Sujith Nonavinakere Subject: Re: Faxing Purchase Orders in PSoft Hi Jennifer, I setup faxing from PeopleSoft PO but the only package that works with POPO005.SQR is Object Fax and no other faxing software is supported. The problem is mainly due to the fact that SQR is 16-bit. Anyway POPO005.SQR only creates a control file that is compatible with object fax and I can assure you setting up Object Fax is not an easy task. If you need help feel free to call me at (301) 979-3405. Sujith ____________________Reply Separator____________________ Subject: Faxing Purchase Orders in PSoft Author: Date: 7/6/98 10:14 AM Has anyone set up their PeopleSoft Purchasing SQR (POPO005.sqr) to be used with RightFAX (a fax software package)? Any help greatly appreciated... Thanks in advance, Jennifer From owner-sqr-users@list.iex.net Tue Jul 7 08:26:02 1998 Date: Tue, 7 Jul 1998 08:08:03 -0500 From: Ray Ontko Subject: Re: ORA-01453 SET TRANSACTION ERROR Duncan, Consider using -s (statistics) on your little test program. There may be another cursor which gets opened as a result of something else in your program. -S should reveal it. Ray > Duncan J Berriman > 07/07/98 14:28 > > Hi, > > SQR code we've had running for ages has just started failing with > > ORA-01453 SET TRANSATION must be first statement of transation. > > The following code reproduces the problem, as you can see the SET > TRANSACTION statement is the ONLY statement and therefore the first > statement. Putting a ROLLBACK or COMMIT before the do get_rollback stops > the error. > > The only thing I can think that can have caused this is turning on database > auditing on the database (AUDIT_TRAIL=TRUE in INIT.ORA and AUDIT SESSION in > SQLPLUS). This will be causing a record to be inserted into SYS.AUD$ on > logon. > > This doesn't cause any problem with other products (such as SQL*PLUS). Has > anyone come across this before ? Is it a bug/ known feature of SQR and is > there a fix ? Removing the SET TRANSATION cures the problem. > > I am turning off auditing this evening to see if it stops the error > occuring. > > Any info greatly appreciated > Thanks > Duncan Berriman > > begin-report > do get_rollback > end-report > > begin-procedure get_rollback > > begin-sql > set transaction > use rollback segment RBS1 > end-sql > > end-procedure > > SQR: Structured Query Report Writer V3.0.7.0.2 > Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. > > (SQR 5528) ORACLE OEXEC error -1453 in cursor 1: > ORA-01453: SET TRANSACTION must be first statement of transaction > > Error on line 7: > (SQR 3735) Couldn't execute SQL. > > SQR: Program Aborting. > ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Tue Jul 7 08:44:37 1998 Date: Tue, 7 Jul 1998 14:15:39 +0100 From: Duncan Berriman Subject: Re: ORA-01453 SET TRANSACTION ERROR Duncan J Berriman 07/07/98 15:15 The -S qualifier gives the following. Seems there is no other cursor. Still suspecting auditing (weird). Nothing on OCIS or METALINK that I can find thats like this. Cursor Status: Cursor #1: SQL = set transaction use rollback segment BEV7_RS15 Compiles = 1 Executes = 0 Rows = 0 From owner-sqr-users@list.iex.net Tue Jul 7 08:47:52 1998 Date: Tue, 7 Jul 1998 09:27:20 -0400 From: "Eric H. Wilson" Subject: Position Available at SUNY College at Oneonta Hi All, The following position is available at the SUNY College at Oneonta in Upstate New York. Oneonta is a small city located on an interstate highway between Albany and Binghamton, New York, about 3.5 hours travel time to/from NYC. If you might be interested, please respond as soon as possible. Thanks. Eric Wilson ASSISTANT DIRECTOR FOR ADMINISTRATIVE APPLICATIONS The State University of New York College at Oneonta Computer Services department is searching for an Assistant Director to be in charge of administrative applications and user office support. We use the SCT BANNER system which runs on the ORACLE database using the SQL programming language on a DIGITAL VMS platform. We will consider applications from individuals with strong backgrounds in computer applications support, preferably using a relational database in a university environment. Responsibilities include leading a team of Programmer/ Analysts to meet needs as identified by user offices and committees. We are looking for a person with excellent interpersonal, organizational, and communications skills, along with a relevant technical background. Requirements: Bachelors degree; five years experience in administrative computer applications work. To apply: Send letter of application, resume, names, addresses and telephone numbers of three references to: Employment Opportunities, Box I, 208 Netzer Administration Building, SUNY Oneonta, Oneonta, NY 13820. The review of applications will begin immediately and continue until the position is filled. SUNY Oneonta is an Affirmative Action, Equal Opportunity Employer. From owner-sqr-users@list.iex.net Tue Jul 7 09:42:30 1998 Date: Tue, 7 Jul 1998 15:15:27 +0100 From: Duncan Berriman Subject: Re: ORA-01453 SET TRANSACTION ERROR Duncan J Berriman 07/07/98 16:15 As you can see there are no other statements in my bit of test code. The WHOLE procedure is as follows. Weird ? Thanks Duncan begin-report do get_rollback end-report begin-procedure get_rollback begin-sql set transaction use rollback segment RBS1 end-sql end-procedure From owner-sqr-users@list.iex.net Tue Jul 7 10:25:31 1998 Date: Tue, 7 Jul 1998 10:04:44 -0500 From: "Daniel F. Dugal" Subject: Re: ORA-01453 SET TRANSACTION ERROR I might be way off-base here, but shouldn't there be a begin-program / end-program paragraph with 'do get_rollback' there instead of begin/end-report? > ---------- > From: Duncan Berriman[SMTP:Duncan.J.Berriman@ITSERVICES.CO.UK] > Reply To: SQR-USERS@USA.NET > Sent: Tuesday, July 07, 1998 9:15 AM > To: Multiple recipients of list SQR-USERS > Subject: Re: ORA-01453 SET TRANSACTION ERROR > > Duncan J Berriman > 07/07/98 16:15 > > > As you can see there are no other statements in my bit of test code. > The WHOLE procedure is as follows. Weird ? > Thanks > Duncan > > begin-report > do get_rollback > end-report > > begin-procedure get_rollback > > begin-sql > set transaction > use rollback segment RBS1 > end-sql > > end-procedure > From owner-sqr-users@list.iex.net Tue Jul 7 12:09:58 1998 Date: Tue, 7 Jul 1998 12:39:23 -0400 From: Jennifer Sieber Subject: Re: Faxing Purchase Orders in PSoft Hi Sujith, Thanks for the reply. What fax software did you look at? I know all the peoplesoft side that I need to customize to work with RighFAX, my question resides on making RightFax recognize the .LIS file. All help appreciated, Jennifer sujith_nonavinakere@MANORCARE.COM on 07/07/98 09:38:22 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Jennifer A. Sieber/Westfield Companies) Subject: Re: Faxing Purchase Orders in PSoft Hi Jennifer, I setup faxing from PeopleSoft PO but the only package that works with POPO005.SQR is Object Fax and no other faxing software is supported. The problem is mainly due to the fact that SQR is 16-bit. Anyway POPO005.SQR only creates a control file that is compatible with object fax and I can assure you setting up Object Fax is not an easy task. If you need help feel free to call me at (301) 979-3405. Sujith ____________________Reply Separator____________________ Subject: Faxing Purchase Orders in PSoft Author: Date: 7/6/98 10:14 AM Has anyone set up their PeopleSoft Purchasing SQR (POPO005.sqr) to be used with RightFAX (a fax software package)? Any help greatly appreciated... Thanks in advance, Jennifer From owner-sqr-users@list.iex.net Tue Jul 7 12:17:14 1998 Date: Tue, 7 Jul 1998 09:36:00 -0400 From: Richard Mitchell Subject: Re[2]: ORA-01453 SET TRANSACTION ERROR --UNS_gsauns2_2902817281 Content-Type: text/plain; charset="us-ascii" Content-Disposition: inline Sometimes, when the SQR is not working right, I can find out what gets 'added' or not by putting an extra character just before the 'END-SELECT'. I use an 'X' just so I can find what I added. Instead of getting the expected error, I get an SQL error with all substitution showing. Happy hunting, Rick ______________________________ Reply Separator _________________________________ Subject: Re: ORA-01453 SET TRANSACTION ERROR Author: "duncan berriman" at internet Date: 7/7/98 3:15 PM Duncan J Berriman 07/07/98 16:15 As you can see there are no other statements in my bit of test code. The WHOLE procedure is as follows. Weird ? Thanks Duncan begin-report do get_rollback end-report begin-procedure get_rollback begin-sql set transaction use rollback segment RBS1 end-sql end-procedure --UNS_gsauns2_2902817281-- From owner-sqr-users@list.iex.net Tue Jul 7 13:36:12 1998 Date: Tue, 7 Jul 1998 09:55:20 -0400 From: Paul Cruz Subject: Re: ORA-01453 SET TRANSACTION ERROR Hi Duncan. The SET TRANSACTION command should be the first statement executed RIGHT AFTER connecting to the database. Have you check the sequence of all your SQL calls making sure that no other statement were issued before the "SET TRANSACTION..." statement? -----Original Message----- From: Duncan Berriman To: Multiple recipients of list SQR-USERS Date: Tuesday, July 07, 1998 8:38 AM Subject: ORA-01453 SET TRANSACTION ERROR >Duncan J Berriman >07/07/98 14:28 > >Hi, > >SQR code we've had running for ages has just started failing with > >ORA-01453 SET TRANSATION must be first statement of transation. > >The following code reproduces the problem, as you can see the SET >TRANSACTION statement is the ONLY statement and therefore the first >statement. Putting a ROLLBACK or COMMIT before the do get_rollback stops >the error. > >The only thing I can think that can have caused this is turning on database >auditing on the database (AUDIT_TRAIL=TRUE in INIT.ORA and AUDIT SESSION in >SQLPLUS). This will be causing a record to be inserted into SYS.AUD$ on >logon. > >This doesn't cause any problem with other products (such as SQL*PLUS). Has >anyone come across this before ? Is it a bug/ known feature of SQR and is >there a fix ? Removing the SET TRANSATION cures the problem. > >I am turning off auditing this evening to see if it stops the error >occuring. > >Any info greatly appreciated >Thanks >Duncan Berriman > >begin-report > do get_rollback >end-report > >begin-procedure get_rollback > >begin-sql >set transaction >use rollback segment RBS1 >end-sql > >end-procedure > >SQR: Structured Query Report Writer V3.0.7.0.2 >Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. > >(SQR 5528) ORACLE OEXEC error -1453 in cursor 1: > ORA-01453: SET TRANSACTION must be first statement of transaction > >Error on line 7: > (SQR 3735) Couldn't execute SQL. > >SQR: Program Aborting. From owner-sqr-users@list.iex.net Tue Jul 7 16:58:47 1998 Date: Tue, 7 Jul 1998 15:57:10 -0500 From: Jimmy Liao Subject: Re: Database Hi, Does anyone know whether if it is possible for the SQR program to be located in one database and yet retrieve data from another database within the same server? If so, how can it be accomplished? Thanks in advance! Jimmy Liao From owner-sqr-users@list.iex.net Tue Jul 7 17:44:33 1998 Date: Tue, 7 Jul 1998 15:20:59 PDT From: Parijat Sahai Subject: ODBC error 'Function Sequence Error' in SQR Hi, I'm using SQR v3.0 in PeopleSoft v6 with MS SQLServer as the back-end. Every now and then, I get the ODBC error '[Microsoft][ODBC SQL Server Driver]Function sequence error'. It stays for a long time and then stops appearing all of a sudden (I'm not aware of any activity at the database end by DBA or anybody, for that matter). This error comes in begin-select statements or during begin-sql (UPDATE) statement. Can anyone diagnose the problem and/or suggest a possible solution? Parijat ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jul 7 18:36:08 1998 Date: Tue, 7 Jul 1998 17:48:08 -0500 From: Jim_Anderson Subject: Re: Database Jimmy Liao wrote >Does anyone know whether if it is possible for the SQR program to be >located in one >database and yet retrieve data from another database within the same >server? If so, >how can it be accomplished? Snip---> Actually, SQR programs are not located IN a database. In the Oracle world sometimes PeopleSoft refers to multiple schemas in tha same database instance as multiple databases. If this is what you are talking about then you can simply prefix the table names with the proper schema as below: Where sysadm is the owner of one schema and sysadm2 owns the other. select xxxx,yyyyy from sysdadm.ps_job a, sysadm2.ps_job where some condition etc; If you are actually talking about selecting data from two distinct instances then you will need to do have your dba create a database link. Then your query would look something like: Where the two instances are HDMO and HRTEST. select xxxx,yyyyy from sysadm.ps_job@HDMO a, sysadm.ps_job@HRTEST b where some condition...etc; Hope this helps. Of course there are some gotchas left. Jim Anderson Oracle/PeopleSoft DBA From owner-sqr-users@list.iex.net Tue Jul 7 18:58:35 1998 Date: Tue, 7 Jul 1998 15:37:03 -0700 From: Michael Lee Subject: Re: Database What database environment are you on? It is possible to access multiple databases. In DB2, you can prefix the table name with the DB owner. As long as you have access to both DBs, you should be fine. One thing is that the DB owner IDs have to exist on the same subsystem. Michael K. Lee mlee@agconsult.com Consultant AG Consulting, an ADP Company chien-wei.j.liao@AC.COM on 07/07/98 01:57:10 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Re: Database Hi, Does anyone know whether if it is possible for the SQR program to be located in one database and yet retrieve data from another database within the same server? If so, how can it be accomplished? Thanks in advance! Jimmy Liao From owner-sqr-users@list.iex.net Tue Jul 7 18:59:35 1998 Date: Tue, 7 Jul 1998 15:38:44 +0200 From: Jean-Luc Peyret Subject: Re: ODBC error 'Function Sequence Error' in SQR Hi. This is from a an earlier exchange I had with someone else on this subject (who was creating temp tables). Check what could be triggering a COMMIT of some kind. JLuc >>>> Hi, I've seen this error before, in an Application Engine. Error code S1010. Cause: when you COMMIT you close all opened cursors. In other words: 1. you select 2. you COMMIT => implicit close of your cursors 3. you fetch - no more open cursor => your error. Now, I think a DDL command (Data Definition Language - like Create Table, View, etc...) issues an implicit COMMIT on most databases, hence your error because SQR typically keeps lots of cursors open. Solutions: In SQR, I believe you are advised to do most of that CREATE xxx stuff in the begin-setup section of the program. There maybe a switch to set your server to a different state where it doesn't close cursors. You might avoid this if you don't have any begin-select processing loops open when you create your temp table. Meaning that you process all your current begin-selects (including loops which are calling from a higher level, if any). JLuc From owner-sqr-users@list.iex.net Tue Jul 7 21:59:32 1998 Date: Tue, 7 Jul 1998 20:54:03 -0500 From: Don Mellen Subject: Re: Using the edit mask for date fields on Oracle You might want to check out the oracle "set-nls-date-format" command (I dont have the books here with me at the moment). You can call this in a BEGIN-SQL section in an include file and simply include that file in all your programs ( and can #ifdef sections for each database type if you want to get fancy). This command alters the default format that oracle will return dates in and will also affect any string date comparisons. HTH, Don On Mon, 6 Jul 1998, Anders Eriksson wrote: > Hello! > > I have a problem. I am tying to convert a large number of reports frm > SQLBase to Oracle > and I can't get the formating of date formats on Oracle to work. I have the > folowing code: > > begin-select > faildate (,10) edit 'yyyy-mm-dd hh:mi' ! Won't work > statusdate > print &statusdate (,27) edit 'yyyy-mm-dd hh:mi' ! Will > not work either > .... > > When executing this code on the Oracle database i get the edit string > yyyy-mm-dd hh:mi > insted of the formated date. Since I am going to convert a large number > of reports I would like to avoid to rewrite every line where dates are > formated to: > > to_char( faildate, {d_DateTimeMask} ) (,10) > to_char( statusdate, {d_DateTimeMask} ) (,27) > > As far as I have understod it should be possible to use the edit comand for > date fields for Oracle > databases as well. > > I am using: > Windows 95 and NT Clients > SQR 3.0.13.2 for PC/Windows > Oracle 7.3 > > Regards > Anders Eriksson > ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Wed Jul 8 02:07:42 1998 Date: Wed, 8 Jul 1998 16:48:36 +1000 From: Dean Morris Subject: Re: Faxing Purchase Orders in PSoft Jennifer, I have successfully altered the standard sqr to support the MSXFAX Fax server. This program sends out faxes using Microsoft Outlook as the facilitating agent. That is, to send a fax, you send an e-mail to the fax server's email address, which then processes the fax and sends it off. The task was not easy and involved a high level of customisation of POPO005.sqr. It does work though and works well. The way we did this was to generate each page of the Purchase Order as an image file, which the fax server was then able to process and send. We did this using the Ghostscript program. Once all the files were generated, we then sent them out using a custom written C++ mail program. All good stuff! If you want any more details, let me know. Dean. Dean Morris PricewaterhouseCoopers e-mail: Dean.Morris@au.pwcglobal.com Subject: Faxing Purchase Orders in PSoft Author: Date: 7/6/98 10:14 AM Has anyone set up their PeopleSoft Purchasing SQR (POPO005.sqr) to be used with RightFAX (a fax software package)? Any help greatly appreciated... Thanks in advance, Jennifer From owner-sqr-users@list.iex.net Wed Jul 8 03:12:45 1998 Date: Wed, 8 Jul 1998 09:50:15 +0200 From: Makhari T Subject: ENCODE - Table List Hi All , We are loking for the ENCODE table list , we only know of certain codes like '<27>L11233' listed in the SQR 3 manual , for setting the printer to boldface. We needed to use other codes but we do not know where to get them. Any one who has such a table or information on where to get one ?? Thanking you in advance. Tshenuwani Makhari Systems Analyst - ISCOR - Newcastle Tel : +27 03431 - 48138 or 81917 E-Mail : makharit@dp.new.iscorltd.co.za From owner-sqr-users@list.iex.net Wed Jul 8 04:00:50 1998 Date: Wed, 8 Jul 1998 04:10:12 -0400 From: Peter Alan Burton Subject: Re: ENCODE - Table List Tshenuwani, There is no fixed ENCODE table list. The ENCODE command allows the user to create a string variable which contains non-editable characters. Some of the uses is the ability to create printer directives (i.e. BOLD ON). Peter On 8 Jul 98, at 9:50, Makhari T wrote: Priority: normal Date sent: Wed, 8 Jul 1998 09:50:15 +0200 Send reply to: SQR-USERS@USA.NET From: Makhari T Organization: Iscor Profile Product Subject: ENCODE - Table List Originally to: SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS > Hi All , > > We are loking for the ENCODE table list , we only know of certain > codes like '<27>L11233' listed in the SQR 3 manual , for setting the > printer to boldface. > > We needed to use other codes but we do not know where to get them. > Any one who has such a table or information on where to get one ?? > > Thanking you in advance. > > Tshenuwani Makhari > Systems Analyst - ISCOR - Newcastle > Tel : +27 03431 - 48138 or 81917 > E-Mail : makharit@dp.new.iscorltd.co.za > From owner-sqr-users@list.iex.net Wed Jul 8 06:42:20 1998 Date: Wed, 8 Jul 1998 06:16:21 -0500 From: Ray Ontko Subject: Re: ENCODE - Table List Makhari, > We are loking for the ENCODE table list , we only know of certain > codes like '<27>L11233' listed in the SQR 3 manual , for setting the > printer to boldface. > > We needed to use other codes but we do not know where to get them. > Any one who has such a table or information on where to get one ?? The codes vary from printer to printer, but most printers made by a single manufacturer often share the same codes. In most cases the printer escape codes are documented in the manuals that come with the printer. If you're looking for help in using an HP printer, take a look at: http://www.ontko.com/sqr/hp.html We have a collection of routines that do things for HP printers. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jul 8 08:47:41 1998 Date: Tue, 7 Jul 1998 15:43:00 -0500 From: "Derry, Denny" Subject: Re: ORA-01453 SET TRANSACTION ERROR Try using the -xp option in your begin-sql statement. Without this SQR creates procedures on the server for your query. i.e. begin-sql -xp set transaction rest of code end-sql Just a guess. -Denny ______________________________ Reply Separator _________________________________ Subject: Re: ORA-01453 SET TRANSACTION ERROR Author: Duncan Berriman [SMTP:Duncan.J.Berriman@ITSERVICES.CO.UK] at NMB Date: 7/7/98 9:15 AM Duncan J Berriman 07/07/98 16:15 As you can see there are no other statements in my bit of test code. The WHOLE procedure is as follows. Weird ? Thanks Duncan begin-report do get_rollback end-report begin-procedure get_rollback begin-sql set transaction use rollback segment RBS1 end-sql end-procedure From owner-sqr-users@list.iex.net Wed Jul 8 08:53:53 1998 Date: Wed, 8 Jul 1998 08:42:25 -0500 From: Ray Ontko Subject: Re: Database Jimmy, > Does anyone know whether if it is possible for the SQR program to be > located in one > database and yet retrieve data from another database within the same > server? If so, > how can it be accomplished? If you're using Sybase, use the USE command of SQR. Or, prefix the tablename with "database.." as in begin-select ... from database..tablename ... end-select Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Jul 8 09:52:13 1998 Date: Wed, 8 Jul 1998 08:18:50 -0500 From: Wes Williams Subject: Using the edit mask for date fields on Oracle -Reply sqr: #if {sqr-database}=ORACLE #include 'nls.h' #endif .. .. .. .. .. #if {sqr-database}=ORACLE to_char(targstartdate,'dd-Mon-yy') &targstartdate to_char(targcompdate,'dd-Mon-yy') &targcompdate to_char(schedstart,'dd-Mon-yy') &schedstart to_char(schedfinish,'dd-Mon-yy') &schedfin to_char(faildate,'dd-Mon-yy') &faildate #endif file nls.h: begin-procedure set_nls_date_format begin-sql alter session set nls_date_format = 'YYYY-MM-DD-HH24-MI.SS' end-sql commit end-procedure Hope this helps Wes Williams >>> Anders Eriksson 07/06/98 12:11pm >>> Hello! I have a problem. I am tying to convert a large number of reports frm SQLBase to Oracle and I can't get the formating of date formats on Oracle to work. I have the folowing code: begin-select faildate (,10) edit 'yyyy-mm-dd hh:mi' ! Won't work statusdate print &statusdate (,27) edit 'yyyy-mm-dd hh:mi' ! Will not work either ..... When executing this code on the Oracle database i get the edit string yyyy-mm-dd hh:mi insted of the formated date. Since I am going to convert a large number of reports I would like to avoid to rewrite every line where dates are formated to: to_char( faildate, {d_DateTimeMask} ) (,10) to_char( statusdate, {d_DateTimeMask} ) (,27) As far as I have understod it should be possible to use the edit comand for date fields for Oracle databases as well. I am using: Windows 95 and NT Clients SQR 3.0.13.2 for PC/Windows Oracle 7.3 Regards Anders Eriksson From owner-sqr-users@list.iex.net Wed Jul 8 10:10:31 1998 Date: Wed, 8 Jul 1998 09:45:00 -0500 From: Veso Lukovic Subject: SQL Talk and Oracle. I have been told that SQL Talk cannot be used on Oracle, is this correct? I used to work at a DB2/Mainframe shop, and I was able to use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jul 8 10:21:01 1998 Date: Wed, 8 Jul 1998 07:31:32 -0700 From: "Walcker, Paul" Subject: Re: ODBC error 'Function Sequence Error' in SQR You may want to pick up a tool from Microsoft call ODBC Spy 32 (ODBCSP32.EXE). This tool allows you to capture all of the ODBC API calls issued against a specific data source. With this tool you should be able to determine exactly where your error messages are being generated, then move backwards to determine which API statement started the problem. I haven't found a place to download it from, but I know it is shipped with some versions of Visual Basic 5.0 (like the Enterprise Edition). Quite a handy tool to have on around! Paul >-----Original Message----- >From: Parijat Sahai [SMTP:parijatsahai@HOTMAIL.COM] >Sent: Tuesday, July 07, 1998 3:21 PM >To: Multiple recipients of list SQR-USERS >Subject: ODBC error 'Function Sequence Error' in SQR > >Hi, > >I'm using SQR v3.0 in PeopleSoft v6 with MS SQLServer as the back-end. >Every now and then, I get the ODBC error '[Microsoft][ODBC SQL Server >Driver]Function sequence error'. It stays for a long time and then stops >appearing all of a sudden (I'm not aware of any activity at the database >end by DBA or anybody, for that matter). This error comes in >begin-select statements or during begin-sql (UPDATE) statement. > >Can anyone diagnose the problem and/or suggest a possible solution? > >Parijat > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 8 10:42:51 1998 Date: Wed, 8 Jul 1998 08:19:42 -0700 From: Michael Lee Subject: Re: SQL Talk and Oracle. >From my experience, SQLTalk can be used with both SQLBase and DB2. You may be able to find out some information about this at http://www.centurasoft.com or at info_usa@centurasoft.com. Oracle has their own front-end app called SQLPlus (SQL+). It is similar to SQLTalk. Michael K. Lee mlee@agconsult.com Consultant AG Consulting VESO_LUKOVIC@CONSECO.COM on 07/08/98 07:45:00 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: SQL Talk and Oracle. I have been told that SQL Talk cannot be used on Oracle, is this correct? I used to work at a DB2/Mainframe shop, and I was able to use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jul 8 11:26:18 1998 Date: Wed, 8 Jul 1998 11:04:27 -0500 From: "Hood, Paul" Subject: ORA-01013 ORACLE Patch There was some discussion earlier this week regarding the ORA-01013 error. Does anyone know the patch number or title for the ORA-01013 error for Oracle 7.2. Our DBA won't do anything until I get more information on the bug. Thanks Paul Tri-Com Tech From owner-sqr-users@list.iex.net Wed Jul 8 11:45:52 1998 Date: Wed, 8 Jul 1998 11:47:23 -0400 From: Art DiRamio Subject: Re: SQL Talk and Oracle. Veso - We use SQL Talk against Oracle here, and have been for quite some time without incident. It's not my first choice of SQL tools, but different strokes. . . > -----Original Message----- > From: Veso Lukovic [SMTP:VESO_LUKOVIC@CONSECO.COM] > Sent: Wednesday, July 08, 1998 10:45 AM > To: Multiple recipients of list SQR-USERS > Subject: SQL Talk and Oracle. > > I have been told that SQL Talk cannot be used on Oracle, is this > correct? I used to work at a DB2/Mainframe shop, and I was able > to > > use SQL Talk there. Is SQL Talk now only compatible with > SQLBASE? > > Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jul 8 12:54:38 1998 Date: Wed, 8 Jul 1998 10:30:06 -0600 From: "Duckworth, Jerry" Subject: Re: SQL Talk and Oracle. I haven't tried it yet, but I was in a code class a couple of weeks ago = and was told the SQL Talk would work with Oracle. Sorry I can't tell you = = that it works from experience. ---------- From: SQR-USERS=5BSMTP:SQR-USERS=40USA.NET=5D Sent: Wednesday, July 08, 1998 9:45 AM To: Multiple recipients of list SQR Subject: SQL Talk and Oracle. Subject: SQL Talk and Oracle. To: Multiple recipients of list SQR-USERS I have been told that SQL Talk cannot be used on Oracle, is this correct? I used to work at a DB2/Mainframe shop, and I was able to use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jul 8 13:47:10 1998 Date: Wed, 8 Jul 1998 14:24:10 -0400 From: "Mosley, Banessa" Subject: Re: Database I believe that you can also use a database link in the SQR program to access multiple databases....at least I know you can to that in Oracle. Your DBA will create the link and you can access the database using the link. The statement would look something like this: begin-SELECT VCHR.VOUCHER_ID VCHR.INVOICE_ID FROM PS_VOUCHER@FDEV (FDEV - the database link name) end-SELECT I hope this helps. Banessa Mosley Business Information Technology > -----Original Message----- > From: Michael Lee [SMTP:MLee@AGCONSULT.COM] > Sent: Tuesday, July 07, 1998 6:37 PM > To: Multiple recipients of list SQR-USERS > Subject: Re: Database > > What database environment are you on? It is possible to access > multiple > databases. In DB2, you can prefix the table name with the DB owner. > As > long as you have access to both DBs, you should be fine. One thing is > that > the DB owner IDs have to exist on the same subsystem. > > > Michael K. Lee > mlee@agconsult.com > Consultant > AG Consulting, an ADP Company > > > > > > chien-wei.j.liao@AC.COM on 07/07/98 01:57:10 PM > > Please respond to SQR-USERS@USA.NET > > To: SQR-USERS@list.iex.net > cc: (bcc: Michael Lee/Application Group) > Subject: Re: Database > > > > > Hi, > Does anyone know whether if it is possible for the SQR program to be > located in one > database and yet retrieve data from another database within the same > server? If so, > how can it be accomplished? > > Thanks in advance! > Jimmy Liao From owner-sqr-users@list.iex.net Wed Jul 8 14:21:56 1998 Date: Wed, 8 Jul 1998 15:02:49 -0400 From: "Parenteau, Brian P." Subject: nVision for Peoplesoft Hi All, I know this list is mostly for technical info on SQR's, but I'm assuming that a lot of you have experience with Peoplesoft. So my question is....has anyone had any experience with PS/nVision...or know where I can get some information about it? We are having serious performance issues trying to run a report against a large amount of data. Any help would be greatly appreciated. Thanks Brian From owner-sqr-users@list.iex.net Wed Jul 8 14:37:55 1998 Date: Wed, 8 Jul 1998 13:03:36 -0600 From: Robert Goshko Subject: Re: SQL Talk and Oracle. ------ =_NextPart_000_01BDAA70.F4A36550 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable SQLTalk should work with Oracle, I haven't tried it personally. There = is actually a shareware package called Golden Retriever = (http://www.tiac.net/users/markford/) which is similar to SQLTalk, but = built for Oracle. The latest beta allows connections to multiple = databases within different windows. ......Rob -------------------------------------------------------------------------= --- Robert Goshko | Axis Developments | System Consulting = Services robert.goshko@axis-dev.com | Sherwood Park, AB | = http://www.axis-dev.com -----Original Message----- From: Veso Lukovic [SMTP:VESO_LUKOVIC@CONSECO.COM] Sent: Wednesday, July 08, 1998 8:45 AM To: Multiple recipients of list SQR-USERS Subject: SQL Talk and Oracle. I have been told that SQL Talk cannot be used on Oracle, is this correct? I used to work at a DB2/Mainframe shop, and I was able to use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? Thanks in Advance. ------ =_NextPart_000_01BDAA70.F4A36550 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IiMTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAkAEAAAEAAAAQAAAAAwAAMAIAAAAL AA8OAAAAAAIB/w8BAAAAQQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFNRUi1VU0VSU0BVU0Eu TkVUAFNNVFAAU1FSLVVTRVJTQFVTQS5ORVQAAAAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAA ABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAMAFQwBAAAAAwD+DwYAAAAeAAEwAQAAABQAAAAnU1FS LVVTRVJTQFVTQS5ORVQnAAIBCzABAAAAFwAAAFNNVFA6U1FSLVVTRVJTQFVTQS5ORVQAAAMAADkA AAAACwBAOgEAAAAeAPZfAQAAABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAIB918BAAAAQQAAAAAA AACBKx+kvqMQGZ1uAN0BD1QCAAAAAFNRUi1VU0VSU0BVU0EuTkVUAFNNVFAAU1FSLVVTRVJTQFVT QS5ORVQAAAAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALhQwEEgAEAGQAAAFJFOiBT UUwgVGFsayBhbmQgT3JhY2xlLgCEBwEFgAMADgAAAM4HBwAIAA0AAwAkAAMAGwEBIIADAA4AAADO BwcACAAMADsANQADAGMBAQmAAQAhAAAANjkzOTQ3MTE1RjE2RDIxMTg1NDUwMDYwOTczN0E1RTAA wwYBA5AGABwHAAAhAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMA NgAAAAAAQAA5ABDZJByjqr0BHgBwAAEAAAAZAAAAUkU6IFNRTCBUYWxrIGFuZCBPcmFjbGUuAAAA AAIBcQABAAAAFgAAAAG9qqMcDRFHOWoWXxHShUUAYJc3peAAAB4AHgwBAAAABQAAAFNNVFAAAAAA HgAfDAEAAAAbAAAAcm9iZXJ0Lmdvc2hrb0BheGlzLWRldi5jb20AAAMABhCyibwaAwAHEAcDAAAe AAgQAQAAAGUAAABTUUxUQUxLU0hPVUxEV09SS1dJVEhPUkFDTEUsSUhBVkVOVFRSSUVESVRQRVJT T05BTExZVEhFUkVJU0FDVFVBTExZQVNIQVJFV0FSRVBBQ0tBR0VDQUxMRURHT0xERU5SRVRSAAAA AAIBCRABAAAA9QMAAPEDAADvBQAATFpGdbPqUvIDAAoAcmNwZzEyNRYyAPgLYG4OEDAzM50B9yAC pAPjAgBjaArA4HNldDAgBxMCgwBQ4wLyENlUYWgDcQKDDlBfBFUQ2QhVB7ICgzMQZ3BocnEyEXZ9 CoAIyCA2OwlvDjA1AoAKgXVjOwBQCwNjEhILxAYAUUwhEzBsayBzE1B1bDhkIHcFsBuwA/B0aAgg T3IA0GxlLCBUSSARAHYJ8CcFQHSnCIEcIBygIHAEkHMCIKEHQGx5LiATIGgEkM5lHlAEIADQdHUe 8h/gPxvBCsAH0CDBHoAA0Gth2mcfoGMe8R4xRwbwAQC9A6BSEUAIgR2gBcAoDGAFAyBoAkBwOi8v d4kkAC50BzBjLm4RQOwvdREwESAvAMAcYAIQrQsgLyNREWApHDBoDeA3HMAfwQCQbQMQCsF0b/Mb Rh1AYnUFQCgAAxAFQNclcRzVHzQgC2B0B5AoIWcRQCCAHvFvdwQgBaBuuySQIABpAiAEICdBbRwA tyRAC1AfoGQpwAGgYREw3wQgHJILgCxQBpBmH4ECMOkcgW5kKqEuCqIKhAqEBxpyAtESIXMxNyAu nzByCAAMMC6qE9AgLTH//zMPNB81LzWlLpQfQDcSMMFvBJAFQCIwG9BrJ1A4RXy1EXB4H8FEIvEJ AHAHgJ8CMAQgOMAGsCnwZW0VEe8AgCviDyAGUnYN4AeQLpSTA2A3ki5nN/NAYTjx8i0BAHYuBaA6 cDoBH3EzHEAEcCBQJUEdQEFC/zixAzAakiNsPQovoyXRL+UONi76FhEvCWxpMzZ7AUAWwG8p0CAA MeQc4GneZwuAB0AF0AeQcyGBNmkfRCZEEQsTREQCAGktMYw0NAFAQ9AxODABQKMM0EhTYiBGA2E6 DIOaYhFgVgeQJ1BMdTggATtxIFtTTVRQOgBWRVNPX0xVSwBPVklDQENPTpRTRUxwLkxwTV0ulW9J gAZgAjBJ51cJgCSQczUsYHkdQEocACBgMDgBHUAxOTk4IDg6lDQ1EXBNTTdUb0nndk0r5glwYwUg CJA5wm8eZimgBAAFQBtQUi1ViUygUlNNOHViaish/0nnG1ETIRuhAHAcICjlRl//R2pD1Au2Nsgd ZCoRInEnQP8cERywKcBVqCHAKwBEUCoR/iAk0RwgAiAc1x/BLSE7tec3EwWhUmF0P1oiXNMnQQcc Q1txIIBEQjIvTdsLcQNQYQeAG8JwHUBWQv8dYCDwH9ECYB+gJ0AumjcT3yTRVagcsB+BHzFJBkFV xv9cYAfgAiAgUT2RCrAkQGLC0xyTG1FCQUygP2MvH2CNAHBrBCAtQUFkdgBwLzuQLo8KgBeBAGvg AAAAAwAQEAAAAAADABEQAQAAAAMAgBD/////QAAHMOAROJeiqr0BQAAIMOAROJeiqr0BCwAAgAgg BgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADADqACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0A AB4AO4AIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguMAADADyACCAGAAAAAADAAAAA AAAARgAAAAABhQAAAAAAAAsARYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwBGgAggBgAA AAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAEeACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMA SoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgBagAggBgAAAAAAwAAAAAAAAEYAAAAANoUA AAEAAAABAAAAAAAAAB4AW4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAFyA CCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAAD AA00/TcAAI+o ------ =_NextPart_000_01BDAA70.F4A36550-- From owner-sqr-users@list.iex.net Wed Jul 8 14:42:10 1998 Date: Wed, 8 Jul 1998 14:21:02 -0500 From: Wes Williams Subject: SQL Talk and Oracle. -Reply I just talked to a buddy who is using SQL Talk and Oracle. Wes >>> Veso Lukovic 07/08/98 09:45am >>> I have been told that SQL Talk cannot be used on Oracle, is this correct? I used to work at a DB2/Mainframe shop, and I was able to use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? Thanks in Advance. From owner-sqr-users@list.iex.net Wed Jul 8 14:46:14 1998 Date: Wed, 8 Jul 1998 14:22:35 -0500 From: Krishnan Sarangarajan Subject: Re: SQLTalk & Oracle This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BDAAA5.C6CBCC14 Content-Type: text/plain Hello! In regards to using SQLTalk and Oracle, it is certainly feasible. We have Maximo [PSDI product] that we are running on Oracle and SQLTalk is currently the standard in that environment. I have used SQLTalk on Oracle, a couple of times but do not know if an Oracle database can be accessed using both SQLTalk as well as SQL+ from the same workstation. Krishnan Sarangarajan ksaranga@ruan.com Suite 400, 2 Ruan Center 601 Locust Street Des Moines, IA [O] (515) 245-5655 [F] (515) 247-2065 ------ =_NextPart_000_01BDAAA5.C6CBCC14 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IisTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzgcHAAgADgAWACMAAwAuAQEggAMADgAAAM4HBwAI AA4AFgApAAMANAEBCYABACEAAAA0MjI0N0E2NDcxMTZEMjExOTRCMDAwMDhDNzI0ODJCRQDNBgEE gAEAFQAAAFJlOiBTUUxUYWxrICYgT3JhY2xlAEkGAQ2ABAACAAAAAgACAAEDkAYADAYAACAAAAAC AQkQAQAAAGICAABeAgAAgQMAAExaRnVo+dhX/wAKAQ8CFQKkA+QF6wKDAFATA1QCAGNoCsBzZXQu MgYABsMCgzIPemhlomwDIERsZwKDMxMPRRQWNBEncHJxEiBGgG9vdGxpZ2gFQLBNVCBMF3ICgH0K gIsIzwnZOxk/MjU1AoAHCoENsQtgbmcxMDNvFJALChYxC/A4GKAAQCDCSBPRbyEgSQOgGUCGZwsR BCB0byB1AJAjHEAGAFFMVAdAayAhAHBkIE9yANBsZZgsIGkFQAQAIGMEkAMBkAuAbHkgZmVhAwCQ AmBlLiBXZSDFEcB2IsBNYXgHcB9QwFtQU0RJIBbQBHBwdWN0XR8wEcAFQHfHIsAKwCLAcnVuAwAf of8CICCFIEMf1iFCCHAZQAIw9yHhJJAiwHMBkCBgCxEhAKcDoCSTCfB2aQNgbgeA/wIwIpAKhQqF I+Ai4x9wCYD3H8cl1yDwYSFgCGALUCLATG9mHzAHc2J1BUBk5R9QbhdAIGsugAfgBpC/IEEl9iiA AZEiMCLAYwOR+mIk8WMhcAQQK5EfdAbgfySQH8gEICTgE+EyoR/RK3ciAANhJ/RhB4Ak0AWwa3co QS2wAiAuKiwqLAr0cRMA4B0PIEsFEHNobt8DkQYQIKAcQDlRagBwCoVbNLA5VEAlUABwLgWgbRkK hVN1IRAiwDQwMMsg8BIgUjsRIEMnoQSQyQqFNjAeAExvJ2AoQFUGAHQJ0XQKhUQHkU1ObwuAB5Ag 8ElBCoVbgk8kcCg1MTUpPJBgNDUtNTYbgEBGRnlA2DctAdBBoAtGFJIxFjcqFhhhAEUAAAAeAHAA AQAAABUAAABSZTogU1FMVGFsayAmIE9yYWNsZQAAAAACAXEAAQAAABYAAAABvaql3acCFz1lFbMR 0pfqAGCXcnJqAABAADkAADVXw6WqvQEDAPE/CQQAAB4AMUABAAAACQAAAEtTQVJBTkdBAAAAAAMA GkAAAAAAHgAwQAEAAAAJAAAAS1NBUkFOR0EAAAAAAwAZQAAAAAADAP0/5AQAAAMAJgAAAAAAAwA2 AAAAAAACAUcAAQAAAC8AAABjPVVTO2E9IDtwPVJ1YW47bD1FWENIQU5HRS05ODA3MDgxOTIyMzVa LTMwOTU0AAACAfk/AQAAAEsAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089UlVBTi9P VT1DT1JQT1JBVEUvQ049UkVDSVBJRU5UUy9DTj1LU0FSQU5HQQAAHgD4PwEAAAAWAAAAS3Jpc2hu YW4gU2FyYW5nYXJhamFuAAAAHgA4QAEAAAAJAAAAS1NBUkFOR0EAAAAAAgH7PwEAAABLAAAAAAAA ANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPVJVQU4vT1U9Q09SUE9SQVRFL0NOPVJFQ0lQSUVO VFMvQ049S1NBUkFOR0EAAB4A+j8BAAAAFgAAAEtyaXNobmFuIFNhcmFuZ2FyYWphbgAAAB4AOUAB AAAACQAAAEtTQVJBTkdBAAAAAEAABzCmQ1fDpaq9AUAACDAUzMvGpaq9AR4APQABAAAAAQAAAAAA AAAeAB0OAQAAABUAAABSZTogU1FMVGFsayAmIE9yYWNsZQAAAAAeADUQAQAAADsAAAA8RjI0QUNF RjQ0RjBFRDIxMTk0QUYwMDA4QzcyNDgyQkUxNENBODRAZXhjaGFuZ2UucnVhbi5jb20+AAALACkA AAAAAAsAIwABAAAAAwAGELSchyMDAAcQjgEAAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABI RUxMT0lOUkVHQVJEU1RPVVNJTkdTUUxUQUxLQU5ET1JBQ0xFLElUSVNDRVJUQUlOTFlGRUFTSUJM RVdFSEFWRU1BWElNT1BTRElQUk9EVUNUVEhBVFdFQVJFUlVOTklOR09OAAAAAAIBfwABAAAAOwAA ADxGMjRBQ0VGNDRGMEVEMjExOTRBRjAwMDhDNzI0ODJCRTE0Q0E4NEBleGNoYW5nZS5ydWFuLmNv bT4AACx8 ------ =_NextPart_000_01BDAAA5.C6CBCC14-- From owner-sqr-users@list.iex.net Wed Jul 8 16:14:10 1998 Date: Wed, 8 Jul 1998 16:52:16 -0400 From: "Kearns, Gary" Subject: Re: nVision for Peoplesoft I have a document which explains some of the performance enhancements I was referring to within the nVision tool itself. These build the selector tables dynamically and are attached to layouts. If you send your fax number, I'd be happy to send it. Also what chartfields are you using in the nVisions? We added indexes on the PSTREESELECTxx (xx is the size of the field) tables that you are accessing. For instance, we have dept level rpts which use PSTREESELECT10. I have added an index SELECTOR_NUM, RANGE_FROM_10 and have noticed performance improvements. We did this likewise to PSTREESELECT08. The SQL is very inefficient. I've run explain plans and it typically does a complete table scan against the ledger or ledger_budg. None of the selects use business_unit so they by-pass the index. They all use ledger, account, etc... I plan on creating some indexes in the hopes to get the nVision SQL to use them... Hope this helps. Good luck. Gary Gary Kearns HSN PeopleSoft Implementation (813) 572-8585 x5070 kearnsg@hsn.net > -----Original Message----- > From: Parenteau, Brian P. [SMTP:BPParenteau@CVS.COM] > Sent: Wednesday, July 08, 1998 3:03 PM > To: Multiple recipients of list SQR-USERS > Subject: nVision for Peoplesoft > > Hi All, > I know this list is mostly for technical info on SQR's, but I'm > assuming > that a lot of you have experience with Peoplesoft. So my question > is....has > anyone had any experience with PS/nVision...or know where I can get > some > information about it? We are having serious performance issues trying > to run > a report against a large amount of data. > > Any help would be greatly appreciated. > > Thanks > > Brian From owner-sqr-users@list.iex.net Wed Jul 8 16:33:54 1998 Date: Wed, 8 Jul 1998 15:04:51 -0500 From: Johnny Ravela Subject: Re: SQLTalk & Oracle Yes SQLTalk works with ORACLE and yes you can use both SQL*Plus and SQLTALK from the same machine at the same time even to talk to the Oracle DB. I have done the same on an NT workstation working with MAXIMO and ORACLE. > > Hello! In regards to using SQLTalk and Oracle, it is certainly feasible. > We have Maximo [PSDI product] that we are running on Oracle and SQLTalk > is currently the standard in that environment. > > I have used SQLTalk on Oracle, a couple of times but do not know if an > Oracle database can be accessed using both SQLTalk as well as SQL+ from > the same workstation. > From owner-sqr-users@list.iex.net Wed Jul 8 16:58:13 1998 Date: Wed, 8 Jul 1998 14:36:56 PDT From: Parijat Sahai Subject: Working with Null values of database in SQR Hi, I need to select rows from a table using begin-select based on a criteria that one particular column has a null value. How can I do that? Parijat ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 8 17:46:44 1998 Date: Wed, 8 Jul 1998 20:23:40 GMT From: "John S. Fetzik" Subject: Re: SQL Talk and Oracle. On Wed, 8 Jul 1998 09:45:00 -0500, Veso Lukovic wrote: > I have been told that SQL Talk cannot be used on Oracle, is this > correct? I used to work at a DB2/Mainframe shop, and I was able to > use SQL Talk there. Is SQL Talk now only compatible with SQLBASE? SQLTalk will communicate with all kinds of database servers, including Oracle. For Oracle you will need to install SQL-Net and then make the appropriate entries in the Centrue\Gupta SQL.INI file. -- John S. Fetzik jsf@wwa.com http://www.darclight.com/ From owner-sqr-users@list.iex.net Wed Jul 8 18:16:58 1998 Date: Wed, 8 Jul 1998 12:52:33 -0700 From: Michael Lee Subject: Re: nVision for Peoplesoft Brian, Are you subscribed to ps-users.com? There is a PeopleSoft User Mailing list there. You can subscribe at: http://www.ps-users.com You should find some nVision people on that list. Michael K. Lee mlee@agconsult.com Consultant AG Consulting, an ADP Company http://www.agconsult.com BPParenteau@CVS.COM on 07/08/98 12:02:49 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: nVision for Peoplesoft Hi All, I know this list is mostly for technical info on SQR's, but I'm assuming that a lot of you have experience with Peoplesoft. So my question is....has anyone had any experience with PS/nVision...or know where I can get some information about it? We are having serious performance issues trying to run a report against a large amount of data. Any help would be greatly appreciated. Thanks Brian From owner-sqr-users@list.iex.net Wed Jul 8 18:24:43 1998 Date: Wed, 8 Jul 1998 18:44:36 EDT From: Terri Jenkins Subject: Re: nVision for Peoplesoft I've had a lot of experience with nVision for Financials. It's kind of my thing. Your performance issues may be site related rather than nVision related, but I'd be interested in hearing your problems. What database are you using? Have you considered Summary Ledgers? Sometimes they help, but not always, it depends. From owner-sqr-users@list.iex.net Wed Jul 8 18:32:17 1998 Date: Wed, 8 Jul 1998 16:03:26 -0700 From: Michael Lee Subject: Re: Working with Null values of database in SQR Parijat, BEGIN-SELECT .. .. .. FROM WHERE IS NULL END-SELECT Try that. You can also try: WHERE = '' Michael K. Lee mlee@agconsult.com Consultant AG Consulting, an ADP Company http://www.agconsult.com parijatsahai@HOTMAIL.COM on 07/08/98 02:36:56 PM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Working with Null values of database in SQR Hi, I need to select rows from a table using begin-select based on a criteria that one particular column has a null value. How can I do that? Parijat ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jul 9 00:50:45 1998 Date: Thu, 9 Jul 1998 10:59:09 +0530 From: Srinivasan S Subject: Reading Flat Files from SQR Hi all, Is it possible to read a flat file(ASCII) file from SQR. We have a requirement where in , we would have to read a flat file and populate a table. TIA, Srini From owner-sqr-users@list.iex.net Thu Jul 9 05:40:03 1998 Date: Thu, 9 Jul 1998 12:17:13 +0100 From: Anders Eriksson Subject: Re: Reading Flat Files from SQR Hello Srini, Yes it is easy to read flat files with SQR. We have used that opetunity= a lot. 1) Use OPEN to open the file(s). OPEN { filename_lit=A0|=A0_var } AS { filenum_int_lit=A0|=A0_var } { FOR-READING | FOR-WRITING | FOR-APPEND } { RECORD =3D length_int_lit [ :FIXED | :FIXED_NOLF | :VARY ] } [ STATUS =3D { num_var } ] 2) Read records with GET. GET { dst_any_var } ... FROM { src_array_name ( element ) } [ field= [ ( occurs ) ] ] ... 3) Close the file with CLOSE. CLOSE { filenum_lit=A0|=A0_var } Regards Anders Eriksson = From owner-sqr-users@list.iex.net Thu Jul 9 06:02:34 1998 Date: Thu, 9 Jul 1998 03:47:43 PDT From: shishir guduri Subject: change of mail address Please change my mail address to shishir.guduri@usa.net ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jul 9 07:10:11 1998 Date: Thu, 9 Jul 1998 06:51:43 CDT From: "C. Willis III" Subject: Re: Reading Flat Files from SQR Srini, Yes, it is. See the Read command in the SQR manual. I think there may even be a sample program. clark Hi all, Is it possible to read a flat file(ASCII) file from SQR. We have a requirement where in , we would have to read a flat file and populate a table. TIA, Srini ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jul 9 07:26:24 1998 Date: Thu, 9 Jul 1998 14:55:42 +0300 From: SEMECH Subject: Creating 2 line charts overlaped Hello, We have 2 line charts as follows: On the 1st chart, the Y Axis has a scale of 1 to 4 and the X Axis has a scale of 1 to 12 (Months). (e.g. data about avr. trans/sec) On the 2nd chart, the Y Axis has a scale of 1 to 100 and the X Axis has a scale of 1 to 12 (months) like on the 1st chart (e.g. data about avr. %cpu) We would like to overlap the 2 charts, so we will have only 1 chart with 2 Y Axis scales and 1 - X Axis scale. So the chart would look something like this: 4 ! * * * ! 100 ! * * * * ! 3 ! * * ! ! * ^^ ^^ ! 2 ! ^^^^^ ^^^ ! 50 ! ^^^^ ^^^ ^^^^^^^^^^ ! 1 ! ^^^ ! ! ! !---------------------------------------------------! 0 1 2 3 4 5 6 7 8 9 10 11 12 Any ideas how to implement this with SQR - Print-chart ? Thank's in advance, Yoav Hornik ------------------------------------------------------------------- SEMECH SOFTWARE MARKETING LTD. TEL : (972) - 3 - 5333144 FAX : (972) - 3 - 5333132 Email: ------------------------------------------------------------------ From owner-sqr-users@list.iex.net Thu Jul 9 07:50:39 1998 Date: Thu, 9 Jul 1998 07:37:49 -0500 From: Ray Ontko Subject: Re: Working with Null values of database in SQR Parijat, > I need to select rows from a table using begin-select based on a > criteria that one particular column has a null value. How can I do that? begin-select my_column_1 (1,1) from my_table where my_column_2 is null end-select Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Jul 9 08:02:26 1998 Date: Thu, 9 Jul 1998 08:40:31 -0400 From: "Parenteau, Brian P." Subject: Re: Reading Flat Files from SQR Hi Srini, It sure is possible......here's some sample code from an SQR that I've written........ !******************************************************* ! * define the input file !******************************************************* move 'acctdept' to $filename let $input_file = 'c:\temp\' || $filename || '.dat' open $input_file as 1 for-reading record=80 status=#Open1 if #Open1 = -1 STOP QUIET end-if This logic is in the Begin-Report section...it reads the file into a variable, then separates each field into it's own variable. read 1 into $INPUT:80 if #end-file = 1 STOP QUIET end-if let $IN_ACCOUNT = RTRIM(SUBSTR($INPUT,1,5),' ') let $IN_DEPT = RTRIM(SUBSTR($INPUT,6,5),' ') let $IN_PRODUCT = RTRIM(SUBSTR($INPUT,11,3),' ') > ---------- > From: Srinivasan S[SMTP:srinivasan.seetharaman@DB.COM] > Sent: Thursday, July 09, 1998 1:29 AM > To: Multiple recipients of list SQR-USERS > Subject: Reading Flat Files from SQR > > Hi all, > Is it possible to read a flat file(ASCII) file from SQR. We have a > requirement where in , we would have to read a flat file and populate a > table. > > TIA, > > Srini > From owner-sqr-users@list.iex.net Thu Jul 9 08:03:13 1998 Date: Thu, 9 Jul 1998 07:45:57 -0500 From: Ray Ontko Subject: Re: Creating 2 line charts overlaped Yoav, > We have 2 line charts as follows: > > On the 1st chart, the Y Axis has a scale of 1 to 4 and the X Axis has a > scale of 1 to 12 (Months). (e.g. data about avr. trans/sec) > > On the 2nd chart, the Y Axis has a scale of 1 to 100 and the X Axis has a > scale of 1 to 12 (months) like on the 1st chart (e.g. data about avr. %cpu) > > We would like to overlap the 2 charts, so we will have only 1 chart with 2 > Y Axis scales and 1 - X Axis scale. > > So the chart would look something like this: > > 4 ! * * * ! 100 > ! * * * * ! > 3 ! * * ! > ! * ^^ ^^ ! > 2 ! ^^^^^ ^^^ ! 50 > ! ^^^^ ^^^ ^^^^^^^^^^ ! > 1 ! ^^^ ! > ! ! > !---------------------------------------------------! 0 > 1 2 3 4 5 6 7 8 9 10 11 12 > > Any ideas how to implement this with SQR - Print-chart ? You can't do it the way you're hoping to. Although you can have two lines present in a single graph, you can't have two scales. However, you CAN divide your y axis values for the second graph by 25 and then use PRINT to place your own labels for the second chart by hand. This is definitely a hack, but it may work for you. Ray P.S. Your desired feature is number 38 on my 'Top n SQR Enhancements' page: http://www.ontko.com/sqr/enhancements.html. ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Jul 9 09:52:27 1998 Date: Thu, 9 Jul 1998 09:59:32 -0400 From: Ken Arnold Subject: Re: Reading Flat Files from SQR !****Open file as file number "1" Open 'Afile.dat' as 1 For-Reading Record=80 Status = #Open1 If #Open1 <> 0 Show 'Open for file 1 (Afile) failed' Else Show 'Open for file 1 (Afile) succeeded' End-If !****Read file you opened as file number one "1" Read 1 into $Afield1:06 $Fill1:01 $Another_field:3 $And_Another:70 !****This splits up the file into variables that you can use or manipulate without using the substr !****Not quite sure how one of the suggestions of using "Get" would work. Get is used with arrays. ???? !****Close file you opened as file number one "1" Close 1 !Closing Input File 1 This used in both incoming interfaces and conversions. From owner-sqr-users@list.iex.net Thu Jul 9 09:54:33 1998 Date: Thu, 9 Jul 1998 07:34:22 -0700 From: "C. Duncan Hudson" Subject: SQL Select Question I realize that this is really an SQL question, and not an SQR question but I was hoping that with everyone's expertise here I could get a quick (and satisfactory) answer. Here's my question. I want to create a report that selects about 10 columns from a single table. The selection should be based upon field values within that table. Also (and here's where I'm having problems), I need to look at another table to see if the first table's primary key is represented in it. If it is, I want to exclude it from my selection. Do you follow that? Here's a crude visual: TABLE A TABLE B 100 98 101 100 105 108 107 110 110 111 In the above example I would want to select 101, 105, 107 and 111 from Table A. Can anyone give me a hand? Thanks in advance, Dunc. _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jul 9 10:07:59 1998 Date: Thu, 9 Jul 1998 11:00:51 -0400 From: "Connaghan, Rebecca" Subject: Re: SQL Select Question Duncan Why don't you try a subselect: select from table A where not in (select from table B). > -----Original Message----- > From: C. Duncan Hudson [SMTP:c_duncan_hudson@YAHOO.COM] > Sent: Thursday, July 09, 1998 10:34 AM > To: Multiple recipients of list SQR-USERS > Subject: SQL Select Question > > I realize that this is really an SQL question, and not an SQR question > but I was hoping that with everyone's expertise here I could get a > quick (and satisfactory) answer. > > Here's my question. I want to create a report that selects about 10 > columns from a single table. The selection should be based upon field > values within that table. Also (and here's where I'm having > problems), I need to look at another table to see if the first table's > primary key is represented in it. If it is, I want to exclude it from > my selection. Do you follow that? Here's a crude visual: > > TABLE A TABLE B > 100 98 > 101 100 > 105 108 > 107 110 > 110 > 111 > > In the above example I would want to select 101, 105, 107 and 111 from > Table A. Can anyone give me a hand? Thanks in advance, > > > Dunc. > > > > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jul 9 10:15:36 1998 Date: Thu, 9 Jul 1998 10:53:16 -0400 From: Heather Shuler Subject: Re: SQL Select Question You could call a procedure from within your main select. Then in the called procedure look at table B (through a select) to see if it contains the value from table A. If it does set a flag. Back in the main select check the flag's value. If it is acceptable print or write the values. Outline: BEGIN PROCEDURE BEGIN - SELECT COL1 COL2 COL3 DO CHECKB IF $VALUEEXISTS = 'FALSE' PRINT COL1 () PRINT COL2 () PRINT COL3 ()... END-IF FROM TABLE_A END - SELECT END PROCEDURE ***************** BEGIN PROCEDURE CHECKB MOVE 'FALSE' TO $VALUEEXISTS BEGIN - SELECT COL1 MOVE 'TRUE' TO $VALUEEXISTS FROM TABLE_B WHERE COL1 = &TABLE_A.COL1 C. Duncan Hudson wrote: > > I realize that this is really an SQL question, and not an SQR question > but I was hoping that with everyone's expertise here I could get a > quick (and satisfactory) answer. > > Here's my question. I want to create a report that selects about 10 > columns from a single table. The selection should be based upon field > values within that table. Also (and here's where I'm having > problems), I need to look at another table to see if the first table's > primary key is represented in it. If it is, I want to exclude it from > my selection. Do you follow that? Here's a crude visual: > > TABLE A TABLE B > 100 98 > 101 100 > 105 108 > 107 110 > 110 > 111 > > In the above example I would want to select 101, 105, 107 and 111 from > Table A. Can anyone give me a hand? Thanks in advance, > > Dunc. > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com -- Heather C. Shuler Computer Consultant Human Resources Department Syracuse University (315) 443-3941 hcshuler@syr.edu From owner-sqr-users@list.iex.net Thu Jul 9 10:21:59 1998 Date: Thu, 9 Jul 1998 10:52:51 -0500 From: David Anderson Subject: SQL Select Question -Reply I'm referring to SAMS Publishing's "Teach Yourself SQL in 21 Days" (my bible)... You will probably need to employ the keyword EXISTS (pgs 139-142) in your select statement. I'm not exactly sure of the syntax, but it will probably look something like... select A.field from TableA A where not exists (select B.field from TableB B where A.field = B.field) This is only a somewhat educated WAG. Good luck!! From owner-sqr-users@list.iex.net Thu Jul 9 10:33:24 1998 Date: Thu, 9 Jul 1998 10:00:04 -0500 From: "Hood, Paul" Subject: Re: SQL Select Question Duncan Just use a does not exist in a subselect in your where clause. > -----Original Message----- > From: Connaghan, Rebecca [SMTP:RConnaghan@OMNIPOINT-CORP.COM] > Sent: Thursday, July 09, 1998 10:01 AM > To: Multiple recipients of list SQR-USERS > Subject: Re: SQL Select Question > > Duncan > Why don't you try a subselect: > > select from table A where not in (select from table B). > > > -----Original Message----- > > From: C. Duncan Hudson [SMTP:c_duncan_hudson@YAHOO.COM] > > Sent: Thursday, July 09, 1998 10:34 AM > > To: Multiple recipients of list SQR-USERS > > Subject: SQL Select Question > > > > I realize that this is really an SQL question, and not an SQR > question > > but I was hoping that with everyone's expertise here I could get a > > quick (and satisfactory) answer. > > > > Here's my question. I want to create a report that selects about 10 > > columns from a single table. The selection should be based upon > field > > values within that table. Also (and here's where I'm having > > problems), I need to look at another table to see if the first > table's > > primary key is represented in it. If it is, I want to exclude it > from > > my selection. Do you follow that? Here's a crude visual: > > > > TABLE A TABLE B > > 100 98 > > 101 100 > > 105 108 > > 107 110 > > 110 > > 111 > > > > In the above example I would want to select 101, 105, 107 and 111 > from > > Table A. Can anyone give me a hand? Thanks in advance, > > > > > > Dunc. > > > > > > > > > > _________________________________________________________ > > DO YOU YAHOO!? > > Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jul 9 10:37:28 1998 Date: Thu, 9 Jul 1998 09:50:28 -0400 From: "Nina H. Chou" Subject: Re: Reading Flat Files from SQR At 12:17 PM 7/9/98 +0100, you wrote: >Hello Srini, > >Yes it is easy to read flat files with SQR. We have used that opetunity a >lot. > >1) Use OPEN to open the file(s). >OPEN { filename_lit=A0|=A0_var } AS { filenum_int_lit=A0|=A0_var } >{ FOR-READING | FOR-WRITING | FOR-APPEND } >{ RECORD =3D length_int_lit [ :FIXED | :FIXED_NOLF | :VARY ] } >[ STATUS =3D { num_var } ] Some examples for different platform: --MVS/DB2 batch open 'DSN:userid.flat.file.TXT' <-- specify DSN name open 'DDN:INDATA' <-- specify DD name, preferred as 1 for-reading record=3D162:vary status=3D#filestat and on IBM/OS390, even if the data is fixed block, read the record as "vary" instead of as "fixed" to avoid the trailing blank problems. ------------------------------------------------------------ =20 Analyst Programmer =20 Administrative Information Services =20 Case Western Reserve University Cleveland OH 44106 Email: hxc15@po.cwru.edu Phone: (216) 368-0401 (O) =09 (440) 572-8965 (H) From owner-sqr-users@list.iex.net Thu Jul 9 10:46:07 1998 Date: Thu, 9 Jul 1998 16:03:01 +0100 From: Beverley Childs Subject: Re: SQL Select Question If I understand the problem correctly, I think the following will work: select tablea.* (or list of columns) from tablea, tableb where tablea.key != tableb.key -----Original Message----- From: C. Duncan Hudson [mailto:c_duncan_hudson@YAHOO.COM] Sent: 09 July 1998 15:34 To: Multiple recipients of list SQR-USERS Subject: SQL Select Question I realize that this is really an SQL question, and not an SQR question but I was hoping that with everyone's expertise here I could get a quick (and satisfactory) answer. Here's my question. I want to create a report that selects about 10 columns from a single table. The selection should be based upon field values within that table. Also (and here's where I'm having problems), I need to look at another table to see if the first table's primary key is represented in it. If it is, I want to exclude it from my selection. Do you follow that? Here's a crude visual: TABLE A TABLE B 100 98 101 100 105 108 107 110 110 111 In the above example I would want to select 101, 105, 107 and 111 from Table A. Can anyone give me a hand? Thanks in advance, Dunc. _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jul 9 10:46:28 1998 Date: Thu, 9 Jul 1998 15:48:36 +0100 From: Duncan Berriman Subject: Re: SQL Select Question Duncan J Berriman 09/07/98 16:48 select x from a where x not in (select y from b) From owner-sqr-users@list.iex.net Thu Jul 9 11:00:30 1998 Date: Thu, 9 Jul 1998 11:38:11 -0400 From: Raghu