Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us