|
View previous topic :: View next topic
|
| Author |
Message |
mf_raghuram
New User
Joined: 23 Dec 2005
Posts: 2
Location: bangalore
|
|
|
|
Hi,
If a file have million records with key ws-empno which is comp-3 field.
Now I open a file at 3.4 option and want to find a record where ws-empno value is 1234.
How can I achieve this since the value in file will be like junk.
Regards,
Ram. |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Assuming you're using VIEW or BROWSE mode, the command
should work fine. You may need to put column start and end values between the FIND and the value, though -- depending on what the data in the file looks like other than the key. |
|
| Back to top |
|
|
sudhakar84
New User
Joined: 20 Jun 2008
Posts: 25
Location: chennai
|
|
|
|
Usualy we used to look the record with a layout in the FILE-AID.
or else move the variable of type numeric and write it. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
... since the value in file will be like junk
|
only to the blind. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| sudhakar84 wrote: |
or else move the variable of type numeric and write it. |
COMP-3 IS DEFINITELY A NUMERIC TYPE. If you are a mainframe programmer and you can't handle COMP-3 you are in the wrong profession. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| dbzTHEdinosauer wrote: |
| only to the blind. |
Your comments just blows me away..  |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
[quote="dbzTHEdinosauer"]
| Quote: |
| only to the blind. |
 |
|
| Back to top |
|
|
kespra
Currently Banned
New User
Joined: 03 Jun 2008
Posts: 24
Location: bangalore
|
|
|
|
| Put HEX ON in command prompt, then you see the value of Comp3 |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Also, don't forget the HEX DATA command (horizontal hex instead of vertical hex). Easier to read for people who are half blind, Dick. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
If a file have million records with key ws-empno which is comp-3 field.
Now I open a file at 3.4 option and want to find a record where ws-empno value is 1234. |
Suggest you do what you need in batch rather than online. . .
Trying to work with a million records in the editor makes little sense and wastes a lot of resources. . .
You could create a file of selected records (using your sort product) and use the subset in the editor. |
|
| Back to top |
|
|
|
|
