-
adabas to oracle
How do i convert adabas table structure to oracle table structure.?
data type mapping
i will attach adabas tests.fdu file for more info (DDM speific)
db=24,file=55,name=tests
isnsize=4,maxisn=30000,reuse=(isn,ds),datapfac=5,assopfac=10
dssize=75b,nisize=10b,uisize=4b,noformat
fields
1,g1
2,bn,25,a ; bill
2,pd,5,a ; pind
2,fg,2,b,fi ; fgrp
2,s1,2,b,fi ; spare
2,se,1,b,fi ; service
2,sn,1,b,fi,de ; swnum
2,sq,2,b,fi ; seqnumber
2,ap,1,b,fi ; anstpe1
2,st,1,b,fi ; servtpe
2,od,4,b,fi,de ; origidate
2,rd,4,b,fi ; rxidate
2,dd,4,b,fi,de ; discadate
ac=bn(1,7),pd(1,3) ; auth code
ad=bn(1,7),pd(1,3),dd(1,4) ; authcode date
uk,uq=bn(1,7),pd(1,3),sn(1,1),sq(1,2),od(1,4) ; unique key to prevent duplication
end_of_fields
Pl, help me in this regard (adabas to oracle coversion)
-
Probable not a lot of adabas experts here , I suggest : talk with a adabas expert, find what kind of information lies in each adabas datatype (ie, datatype xxxxxx in adabas contains strings ANSI, datatype yyyyyy contains number represented in this way, datatype zzzzz contains zoned numbers.... With this info, you can make the correspondence with the Oracle datatypes, listed in the Oracle "SQL Reference" manual.
[]s
Chiappa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|