db2
Need free db2 (mainframe) query tool
I thoug开发者_如何学Cht TOAD Freeware would be a good choice, but it doesn\'t support ZOS (mainframe?) connections, only the paid version.[详细]
2023-03-29 21:42 分类：问答SQL JOIN problem joining same table
Here is my mock up data: Groups: MAINGROUP SUBGROUP 1A 2A 3A 1B 2B 3C 1D 2D 3D 2E 3E I\'m trying to write a query that will return me one row per SUBGROUP, with one field for each MAINGROUP displ[详细]
2023-03-29 21:34 分类：问答generate id for self referencing table hibernate mapping
Hi I have a table on DB2 database as follows: id (PKey) doc_id(FKey pointing to id) not null This is a strange legacy table that I cannot change. I cannot write/modify triggers either.[详细]
2023-03-29 15:25 分类：问答group by with where not working
SELECT A.ID, A.COLUMN_B, A.COLUMN_C FROM A WHERE A.COLUMN_A IN ( SELECT A.COLUMN_A FROM B INNER JOIN A ON B.\"COLUMN_A\" = A.\"COLUMN_A\"[详细]
2023-03-29 08:33 分类：问答Re-using parameters in Ole DB?
I\'m writing an Ole DB command and I need to repeat one particular parameter. Basically the situation is that I can\'t control the parameters that are passed in (this is handled by a (horrible) framew[详细]
2023-03-29 08:15 分类：问答How do I use Ruby on Rails 3.1 with DataMapper on JRuby with a DB2/400 database? [closed]
Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2023-03-28 22:57 分类：问答Multiple Join Multipliers
I have 3 tables: Insurance Policies, Claims and Receivables I need a query that will return one row per policy period per policy. The query needs to include the policy start and end date, total claim[详细]
2023-03-28 16:20 分类：问答Import command in DB2
In DB2, I have one table: CREATE TABLE test ( test_id INTEGER NULL, test_name VARCHAR(255) NOT NULL, test_test VARCHAR(255))[详细]
2023-03-28 15:33 分类：问答Efficiently detecting concurrent insertions using standard SQL
The Requirements I hav开发者_如何学编程e a following table (pseudo DDL): CREATE TABLE MESSAGE ([详细]
2023-03-28 08:52 分类：问答Apache Derby Lexical Error on #-sign?
I\'m programmatically transferring data between a DB2 server and an Apache Derby (JavaDB) server. The DB2 server has a number of tables w开发者_运维问答ith column names that include the pound sign (#[详细]
2023-03-28 07:45 分类：问答
加载中,请稍侯......