| Author |
Message |
 Topic: SORT BY IN ESQL select Query. |
pratikp.vasani
Replies: 3
Views: 2729
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 18, 2011 9:43 pm Subject: SORT BY IN ESQL select Query. |
Hi,
I was trying to use the SORT function in the Select query but i am getting some errors.
Which is the proper way to use the SORT function in ESQL. |
| Topic: DB2 Issues. |
pratikp.vasani
Replies: 2
Views: 1817
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 08, 2011 11:43 pm Subject: DB2 Issues. |
I am inserting data into tables using ESQL coding.
But in one broker and DB2 in a system it is working fine for around 30000 rows and more upto 1 lack rows.
But the same flow in other broker and ... |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 13, 2011 2:44 am Subject: Syntax of Passthru(ROLLBACK) |
I am using PASSTHRU 'ROLLBACK TABLE {SCHEMANAME}.TABLENAME1' TO Database.{DATABASENAME};
Where the SCHEMANAME,TABLENAME1 and DATABASENAME are External variables.
When I am usind the values in pl ... |
| Topic: Environment variables usage. |
pratikp.vasani
Replies: 1
Views: 1154
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 12, 2011 1:06 am Subject: Environment variables usage. |
Hi,
I am assigning Evvironment variables with vales from the rows in the db.
They are gettinga assigned also but when I am setting some variables with the Environment variables it is not getting ass ... |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 06, 2011 5:30 am Subject: Roll back ATOMIC feature in ESQL |
Hey I have tried and it is working and my transaction mode is AUTOMATIC.
I have tried it for single table in a sample flow.I will try it out for two related tables.Hope it should work. |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 06, 2011 4:41 am Subject: Roll back ATOMIC feature in ESQL |
| I have two insert statements the first one is right and it is getting inserted into the db but the second one is wrong and the SQLSTATE is 23505 and the below IF condition is happening but the PASSTHR ... |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 05, 2011 10:28 pm Subject: Roll back ATOMIC feature in ESQL |
Can you share the complete syntax to use the ROLLBACK. I tried but it was giving errors.
And also the way to handle the DB exceptions in the code. |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 05, 2011 4:57 am Subject: Roll back ATOMIC feature in ESQL |
| ok, so any other way to deal with the above thing(Updation of primary keys and foreign keys in two tables) with the possibility of data consistancy in both the tables. |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 05, 2011 4:51 am Subject: Roll back ATOMIC feature in ESQL |
| Is there any syntax for rollback in ESQL, because I was able to get only the ROLLBACK keyword but I am not able to find the syntax to rollback the commited queries. |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 05, 2011 1:04 am Subject: Roll back ATOMIC feature in ESQL |
Yes I should have gone for the procedures itself but I have wrriten a huge code for it in ESQL and now it will be quit long thing for me to do it via database procedures.
Can you suggest something i ... |
| Topic: Roll back ATOMIC feature in ESQL |
pratikp.vasani
Replies: 20
Views: 17025
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2011 5:02 am Subject: Roll back ATOMIC feature in ESQL |
I have two tables one is the Main table having primary keys and the second is the Child table having foreign keys pointing reference towards the Main table.
I want to update the foreign key, so in t ... |
