473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

sqledosd(), sqledgne() - list db directory

Hi, has anybody tried this out, I have some troubles. I want to list
(in a "c" program) all databases from the system directory, belonging
to a particular instance. For some reason, these functions always list
only the databases, belonging to the instance its name was in the
DB2INSTANCE at the moment of the start of my program. Any "attach to.."
or seting DB2INSTANCE in the program afterwards (at least on windows)
doesn't seem to make the call to switch to the next instance.
Any idea what has to be done to list several instances in a program
loop?

Nov 12 '05 #1
2 2124
Yes and it works just fine if you get the parameters right. However for
LDAP directories you need a triple of "undocumented" APIs. We got the
documentation by opening a PMR.

"dbrich" <tu***@utanet.at> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi, has anybody tried this out, I have some troubles. I want to list
(in a "c" program) all databases from the system directory, belonging
to a particular instance. For some reason, these functions always list
only the databases, belonging to the instance its name was in the
DB2INSTANCE at the moment of the start of my program. Any "attach to.."
or seting DB2INSTANCE in the program afterwards (at least on windows)
doesn't seem to make the call to switch to the next instance.
Any idea what has to be done to list several instances in a program
loop?

Nov 12 '05 #2
Hi Mark, would it be possible you mail me the documentation? At the
moment I am doing it by starting a process for every instance, but that
is not pretty and bearies other problems with it...

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Gonnasi | last post by:
With >glob.glob("*") or >os.listdir(cwd) I can get a combined file list with directory list, but I just wanna a bare file list, no directory list. How to get it? Tons of thanks in advance!
11
by: Chuck | last post by:
Is there a command that will list all of the databases for a particular instance on the local machine, whether they are activated or not? If there is no such command, is there at least a way to...
3
by: S. Han | last post by:
I'm using Directory.GetFiles to enumerate files in a directory. The problem is if you have to enumerate all files + subdirectories recursively, it takes too much memory, and it fails. Is there...
4
by: Elmo Watson | last post by:
Is there a way, with the System.IO class, to do a recursive list of a directory structure? For instance, in DirectoryInfo, you have GetDirectories and GetFiles .... In Directory, you have...
2
by: Manny Chohan | last post by:
Hi Guys, I am currently programming in Vb .net. I am stuck at point. i have a root directory C:\test which has couple of sub-folders c:\test\test1 ; c:\test\test2 ; c:\test\test1\test4 and so...
2
by: Martin | last post by:
Hi, I have implemeted a recursive function that basically iterate throught the entire file system and prints out the entire path of each directory that it come across. The only problem is the...
2
by: Jim in Arizona | last post by:
My goal, somehow, is to populate a dropdownlist with all the user names in active directory. I don't even know where to begin, really. I added a reference to System.DirectoryServices so I could...
2
by: Alex | last post by:
Hello, I'm creating a program to parse a directory and all files within that directory (including subdirectories), but 'directoryinfo' only parses the current directory. Is it possible to have...
6
by: Scott M. | last post by:
I didn't get a resolution to this in my earlier post, so I'll try again: System: Windows XP Pro. (SP2) with IIS installed and running PRIOR to VS 2008 Pro. installation. VS 2008 Pro. (full...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.