SQL

embedded SQL

I need to get a grip on using the embedded SQL in an RPG ILE program using the word "CURRENT" and I need to know how this works (in laymens terms please.)

View Answer   |  Oct 11 2008   6:51 PM GMT   |  asked by Chinadoll041498
SQL, ILE RPG Dates

Connect to Unix from iSeries

I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008

Answer Question   |  Oct 10 2008   2:57 PM GMT   |  asked by BCL2008
SQL, Unix, RPGLE

MIgration to 64-bit Sql Server

What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

View Answer   |  Oct 8 2008   12:38 AM GMT   |  asked by Tomfitzrugger
64-bit, SQL, SQL Server 2000

VB 2005-SQL CONNECTIVITY

HOW DO I UPDATE A FILED IN SQL THROUGH VB 2005?

Answer Question   |  Oct 7 2008   2:40 PM GMT   |  asked by N7401
SQL Connectivity, SQL, Visual Basic

Using answer as criteria in sql server

I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially...

View Answer   |  Oct 7 2008   3:11 AM GMT   |  asked by Jeremyj54
SQL, SQL Server

oracle 9i instalation

hello guysI have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

View Answer   |  Oct 1 2008   8:38 PM GMT   |  asked by 11g
Oracle 9i, Oracle installation, SQL queries

SQL Injection Removal

How can i remove all instances of the following from my database?<script src=http://www.jic2.ru/script.js></script>thanksBosco

View Answer   |  Sep 29 2008   7:41 PM GMT   |  asked by Bosco322
SQL injection, SQL, Database security

Using SQL CLI APIs to call an sql stored procedure on an AS400

I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) .ThanksMike

Answer Question   |  Sep 26 2008   7:55 PM GMT   |  asked by I5DB2DBA
SQL, API, COBOL/400

ERP form error message on a SQL database

We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is:“FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.”Our DBA team is blaming it on a...

View Answer   |  Sep 25 2008   3:38 PM GMT   |  asked by SQL Server Ask the Experts
SQL, ERP, SQL Server errors

Not Return Any Record if Value Exists

If I have a table that has the following data (f1 & f2 are the field names):f1 f2a 1a 2a 0b 1b 2b 3I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

View Answer   |  Sep 24 2008   8:32 PM GMT   |  asked by Rjwilcox
Oracle, SQL, Oracle SQL

Linking to a table in SQL with Visual Basic

How could I link to a table in SQL using Visual Basic?

View Answer   |  Sep 23 2008   6:12 PM GMT   |  asked by SQL Server Ask the Experts
SQL, Visual Basic, SQL tables

Designing a report in SQL from an Excel worksheet

I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

View Answer   |  Sep 22 2008   3:20 PM GMT   |  asked by SQL Server Ask the Experts
SQL, Microsoft Excel, SQL Server reporting

Updating values in a table in a SQL database

I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and if the count is null, I am...

View Answer   |  Sep 19 2008   5:04 PM GMT   |  asked by SQL Server Ask the Experts
SQL, SQL database, SQL stored procedures

Questions about a SQL database with hourly transaction log backups

We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one...

View Answer   |  Sep 19 2008   4:50 PM GMT   |  asked by SQL Server Ask the Experts
SQL, SQL transaction logs, SQL Server backup

Writing a query in SQL for use in SQL Server 2005

I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

View Answer   |  Sep 16 2008   3:14 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, SQL, Query

Writing a specific query involving primary keys in SQL

I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

View Answer   |  Sep 11 2008   5:51 PM GMT   |  asked by SQL Server Ask the Experts
SQL, Query, Primary keys

Error inserting data in table

hi plz help me ,i want to insert some data in a table but some error ocurred.---------------------------------------------------------------using System;using System.Data.SqlClient;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using...

View Answer   |  Sep 10 2008   6:50 AM GMT   |  asked by Amitshukla
ASP.NET, C#, SQL

Maintaining a company table in SQL

I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time...

View Answer   |  Sep 9 2008   7:56 PM GMT   |  asked by SQL Server Ask the Experts
SQL, SQL tables

Receiving a DOS output with a Visual Basic script in SQL

I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL...

View Answer   |  Sep 9 2008   7:48 PM GMT   |  asked by SQL Server Ask the Experts
SQL, Visual Basic, DOS

how to view data in gridview with a sqldatasource

hi ,i m amiti want a help to view datasource and grideview,when i make connection in datasourse and use this connection in gridview and run it page can not display gridview structure.plz help me

Answer Question   |  Sep 9 2008   11:02 AM GMT   |  asked by Amitshukla
C#, GridView, SQL