IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Freezing a particular line in the dataset


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Thu Aug 09, 2007 11:17 am
Reply with quote

Hi all,

Can anyone tell me, is it posssible to freeze a particular record/line in a seq dataset, like the option Freeze panes in excel.?

If it is possible, please tell me...... I need that atleast for manually entering the data in the correct columns of a dataset.

Hope you understand my problem,
Please let me know, if you need further information,

Thanks,
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Thu Aug 09, 2007 12:01 pm
Reply with quote

hi ursvmg,

can you be more specific to your requirement.
Quote:

is it possible to freeze a particular record/line in a seq dataset


you want to protect that record from accessing or doing any updations in it.
Back to top
View user's profile Send private message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Thu Aug 09, 2007 12:15 pm
Reply with quote

Hi,

My seq ds looks like this.....

Code:
NAME----------------------------EMPNO--DEPT-----------------AGE--------
URSVMG                          200    DEVELOPMENT          22         


In this, i need to enter the details of each and every person manually...... when i go for the next page the first line which contains the NAME, EMPNO... headers will not be visible.....

I want this line to be visible in all the pages.....

Code:
NAME----------------------------EMPNO--DEPT-----------------AGE--------


So when press next page, i should be able to see the header.... so that i can enter the details in anypage on appropriate columns......


Hope u r now clear....
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Thu Aug 09, 2007 12:35 pm
Reply with quote

You can use MASK, TABS and COLS to help you enter data. For more info, please refer to the fine manual.

O.
Back to top
View user's profile Send private message
hariibm

New User


Joined: 05 Feb 2007
Posts: 61
Location: Chennai

PostPosted: Thu Aug 09, 2007 12:36 pm
Reply with quote

I think that would not be possible on mainframes.
Back to top
View user's profile Send private message
paray2x

New User


Joined: 28 Dec 2005
Posts: 21

PostPosted: Thu Aug 09, 2007 10:23 pm
Reply with quote

Why don't you try entering the data in excel, save it as a text file and then upload it to mainframe?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Aug 09, 2007 10:58 pm
Reply with quote

Hello,

If you write your own "data entry" process, you can control how the panel is displayed, what the pfkeys do, etc. You would just make the "headings" part of your fixed panel - not the data entry area. Depending on how elegant you wanted to make your process, you could support entering the headings once and then "locking them in" for the editing session.

The tso/ispf editor has no "freeze" that i'm aware of.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Aug 09, 2007 11:22 pm
Reply with quote

hariibm and paray2x,

If you do not wish to remain ignorant of the capabilites of the mainframe I suggest you look at the link provided by [b]ofer71[/]. Heaven forbid that you learn something new!
Back to top
View user's profile Send private message
paray2x

New User


Joined: 28 Dec 2005
Posts: 21

PostPosted: Fri Aug 10, 2007 7:04 am
Reply with quote

dbz,

I did not try to say anything against the mainframe.

I only felt that tasks like "data entry" could be done in other apps and mainframe could be the best to use for processing data.

Sorry if my reply had anything to do with not using the capabilities of the mainframe..

--Para
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Aug 10, 2007 7:58 am
Reply with quote

Mask is pretty sweet. I found that one about a month ago myself.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Aug 10, 2007 10:14 am
Reply with quote

Quote:
ursvmg


If you need something like Column heading should always be displayed and allow entering data in the correct column -
--- Then PLEASE use FILE-AID EDIT with VFMT option.
Back to top
View user's profile Send private message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Fri Aug 10, 2007 10:21 am
Reply with quote

Hi Devzee,

But this VFMT option requires a copybook it seems........ It is prompting me to enter a copybook.......
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Aug 10, 2007 10:22 am
Reply with quote

Yes you need to have a copybook, otherwise how do u know what is the data structure of your record.
Create a copy book for your file.
Back to top
View user's profile Send private message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Fri Aug 10, 2007 10:56 am
Reply with quote

Thanks everybody for your suggestions........

I learned some new things through this post.

Thanks a lot everybdy....
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Aug 10, 2007 1:29 pm
Reply with quote

Devzee wrote:
Yes you need to have a copybook, otherwise how do u know what is the data structure of your record.

Yup, you need a copybook if you are looking at data on mainframes. Now I doubt how's the OP shows following
Code:
NAME----------------------------EMPNO--DEPT-----------------AGE--------

in his/her earlier posts, without a copybook. BTY, if you open your files with valid COPYBOOK(using (F1/F2 in ISPF), the headings of COPYBOOK is always visible, only the data moves.
Back to top
View user's profile Send private message
kairaly

New User


Joined: 29 May 2007
Posts: 4
Location: TVM

PostPosted: Fri Aug 10, 2007 2:22 pm
Reply with quote

Hi all

While working in MS Excel we have the option of “freeze Panes”. By this options we can freeze
some columns and have other columns scrolling. This feature is helpful in analysis when there
are lots of columns(fields) in a file.

In mainframe too, we have similar such facility thru File-Aid.

Steps

1.Open the file in File-Aid
2. use VFMT format
3. If you want to freeze columns(fields) 1,2,3, and 6 and have the rest as scrollable
issue command HOLD 1-3,6
Back to top
View user's profile Send private message
ursvmg

New User


Joined: 24 May 2007
Posts: 52
Location: Chennai

PostPosted: Fri Aug 10, 2007 2:37 pm
Reply with quote

Hi kairaly,

The option u said is working perfectlf for columns...... But my requirement is for Rows...... i mean for horizontal freeze.,....

Hope u understand,

Correct me, if I'm wrong....
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Aug 10, 2007 6:05 pm
Reply with quote

You don't need a copybook to look at data on the mainframe. That statement is incorrect. The OP is showing his line because it is the first line in the file. He wants to freeze that to the top of his edit window. As everyone has said, that is not possible.

If you enter MASK on any line number and paste the this into the MASK line
Code:

NAME                            EMPNO  DEPT                 AGE         



Each new line will show that and you can just type over it. I removed the dashes because they would stay each time you hit enter.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Aug 10, 2007 6:09 pm
Reply with quote

Hello,

And you might create a "copybook" that supports only your data entry - never actually used in code.

However, if you are entering data in some format, i suspect that a program might then process the data after it is entered and the copybook may be useful for that program.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 10, 2007 7:03 pm
Reply with quote

you can also create a note or info line and enter (insert) data before which would give the effect of a 'frozen line' only underneath, not on top.

combined with setting a tabs line, you could do the data entry.

Also, if one were to utilize the given resources, one could use IEBDG (Test Data Generator) Program which is explained here

but that means something new......
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Fri Aug 10, 2007 7:17 pm
Reply with quote

...or if you have option 11 below

Code:

                           Utility Selection Panel                           
Option ===>                                                                   
                                                                             
1  Library     Compress or print data set.  Print index listing.  Print,     
                 rename, delete, browse, edit or view members                 
2  Data Set    Allocate, rename, delete, catalog, uncatalog, or display       
                 information of an entire data set                           
3  Move/Copy   Move, or copy members or data sets                             
4  Dslist      Print or display (to process) list of data set names.         
                 Print or display VTOC information                           
5  Reset       Reset statistics for members of ISPF library                   
6  Hardcopy    Initiate hardcopy output                                       
7  Transfer    Download ISPF Client/Server or Transfer data set               
8  Outlist     Display, delete, or print held job output                     
9  Commands    Create/change an application command table                     
11 Format      Format definition for formatted data Edit/Browse               
12 SuperC      Compare data sets                             (Standard Dialog)
13 SuperCE     Compare data sets Extended                    (Extended Dialog)
14 Search-For  Search data sets for strings of data          (Standard Dialog)
15 Search-ForE Search data sets for strings of data Extended (Extended Dialog)


then you could format the data entry
eg



Code:
Field   Start   Field   Field        Field   Start   Field   Field     
Number  Column  Length  Type         Number  Column  Length  Type       
   1    00001     30      E             2    00031     04      E       
   3    00035     12      E             4    00047     02      E       
   5    00000     00      _             6    00000     00      _       
   7    00000     00      _             8    00000     00      _       


and when you edit your dataset then you can tab between fields, thus you might not need to use a header as a guide.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top