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

Some interview questions


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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

New User


Joined: 28 Apr 2005
Posts: 99

PostPosted: Thu Jun 09, 2005 5:56 pm
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
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
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: 62
Location: Basildon

PostPosted: Fri Jun 10, 2005 8:16 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Comp interview questions Mainframe Interview Questions 5
No new posts Interview Questions on Cobol DB2 program Mainframe Interview Questions 5
No new posts The Last Two Question For You To Ask ... Mainframe Interview Questions 0
No new posts Mainframe Interview Questions CICS,CO... Mainframe Interview Questions 6
No new posts Viewing executing process in NDM .. q... IBM Tools 0
Search our Forums:

Back to Top