| Author |
Message |
 Topic: Error showing in INSERT st'nwhile importing correct bar file |
pdmenon
Replies: 0
Views: 1224
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 02, 2011 5:50 pm Subject: Error showing in INSERT st'nwhile importing correct bar file |
Dear Experts,
I have a production bar file (which is of 2 yrs back), which i unzipped and imported into my workspace. When imported, in esql for an "INSERT" statement like ,
INSERT INTO ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 10:40 pm Subject: Using Database and Schema name in PASSTHRU Statement |
So when you reviewed the documentation on the PASSTHRU command, including what the TO Parameter of it does, then you reached an understanding of why it worked?
Dear Jeff,
Yes, I reviewed the doc ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 6:55 am Subject: Solved!!!! Using Database and Schema name in PASSTHRU Statem |
Did you try this.
SET Environment.Variables.DUMSHDatabase[]= PASSTHRU(DUMSHDQuery TO Database.DSN2 );
Here DSN2 is the Other Datasource.
Dear Khudania,
I will definitely ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 6:01 am Subject: Using Database and Schema name in PASSTHRU Statement |
Did you try this.
SET Environment.Variables.DUMSHDatabase[]= PASSTHRU(DUMSHDQuery TO Database.DSN2 );
Here DSN2 is the Other Datasource.
Dear Khudania,
I will definitely ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 5:02 am Subject: Using Database and Schema name in PASSTHRU Statement |
Apologies!!! It was Typo. It is "dbn1.sn1.tbl1".
I dont think its a typo, your code is doing the same...
SET DUMSHDQuery = 'SELECT DISTINCT col1,col2 FROM ' || SchemaName|| '.' || ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 3:32 am Subject: Using Database and Schema name in PASSTHRU Statement |
sn1.dbn1.tbl1
Dont you think it should have been
dbn1.sn1.tbl1
or
sn1.tbl1
I mean, how come db name preceded by schema, it should hv been opposite instead.
Apologies!!! It was Typo. ... |
| Topic: Using Database and Schema name in PASSTHRU Statement |
pdmenon
Replies: 12
Views: 10778
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 05, 2011 2:30 am Subject: Using Database and Schema name in PASSTHRU Statement |
Dear Experts,
We are trying to use "database"."schema"."tablename" in PASSTHRU Statement, using the following code:
SET DBName = 'dbn1';
SET SchemaName = 's ... |
| Topic: Transfering an XML File to a particular folder in AIX |
pdmenon
Replies: 14
Views: 7755
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Apr 19, 2011 12:17 am Subject: SOLVED:Transfering an XML File to a particular folder in AIX |
Take a user trace of the flow.
It is your job to troubleshoot this problem. This means that you need to analyze what is happening. To do that you must gather data on what is happening.
Dear J ... |
| Topic: Transfering an XML File to a particular folder in AIX |
pdmenon
Replies: 14
Views: 7755
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2011 5:00 am Subject: Transfering an XML File to a particular folder in AIX |
"this is not happening"
Hi Jeff,
It is my mistake. I should be more clear.
So, this makes the third time I have asked, and the fourth time in this specific thread you have be ... |
| Topic: Transfering an XML File to a particular folder in AIX |
pdmenon
Replies: 14
Views: 7755
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2011 3:54 am Subject: Transfering an XML File to a particular folder in AIX |
Did you restart the broker once you did this?
Dear Davies,
In ESQL, the generated XML File, will be transferred directly as:
SET OutputLocalEnvironment.Destination.File.Directory = '/home ... |
| Topic: Transfering an XML File to a particular folder in AIX |
pdmenon
Replies: 14
Views: 7755
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Apr 18, 2011 2:22 am Subject: Transfering an XML File to a particular folder in AIX |
Dear Mqjeff,
In AIX server say 'X', which has MB(6.1) installed, has generated an xml file, and I need to transfer this xml file to a particular path say:'/home/sample/' on the same server 'X'. Th ... |
| Topic: Transfering an XML File to a particular folder in AIX |
pdmenon
Replies: 14
Views: 7755
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 17, 2011 9:12 pm Subject: Transfering an XML File to a particular folder in AIX |
Dear Experts,
I have generated an XML file using MB Compute Node, and the resultant XML file should be transferred to a particular folder in AIX.
In "FileOutput" Node, I have specified ... |
| Topic: killing process of a particular message flow |
pdmenon
Replies: 4
Views: 4469
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2011 3:18 am Subject: killing process of a particular message flow |
You obviously need one of the following:-
1) some broker admin training
or
2) a competant broker admin who can tell you what you want to do is dangerous.
A flow as you are aware runs inside an ... |
| Topic: killing process of a particular message flow |
pdmenon
Replies: 4
Views: 4469
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 14, 2011 2:53 am Subject: killing process of a particular message flow |
Dear Experts,
In AIX, I want to kill a particular message flow under a set of message flows running under an EG, since I am unable to undeploy that particular message flow.
How can I do that?
If ... |
| Topic: Renaming an XML File while transfering to a file folder |
pdmenon
Replies: 2
Views: 2418
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 13, 2011 2:56 am Subject: Renaming an XML File while transfering to a file folder |
I got it.
SET OutputLocalEnvironment.Destination.File.Name = 'myid.xml';
 |
