Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What could be the LRECL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Wed Sep 12, 2007 11:54 am    Post subject: What could be the LRECL
Reply with quote

Sir,
I am having a table named INSURE with 28 columns. But when I am selecting the same, I am able to view only 13 columns with a message given below. I tried the same by changing the record length of the output data set upto 8000. What could be the record length of output dataset. Please help me.


Menu Utilities Compilers Help ------------------------------------------------------------------------------- BROWSE ESCUB14.AUTO.DB2OUT Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE ********************************* Top of Data ********************************** ---------+---------+---------+---------+---------+---------+---------+---------+ --DELETE FROM INSURE; 00000110 --INSERT INTO INSURE(VEHNO,VEHVALUE,VEHTYPE,PIN,COUNTRY,CLAIMST,REASON) 00000210 --VALUES('KLKL01234',1234567,'LMV',678008,'INDIA','PENDING','B'); 00000310 SELECT * FROM INSURE; 00000405 ---------+---------+---------+---------+---------+---------+---------+---------+ VEHNO CUSNAME CUSPWD VEHTYPE ENGNO CHASNO
---------+---------+---------+---------+---------+---------+---------+---------+ KLKL01234 -------------------- ------ LMV ------------ ------------
DSNE610I NUMBER OF ROWS DISPLAYED IS 1 DSNE613I OUTPUT LRECL IS TOO SMALL TO DISPLAY THE FOLLOWING COLUMNS:
COUNTRY
PIN
CURPREMIUM
DUEDATE
LASCLDATE
CLAIMST
CLAIMCNT
LASPDATE
REASON
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 ---------+---------+---------+---------+---------+---------+---------+---------+ --*CREATE UNIQUE INDEX INSINDEX ON INSURE(VEHNO); 00001005 F1=Help F2=Split F3=Exit F4=SPOOL F5=Rfind F6=ref F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel . . . . . . . . . . . . . . . . . . . . . . . . . .
Menu Options View Utilities Compilers Help
Back to top
View user's profile Send private message

achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Wed Sep 12, 2007 12:16 pm    Post subject: Re: what could be the LRECL
Reply with quote

achusarath wrote:
Sir,
I am having a table named INSURE with 28 columns. But when I am selecting the same, I am able to view only 13 columns with a message given below. I tried the same by changing the record length of the output data set upto 8000. What could be the record length of output dataset. Please help me.


Menu Utilities Compilers Help ------------------------------------------------------------------------------- BROWSE ESCUB14.AUTO.DB2OUT Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE ********************************* Top of Data ********************************** ---------+---------+---------+---------+---------+---------+---------+---------+ --
INSERT INTO INSURe VEHNO,VEHVALUE,VEHTYPE,PIN,COUNTRY,CLAIMST,REASON)
VALUES('KLKL01234',1234567,'LMV',678008,'INDIA','PENDING','B');
SELECT * FROM INSURE;
---------+---------+---------+---------+---------+---------+---------+---------+ VEHNO CUSNAME CUSPWD VEHTYPE ENGNO CHASNO
---------+---------+---------+---------+---------+---------+---------+---------+ KLKL01234 -------------------- ------ LMV ------------ ------------
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE613I OUTPUT LRECL IS TOO SMALL TO DISPLAY THE FOLLOWING COLUMNS:
COUNTRY
PIN
CURPREMIUM
DUEDATE
LASCLDATE
CLAIMST
CLAIMCNT
LASPDATE
REASON
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 ---------+---------+---------+---------+---------+---------+---------+---------+ --*CREATE UNIQUE INDEX INSINDEX ON INSURE(VEHNO); 00001005 F1=Help F2=Split F3=Exit F4=SPOOL F5=Rfind F6=ref F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel . . . . . . . . . . . . . . . . . . . . . . . . . .
Menu Options View Utilities Compilers Help
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Sep 12, 2007 12:17 pm    Post subject:
Reply with quote

Hi there,

Identify the length using copy book/dclgen of the table
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Wed Sep 12, 2007 12:41 pm    Post subject:
Reply with quote

I TRIED IT CALCULATING DCLGEN LENGTH I GOT IT 227,SO I CREATED THE OUTPUT DATA SET WITH 240 RECORD LENGTH AND 960 BLOCK SIZE,BUT GETTING THE SAME MESSAGE



guptae wrote:
Hi there,

Identify the length using copy book/dclgen of the table
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Sep 12, 2007 12:45 pm    Post subject:
Reply with quote

Hi Achu,

Is it possible for u to paste the dclgen here
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Wed Sep 12, 2007 12:56 pm    Post subject:
Reply with quote

YES I AM ATTACHING IT
Hi Achu,

Is it possible for u to paste the dclgen here[/quote]
Code:
 000001       ******************************************************************
 000002       * DCLGEN TABLE(INSURE)                                           *
 000003       *        LIBRARY(ESCUB14.AUTO.COPYLIB(TEST))                     *
 000004       *        ACTION(REPLACE)                                         *
 000005       *        LANGUAGE(COBOL)                                         *
 000006       *        QUOTE                                                   *
 000007       *        LABEL(YES)                                              *
 000008       *        INDVAR(YES)                                             *
 000009       * ... IS THE DCLGEN COMMAND THAT MADE THE FOLLOWING STATEMENTS   *
 000010       ******************************************************************
 000011            EXEC SQL DECLARE INSURE TABLE                               
 000012            ( VEHNO                          CHAR(9) NOT NULL,           
 000013              CUSNAME                        VARCHAR(20),               
 000014              CUSPWD                         CHAR(4),                   
 000015              VEHTYPE                        CHAR(3),                   
 000016              ENGNO                          CHAR(12),                   
 000017              CHASNO                         CHAR(12),                   
 000018              VEHVALUE                       DECIMAL(7, 0),             
 000019              MFGDATE                        DATE,                       
 000020              ENGCC                          CHAR(12),                   
 000021              HOUSENO                        CHAR(6),                   
 000022              STREET                         CHAR(12),                   
 000023              DISTRICT                       VARCHAR(15),               
 000024              STATE                          VARCHAR(15),               
 000025              COUNTRY                        VARCHAR(15),               
 000026              PIN                            DECIMAL(6, 0),             
 000027              CURPREMIUM                     DECIMAL(7, 2),             
 000028              DUEDATE                        DATE,                       
 000029              LASCLDATE                      DATE,                       
 000030              CLAIMST                        VARCHAR(7),                 
 000031              CLAIMCNT                       INTEGER,                   
 000032              LASPDATE                       DATE,                       
 000033              REASON                         CHAR(1)                     
 000034            ) END-EXEC.                                                 
 000035       ******************************************************************
 000036       * COBOL DECLARATION FOR TABLE INSURE                             *
 000037       ******************************************************************
 000038        01  DCLINSURE.                                                   
 000039       *    *************************************************************
 000040            10 VEHNO                PIC X(9).                           
 000041       *    *************************************************************
 000042            10 CUSNAME.                                                 
 000043               49 CUSNAME-LEN       PIC S9(4) USAGE COMP.               
 000044               49 CUSNAME-TEXT      PIC X(20).                           
 000045       *    *************************************************************
 000046            10 CUSPWD               PIC X(4).                           
 000047       *    *************************************************************
 000048            10 VEHTYPE              PIC X(3).                           
 000049       *    *************************************************************
 000050            10 ENGNO                PIC X(12).                           
 000051       *    *************************************************************
 000052            10 CHASNO               PIC X(12).                           
 000053       *    *************************************************************
 000054            10 VEHVALUE             PIC S9(7)V USAGE COMP-3.             
 000055       *    *************************************************************
 000056            10 MFGDATE              PIC X(10).                           
 000057       *    *************************************************************
 000058            10 ENGCC                PIC X(12).                           
 000059       *    *************************************************************
 000060            10 HOUSENO              PIC X(6).                           
 000061       *    *************************************************************
 000062            10 STREET               PIC X(12).                           
 000063       *    *************************************************************
 000064            10 DISTRICT.                                                 
 000065               49 DISTRICT-LEN      PIC S9(4) USAGE COMP.               
 000066               49 DISTRICT-TEXT     PIC X(15).                           
 000067       *    *************************************************************
 000068            10 STATE.                                                   
 000069               49 STATE-LEN         PIC S9(4) USAGE COMP.               
 000070               49 STATE-TEXT        PIC X(15).                           
 000071       *    *************************************************************
 000072            10 COUNTRY.                                                 
 000073               49 COUNTRY-LEN       PIC S9(4) USAGE COMP.               
 000074               49 COUNTRY-TEXT      PIC X(15).                           
 000075       *    *************************************************************
 000076            10 PIN                  PIC S9(6)V USAGE COMP-3.             
 000077       *    *************************************************************
 000078            10 CURPREMIUM           PIC S9(5)V9(2) USAGE COMP-3.         
 000079       *    *************************************************************
 000080            10 DUEDATE              PIC X(10).                           
 000081       *    *************************************************************
 000082            10 LASCLDATE            PIC X(10).                           
 000083       *    *************************************************************
 000084            10 CLAIMST.                                                 
 000085               49 CLAIMST-LEN       PIC S9(4) USAGE COMP.               
 000086               49 CLAIMST-TEXT      PIC X(7).                           
 000087       *    *************************************************************
 000088            10 CLAIMCNT             PIC S9(9) USAGE COMP.               
 000089       *    *************************************************************
 000090            10 LASPDATE             PIC X(10).                           
 000091       *    *************************************************************
 000092            10 REASON               PIC X(1).                           
 000093       ******************************************************************
 000094       * INDICATOR VARIABLE STRUCTURE                                   *
 000095       ******************************************************************
 000096        01  IINSURE.                                                     
 000097            10 INDSTRUC           PIC S9(4) USAGE COMP OCCURS 22 TIMES. 
 000098       ******************************************************************
 000099       * THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 22      *
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Sep 12, 2007 1:41 pm    Post subject:
Reply with quote

Hi Ashu,

Please check the attachment for the spool setting
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Sep 12, 2007 11:32 pm    Post subject:
Reply with quote

Are you doing this through spufi?
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Thu Sep 13, 2007 11:55 am    Post subject:
Reply with quote

yeah im doing it thru spufi



stodolas wrote:
Are you doing this through spufi?
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Thu Sep 13, 2007 11:59 am    Post subject:
Reply with quote

sorry sir i didnt get you

guptae wrote:
Hi Ashu,

Please check the attachment for the spool setting
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Sep 13, 2007 6:33 pm    Post subject:
Reply with quote

What does this section of the panel show?

This is from my session
Code:

Output data set characteristics:                                           
 6  RECORD LENGTH ... ===> 4092       (LRECL=Logical record length)         
 7  BLOCK SIZE ...... ===> 4096       (Size of one block)                   
 8  RECORD FORMAT ... ===> VB         (RECFM=F, FB, FBA, V, VB, or VBA)     
 9  DEVICE TYPE ..... ===> SYSDA      (Must be DASD unit name)             
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Fri Sep 14, 2007 11:56 am    Post subject:
Reply with quote

these are my section panel values
Output data set characteristics:
6 RECORD LENGTH ... ===> 240 (LRECL=Logical record length)
7 BLOCK SIZE ...... ===> 960 (Size of one block)
8 RECORD FORMAT ... ===> fB (RECFM=F, FB, FBA, V, VB, or VBA)
9 DEVICE TYPE ..... ===> (Must be DASD unit name)




stodolas wrote:
What does this section of the panel show?

This is from my session
Code:

Output data set characteristics:                                           
 6  RECORD LENGTH ... ===> 4092       (LRECL=Logical record length)         
 7  BLOCK SIZE ...... ===> 4096       (Size of one block)                   
 8  RECORD FORMAT ... ===> VB         (RECFM=F, FB, FBA, V, VB, or VBA)     
 9  DEVICE TYPE ..... ===> SYSDA      (Must be DASD unit name)             
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Sep 14, 2007 5:49 pm    Post subject:
Reply with quote

Up them. Even though you are taking care of the recl, you aren't accounting for column names that are longer than the data. Don't be using spufi to try and do a table extract, there are tools for that already. Try switching to VB and up the RECL to 32000.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Sep 14, 2007 6:33 pm    Post subject:
Reply with quote

Hi Achu,

Check what value u provided for the follwoing pannel

Code:
Specify processing options:                                                 
 5  CHANGE DEFAULTS   ===> YES        (Y/N - Display SPUFI defaults panel?) 
 6  EDIT INPUT ...... ===> YES        (Y/N - Enter SQL statements?)         
 7  EXECUTE ......... ===> YES        (Y/N - Execute SQL statements?)       
 8  AUTOCOMMIT ...... ===> YES        (Y/N - Commit after successful run?)   
 9  BROWSE OUTPUT ... ===> YES        (Y/N - Browse output data set?)       
                                                                             
For remote SQL processing:                                                   
10  CONNECT LOCATION  ===>   
Back to top
View user's profile Send private message
achusarath

New User


Joined: 21 Mar 2007
Posts: 26
Location: kerala

PostPosted: Mon Sep 17, 2007 9:20 am    Post subject:
Reply with quote

I am having the same panel values that yopu hav provided. icon_wink.gif





guptae wrote:
Hi Achu,

Check what value u provided for the follwoing pannel

Code:
Specify processing options:                                                 
 5  CHANGE DEFAULTS   ===> YES        (Y/N - Display SPUFI defaults panel?) 
 6  EDIT INPUT ...... ===> YES        (Y/N - Enter SQL statements?)         
 7  EXECUTE ......... ===> YES        (Y/N - Execute SQL statements?)       
 8  AUTOCOMMIT ...... ===> YES        (Y/N - Commit after successful run?)   
 9  BROWSE OUTPUT ... ===> YES        (Y/N - Browse output data set?)       
                                                                             
For remote SQL processing:                                                   
10  CONNECT LOCATION  ===>   
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts WER247A incompatible lrecl Danielle.Filteau SYNCSORT 8 Tue May 02, 2017 4:04 am
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts PL/I: opening file w/ dynamically det... Sam Dodgers PL/I & Assembler 6 Wed Jul 27, 2016 4:05 pm
No new posts SORT Format should be RECFM=VB,LRECL=350 senthamizh SYNCSORT 8 Fri Jan 15, 2016 8:20 pm
No new posts Concatenate different LRECL GDG's Rohit Umarjikar DFSORT/ICETOOL 6 Wed Nov 18, 2015 3:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us