View previous topic :: View next topic
|
Author |
Message |
sunojsm Warnings : 1 New User
Joined: 21 Jun 2004 Posts: 33 Location: Andorra
|
|
|
|
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 |
|
|
Deepa.m
New User
Joined: 28 Apr 2005 Posts: 99
|
|
|
|
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
New User
Joined: 08 Mar 2005 Posts: 62 Location: Basildon
|
|
|
|
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 |
|
|
|