[suse-oracle] z/OS SQLPlus Spool Question

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