SYSOUT=* Output for SPOOL in SQL*PLUS Splits into Multiple lines in z/OS Batch job after upgrading to 10.2.0.3

(Doc ID 1297125.1)

Last updated on APRIL 24, 2017

Applies to:

SQL*Plus - Version: 10.2.0.3 to 10.2.0.3 - Release: Oracle10g to Oracle10g
IBM z/OS on System z

Symptoms

After upgrading from 9.2   to 10.2.0.3, SYSOUT=* output for SPOOL in SQL*PLUS splits into multiple lines when running Batch job in z/OS.  This is behavior is not exhibited under 9.2.

Sample failing case:
sql*plus input:
  SET LINESIZE 250
  SPOOL /DD/ORAPRINT

JCL:
//ORAPRINT DD SYSOUT=*


When DCB information is added to SYSOUT=*, line does not split (or wraps):

Working case:
SET LINESIZE 250
SPOOL /DD/ORAPRINT

//ORAPRINT DD SYSOUT=*,DCB=(RECFM=FB,LRECL=1000)


Changes

Upgraded from 9.2  to 10.2.0.3.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms