| Author |
Message |
 Topic: Query to insert multiple data in Oracle through ESQL |
varshasvin
Replies: 5
Views: 6067
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 12, 2008 3:19 am Subject: Query to insert multiple data in Oracle through ESQL |
| PASSTHRU 'Insert into STG_ZGLUPLOAD_OUTPUT (SYSTEM_ID,SEQUENCE_ID,ITEM_CODE)(select SourceSystem,Accounting_Doc_Line_Item_No,Line_Item_Code from Environment.Variables.OutputLineItem)' TO Database.{ext ... |
| Topic: Query to insert multiple data in Oracle through ESQL |
varshasvin
Replies: 5
Views: 6067
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 12, 2008 3:02 am Subject: Inserting Batch of data into database |
I have tried with PASSTHRU but...that is also giving runtime exception that "Invalid Database specification "
Can u tell me any other way to insert the Batch or chunks of data into databa ... |
| Topic: Query to insert multiple data in Oracle through ESQL |
varshasvin
Replies: 5
Views: 6067
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 12, 2008 2:41 am Subject: Query to insert multiple data in Oracle through ESQL |
Anybody knows the syntax of query to insert multiple rows in the database?
I have tried following query in Database System :
Insert into STG_OUTPUT (SYSTEM_ID,SEQUENCE_ID,ITEM_CODE)(select Sourc ... |
| Topic: Using Multiple databases (Oracle and DB2) |
varshasvin
Replies: 8
Views: 5608
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 13, 2008 11:28 pm Subject: Using Multiple databases (Oracle and DB2) |
| We specify a data source into Compute code if there is one database and if there are two databases Oracle and DB2 from which tables to be fetched then how to define two data source names for two diff ... |
| Topic: Problem with JText adapter |
varshasvin
Replies: 1
Views: 7377
|
Forum: WebSphere Interchange Server + Adapters Posted: Mon Mar 17, 2008 10:43 pm Subject: Problem with JText adapter |
Hi,
In this scenario, JText adapter is picking up a data from queue and writing it into a file with .CSV extension in Unix directory e.g /out and IRMS flow is polling to this /out fold ... |
| Topic: Using multiple instances of JDBC adapter |
varshasvin
Replies: 2
Views: 5837
|
Forum: WebSphere Interchange Server + Adapters Posted: Thu Feb 28, 2008 10:37 pm Subject: Using multiple instances of JDBC adapter |
Can anyone know how to use multiple instances of JDBC adaper?
Please help me in that. |
| Topic: Performance issue due to bottleneck JDBC Adapter |
varshasvin
Replies: 4
Views: 6285
|
Forum: WebSphere Interchange Server + Adapters Posted: Thu Feb 28, 2008 1:18 am Subject: Performance issue due to bottleneck JDBC Adapter |
Can I solve this issue using multiple instances of adapter?
If yes then , how can i do it? |
| Topic: Performance issue due to bottleneck JDBC Adapter |
varshasvin
Replies: 4
Views: 6285
|
Forum: WebSphere Interchange Server + Adapters Posted: Thu Feb 28, 2008 1:01 am Subject: Performance issue due to bottleneck JDBC Adapter |
Thnanks,
In this case only one instance of adapter is running |
| Topic: Performance issue due to bottleneck JDBC Adapter |
varshasvin
Replies: 4
Views: 6285
|
Forum: WebSphere Interchange Server + Adapters Posted: Wed Feb 27, 2008 11:40 pm Subject: Performance issue due to bottleneck JDBC Adapter |
Hi ,
I think you were facing problem of bottleneck in JDBC adapter due to huge data coming from database.
I am also facing same problem. In my case the data is really huge, its about 120,000+ docu ... |
