I'm not anti-social, I just don't like people -Tommy Holden Comment Post Cancel JonBoy Analyst Join Date: Jun 2005 Posts: 422 #11 September 11th, 2010, 05:43 PM Re: Close printer file Oracle Database(Oracle DBA) Tuesday, 7 October 2014 SP2-0308: cannot close spool file SP2-0308: cannot close spool file This Error popup due to disk partition is going to full so to remove Pgm2 declares a print file and passes it as a parm to Pgm1. http://dbarahul.blogspot.com/2014/10/sp2-0308-cannot-close-spool-file.html All rights reserved.
Posted by Rahul Joshi at 04:21 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: dba_errors, oracle 11g, Oracle error, SP2-0308: cannot close spool file No comments: Post a Comment Newer All times are GMT-6. Powered by Blogger. Below is from Oracles Support site...
Getting error: SP2 0308: cannot close spool file. http://dbaspot.com/oracle-errors/336178-sp2-0308-cannot-close-spool-file.html Join Now For immediate help use Live now! It stays open. Hits: 14743970 Books Terms & Conditions About Comments Facebook Sitemap Copyright © 2013 Login or Sign Up Log in with Facebook Search in titles only Search in RPG/RPGLE only Advanced Search
Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. news When Pgm2 is done printing it just closes the file - voila! Connect with top rated Experts 13 Experts available now in Live! I'm not anti-social, I just don't like people -Tommy Holden Comment Post Cancel GLS400 Analyst Join Date: May 2006 Posts: 2020 #4 September 8th, 2010, 03:59 PM Re: Close printer file
Printed everything by calling program A, and after printing everything, i do a DLTOVR (*all) and then close PRT198. spool d:somedirFILE1.dat select cluster_cd,cluster_desc,setid,eff_start_dt,eff_end_dt,active_fg,start_dt,end_date from v_tmp_cluster; spool off Report message to a moderator Re: Spooling query to File give SP2-0308: cannot close spool file [message #5271 is a Pgm1 does the printing and returns. have a peek at these guys Join our community for more solutions or to ask questions.
For now i am using the extra parameter to set on LR at the end, but i am intrigued by the SHARE(*YES) one. thanks. I have a program (letīs call it A), that basically reads some data from files, and outputs it to a printer file (with O specs).
LEARN MORE Join & Write a Comment Already a member? What is the point? Add Comment Your Comment Name: Comment: Captcha: Post Comment More Information The Google Search results shown above are obtained by searching for this error using a custom google search engine which Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Forum Operations by The UNIX and Linux Forums Skip to content rahuljoshidba SP2-0308: cannot close spoolfile Posted on April 15, 2015 by rahuljsh1991 SP2-0308: cannot close spool file This Error Share this:TwitterFacebookGoogleLike this:Like Loading... Get 1:1 Help Now Advertise Here Enjoyed your answer? check my blog Tags: None GLS400 Analyst Join Date: May 2006 Posts: 2020 #2 September 8th, 2010, 03:56 PM Re: Close printer file from another program Hi fjleon: The easiest way is for program
I made up some free space and I was able to create the extracts. set pagesize 0 set head off set linesize 100 set feedback off set colsep '' spool FILE1.dat select cluster_cd,cluster_desc,setid,eff_start_dt,eff_end_dt,active_fg,start_dt,end_date from v_tmp_cluster; spool off Thanks for your help. MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask a Question Where is this file written?
Pgm2 calls Pgm1 to do the print. sponsored links Collapse Announcement Collapse No announcement yet. Seems you can't close files opened by other programs. Our system handles 2 Gig + files but we couldn't create a file > 2 gig....
Oracle Database Restoring a Database from User Managed Backups with Oracle Video by: Steve This video shows how to recover a database from a user managed backup Oracle Database Advertise Here The time now is 07:50 AM. - Contact Us - UNIX & Linux - unix commands, linux commands, linux server, linux ubuntu, shell script, linux distros. - Advertising - Top Join the community of 500,000 technology professionals and ask your questions. Program B has PRT198 declared as USROPN, and before opening it i did: OVRPRTF FILE(PRT198) TOFILE(*LIBL/PRT198) SHARE(*YES) Program A has prt198 declared without USROPN.