[
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)
