SQL query results wrapping

[David Butler]

Hi, I am running SQL dataqueries for the first time on our mainframe and the output is wrapping at pos 132.

How can I increase the width of the output to 182 to prevent wrapping and/or what JCL syntax do I need to use to output the results to a dataset instead.

 

           DBID ARA                       BLKSZ       #BLOCKS       LGLREADS     LGLWRITES     PHYSREADS    PHYSWRITES        M_MEGS
 M_TOT_READS    M_PHYSIO M_SAVED_READS SAVED_PER_MB
  NUM(4,0) N.N. CHAR(3) N.N. UNS. SMALLINT N.N. NUM(7,0) N.N. DEC(11,0) N.N. NUM(9,0) N.N. NUM(9,0) N.N. NUM(9,0) N.N. NUM(6,2) N.N.
    UNS. INT    DEC(9,0)      UNS. INT     DEC(9,0)
  _____________ ____________ __________________ _____________ ______________ _____________ _____________ _____________ _____________
 ___________ ___________ _____________ ____________
              0 CXX                        4096           349          13695          2323          2561          1417          1.00
           0           0             0         2561
            110 IXX                        4096           486            189            17            98             3          1.00
           0           0             0           98
              2 DD1                        4096          2809          56376          5455           403             9         10.00
           0           0             0           40
              2 IXX                        4096          5332         187334         21740           573           127         20.00
           0           0             0           28
              3 DQM                        4096           525             64             0            18             0          2.00
           0           0             0            9
            110 POL                        4096          1010             52             7            27             2          3.00
           0           0             0            9
              3 DQW                        4096           600             32            12             5            12          2.00
           0           0             0            2
  ___ 7 rows returned ___

[David Butler]

JCL I am running is as follows

 

//LOADDEMO PROC BDCHLQ='TCAI.DCOM150',

// BDTHLQ='TCAI.DCOM150'

//*

//*------------------------------------------------------------------**

//* EXECUTE PROGRAM DBSQLPR TO DISPLAY DATA AREA PHYSICAL AND LOGICAL

//* I/O FROM THE DYNAMIC SYSTEM TABLES DATABASE

//*------------------------------------------------------------------**

//*

//STEP1 EXEC PGM=DBSQLPR,REGION=4M,

// PARM='PRTWIDTH=1500,INPUTWIDTH=70'

//STEPLIB DD DISP=SHR,

// DSN=&BDCHLQ..CUSLIB

// DD DISP=SHR,

// DSN=&BDTHLQ..CABDLOAD

//SYSUDUMP DD SYSOUT=*

//SYSPRINT DD SYSOUT=*

//STDERR DD SYSOUT=*

//STDOUT DD SYSOUT=*

//SYSOUT DD SYSOUT=*

//*

//*

// PEND

//*

//*==================================================================**

//*

//PROC1 EXEC LOADDEMO

//*

//*------------------------------------------------------------------**

//*------------------------------------------------------------------**

//STEP1.OPTIONS DD *

AUTHID=SYSADM

MSG=NN

SQLMODE=DATACOM

NOPAGEHDR

WORKSPACE=128

PRTWIDTH=1500

ROWLIMIT=999999

[Umberto Comotti]

Hi David,

you need to specify an LRECL value to the STDOUT ddname. Please take a look to technical document TEC1956066 which provides details about this.

Let us know if the document helps.

Umberto

[David Butler]

Thanks Umberto that works well