SQL Questions


AS/400 – SQL
I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won’t update the record. I want to check the record lock before performing the update statement. I don’t want to check the SQL code after performing the update statement. What I want is: [...]

Answer Question   |  June 7, 2013  4:07 AM
AS/400, SQL, SQL statement
asked by:
1,040 pts.

SQL installation
What is an Instance Name? What is an Instance ID?

Answer Question   |  June 7, 2013  12:11 AM
SQL, SQL Installation
asked by:
10 pts.

SQL vs RPG
We are using a huge number of SQL on our production machine. We have our back up machine equal to the production machine where is located our data warehouse based on RPG. Can you help me with arguments to defense that all SQL should be moved into RPG programs at our DW?

Answer Question   |  May 31, 2013  10:46 AM
RPG, RPG Program, SQL
asked by:
5 pts.

SQL logging
How do we prevent our SQLRPGLE programs from creating so many job log records when executing?

Answer Question   |  May 30, 2013  3:41 PM
SQL, SQLRPGLE
asked by:
5 pts.

Is there any GUI tool in Java to make a map of seats in a classroom for seat allotmment
I want to develop a graphical seat allotment software, for which I want to make a map of the area and then visually allot seats (like in cinema theaters). Is there any tool already available in Java for this?

Answer Question   |  May 16, 2013  2:39 AM
Java, Java tools, SQL
asked by:
425 pts.

Notrix formula
I have a Notrix job which is transferring data from Notes to SQL.  I have a date field that appears on the form 03/27/2013 but comes over to SQL as 27 Mar 2011.  I haven’t had too much experience with Notrix and have only done some trim formulas. I tried @Trim(@Date(FIELD)) and it brought back [...]

Answer Question   |  March 28, 2013  12:06 PM
Lotus Notes, Notrix, SQL
asked by:
10 pts.

JDBC in SQL
Need example to retrieve data from JDBC in SQL?

Answer Question   |  March 26, 2013  5:27 PM
JDBC, SQL
asked by:
40 pts.

SQL insert error in php
When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]

Answer Question   |  March 19, 2013  9:20 PM
AS/400, DB2, PHP, SQL
asked by:
1,565 pts.

Numeric value error
How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Answer Question   |  March 15, 2013  4:59 AM
ORA, ORA-06502, SQL
asked by:
10 pts.

Inventory transaction using Crystal Reports Visual and SQL
I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in [...]

Answer Question   |  March 7, 2013  3:53 PM
Crystal Reports, SQL
asked by:
5 pts.

Compiler
Which compiler should I use in SQL?

Answer Question   |  February 4, 2013  4:12 PM
Compiler, SQL
asked by:
5 pts.

Expression to insert value to a table column in SQL
My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C – (13,5) D [...]

Answer Question   |  January 17, 2013  10:11 AM
AS/400, SQL
asked by:
2,030 pts.

Entry Level Vendor Neutral SQL Certification
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.

Answer Question   |  December 18, 2012  2:54 PM
SQL, SQL certifications
asked by:
5 pts.

AS400 to Oracle query
Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

Answer Question   |  December 4, 2012  3:03 PM
AS400 Command, Oracle, SQL
asked by:
130 pts.

DFU to SQL translator
Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn’t see DFU commands but does see SQL statements.

Answer Question   |  November 30, 2012  9:21 PM
DFU, SQL, SQL statement
asked by:
10 pts.

Debug
How to debug an SQL Stored Procedure?

Answer Question   |  November 16, 2012  1:14 PM
SQL, SQL procedure
asked by:
35 pts.

SQL SERVER
 The SQL Server mobile edition is supported on?

Answer Question   |  October 10, 2012  8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
asked by:
10 pts.

Complex sort for SQL Query?
I have a table: MY_TABLE IDENTIFIER (VARCHAR) NAME (VARCHAR2) DATE (DATE) SELECT NAME, IDENTIFIER, DATE FROM MY_TABLE ORDER BY IDENTIFIER, DATE; So that works great for ordering the identifiers (basically making them look like a grouping in the output). Then sorting them by date (makes it sort within each unique identifiers results). However, the results [...]

Answer Question   |  October 9, 2012  8:40 PM
Oracle, SQL
asked by:
50 pts.

Database
How to create a database of prison management system using SQL?

Answer Question   |  October 9, 2012  4:33 PM
SQL, SQL Database
asked by:
25 pts.

Oracle first or SQL
Hello Everybody, I would like to learn Oracle. The question is: should I learn SQL before I start to learn Oracle? Why? Thankx Zaid

Answer Question   |  October 1, 2012  1:25 PM
Oracle, SQL
asked by:
40 pts.