Ggtcf

Multiplicative persistence

Why did the EU agree to delay the Brexit deadline?

When were female captains banned from Starfleet?

Offered money to buy a house, seller is asking for more to cover gap between their listing and mortgage owed

A social experiment. What is the worst that can happen?

why `nmap 192.168.1.97` returns less services than `nmap 127.0.0.1`?

Why is so much work done on numerical verification of the Riemann Hypothesis?

I am looking for the correct translation of love for the phrase "in this sign love"

What are the purposes of autoencoders?

Is it better practice to read straight from sheet music rather than memorize it?

Where did Heinlein say "Once you get to Earth orbit, you're halfway to anywhere in the Solar System"?

Closed-form expression for certain product

Why do compilers behave differently when static_cast(ing) a function to void*?

Can I sign legal documents with a smiley face?

Strong empirical falsification of quantum mechanics based on vacuum energy density

Why did the HMS Bounty go back to a time when whales are already rare?

Is the U.S. Code copyrighted by the Government?

If a character has darkvision, can they see through an area of nonmagical darkness filled with lightly obscuring gas?

Does an advisor owe his/her student anything? Will an advisor keep a PhD student only out of pity?

Pre-mixing cryogenic fuels and using only one fuel tank

Is a bound state a stationary state?

Not using 's' for he/she/it

Why should universal income be universal?

Fear of getting stuck on one programming language / technology that is not used in my country

Running multiple queries in prepared statement in batch

fetching data from a prepared statementBatch Inserts And Prepared Query Errorjdbc batch insert and query vs single inserts with gernerated keyPrepared statements while fetching prepared statementJDBC prepared statement, batch insert performance improvementPDO Prepared Statement returns 0 rows, but query works fineSingle INSERT query for multiple records using Prepared statementMysqli insert queries getting lost with prepared statementsPHP MySQL Bulk inserts by BATCH with prepared statementsBuilding Multiple LIKE Operator Prepared Statement at run-time

1

I have a scenario where i want to insert record if it doesn't exist in DB2. If it already exists update is_active column to 0 of the existing row and insert the new row with is_active as 1.

I cannot use merge into as i cannot run 2 queries in when matched section.

How can i achieve this in batch.

If i were to run queries one by one i could have run them. But since there are streaming and there around 500msg per sec, i want to do this in batch

If we use statement we could have done

statement.addBatch(sql1)
statement.addBatch(sql2)

After doing above lets say 500 times we just execute batch
statement.excuteBatch()

But we are looking for something similar in prepared statement. When we tried to do it the same way as statement it failed

prepared-statement

share|improve this question

asked Mar 8 at 4:56

AbhishekAbhishek

659

add a comment | 

1

I have a scenario where i want to insert record if it doesn't exist in DB2. If it already exists update is_active column to 0 of the existing row and insert the new row with is_active as 1.

I cannot use merge into as i cannot run 2 queries in when matched section.

How can i achieve this in batch.

If i were to run queries one by one i could have run them. But since there are streaming and there around 500msg per sec, i want to do this in batch

If we use statement we could have done

statement.addBatch(sql1)
statement.addBatch(sql2)

After doing above lets say 500 times we just execute batch
statement.excuteBatch()

But we are looking for something similar in prepared statement. When we tried to do it the same way as statement it failed

prepared-statement

share|improve this question

asked Mar 8 at 4:56

AbhishekAbhishek

659

add a comment | 

I have a scenario where i want to insert record if it doesn't exist in DB2. If it already exists update is_active column to 0 of the existing row and insert the new row with is_active as 1.

I cannot use merge into as i cannot run 2 queries in when matched section.

How can i achieve this in batch.

If i were to run queries one by one i could have run them. But since there are streaming and there around 500msg per sec, i want to do this in batch

If we use statement we could have done

statement.addBatch(sql1)
statement.addBatch(sql2)

After doing above lets say 500 times we just execute batch
statement.excuteBatch()

But we are looking for something similar in prepared statement. When we tried to do it the same way as statement it failed

prepared-statement

share|improve this question

asked Mar 8 at 4:56

AbhishekAbhishek

659

share|improve this question

asked Mar 8 at 4:56

AbhishekAbhishek

659

share|improve this question

asked Mar 8 at 4:56

AbhishekAbhishek

659

asked Mar 8 at 4:56

AbhishekAbhishek

659

asked Mar 8 at 4:56

AbhishekAbhishek

659