istar data loads 
Author Message
 istar data loads

--
Art S. Kagel

Any organism which has ceased to grow, has begun to die.


Quote:
> This is a pretty simpe question, but I haven't been able to find an answer
--
> how can I select from database A into database B through istar without
> getting a long transaction???  From what I understand, 4gl does not support
> "insert into" into a for loop (to put start a counter to commit every 5 or
> 10K).  Is that accurate??

> We're trying to avoid unloading from one database, then rcp-ing the .unl
file
> and loading back into another database.

> Any ideas??  Any pieces of code?  Anything.......???????

Get my submission to the IIUG Software Repository, named utils2_ak.  It
contains
a program, dbcopy.ec which does just what you want.  It is VERY fast, commits

every N rows and can even copy between databases with different logging modes
(ie
from a non-logged database to a logged one).

Art S. Kagel



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Istar to Istar connection problem

2. Problems loading data: LOAD vs. DTS

3. Loading Xml Data returned from the query loaded into recordset

4. loading data dump from ASE 11.9 to ASE 12.0 sets it to offline after load

5. Error loading data via BUTIL -LOAD

6. Loading data from non-relational data stores

7. loading data into a table from an external data source

8. Reset source of data for Data Report on Load

9. Data Loads for High availability data warehouse

10. how to import/load multi-line data into a column (basically data has newline)

11. Data Admin utility - data loading

12. Big Istar Performance


 
Powered by phpBB® Forum Software