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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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