|
|
| 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 |
|
 |
References
|
|
 |
Robert Sample
Senior Member
Joined: 06 Jun 2008
Posts: 941
Location: Atlanta, GA
|
|
|
|
| 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: 21
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
Senior Member
Joined: 20 Oct 2006
Posts: 1639
Location: germany
|
|
|
|
| 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: 1001
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 D.
Global Moderator
Joined: 22 Apr 2006
Posts: 2222
Location: Phoenix, AZ
|
|
|
|
| dbzTHEdinosauer wrote: |
| only to the blind. |
Your comments just blows me away..  |
|
| Back to top |
|
|
Terry Heinze
Active User
Joined: 14 Jul 2008
Posts: 176
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
Active User
Joined: 14 Jul 2008
Posts: 176
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
Global Moderator
Joined: 23 Nov 2006
Posts: 8729
Location: 221 B Baker St
|
|
|
|
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 |
|
|
|
|
