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

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

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

Answer Question   |  March 26, 2013  5:27 PM
JDBC, SQL

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

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

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

Compiler
Which compiler should I use in SQL?

Answer Question   |  February 4, 2013  4:12 PM
Compiler, SQL

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

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

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

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

Debug
How to debug an SQL Stored Procedure?

Answer Question   |  November 16, 2012  1:14 PM
SQL, SQL procedure

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

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

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

Answer Question   |  October 9, 2012  4:33 PM
SQL, SQL Database

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

using SQL in RPG
I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from WFILES.RNSORDP WHERE RNSREGN > [...]

Answer Question   |  September 21, 2012  3:30 PM
AS/400, RPG, SQL

Best Technology for learn
i m the computer graduate doing job in technical support & wants to learn new technology can u suggest any new technology

Answer Question   |  August 28, 2012  4:20 AM
Mainframe, Oracle 10g, SAP ABAP, SQL

need help with measuring dates
I am trying to select records from a table where the CREATEDT field is between SYSDATE and 20 days prior. select distinct(createdt) from U_table where to_char(createdt, ‘dd/mm/yyyy’) between to_char(sysdate, ‘dd/mm/yyyy’) and to_char(sysdate – 20, ‘dd/mm/yyyy’) There are records in that table that are in the date range but the SQL is not finding them. What [...]

Answer Question   |  August 27, 2012  7:34 PM
Oracle, SQL

Using Decode in oracle sql query for Debtors Analysis Report
i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT, TRANDATE, POSTDATE, USER_ID, BATCH_ID, CONFIRMEDBY, CONFIRMDATE, COMMENTS, GLPOSTED, GLPOSTDATE, REVERSED, REVERSEDBY, REVERSEDATE, REVERSEREASON, REVERSEDTRAN_ID, [...]

Answer Question   |  June 15, 2012  8:35 AM
SQL