ChannelDB2

August 2012 Blog Posts (3)

DB2 SQL Developer Position- New Jersey

Hi,
 
Listed below is the job requirement.
Please respond with your updated resume.
 
Title: DB2 SQL Developer…
Continue

Added by Sharon Grace on August 27, 2012 at 12:40pm — No Comments

Retrieving data as XML using stored procedure

On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here I am going to show how to retrieve data from a table as an XML document.  Using the table set of tables from the previous post lets retrieve all the order details for a given customer.  Here is a stored procedure that will take customer_id as an input and then return an xml document that has all the orders and…

Continue

Added by Raju Pillai on August 4, 2012 at 6:33am — No Comments

Stored Procedure to insert data to parent and child using XML

Couple of days back I wrote an article that showed how to quickly insert a child table with a  parent table having generated column. On this one I am going to show you how to insert data using XML as a value.  As my previous article show its easy to insert to child table , but you have to insert one row at a time. Well what if we have multiple child rows…

Continue

Added by Raju Pillai on August 4, 2012 at 6:31am — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service