V6R1 restore Opt 21 to replacement box
I have a complete Opt 21 save tape from my current 520 running V6R1. I have the following license pgms installed…Performance tools, DB2 query & SQL Dev kit, WDS, Client access. We found another 520 box(hardware upgraded), it has been wiped clean , no OS. Can I use our opt 21 tape and restore it to [...]

Answer Question   |  June 10, 2012  9:02 PM
DB2, SQL development, Tape Backups, V6R1

unable to create a connection to DB from SQL developer
Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked “Test”, it was success. But when tried connecting, no response. Also tried importing the connections, but throwing “java.lang.NullpointeException”. What might be the issue?

Answer Question   |  May 2, 2011  6:46 AM
SQL Database, SQL Developer, SQL development

Getting password when we know Product Code and Serial in Pl/SQL Developer
Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

Answer Question   |  September 13, 2010  8:31 PM
PL/SQL Developer, Security in 2010, SQL Developer, SQL development, SQL passwords, SQL Security, SQL Server

search a data in database
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name . [strong]Is there a query to find the table and column which contains that data[/strong]

Answer Question   |  June 9, 2010  4:27 AM
Database query, SQL development

SQL server query to search for table and column data in database
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

Answer Question   |  June 9, 2010  4:40 AM
SQL Database, SQL Developer, SQL development, SQL Server Query

STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

Answer Question   |  October 20, 2009  4:16 PM
CL, SQL, SQL development, STRQMQRY

SQL image data type
Hello expert, I have a developer using .NET front end then call function with image data type to load data into #temp table. He said that will be easy. I need help with few questions. 1. Using image, xml and ntext, will those data type effect performance. 2. If I do not want to use [...]

Answer Question   |  June 19, 2009  2:12 PM
.NET development, SQL development

I want to select months from Jan to Dec using SQL query
I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

Answer Question   |  April 19, 2013  9:04 AM
SQL development, SQL queries

What is the difference between software package in SQL and PL/SQL
why is the need of psql when the sql is already avaliable.

Answer Question   |  March 30, 2009  7:43 AM
Oracle SQL, PL/SQL, SQL, SQL development

Custom alert messages with SQL
sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?

Answer Question   |  March 11, 2009  4:14 AM
SQL custom message, SQL development

SQL Developer Views and Programs
I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn’t returning anything. [...]

Answer Question   |  February 10, 2009  2:44 PM
AS/400 SQL View, SQL Developer, SQL development, SQL statements

Query performance and tuning
Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when [...]

Answer Question   |  December 29, 2008  9:34 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements

Need SQL query
Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?

Answer Question   |  November 21, 2008  8:36 AM
SQL development, SQL Query, SQL tables

Get all table names by SQL
Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

Answer Question   |  April 17, 2013  7:34 AM
Bib tables, SQL, SQL development, SQL Query