|
|
| Author |
Message |
sunojsm
Warnings : 1
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 |
|
| Back to top |
|
 |
References
|
 Posted: Thu Jun 09, 2005 5:35 pm Post subject: Re: Some interview questions |
|
|
|
|
Deepa.m
Warnings : 1
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. |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
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] |
|
| Back to top |
|
|
rsshanmugam
Active User
Joined: 08 Mar 2005
Posts: 53
Location: Chennai
|
|
|
|
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 |
|
|
|
|
