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
 
Some interview questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
sunojsm
Warnings : 1

New User


Joined: 21 Jun 2004
Posts: 33
Location: Andorra

PostPosted: Thu Jun 09, 2005 5:35 pm    Post subject: Some interview questions
Reply with quote

hi members,

Please answer the following ,

1. What are the differences between Oracle and DB2 ?

2. Can u declare Redefines clause in File Section ?

3. Can u declare Occurs clause in File Section ?

4. can u part a number using Unstring Command ...if no..then how will u do it ?
e.g., 77 b pic 9(7) 1234056. I want to part this no. into two other data names containing the values 1234 and 56.

bye
Back to top
View user's profile Send private message

Deepa.m
Warnings : 1

New User


Joined: 28 Apr 2005
Posts: 99

PostPosted: Thu Jun 09, 2005 5:56 pm    Post subject:
Reply with quote

2.You can use redefines in FD section

3.Yes (not sure)

4. Unstring is for strings.
u can part b as

MOVE B(1:4) TO VAR1.
MOVE B(6:2) TO VAR2.
Back to top
View user's profile Send private message
shailendra

New User


Joined: 08 Jun 2005
Posts: 10
Location: Pune

PostPosted: Fri Jun 10, 2005 4:14 pm    Post subject:
Reply with quote

4) UNSTRING is for string only. You can't use it for numeric seggregation.

shailendra
Back to top
View user's profile Send private message
durga_prasad

New User


Joined: 17 May 2005
Posts: 7
Location: Melbourne

PostPosted: Fri Jun 10, 2005 4:44 pm    Post subject: Re: Some interview questions
Reply with quote

Hi
if that is numeric, u can redefine by breaking two numeric values. otherwise you can move to alphanumeric variable and reference move

Durga[/list][/code]
Back to top
View user's profile Send private message
rsshanmugam

New User


Joined: 08 Mar 2005
Posts: 54
Location: Chennai

PostPosted: Fri Jun 10, 2005 8:16 pm    Post subject:
Reply with quote

In oracle u can drop a column after creating it where as in DB2 u cant.

you can use occurs class in FD entry.
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm

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