View previous topic :: View next topic
|
Author |
Message |
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
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 |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Identify the length using copy book/dclgen of the table |
|
Back to top |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi Achu,
Is it possible for u to paste the dclgen here |
|
Back to top |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi Ashu,
Please check the attachment for the spool setting |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Are you doing this through spufi? |
|
Back to top |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
yeah im doing it thru spufi
stodolas wrote: |
Are you doing this through spufi? |
|
|
Back to top |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
sorry sir i didnt get you
guptae wrote: |
Hi Ashu,
Please check the attachment for the spool setting |
|
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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 |
|
|
achusarath
New User
Joined: 21 Mar 2007 Posts: 26 Location: kerala
|
|
|
|
I am having the same panel values that yopu hav provided.
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 |
|
|
|