AS400 ILE program with Embedded SQL
I need to load a file based on several search criteria and then use the file to display in a subfile

Answer Question   |  March 24, 2011  1:13 PM
ILE, SQL

can a file be loaded from an embedded sql statement?
can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

Answer Question   |  August 29, 2008  6:28 PM
SQL, SQL statements

WRKDBF replacement?
Does anyone know of a good, free alternative to WRKDBF? I’ve been using it for years. However we just upgraded our business software. In this new version it has ISO date fields. For those fields that are null (essentially are 0001-01-01), WRKDBF can’t handle it and blows up. I’m NOT a programmer by any means [...]

Answer Question   |  December 9, 2011  4:01 PM
SQL, WRKDBF

How to get local time of a SQL server?
Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

Answer Question   |  August 27, 2008  8:03 AM
C#, SQL, SQL Server

how to get database name?
hi i am using th sql statement “SELECT * FROM MASTER..SYSDATABASES” but i want for perticular username and password

Answer Question   |  August 27, 2008  6:04 AM
Database, SQL

SQP file members
Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

Answer Question   |  August 26, 2008  4:04 PM
AS/400 and SQL, OVRDBF, SQL

Duplicate Sql
Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

Answer Question   |  September 2, 2008  3:40 AM
Oracle development, Oracle PL/SQL, SQL

DB2 Select on a large number of rows/
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the [...]

Answer Question   |  September 22, 2009  3:52 PM
DB2, JCL, SQL

When do I use a collection instead of a table
I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists. I was wondering if that is the most efficient way in [...]

Answer Question   |  September 11, 2008  2:51 PM
Oracle 10g, SQL

Problems with the SQL query function
I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id=’1001′,” it returns 1002, 1003 and 1004. [...]

Answer Question   |  August 22, 2008  4:16 PM
Query, SQL, tables

Why sqlcode error=100 comes ?
sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

Answer Question   |  August 21, 2008  3:58 PM
Informix, ISAM, SQL, sqlcode error=100

VB updates to DB2 table.
Why does as DB2 table need journaling when doing updats from VB SQL? Our setup is SQL, link server, local DSN to AS400.

Answer Question   |  June 16, 2010  1:11 PM
Journaling (AS/400), SQL, VB

SQL insert statement
Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement [...]

Answer Question   |  August 20, 2008  6:08 PM
ASP, INSERT statement, SQL

Retrieving values from a table in SQL
I have values stored in a table in SQL this order: -99.4%, 99.5%, -99.6%, -99.7%, 99.8%, 99.9% I’d like to retrieve them in this order: -99.4%, -99.6%, -99.7%, 99.5%, 99.8%, 99.9% The ORDER BY clause does not do so. Is there another clause I could use?

Answer Question   |  September 26, 2008  6:46 PM
SQL, SQL tables

to write code
i have created a table “stu” in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it prompts the user [...]

Answer Question   |  September 22, 2008  11:06 AM
Oracle SQL, SQL

SQL
I have some duplicate rows in my SQL database table, Please Tell me how’ll delete duplicate

Answer Question   |  August 18, 2008  8:58 AM
Duplicate records, SQL

free software for measuring disk I/O
Hi, any recommendations for a free software to: Measure disk I/O & SQL Server statistics from many server at once + make graphs of the data?

Answer Question   |  August 14, 2008  6:21 AM
Disk I/O, SQL

How Do I Fix A Implicit conversion Error
I got the following error on the first line and I’m not sure why. The appropriate fields in both tables (oas_balance and oas_testit) have the same data-types. Could it be an out of order thing? ERROR: Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to run this query. [...]

Answer Question   |  August 14, 2008  12:37 AM
Implicit Conversion Error, SQL

How Do I assign a value if a value in the field is empty
In my script (that is not working yet) I want to make sure if “full_value” (a field) is empty in a particular record then the value zero will be inserted. This is working in Access, but I’m trying to rebuild the query in SQL. Thank you. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, oas_balance.el2, oas_balance.full_value, CASE WHEN balcode [...]

Answer Question   |  August 13, 2008  12:31 AM
CASE statement, SQL, SQL Query

Access databases
I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

Answer Question   |  August 29, 2008  2:26 PM
Access Database, Microsoft Access, SQL, SQL Server 2000