| Author |
Message
|
| selvaetkt |
 Posted: Sun Jul 28, 2013 9:29 pm Post subject: Doubt in icon available under .esql file |
 |
|
Novice
Joined: 25 Jun 2013
Posts: 16
Location: chennai
|
Hi all,
I have a message flow . once the message is received , it is logged into database for audit purpose. for that the compute node calls the Database read/write using parm varibales. i found the database read/write/update functions are written in the some icons below the .esql in acting working set . the icons are seemes to be blue and green like a flower. can you please explain me about this icon . whether it is database manager ? if means how to create in the toolkit . please advice me if i am wrong . |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Jul 29, 2013 3:29 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Can you point to an InfoCentre article where you learned this? Usually, to call a database, you use the in-built ESQL functions. I'm not sure what you mean by 'flower'. Where in the InfoCentre are you reading about database access from ESQL ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| selvaetkt |
| Posted: Mon Jul 29, 2013 3:56 am Post subject: Can you point to an InfoCentre article where you learned thi |
|
|
Novice
Joined: 25 Jun 2013
Posts: 16
Location: chennai
|
I am analysing the existing message flow . in this a call to database is done by the following expression
CALL DatabaseWrite(SQL_STATEMENT, 'ERR:00001', DB_IN_PARAMS);
Then i searched in search file option in the toolkit
I found the DatabaseWrite function . Once we expand the .esql file in the left side of the toolkit , i can find some circle type of icon once i click it it opens the DatabaseWrite function written code page opens .
For Compute Node ESQL we have some icon like esql in the left side of the toolkit .
For databasewrite function is also written in esql only . but why the icon is like a blue coloured circle.
For example consider , in left side of toolkit i have
default broker schema ->core.esql on expanding core.esql i found database write function like a blue colour ring . what it means . if i click that blur ring it opens the core.esql file only. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jul 29, 2013 4:03 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
What version of toolkit are you using? What version of toolkit was this originally written in?
As a practice, I never use 'default' schema. Not that it won't work, just that its better to have your code organized well.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jul 29, 2013 4:08 am Post subject: Re: Can you point to an InfoCentre article where you learned |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| selvaetkt wrote: |
consider , in left side of toolkit i have
default broker schema ->core.esql on expanding core.esql i found database write function like a blue colour ring . what it means . if i click that blur ring it opens the core.esql file only. |
Are you speaking about the 'Outline' pane ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| selvaetkt |
| Posted: Mon Jul 29, 2013 4:14 am Post subject: What version of toolkit are you using |
|
|
Novice
Joined: 25 Jun 2013
Posts: 16
Location: chennai
|
I am analysing the code using v6.1.0.4 . and it is written in the same version .
LIB_Core.esql , it is the schema name , under this i can find core.esql . on expanding this i found a blue circle , the icon is similar like thread run when we open DB2 Control Center database by giving user id and password .
Once i click this i can able to view the core.esql code . in this only databasewrite function is written.What the icon it means that is the confusion. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jul 29, 2013 4:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
I would disregard the icon. If I am reading you correctly, the icon is simply a function marker in the Outline pane.
How one connects to the database in ESQL is through the 'Data source' property of the Compute node. Single-left-click the Compute node, then select 'Properties' view. Look for the 'Data source' property, near the top of the Properties view.
Then, use mqsicvp command on the runtime broker system to determine what database that Data source is talking to.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| stevarg |
| Posted: Mon Jul 29, 2013 4:19 am Post subject: |
|
|
Novice
Joined: 20 Nov 2012
Posts: 24
|
I guess the blue color you are talking abt is the procedures written in the ESQL file.
Double clicking on them opens the esql file containing the procedure. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jul 29, 2013 4:23 am Post subject: Re: What version of toolkit are you using |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| selvaetkt wrote: |
| LIB_Core.esql |
For the benefit of future readers, my opinion is that too much emphasis is placed on code-reuse and not enough on core functionality. Its better to inline the few lines of database calls rather than move them out to a separate file. I see no benefit to putting all your ESQL functions in a single file. Better to leave them in the using Compute node's ESQL file separately. There may be exceptions to this rule. Code reuse is way overblown. As if -- once a system is in PROD, your database schema is going to change often?
I've heard argument that, putting all the ESQL in one file makes it easy to find. My rebuttal to that is, use the Eclipse search function, it works just fine.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
