Hi all: Just some questions about ADS support for DB2 for z/0S v8. When we try to edit a table or just go trhough the ADS tree (schema, storage -> tablespace),...
ivan.losadajuan@...
Mar 2, 2006 7:28 am
3423
Hi Ivan, ADS does not have native support for DB2 for z/OS. The DB2 connection type is for DB2 for LUW. When I say "native" support, it means that ADS is...
Hi John OK, i've connected using the generic jdbc connection type and works fine (except the table editor, the feature that we're searching) thanks Ivan ...
ivan.losadajuan@...
Mar 2, 2006 4:41 pm
3425
Hi Ivan, The table editor only works for native connections. So, this feature would not be available. -John ... Hi Ivan, The table editor only works for...
Hi John, The Oracle DBA here added four columns to an Oracle 9i table. Now when I look at the table in the schema browser on the left pane I can see those...
Hi John, ... You can only change this by changing the user you login as in the Server Registration. (There is a feature on the todo list to allow the changing ...
Hi John, You, as always, are correct. I am not logged in as LPPTEST - my login is just my name - and up until now it had always worked. I also noticed that...
Hi John, Different vendors have different database/schema concepts. On Oracle you only have one database per Instance, while on SQL Server you have multiple...
Hi John, Thanks for your illuminating response. I have spoken to my DBA before emailing you but sometimes what one really needs is to be able to ask the right...
Hi ... select field1, left() from a_table ... At this time field completion works. ... select field1, left(field1, 2) from a_table ... At this time, completion...
Hi Carlos, The problem seems to occur when you have a function with a "," in the parameter brackets. I am looking into this and will have a fix for Friday or...
Hello all, I'm new to this forum and my question maybe asked by another one(i can't find any postings usign the search) but I have a simple question regarding...
Hi John, there seems to be a bug in displaying key constraints in the table tree (Oracle 9.2, ADS 4.6.13_3). Consider the following primary key constraint: ...
Hi Andreas, Here is a fix ... http://download.aquafold.com/download/datastudio_4_6_14_2-Requires-Java-1.5.jar I've been working to optimize the schema browser...
Hi John, I was wondering about an optional feature for the results. Let's say you are querying two tables with a one to many relationship and you order the...
What I wrote came out wrongly formatted in my email so I have attached it here. Hopefully this comes out right. John customer.name1 customer.address inv.no1...
Hi John, I feel You can solve this by coding some extra codes in COBOL, say u have A.B A.C B.C Then your output should be A.B .C B.C for this read a each...
Hi Kiran, The results for ADS are in an array value, so it is easy to solve the problem by just accessing the value above it and see if it is the same to...
Hi John, I am assuming you are referring to the Grid results, correct? Would it be preferable to make the values blank, or would it be better to make the...
Hi John, If you do think this is possible, I believe it would be best to only look for reoccurring values up to a certain position (in a left to right sense)....
Hi John, I didnt get you, can you tell in detail, Dont mind Thanks Kiran G R John LH <JohnLH@...> wrote: Hi Kiran, The results for ADS are in an array...
Hi all, I am trying to connect to a DB2 v7 server with ADS and witl all parameters filled in for the connection after I hit the OK button ADS just freezes and...
Hi Djuby, This problem occurs when your JDBC driver is not compatible with the version and fix pack of your server. DB2 7 JDBC drivers are not compatible...
Hi John, You have confused me with your suggestions. From your previous email I gathered that you wanted to identify repeating values from top-to-down order...
Hi, This is the logic I would use in the ADS grid ... public String getValue(int row, int column) { if ( _gridArray[row][column] == _gridArray[row][column-1] )...
Hi guys Apologies if this is too simple! I have download this program and installed it. Connected to my SQL server databases with my website host fine. I will...
Hi Ray, The only way to rearrange the order of columns is to DROP and CREATE the table. This is a limitation on the database server. ADS doesn't DROP and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
