| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| mq_crazy |
 Posted: Thu Feb 03, 2005 2:16 pm Post subject: ESQL |
 |
|
Master
Joined: 30 Jun 2004
Posts: 295
|
I am getting unresolvable database table reference error when i insert this code in ESQL. I checked the database and table ODBC connection everything is good. why is the ESQL not taking this statement???
SET OutputRoot.XML.Invoice.Data[]= (SELECT T.Column1, T.Column2 FROM Database.TEST_TABLE AS T); |
|
| Back to top |
|
 |
| JT |
| Posted: Thu Feb 03, 2005 4:13 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
It's a warning, that indicates there are references to database elements within the ESQL code, that have not been resolved against the database's schema.
As with most warnings it can be ignored, if you're confident that the database references are valid. Otherwise, you should import the database schema by switching to the Data perspective, and creating a new database connection. Once connected to the database, import the database definitions into a project, and then establish a project reference from your messageflow project to the new 'database' project. |
|
| Back to top |
|
|
| mq_crazy |
| Posted: Fri Feb 04, 2005 8:01 am Post subject: |
|
|
Master
Joined: 30 Jun 2004
Posts: 295
|
| Can you tell me on how to do that???? |
|
| Back to top |
|
|
| JT |
| Posted: Fri Feb 04, 2005 9:47 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
I thought I did.
I'll expand a little further.- Create a messageflow project, say 'Database_References_Project'
- Switch to the Data perspective
- From the toolbar, select 'Window --> Open Perspective --> Data'
- Create a new database connection
- In the 'DB Servers' window-pane, right-click and select 'New Connection', then configure your database connection
- Import the database definitions
- In the 'DB Servers' window-pane, right-click the desired table, and select 'Import to Folder', then browse the available folders and select 'Database_References_Project'
- Establish a project reference
- Switch to Broker Application Development perspective, right-click on your messageflow project, select 'Properties --> Project References', and then in the window pane on the right, select 'Database_References_Project'
That's it in a nutshell. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
