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
 

 

Freezing a particular line in the dataset
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
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    Post subject: Freezing a particular line in the dataset
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: 130
Location: Guntur

PostPosted: Thu Aug 09, 2007 12:01 pm    Post subject:
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    Post subject: Re: Freezing a particular line in the dataset
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: 2360
Location: Israel

PostPosted: Thu Aug 09, 2007 12:35 pm    Post subject:
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    Post subject: Re: Freezing a particular line in the dataset
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    Post subject:
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

Site Director


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

PostPosted: Thu Aug 09, 2007 10:58 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Senior Member


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

PostPosted: Fri Aug 10, 2007 1:29 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Aug 10, 2007 6:09 pm    Post subject:
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    Post subject:
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts Allocate dataset withour BLKSIZE Susanta CLIST & REXX 2 Thu Sep 22, 2016 11:51 am
No new posts Insert Lines in JCL with Rexx after a... Willy Jensen CLIST & REXX 3 Tue Aug 30, 2016 4:18 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm


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