Unanswered: Extracting data from ASIQ 12.5 and loading into ASIQ 12.5
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.
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.