There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
Hi
my program is accesing data from two db2 databases.what
is the bind card for this program to genarate plan? how to
specify the two owners and two qualifiers in bind card
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
<?xml version="1.0"?>
<breakfast_menu>
<food>
<name>Belgian Waffles</name>
<price>$5.95</price>
<description>
two of our famous Belgian Waffles with plenty of real
maple syrup
</description>
<calories>650</calories>
</food>
<food>
<name>Strawberry Belgian Waffles</name>
<price>$7.95</price>
<description>
light Belgian waffles covered with strawberries and
whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>Berry-Berry Belgian Waffles</name>
<price>$8.95</price>
<description>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>French Toast</name>
<price>$4.50</price>
<description>
thick slices made from our homemade sourdough bread
</description>
<calories>600</calories>
</food>
<food>
<name>Homestyle Breakfast</name>
<price>$6.95</price>
<description>
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
</description>
<calories>950</calories>
</food>
</breakfast_menu>
188
How to use online Backups?
13
How to create an external table.
18
Can you instantiate a COM object by using T-SQL?
179
Write short notes on manual refreshes.
16
What are the disadvantages of cursors? How can you avoid
cursors?
962
Write short notes on XSU and JAVA
22
Write the difference between case version and decode version.
10
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
206
Hi ,
any one can help me on the same,this is regarding the
Informatica Function doc,i want to know how developer is
will develop the mapping. pl forwar the any function
doc .just for my references.
svlc75@yahoo.co.in
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
196
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?