Some interview questions

sunojsm · New User Joined: 21 Jun 2004 Posts: 48 Location: Heaven

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

Deepa.m · Active User Joined: 28 Apr 2005 Posts: 88

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.

shailendra · New User Joined: 08 Jun 2005 Posts: 10 Location: Pune

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

shailendra

durga_prasad · New User Joined: 17 May 2005 Posts: 7 Location: Melbourne

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]

rsshanmugam · Posted: Fri Jun 10, 2005 8:16 pm Post subject:

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

you can use occurs class in FD entry.