Re: [suse-oracle] z/OS SQLPlus Spool Question

Hi Michael,

I have forwarded your question to IBM to see If they know workaround. Looks like you should file TAR with Oracle to look into this issue.

Thanks,
Arun

>>> On 10/13/2010 at 8:09 AM, Michael Stephens <[email protected]> wrote:
> Good Day!
> I have been lurking for a couple of years now, and finally need to ask a 
> question.  Actually, I have lots of questions, but one at a time is usually 
> better.
> 
> We have Oracle executing in z/Linux, Oracle Database 10g Enterprise Edition 
> Release 10.2.0.4.0 - 64bit Production, and I am using SQLPlus in batch on the 
> z/OS side, SQL*Plus: Release 10.2.0.3.0 - Production.  Most things work just 
> fine.  The main issue I am having is it to get SQLPlus to not use the line 
> feed character to terminate an output line to the spool file.  It is putting 
> EBCDIC x'15' at the end of the line instead of starting a new record.  New 
> line is fine for non-mainframe OS's, but doesn't work for z/OS.  Lines are 
> written to the spool file until the LRECL is used up and then starts a new 
> record, even in the middle of the SQLPlus record.
> 
> The example I am using is trying to create a comma separated output file 
> from a table:
> 
> ...
> SPOOL //DD:CSVOUT
> SELECT
>            '"' || trim(CAMPUS_ID)
>       || '","' || trim(CRS_NBR)
>       || '","' || trim(SEC_NBR)
>       || '","' || trim(MAX_SEAT)
>       || '"'
> FROM DDD.SR_SCHED_SEC
> ;
> The output file DD is:
> 
> //CSVOUT   DD DISP=OLD,DSN=ISSMJS1.ODBA.CSVOUT
> where DCB=(RECFM=VB,LRECL=4096,BLKSIZE=0)
> 
> I have also tried defining fixed length columns and lines, matching to an FB 
> dataset with the same line length, and get the same type of results.
> 
> I hope some of you have solved this before and can point me in the right 
> direction.  SQLPlus using z/Linux or PC environments works as documented, 
> however, it would be nice to be able to use the z/OS batch features and to 
> get the spool files directly into the z/OS side without FTPing or otherwise.
> 
> Thanks,
> Michael Stephens
> DBA I
> ESC Region 20
> San Antonio, TX
> 
> 
> [ESC-20]<http://www.esc20.net>
> 
> 1314 Hines Avenue, San Antonio, TX 78208
> 
> CONFIDENTIALITY NOTICE
> 
> The information contained in this transmission may contain privileged and 
> confidential information and is intended only for the use of the person(s) 
> named above. If you are not the intended recipient, or an employee or agent 
> responsible for delivering this message to the intended recipient, any 
> review, dissemination, distribution or duplication of this communication is 
> strictly prohibited. If you are not the intended recipient, please contact 
> the sender immediately by reply e-mail and destroy all copies of the original 
> message. This message may be subject to disclosure under the Open Records 
> Act.

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle