[jira] [Updated] (DERBY-6844) SYSCS_IMPORT_TABLE for multiple table should be in one transaction

["Rick Hillegas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-6844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-6844:
---------------------------------
        Urgency: Normal  (was: Blocker)
    Description: 
We are using system procedure SYSCS_UTIL.SYSCS_IMPORT_TABLE to import data from a file. We have 30 imports of the table. 

As per understanding each call to SYSCS_IMPORT_TABLE each import is in one transaction. The transaction for complete imports i.e all the table is not achievable. 
If it is not then can we define system procedure . Can anyone please guide if  any documentation available on same. 

Thanks,
Anjana

  was:

We are using system procedure SYSCS_UTIL.SYSCS_IMPORT_TABLE to import data from a file. We have 30 imports of the table. 

As per understanding each call to SYSCS_IMPORT_TABLE each import is in one transaction. The transaction for complete imports i.e all the table is not achievable. 
If it is not then can we define system procedure . Can anyone please guide if  any documentation available on same. 

Thanks,
Anjana

     Issue Type: Improvement  (was: Bug)

Marking this as an enhancement request. As a workaround, you could write a table function which parses a csv file by re-using the logic in org.apache.derby.impl.load.ImportAbstract. Then you could populate your tables by calls like this:

create function t1VTI ...;
insert into t1 select * from table( t1VTI() ) t;

Those statements will execute within a transaction, so they can be rolled back. Information on writing table functions can be found in the Derby Developer's Guide in the section titled "Programming Derby-style table functions".

If you do end up writing that table function, please consider donating it to the community in order to help the next person who needs this workaround.

Hope this helps,
-Rick

>  SYSCS_IMPORT_TABLE for multiple table should be in one transaction
> -------------------------------------------------------------------
>
>                 Key: DERBY-6844
>                 URL: https://issues.apache.org/jira/browse/DERBY-6844
>             Project: Derby
>          Issue Type: Improvement
>          Components: Build tools
>    Affects Versions: 10.11.1.1, 10.12.1.1
>         Environment: CENTOS
>            Reporter: Anjana
>
> We are using system procedure SYSCS_UTIL.SYSCS_IMPORT_TABLE to import data from a file. We have 30 imports of the table. 
> As per understanding each call to SYSCS_IMPORT_TABLE each import is in one transaction. The transaction for complete imports i.e all the table is not achievable. 
> If it is not then can we define system procedure . Can anyone please guide if  any documentation available on same. 
> Thanks,
> Anjana



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)