Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Difference between sync sort and dfsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: Difference between sync sort and dfsort
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: 1452
Location: Chicago, IL

PostPosted: Mon Feb 20, 2006 10:25 pm    Post subject: Re: HI,I have some doubts
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    Post subject: Re: HI,I have some doubts
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    Post subject: how to recover the pds and its corresponding members
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    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us