View previous topic :: View next topic
|
Author |
Message |
ursvmg
New User
Joined: 24 May 2007 Posts: 52 Location: Chennai
|
|
|
|
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 |
|
|
balakrishna reddy
Active User
Joined: 13 Jul 2007 Posts: 128 Location: Guntur
|
|
|
|
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 |
|
|
ursvmg
New User
Joined: 24 May 2007 Posts: 52 Location: Chennai
|
|
|
|
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 |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
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 |
|
|
hariibm
New User
Joined: 05 Feb 2007 Posts: 61 Location: Chennai
|
|
|
|
I think that would not be possible on mainframes. |
|
Back to top |
|
|
paray2x
New User
Joined: 28 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
paray2x
New User
Joined: 28 Dec 2005 Posts: 21
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Mask is pretty sweet. I found that one about a month ago myself. |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
ursvmg
New User
Joined: 24 May 2007 Posts: 52 Location: Chennai
|
|
|
|
Hi Devzee,
But this VFMT option requires a copybook it seems........ It is prompting me to enter a copybook....... |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
ursvmg
New User
Joined: 24 May 2007 Posts: 52 Location: Chennai
|
|
|
|
Thanks everybody for your suggestions........
I learned some new things through this post.
Thanks a lot everybdy.... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
kairaly
New User
Joined: 29 May 2007 Posts: 4 Location: TVM
|
|
|
|
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 |
|
|
ursvmg
New User
Joined: 24 May 2007 Posts: 52 Location: Chennai
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
IQofaGerbil
Active User
Joined: 05 May 2006 Posts: 183 Location: Scotland
|
|
|
|
...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 |
|
|
|