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
What is an Instance Name? What is an Instance ID?
Answer Question | June 7, 2013 12:11 AM
SQL, SQL Installation
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
How do we prevent our SQLRPGLE programs from creating so many job log records when executing?
Answer Question | May 30, 2013 3:41 PM
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
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
Need example to retrieve data from JDBC in SQL?
Answer Question | March 26, 2013 5:27 PM
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
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
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
Which compiler should I use in SQL?
Answer Question | February 4, 2013 4:12 PM
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
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
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
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
How to debug an SQL Stored Procedure?
Answer Question | November 16, 2012 1:14 PM
SQL, SQL procedure
The SQL Server mobile edition is supported on?
Answer Question | October 10, 2012 8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
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
How to create a database of prison management system using SQL?
Answer Question | October 9, 2012 4:33 PM
SQL, SQL Database
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