Code:
create or replace procedure my_parent_proc ... ... call child_proce(params); ...
Anas Mosaad
Last Activity: Nov 10 '14, 06:31 AM
Joined: Jan 5 '13
Location: Big Blue
-
If you are using SQL PL use the call statement. Here's a pseudo code example
-
Code:db2 "select trunc_timestamp(current timestamp + cast((30 + extract(second from current timestamp))/ 60 as int) minutes, 'minute'), current timestamp from sysibm.sysdummy1"
Leave a comment:
-
Connect by is supported in DB2 in the compatibility mode. This mode was added since 9.7. If you have 9.7 or later, you can use it if you enable the compatibility. If you have earlier versions or prefer not to go in the compatibility mode, you can use the details in Serge's article referenced earlier.
9.7 ===> http://www-01.ibm.com/support/knowle...7.html?lang=en
...Leave a comment:
-
Why would u do that? THis affect all databases in the system! You may use quiesce command instead on the subject database.
Anyway, I assume it's offline backup and it was taken successfully, then you are good to go! What are the doubts you may have?Leave a comment:
-
Please check Serge's article on converting such queries http://www.ibm.com/developerworks/da...dm-0510rielau/Leave a comment:
-
Anas Mosaad replied to How do I set up the developer's client in Linux and linkage with the database serverin DB2I believe this is Oracle question, not DB2!Leave a comment:
-
Your export command is exporting IXF file, you just need to change it to DEL instead of IXF.Leave a comment:
-
I can see that you are trying to implement versioning to your operators table. If you are using DB2 10.1 you can use system period tables to implement this seamlessly by DB2 system.
If you still need to do this your own, you can call a procedure that does whatever you want.Leave a comment:
-
You can have a table function taking the start and end parameters. Please show us what you have done to help you fix the problem you have.Leave a comment:
-
I'm not sure how you do this, but you can do this the opposite way. I mean include activities from certain users that you want to audit. The audit policy can contain auth_ID, groups or even roles.Leave a comment:
-
It's weird that DB2 v 10.1 saying "NOTE: This error is only applicable to releases of DB2 prior toVersion 2"
Would you please share the code causing the issue to be able to support you?Leave a comment:
-
By command I guess u mean db2pd. Let me give you an example of collecting the buffer pools data. db2pd -d your_db_name -bufferpools. Note that the database has to be activated.
The same data but probably not the same format can be retrieved using other ways. For example, the CLP command "GET SNAPSHOT FOR ALL BUFFERPOOLS" will get the buffer pools data for you. Also SNAP_GET_BP will get the same data. The system view "SYSIBMADM.BP_H ITRATIO"...Leave a comment:
-
To my knowledge, only 9.7 and above is in support now -unless u are entitled for extended support. For DB2 9, please check the monitor table functions, snapshot views or may be db2pd command.
There are lots of stats to collect, it's not a single command to get everything. Know what you are looking for and you will find the appropriate view or table function.Leave a comment:
-
What version of DB2 do u use?Leave a comment:
-
try
Code:CALL get_maxprice(?) @
Leave a comment:
-
Only this statement is enough:
Unless you want to create dynamic tables you will use execute immediate.Code:create table abc ( empid numeric );
Leave a comment:
-
What is the field type of Date column in your email table?
Why don't you use between?
Make sure you convert to the correct type using to_date and to_char.Leave a comment:
-
Please take a look at InfoSphere Federation server classic editionLeave a comment:
-
Although you should not but you may consider looking at the SQLDBCONF file.
For more details please check http://pic.dhe.ibm.com/infocenter/db.../t0005086.htmlLeave a comment:
-
Anas Mosaad replied to SQL0723N An error occurred in a triggered SQL statement in trigger "DB2ADMIN.TRG_MQ_in DB2Please try to open a PMR with this issue.Leave a comment:
No activity results to display
Leave a comment: