I’m running Microsoft Visual Studio 2010 Professional on a Windows 7 laptop and trying to learn C#. I’m working on recursion and want to prompt the user to enter a specific word into a console application and then use a recusive method to print each character of the user-supplied word on a separate line by [...]
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf I would need the query in figure 20 and the result in figure 21 which do not show up in the article. I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?
I’m trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I’m sure it has to do with cursors and the prepare statement in my PI. Here’s the code: pprintPrograms b dprintPrograms PI d program 10a value d spacer 10a value [...]
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. [...]
I have a table CREATE TABLE [dbo].[chart_hiera2](





