Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    South Africa
    Posts
    10

    Unanswered: Extracting data from ASIQ 12.5 and loading into ASIQ 12.5

    Hi,

    Can someone help me out with an example of extracting data from an ASIQ database (12.5) and then loading that file into another instance of ASIQ (12.5). Unfortunately - 'insert from location' - is not an option in my scenario.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

  3. #3
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25

    Smile

    Hi,

    To do that, you need to extract with a select from the source and to load into the target.
    Make a select into a named pipe (with options temp_extract_name1='file_name' and temp_extract_binary='ON') and read from this named pipe by executing the load statement with format binary.

    I have executed this and I can tell you that this is the best way to do this transfer.

    I hope you this can help you,

    Xavier

Posting Permissions

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