Increase the LRECL output of the SPUFI.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
ShilpiSRE
Registered Member
Posts: 23
Joined: Sat Aug 17, 2013 12:28 pm

Increase the LRECL output of the SPUFI.

Post by ShilpiSRE »

Hi,

I have been using SPUFI for some time but neve needed to increase the length of the output. Now the SPUFI which I have gets data from many columns of a table. Now the result goes beyond the 133 record length. Is there a way to get around the length of the output dataset?
Last edited by Anuj Dhawan on Wed Jul 13, 2016 8:15 pm, edited 1 time in total.
Reason: Added Tags.
enrico-sorichetti
Global Moderator
Global Moderator
Posts: 825
Joined: Wed Sep 11, 2013 3:57 pm

Re: Increase the LRECL output of the SPUFI.

Post by enrico-sorichetti »

SPUFI ... the interactive one, or the misnomer for DSNTEPx
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)
Chandan Yadav
Website Team
Website Team
Posts: 70
Joined: Wed Jul 31, 2013 10:19 pm

Re: Increase the LRECL output of the SPUFI.

Post by Chandan Yadav »

Hi,
If you asking about interactivd spufi then you have option to change record length on page of spufi where you provide the output dataset or next page which appear just before the page for query writing

Thanks and regards,
Chandan
ShilpiSRE
Registered Member
Posts: 23
Joined: Sat Aug 17, 2013 12:28 pm

Re: Increase the LRECL output of the SPUFI.

Post by ShilpiSRE »

Thanks. Thisis what I have tried as per the suggestion and it helped.

Code: Select all

SPUFI
Ooption 1 : Change Defaults
Option 5   :  yes
On this panel output data set characteristics are listed. Which can be changed:

Code: Select all

6  RECORD LENGTH ... ===> 500   
7  BLOCK SIZE ...... ===> 504   
8  RECORD FORMAT ... ===> VB
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”