View previous topic :: View next topic
|
Author |
Message |
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
Hi
I use file manager to find rows those has value like
X’C345680’ which is the first column in the input file.
It is doing fine and rows are returning correctly, but value that was search criteria as X’C345680’ not shown in the output records. But rest of the record is shown properly.It seems truncated.
How can I stop it truncating in the beginning of the record ,and see full record including value X’C345680’ in output file?
I used
FCH
F X’C345680’
Thanks for your help
Regards
Leila |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
There are several problems with what you posted.
Quote: |
X’C345680’ which is the first column in the input file. |
No, it is not. The first column will consist of two hexadecimal digits and not more than two. That value could be the first FIELD in the data set, but it will not be the first column as it is too long.
Next, hexadecimal values code 2 digits per column -- so, by definition, a value of "C345680'" is NOT a hexadecimal value since it has an odd number of digits.
Also, there are cases when the first character of a data set will be used for carriage control (FBA data sets for example) and in this case they are NOT truncated -- they are used as printer carriage control. |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
Hi
To be more accurate ,I have below lines in file manager Jcl:
$$FILM FCH INPut=DDIN
F X'05444386238C' -->. My key to searching
In result I am sure that rows found correctly, as I used other tools to read the same input for the same value
But file manager output only has x’86’. Instead of X'05444386238C for all found rows.It has been truncated
Thanks for your help
Regards
Leila |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
Hi
I have below lines in file manager Jcl:
$$FILM FCH INPut=DDIN
F X'05444386238C' -->. My key to searching
In result I am sure that rows found correctly, as I used other tools to read the same input for the same value
But file manager output only has x’86’ in column 22, Column 11 through 24 seems empty only .in column 22 it has x’86’ Instead of X'05444386238C for all found rows.It has been truncated or … I really need X'05444386238C‘ in any row that has it and appeared in output.
Thanks for your help
Regards
Leila |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 734 Location: Denmark
|
|
|
|
Works for me when doing a simple test. What is the recfm and reclen for your dataset?
In which position(row) does the hex string begin?
Do you have any file manager controls set, except the $$FILM FCH line? My test ran with
$$FILEM SET WIDEPRT=YES,PRTTRANS=ON |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
Hi Willy
the dataset is on tape ,it has
DCB=(RECFM=VB,LRECL=446,BLKSIZE=32760). it has been generated by Db2 DSNTIAUL , based on DANTIAUL it is in position 1-6 or 7-12 based on load. I have no more clue as data has been archived previously !
before I tried following , those not helped
$$FILEM SET HEADERPG=YES,DATAHDR=YES,RECLIMIT=(1,446)
$$FILEM SET NOTRUNC=YES
$$FILEM FCH INPUT=DDIN
F X'05444386238C'
Today ,I tried $$FILEM SET WIDEPRT=YES,PRTTRANS=ON . below you can see the result.
=COLS>,----+----1----+----2----+----3----+----4----+----5
000022,1IBM File Manager for z/OS
000023,0$$FILEM SET WIDEPRT=YES,PRTTRANS=ON
000024,-$$FILEM FCH INPUT=DDIN
000025, F X'05444386238C'
000026,
000027, Find/Change Listing DSN: HESK.RPVR.RPVR96P1.YEARL
000028,
000029, ----- STRING(S) FOUN
000030, Record Number
000031, 47632972 f 2013-03-26-10.51.06.261081
000032, 47768534 f 2013-04-18-13.18.05.680707
000033, 93745128 f 2012-10-25-15.05.54.737997
000034, 110055631 f 2012-10-10-13.32.19.007725
000035, 120944223 f 2012-08-31-09.50.11.037967
000036, 121219352 f 2012-08-31-09.50.33.781174
000037, 132531298 f 2012-07-23-13.24.59.235755
000038, 132733642 f 2012-07-25-10.33.18.022227 |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 734 Location: Denmark
|
|
|
|
sorry, can't reproduce, what do the record 47632972 look like in hex? |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
hi
please find it as below, my concern is missing string as X'05444386238C' . that supposed to be somewhere in column 11 through 24.
----+----1----+----2----+----3----+----4----+----5
Record Number
4D889984DA9889444444444444444444444444444444444444
09536940544259000000000000000000000000000000000000
--------------------------------------------------
47632972 f 2013-03-26-10.51.06.261081
44FFFFFFFF44444444444844FFFF6FF6FF6FF4FF4FF4FFFFFF
0047632972000000000006002013003026010B51B06B261081
--------------------------------------------------
47768534 f 2013-04-18-13.18.05.680707
44FFFFFFFF44444444444844FFFF6FF6FF6FF4FF4FF4FFFFFF
0047768534000000000006002013004018013B18B05B680707
--------------------------------------------------
93745128 f 2012-10-25-15.05.54.737997
44FFFFFFFF44444444444844FFFF6FF6FF6FF4FF4FF4FFFFFF
0093745128000000000006002012010025015B05B54B737997
--------------------------------------------------
110055631 f 2012-10-10-13.32.19.007725
4FFFFFFFFF44444444444844FFFF6FF6FF6FF4FF4FF4FFFFFF
0110055631000000000006002012010010013B32B19B007725 |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
hi
please see attachment for hex value , missing string is X'05444386238C'
,0$$FILEM SET WIDEPRT=YES,PRTTRANS=ON
,-$$FILEM FCH INPUT=DDIN
, F X'05444386238C'
, |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2140 Location: USA
|
|
|
|
1. Do not use attachments. Use the Code button for ALL your samples of code, and/or input-output data.
2. For testing purposes, truncate your input dataset to 1-3 records. Print the input in char+hex format
3. Run test search with your short test dataset. Maybe, try to tun it several times, trying to find different possible strings (for testing and learning purposes).
4. Print and carefully verify the results of all test runs. Analyze: when the search was successful, and when it was not? Try to guess: why some tests produced wrong result?
5. All said above 1-4 are standard parts of any (real) developer job. Do not suppose others have to do your own job from start to finish.
6. If your results are REALLY mysterious, then present here (using the Code button!) all code used, all input data, all error/warning messages or codes, and all output results. |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 734 Location: Denmark
|
|
|
|
Those are the records reported by filemgr? We need to see at least one input record in hex. |
|
Back to top |
|
|
Leila
New User
Joined: 10 Jun 2023 Posts: 12 Location: Canada
|
|
|
|
Hi
Sorry , was not able to use code, so I attached Input file.
I used IEDDUP to copy data from tape to DASD. You can see missing string in red-box that existed in INPUT. it is only sample of the same input that I searched as:
$$FILEM FCH INPUT=DDIN
F X'05444386238C'
Thanks for your help |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 734 Location: Denmark
|
|
|
|
'not able to use code' you paste text, then mark it and hit the 'code' bottun.
I still cant reproduce your problem even after entering that hex string by hand. Not being a filemgr expert, I'm afraid I can't help. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2140 Location: USA
|
|
|
|
Quote: |
My car doesn't start.
Please take a look at the attached picture of my ignition key, and my wife in my car - when car is not starting.
Please help me: ho to fix this problem? |
|
|
Back to top |
|
|
|