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

Difference between syncsort and Dfsort


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

New User


Joined: 07 Jul 2005
Posts: 10

PostPosted: Fri Mar 03, 2006 1:27 am
Reply with quote

Hi all,

Pls let me know the answer for these questions.

1) CAN WE CREATE PLAN THRU SPUFI?

2) TEST PLAN IN REAL TIME?

3) 801 SQL ERROR


4) 10 FILE STATUS.HOW TO SOLVE?

5) difference between syncsort and Dfsort


Regards,
S.M.Rajaeswari
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


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

PostPosted: Fri Mar 03, 2006 7:00 pm
Reply with quote

Quote:
1) CAN WE CREATE PLAN THRU SPUFI?

You can, If you can BIND a PLAN thru SQL Query... Can You ?
Please correct me, if wrong....
Quote:
2) TEST PLAN IN REAL TIME?

Means What ??
Quote:
3) 801 SQL ERROR

Is that SOLCODE you are receiving... I dont find 801 a valid SQL Code.
Quote:
4) 10 FILE STATUS.HOW TO SOLVE?

File Status Code 10 means you have reached End Of the file & still trying to READ. There was not found any records to be READ.
Quote:
5) difference between syncsort and Dfsort

http://ibmmainframes.com/viewtopic.php?t=4155

Regards,
Priyesh.
Back to top
View user's profile Send private message
SMRAJAESWARI

New User


Joined: 07 Jul 2005
Posts: 10

PostPosted: Sat Mar 04, 2006 1:10 am
Reply with quote

Hi Priyesh,

Thank you for your reply.

Regards,
S.M.Rajaeswari
Back to top
View user's profile Send private message
SMRAJAESWARI

New User


Joined: 07 Jul 2005
Posts: 10

PostPosted: Sat Mar 04, 2006 10:26 pm
Reply with quote

Hi Friends,

Please let me know the answer for these interview questions.


1. How do u decide the complexity of the program/event. Have u used any methodology

2 How do u ensure that your program's functionality remains unaltered, even though
u have deleted a para in your program.

3. What is the difference between ISO 9001 and ISO 9002

5 In ISPF besides nulls, How do you create null character at the end of data line

6. Explain exception handling and security in DB2

7. What is EraseOff


9. How do u compile a BMS Map after changing some fields in it.
How do you check its Syntax

10 How do u test the program from one break point to the next break point in one step

11 How do you retrieve the previous version of a program, write all the steps
involved in it

12 I have these fields in my specs -- > Emp-Id, Dept-No, Salary.
Write a program to count the no of employees in a department.

13 How do u convert a VSAM file into ISAM and viceversa

14 How do u ensure that data is passed from Map to the program

By checking the EIBCALEN length. correct me if im wrong.

15 I pressed update option without changing any field in the map,
Is data passes from Map to the program

16 What is Source Contr4ol Language , what are its uses

17 Can u use Renames clause any where in W-S Section or We have to use it as the last entry

18 How many bytes are required for the following declaration 05 data1
PIC S9(18) Comp-3 and 05 data2 PIC S9(19) Comp-3. Do u get compilation
error for data2

19 difference between Goback ad Exit Program

20 I coded two Symbolic parameters first one is coded correctly and second one is wrong.
After submitting the job, which one is passed the correct one or wrong one

21 What is Normalization ad How do you do it

22. What % does Project Management takes in a Project Plan

23. How do you specify a list of Loadlibs in a Job

24. When you compile a program, where will the program is loaded, Why

25. In latest MVS Version(MVS/ESA), what is the storage capacity

26 How do you do the analysis, Coding and testing of the program,
Do u use any methodology/Tools for testing

27 How many types of LRECL are there in JCL

28 Have u used IF in JCL , why do use it

29 How do u Initialize a particular element when I create an array of 1000 elements.

30 I specified access = Dynamic and tried to access a record which is not there,
How do you handle this error.

31 What is the use of String. Ca u use String to concatenate an alphanumeric
data item with numeric, / a numeric data item with another numeric data item

32 Which configuration management

33 What is Endevor, Have u used it to compile a program

34 Have u coded SQL Statements in JCL

35 What is forward scheduling and backward scheduling.

36 Which estimation methods have u used. What are the contents
of Project Management Plan
Back to top
View user's profile Send private message
SMRAJAESWARI

New User


Joined: 07 Jul 2005
Posts: 10

PostPosted: Tue Mar 07, 2006 12:23 am
Reply with quote

Hi Friends,

Please let me know the answer for these interview questions.


1. How do u decide the complexity of the program/event. Have u used any methodology

2 How do u ensure that your program's functionality remains unaltered, even though
u have deleted a para in your program.

3. What is the difference between ISO 9001 and ISO 9002

5 In ISPF besides nulls, How do you create null character at the end of data line

6. Explain exception handling and security in DB2

7. What is EraseOff


9. How do u compile a BMS Map after changing some fields in it.
How do you check its Syntax

10 How do u test the program from one break point to the next break point in one step

11 How do you retrieve the previous version of a program, write all the steps
involved in it

12 I have these fields in my specs -- > Emp-Id, Dept-No, Salary.
Write a program to count the no of employees in a department.

13 How do u convert a VSAM file into ISAM and viceversa

14 How do u ensure that data is passed from Map to the program

By checking the EIBCALEN length. correct me if im wrong.

15 I pressed update option without changing any field in the map,
Is data passes from Map to the program

16 What is Source Contr4ol Language , what are its uses

17 Can u use Renames clause any where in W-S Section or We have to use it as the last entry

18 How many bytes are required for the following declaration 05 data1
PIC S9(18) Comp-3 and 05 data2 PIC S9(19) Comp-3. Do u get compilation
error for data2

19 difference between Goback ad Exit Program

20 I coded two Symbolic parameters first one is coded correctly and second one is wrong.
After submitting the job, which one is passed the correct one or wrong one

21 What is Normalization ad How do you do it

22. What % does Project Management takes in a Project Plan

23. How do you specify a list of Loadlibs in a Job

24. When you compile a program, where will the program is loaded, Why

25. In latest MVS Version(MVS/ESA), what is the storage capacity

26 How do you do the analysis, Coding and testing of the program,
Do u use any methodology/Tools for testing

27 How many types of LRECL are there in JCL

28 Have u used IF in JCL , why do use it

29 How do u Initialize a particular element when I create an array of 1000 elements.

30 I specified access = Dynamic and tried to access a record which is not there,
How do you handle this error.

31 What is the use of String. Ca u use String to concatenate an alphanumeric
data item with numeric, / a numeric data item with another numeric data item

32 Which configuration management

33 What is Endevor, Have u used it to compile a program

34 Have u coded SQL Statements in JCL

35 What is forward scheduling and backward scheduling.

36 Which estimation methods have u used. What are the contents
of Project Management Plan

Regards,
S.M.Rajaeswari.
Back to top
View user's profile Send private message
M.Bhavani Prasad

New User


Joined: 10 Mar 2006
Posts: 6
Location: Hyderabad

PostPosted: Fri Mar 10, 2006 5:57 pm
Reply with quote

1. How do u decide the complexity of the program/event. Have u used any methodology


-- As per my knowledge
-- In general it depends on many factors like the number of databases it is accessing-for updating/retrieving/reading etc.,,
And the number of procedures it is invoking/using and the number of programs effecting n so on...


2 How do u ensure that your program's functionality remains unaltered, even though u have deleted a para in your program.

-- As a programmer it is important to maintain the existing functionality
and to maintain different versions,we make use of Version controlers

3. What is the difference between ISO 9001 and ISO 9002

-- Am not sure,i know these are certification levels

5 In ISPF besides nulls, How do you create null character at the end of data line

--

6. Explain exception handling and security in DB2
norally we have standard error handling subroutine .we just include those things before procedure division

-- In programming we take care of these exceptions like null-indicators
-- null indicators is different .
7. What is EraseOff
--???

9. How do u compile a BMS Map after changing some fields in it.
How do you check its Syntax

-- whenever u make changes to ur cobol-cics pgm we have to refresh the load module by using the cmd CEMT pgm(pgm-name) SET NEWC

10 How do u test the program from one break point to the next break point in one step

-- In expeditor we define the block from where to where exactly we want to execute after definig the blocks press F12,in one single step it debugs and show s u th eresult

11 How do you retrieve the previous version of a program, write all the steps involved in it

-- Using the version controller retrive the previous version in to ur local pds .we have several version controllers like Endevor,panvalet etc

12 I have these fields in my specs -- > Emp-Id, Dept-No, Salary.
Write a program to count the no of employees in a department.

-- In cobol-db2 pgm use select statement along with the count function
based on emp-id

13 How do u convert a VSAM file into ISAM and viceversa

-- No clue

14 How do u ensure that data is passed from Map to the program

By checking the EIBCALEN length. correct me if im wrong.

-- Ur right by EIBCALEN

15 I pressed update option without changing any field in the map,
Is data passes from Map to the program

-- Displays the same map, as it checks the MDT field for the map

16 What is Source Contr4ol Language , what are its uses

-- No clue

17 Can u use Renames clause any where in W-S Section or We have to use it as the last entry

-- We can use any where in w-s section, but only one condition we have check that it should follow the record's last data description entry

18 How many bytes are required for the following declaration 05 data1
PIC S9(18) Comp-3 and 05 data2 PIC S9(19) Comp-3. Do u get compilation error for data2

-- no compilation error occurs,since both are of same type n no issues

19 difference between Goback ad Exit Program

-- GOBACK returns control to the main program and EXIT performs nothing and indicate the end of a paragrapgh execution

20 I coded two Symbolic parameters first one is coded correctly and second one is wrong.
After submitting the job, which one is passed the correct one or wrong one

-- I couldn't get u

21 What is Normalization ad How do you do it

-- Normalization is used to eliminate the data redundancy i.e repeatition of data , go thru the normalization in db2 we just follow the five noral forms of RDBMS

22. What % does Project Management takes in a Project Plan

-- ??

23. How do you specify a list of Loadlibs in a Job

--??? i couldn't get u
in general we specify only load module in our job

24. When you compile a program, where will the program is loaded, Why

-- During Compilation it expands all the system pgms and converts the pgm into a machine readable format and linkedits with pgm and prepares a executable form called Load Module

25. In latest MVS Version(MVS/ESA), what is the storage capacity

--???

26 How do you do the analysis, Coding and testing of the program,
Do u use any methodology/Tools for testing

-- It depends for unit testing we can make use of tools like xpeditor r simply u can check by submiitin the jcls with sample data we can.

27 How many types of LRECL are there in JCL

-- Fixed and Variable

28 Have u used IF in JCL , why do use it

-- For conditional execution

29 How do u Initialize a particular element when I create an array of 1000 elements.

--????, as per my knowledge array is not get affected with INITIALIZE verb
one way is to move zeros or spaces to the particular element

30 I specified access = Dynamic and tried to access a record which is not there,How do you handle this error.

-- trying to access a record which is out of defined boundary/address space throws a SOC4 error-address exception,

-- can handle by specifying the parm = SSRANGE it gives soc4, if parm= NOSSRANGE than no error gives

31 What is the use of String. Ca u use String to concatenate an alphanumeric data item with numeric, / a numeric data item with another numeric data item
as per my knowledge it works only for alphanumeric to alphatic
32 Which configuration management

33 What is Endevor, Have u used it to compile a program
it is version controller .it will compile the program when u add the element in to endevor
34 Have u coded SQL Statements in JCL
no idea..
35 What is forward scheduling and backward scheduling.
--No clue
36 Which estimation methods have u used. What are the contents
of Project Management Plan
-- No clue


Any mistakes plz correct me!!!
Back to top
View user's profile Send private message
bright_skull

New User


Joined: 22 May 2006
Posts: 7
Location: Bangalore

PostPosted: Mon Jul 17, 2006 7:40 pm
Reply with quote

Hi Bhavani,

I'd like to add/correct few things related to your message.

For Question no. 18] PIC S9(19) Comp-3 can't exist as the maximum that the Numeral can withstand on Mainframe is 9(18); even though the storage is less than 18 bytes.

This logic is the same for scientific calculator/Computers also. So, definitely you can expect Compliation errors.

For Qstn. 34] Have u coded SQL Statements in JCL???
Yes... We can write SQL Statements in JCL. We've implemented the same in Production and it's running fine till date.
I saw the same question and an answer in another thread, but it lacked the ending with an Semi-colon (';').
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 DFSORT GUID DFSORT/ICETOOL 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
Search our Forums:

Back to Top