-
How to get through the "db2 list applications" command displays the agent_id?
To connect the database with a program many times,
through agent_id distinction, but do not know how to obtain using otl.
2009-11-12 14:49:01 UTC by billyfan
-
....sorry..... I had disabled autocommit on the otl_connect object and not on the stream. Now it works. Thanks.
2009-11-12 09:42:31 UTC by patrickjuhl
-
Yes autocommit is disabled.
2009-10-31 21:36:26 UTC by patrickjuhl
-
did you turn off autocommit on the stream and then run a commit afterwards?.
2009-10-30 21:39:12 UTC by feinbd
-
Thanks for a great c++ interface for the Oracle database.
Right now I’m converting our database interface library from Oracle OCCI to the OTL. I’m almost done but there is one crucial function that I haven’t been able to implement.
The function inserts data in a temp table (with blobs in it). When data are inserted they are moved by calling a stored procedure.
In OCCI terms...
2009-10-30 13:49:17 UTC by nobody
-
I used "rlogon" function for DB connection before, but now use "server_attach"
I've a question. which one is the best choice in multi-processor enviroment (40~50)? each of them have DB connection.
"server_attach" function more efficient?.
2009-10-26 23:23:10 UTC by nobody
-
I'm using Oracle 10g Express Edition... I forgot to put this in the first post.
2009-10-24 13:37:53 UTC by dhanuanu
-
I'm using OTL on Microsoft Windows XP (SP3).
As per the given examples RETURNING clause in an UPDATE statement is being used to put BLOB data. I could successfully write code for the same.
Now I want to use RETURNING clause for following kind of statement -
UPDATE abc
SET my_field = my_sequence.nextval
WHERE my_key = 'given value'
RETURNING my_field ...
Is it possible to get...
2009-10-24 13:34:52 UTC by dhanuanu
-
There is a void set_transaction_isolation_level
(const long int level);
But where is the get_transaction_isolation_level(...)?
How can I get the level with OTL?
Thanks.
2009-10-22 16:14:51 UTC by nobody
-
Hi folks, this question have being raised before, yet I couldn't find a helpful answer.
I want to use 'otl_nocommit_stream' for a "INSERT" statement, stream some values into it and subsequently getting somehow the ROWID of the newly created row back. I know there is a "INSERT ..... RETURNING ROWID INTO ????" syntax in Oracle, I just don't seamed to know how to apply this...
2009-10-12 06:45:58 UTC by realskydiver
