DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: adabas to oracle

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    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)

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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
  •  


Click Here to Expand Forum to Full Width