db2
Coalesce Function in DB2
I am using IBM DB2. I have a query which gives the output as: NAME/AMOUNT CST/- VAT/ 1400 ST/- I am trying to write a coalesce function for AMOUNT. The datatype of AMOUNT is decimal(10,2)[详细]
2023-04-08 08:54 分类：问答Why does FETCH FIRST N ROWS not work in combination with WITH statement?
I 开发者_Python百科have the following SQL statement which does not run on my DB2 database: WITH a AS ([详细]
2023-04-08 07:41 分类：问答DB2: How to print few columns with conversion along with all other columns without having to write all the names of the columns?
I have a table having 10 columns, with id, f_name, l_name ..... low_range, high_range, ... I want to write a query which will print all my table, but just this low_range and high_range to be converte[详细]
2023-04-07 02:11 分类：问答Date arithmetic in SQL on DB2/ODBC
I\'m building a query against a DB2 database, connecting through the IBM Client Access ODBC driver. I want to pull fields that are less than 6 days old, based on the field \'a.ofbkddt\'... the problem[详细]
2023-04-07 00:30 分类：问答SQL - count and percent
hit a wall on getting a count AND a percentage of total in a single query I want the TOTAL units per location AND the PERCENT of TOTAL ACROSS ALL LOCATIONS...[详细]
2023-04-06 22:21 分类：问答Help managing many-to-one results for lookup
I didn\'t see this exactly asked, so I\'m hoping it wasn\'t. I have a table that has multiple columns with code variables and a table that has all lookup codes and de开发者_StackOverflow中文版script[详细]
2023-04-06 22:15 分类：问答copying oracle tables to DB2
I want to access oracle tables in DB2(something like DBlink from DB2 to oracle).Any he开发者_Go百科lp is appreciated.You can use db2 federation. One link is here.Oracle has a feature called Heterogene[详细]
2023-04-06 20:01 分类：问答DB2 Select Query with data in file
Lets say I have a csv file(ids.csv) with ids like 101,102,103......1MILLION I wanted to select data from the table by reading ids from file in the where clause[详细]
2023-04-06 17:28 分类：问答db2 SQLCODE=-243, SQLSTATE=36001 ERROR
I am using the DB2Driver in my code like Class.forName(\"com.ibm.db2.jcc.DB2Driver\"); and I am getting the result set i开发者_Python百科n my java code which is scroll sensitive. my sql query look[详细]
2023-04-06 15:24 分类：问答Sql statement for mutually exclusive events
I am trying to run an sql statement on an iSeries that will output retuls based on a type pa开发者_如何学JAVArameter I pass in.[详细]
2023-04-06 14:19 分类：问答
加载中,请稍侯......