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

Repro'ing a dataset


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
suzeet

New User


Joined: 16 May 2005
Posts: 54

PostPosted: Wed Mar 31, 2010 9:25 am
Reply with quote

I am trying to REPRO the below records to a KSDS. While loading the lasr record '336001000790780100' comes after the first one '336001000780750100'. just curios to know why?
Code:
336001000780750100
33600100079ZAA0100
33600100079ZAB0100
33600100079ZBC0100
33600100079ZBD0100
336001000790780100
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Mar 31, 2010 9:29 am
Reply with quote

Hello,

The records were loaded "in sequence". . .

I don't understand the question icon_confused.gif
Back to top
View user's profile Send private message
suzeet

New User


Joined: 16 May 2005
Posts: 54

PostPosted: Wed Mar 31, 2010 12:30 pm
Reply with quote

I have sorted the record and trying to load. After the sort I got
[img]
336001000780750100
33600100079ZAA0100
33600100079ZAB0100
33600100079ZBC0100
33600100079ZBD0100
336001000790780100[/img]

But while loading what sequence it follows? Why the last one comes after the first record?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Mar 31, 2010 12:37 pm
Reply with quote

The sequence is the key of the KSDS.
Is the data shown the key?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Mar 31, 2010 3:56 pm
Reply with quote

I think that suzeet may be unaware of EBCDIC collating sequence.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Mar 31, 2010 4:02 pm
Reply with quote

Hello Akatsukami,

well then im unaware too about the collating sequence.
Everything looks kosher to me.
F0 (0) comes after E9 (Z)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Mar 31, 2010 4:08 pm
Reply with quote

until the TS shows the KSDS define statement everything is just useless speculation icon_cool.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Mar 31, 2010 4:10 pm
Reply with quote

PeterHolland wrote:
Hello Akatsukami,

well then im unaware too about the collating sequence.
Everything looks kosher to me.
F0 (0) comes after E9 (Z)

But if I'm understanding suzeet, he thinks his KSDS is tref icon_biggrin.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Mar 31, 2010 4:11 pm
Reply with quote

"tref" ?

Im lost here.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Mar 31, 2010 4:31 pm
Reply with quote

PeterHolland wrote:
"tref" ?

Im lost here.

Tref (in any of several romanizations) is Yiddish for "not kosher", "not suitable as food". It's derived from Hebrew trefah, "carrion" (one of a number of tref meats).
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Mar 31, 2010 5:03 pm
Reply with quote

Thats funny, my family in law in Israel never uses that word.
But then of course they only eat kosher food icon_lol.gif
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Mar 31, 2010 8:50 pm
Reply with quote

Hello,

Quote:
But while loading what sequence it follows? Why the last one comes after the first record?
Suggest you view these values in hex. This may help clarify what has happened.

To get the green-on-black presentation (see the first post), use Code rather than Img icon_smile.gif
Back to top
View user's profile Send private message
suzeet

New User


Joined: 16 May 2005
Posts: 54

PostPosted: Sat Apr 03, 2010 9:43 am
Reply with quote

Thanks you D.sch. and all. After viewing it in Hex I have to modify my Sort card.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Apr 03, 2010 10:09 am
Reply with quote

You're welcome - good luck icon_smile.gif

Someone will be here if there are any other questoins/doubts.

d
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top