Search results for query: *

Hi, I am aware that a group by cube is not available in DB2 z/OS V8. Any idea how to realize the same in a single SQL statement ? I cannot find anything like that in DB2 z/OS V9 documentation either: does anybody know whether it is planned to be included in future versions ? Thank you very...

I have a little problem with our old DTS packages. We changed them to SSIS packages. They work as long executed in a way that all connections (i.e. file sources) are local and our sqlagent(local system user) has no problem accessing them. I would like to access a remote file system and changed...

After being away from work for quite a while I need a quick update: I have a unix client(SUN) connecting via a connect server(AIX) to zOS. for applications running on the unix(SUN) box, which CLI bindfiles I need to rebind the client or the connect server ones? Thanks a lot, Juliane

Being new on z/OS for some time I do have some problems with Explain. I tried the Visual Explain for z/OS, but since we use Version 7 database I can't even see the join predicates or any cost estimation. I am not sure this is related to that we use V7 and the product has been designed for V8...

Hi, one question: two tables: CUSTOMER and ADDRESS, address having a reference to customer. Is there a way to limit the number of addresses for each customer to lets say, 3 ? I suggested modelling address1, address2 and address3, but since the number might change this should be avoided...

I have a new database to handle. The schema is generated by a (java) persistence layer with no constraints implemented. constraints are checked by the persisitence layer within the application. In a way you could say in this project database design does (almost) not exist. Please don't blame me...

Hi everybody, I am wondering whether this is in fact something useful for us or not to be used as a client package for windows rollout. Since we need Host Support I used to take the DB2 Connect Personal Edition, stripped it down and shipped it. Does the DB2 Runtime Client actually support...

Hi, is there any option to get the information in which folder a document is ? Like, when a document is listed in 'All Documents' view, to see from which folder it actually comes from ? Or is there a function I can call which returns that information ? Juliane

some of our software is using .Net with connection strings to direct connect to DB2 databases on the host without a local catalog. this works fine as long as we don't have a location name longer than 8 chars. As I found out, the official solution would be to either change the location name on...

Does anybody know the maximum number of entrys possible in the tnsnames.ora ??