SQL Error Messages Questions and Answers

Recent IT Questions

1 - 20 of 30
<<PREVIOUS 1|2 NEXT>>

Pulling data from tables on different servers

I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

View Answer   |  Oct 8 2009  5:53 PM GMT
Linked SQL Servers, SQL Database, SQL error messages
asked by CO Bill

  70 pts.

SQL error

I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

View Answer   |  Sep 27 2009  4:57 PM GMT
SQLRPGLE, DB2/400, DB2
asked by Nutangujar

  745 pts.

Aren't correlation IDs ok in MSSQL for an UPDATE statement?

I'm getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I Software/Hardware used: MSSQL

View Answer   |  Sep 2 2009  4:35 PM GMT
SQL error messages, SQL tables
asked by DeloeranGuy

  55 pts.

file user open exceptions for printer file

i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help Software/Hardware used: SQLrpgle

View Answer   |  Aug 24 2009  8:12 PM GMT
SQLRPGLE, SQL Printing, SQL error messages
asked by Nutangujar

  745 pts.

SQL Error

we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.

View Answer   |  Jul 29 2009  2:44 PM GMT
SQL, SQL error messages
asked by RaqT

  5 pts.

Execute command in SQL

can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

View Answer   |  May 9 2009  6:26 AM GMT
SQL queries, SQL error messages, SQL
asked by Ash123

  5 pts.

sqlcode -727

ANY ONE KNOW WHAT -727 SQL RETURN CODEIS?

View Answer   |  Apr 6 2009  7:54 PM GMT
SQL 727, SQL error messages, SQL Return Codes
asked by Bebiii

  15 pts.

"Login Failed."

Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit "OK" they get and error that says "Login Failed." i am getting ERROR Message "Failed...

asked by Sandeepk66

  60 pts.

tell me why I'm getting the message "The multi-part identifier "134062-DB1.netFORUMSTaging.dbo.Individual.individualKey" could not be bound"

I'm trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not...

View Answer   |  Mar 6 2009  3:36 PM GMT
SQL statements, SQL Statement Syntax Errors, SQL
asked by Calvin60616

  5 pts.

My CL program is running CPYTOIMPF cmd & causes an SQL error

Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error code is 10. When I F1 on the line in the job log and then F9 for details, I see this: From program QSQCLI in QSYS, module SQLSEA, procedure SQLSetEnvAttr at stmt 5793 and To program...

View Answer   |  Feb 16 2009  4:35 PM GMT
CPYTOIMPF, SQL error messages, CL programs
asked by Jasingle

  20 pts.

SQL+ running time error

Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:\sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file "c:\sql_build_tables.txt" as show below OBJECT_TYPE ...

View Answer   |  Feb 6 2009  6:27 PM GMT
SQL Plus, SQL, SQL error messages
asked by Kchang747400

  5 pts.

SQLCODE and SQLSTAT error messages?

Does anyone know where I can find SQLCODE and SQLSTAT error numbers and messages?

View Answer   |  Jan 22 2009  2:27 PM GMT
SQLCODES, SQL error messages, SQLSTAT
asked by Vince01

  25 pts.

CPYTOIMPF - SQL ERROR

I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...

View Answer   |  Dec 18 2008  5:28 PM GMT
CPYTOIMPF, SQL error messages, SQL Call Level Interface
asked by Ann

  45 pts.

SQL SERVEUR 2005 SISS AND WHERE statement

I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

Answer Question   |  Dec 5 2008  5:24 PM GMT
SQL error messages, SSIS, SQL 2005
asked by Sqlbeg

  5 pts.

SQL Error

SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

asked by Odunsi

  5 pts.

Round GPA to tenths and remove decimal in SQL

I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0. This is what I have written, but it returns an error "too many values". Can...

Answer Question   |  Dec 3 2008  2:53 PM GMT
SQL, SQL error messages
asked by Cmyers

  40 pts.

Database SQL

During the copy paste the old data (*.MDF and *.Ldf) with current data same files. When going to open database showing error like " server: msg 945,level 14,state 2 database 'vimalind'cannot be opened becouse some of the files could not be activated." How can rectify this... Pls tell me ..

View Answer   |  Nov 28 2008  12:04 AM GMT
SQL Database, SQL error messages
asked by SAP Cum IT

  35 pts.

deployment

While running the setup on client machine, An error Number 5 occurred telling - "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections....

View Answer   |  Nov 20 2008  1:58 PM GMT
SQL Server 2005, SQL error messages, SQL scripts
asked by Pchandrachoudhary

  5 pts.

Unable to open a SQL application on two different machines

If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

View Answer   |  Sep 8 2008  8:18 PM GMT
SQL, SQL error messages
asked by SQL Server Ask the Experts

  2445 pts.

error in reunnig sql plus

when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

View Answer   |  Aug 7 2008  12:20 AM GMT
SQL, Oracle 9i, SQL error messages
asked by Krshah

  5 pts.

1 - 20 of 30
<<PREVIOUS 1|2 NEXT>>