on 04-25-2014 3:07 PM
Hi all,
I'm trying to determine how to write a C program to load a client file with the "load table ... using client file..." syntax without calling out to the dbisql program to load the table. I'm probably not seeing the forest for the trees here. I know I can use the bulk api (equivalent of bcp) but would rather use the load table because it is much faster.
jason
Whats your question? You should be able to do what you want. The LOAD TABLE statement is not DBISQL specific, so you can execute it from any SQLA DB interface.
--Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Jason,
I guess my question is this: Do I have to do anything in my C program to allow for the load table from client file?
On a side note, is there a connect option or similar to disallow the load table from client file (even if the load table from client file permission is granted on the server)?
jason
There is nothing special to do - you execute the statement from your program just like any other SQL statement. The only thing to be aware of are the privilege/permission issues:
When loading from a file on a client computer:
Revoking these privileges is also the only way you can prevent a user from executing the statement.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.