How do you do LIMIT in DB2 for iSeries?
We currently have a table of more than 50,000 records and we’re trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write “LIMIT 0,10000″ at the end of the query, it will bring you that record. How can you do it in...
| December 11, 2013 9:48 PM
Security testing tools and techniques
Hi, We would like to do security testing to our current project which is developed in JAVA, can you please share some information about how to start security testing, related websites, tools, techniques and any documents related to it. Thanks in Advance Regards Harish Malvi
| December 9, 2013 6:45 AM
, Software development
, Software Quality
, Software Quality Assurance
, Software security testing
, Software testing
, Software testing methodologies
, Software testing tools
Hi All, My below SQL query is running fine: - SELECT a.USRP,a.USER1, SUBSTR(a.USER1,23,3) as Template, BRCB, b.MGRP,b.ICDE,INAR,a.SECL,ACA1,ACA2,ACA3,ACA4,ACA5,ACA6 FROM muserdd as a left outer join MACBRDD as b on a.USRP = b.USRP left outer join MITEMDD as c on b.MGRP = c.MGRP and b.ICDE = c.ICDE order by a.USRP But same is giving error when I’m...
| December 4, 2013 10:35 AM
, SQL Query
Inserting multiple rows in Oracle 10g
I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...
| December 2, 2013 4:10 PM
DB2 reorgchk current statistics on table all
With help of below query we are getting output for all tables and indexes ”db2 reorgchk current statistics on table all”. But I want only those tables which we can reorg on that tables like *—*,–** etc….. Please provide me SQL query where I can see only that tables name where they require reorgs.
| November 27, 2013 1:07 PM
, DB2 database
, SQL Query
Help joining data into table 1 from table 2 SQL
I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.
| November 6, 2013 8:35 PM
, update query
Porting a C+ app from SQL to Citrix
I’m running a C# application on a number of workstations through the same MS-SQL database. I’ve been asked to port this to Citrix. How would one even get started on such a transition? Does anyone know of good documentation I could access? Once the C+ app is installed on the Citrix server, will all workstations...
| November 4, 2013 12:20 AM
How to manage SQL queries on iSeries
We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!
| October 31, 2013 3:16 PM