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

Difference between sync sort and dfsort


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prasad43

New User


Joined: 21 Oct 2005
Posts: 7
Location: blore

PostPosted: Mon Feb 20, 2006 9:17 pm
Reply with quote

Hi some doubts plz clarify

1) Diff between sync sort and dfsort.when we have to use then.
2)where we have used vsam.
3) diff b/w vsam and db2.
4) when are compiling db2, cobol program if db2 down then what error will come.
5)what are different types db2 versions.
6)How would u specify spanned records in cobol program.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Feb 20, 2006 10:25 pm
Reply with quote

Quote:
1) Diff between sync sort and dfsort.when we have to use then.

http://ibmmainframes.com/viewtopic.php?t=4155
http://ibmmainframes.com/viewtopic.php?t=5164
http://ibmmainframes.com/viewtopic.php?t=1184
http://ibmmainframes.com/viewtopic.php?t=7817
http://ibmmainframes.com/viewtopic.php?t=7811
Quote:
2)where we have used vsam.

How come we know... icon_lol.gif ...Well, if you are asking where to use VSAM...
VSAM is an access method used for MVS File management system. It has advantage of having Key field for every record, over than Sequential files.
Quote:
3) diff b/w vsam and db2.

DB2 is RDBMS (Relational Database Management System) and VSAM is FMS (File Management System).
DB2 allows MVS users to build, access, and maintain relational databases using SQL.
VSAM is an access method used in the MVS, OS/390 and VSE/ESA operating systems.
Quote:
4) when are compiling db2, cobol program if db2 down then what error will come.

http://ibmmainframes.com/viewtopic.php?t=5979
Quote:
6)How would u specify spanned records in cobol program.

Spanned Records ...means what ??????

Regards,

Priyesh.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Mon Feb 20, 2006 11:51 pm
Reply with quote

Quote:

6)How would u specify spanned records in cobol program.

Code:

    RECORDING MODE S

This link discusses Spanned Records
Back to top
View user's profile Send private message
mbtilak

New User


Joined: 02 Aug 2006
Posts: 1

PostPosted: Wed Aug 09, 2006 9:29 am
Reply with quote

Hi,
i have tried using the Hrecover option to recover the PDS, but the member was not in the pds, how to recover the Members of the PDS.

Thanks In advance
mbt
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 -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts JCL sort card - get first day and las... JCL & VSAM 9
Search our Forums:

Back to Top