Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

    Unanswered: Extract IBM UniData (Pick database) data into SQL Server

    Good afternoon SQL dudes

    Does anyone have any experience of extracting data from IBM's UniData (or any post-relational\ Pick\ nested relational\ multi-valued relational database) into a SQL Server?
    More info here, here and here

    I don't (which is why I am asking) but I could imagine it being a right bugger. No need for detailed or technical info - I have no more info at this stage - just wondered if anyone has any similar experience.

    Super duper, thank you SQL troopers
    Testimonial:
    pootle flump
    ur codings are working excelent.

  2. #2
    Join Date
    Mar 2006
    Posts
    4
    Probably gonna show my age now :/ its been a while since i have done anything in Pick (over 10 years)

    If tools dont already exist to do the export the easies way would be to write a small program in PickBasic that just displayed the data to screen, and a small app that runs on the PC that initates the Pick Program, and then just captures to output to a file (from what i remember alot of pc based terminal emulation programs already do that)

    Just remember to calculate a checksum for the data, then re-calculate it from the captured files.

    If its UniData then there are ODBC drivers available that will let you connect to the data directly.

    Sorry cant be more helpfull, its been a while since i have used that technology, although i must admit, i loved working in that environment xD

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Thanks Mark - appreciated.

    Checksum is a good idea.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •