IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

first column truncated in search result


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Sat Jun 10, 2023 6:54 am
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Jun 10, 2023 7:18 am
Reply with quote

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
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Sat Jun 10, 2023 7:49 am
Reply with quote

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
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Sun Jun 11, 2023 5:24 am
Reply with quote

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
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Sun Jun 11, 2023 5:14 pm
Reply with quote

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
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Sun Jun 11, 2023 6:29 pm
Reply with quote

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
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Sun Jun 11, 2023 11:24 pm
Reply with quote

sorry, can't reproduce, what do the record 47632972 look like in hex?
Back to top
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Mon Jun 12, 2023 12:23 am
Reply with quote

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
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Mon Jun 12, 2023 12:34 am
Reply with quote

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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2021
Location: USA

PostPosted: Mon Jun 12, 2023 2:09 am
Reply with quote

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
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Mon Jun 12, 2023 12:34 pm
Reply with quote

Those are the records reported by filemgr? We need to see at least one input record in hex.
Back to top
View user's profile Send private message
Leila

New User


Joined: 10 Jun 2023
Posts: 12
Location: Canada

PostPosted: Mon Jun 12, 2023 7:37 pm
Reply with quote

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
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Mon Jun 12, 2023 8:00 pm
Reply with quote

'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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2021
Location: USA

PostPosted: Mon Jun 12, 2023 9:47 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top