SQLCODE -10000 (10k)

Mar 24, 2008

Hi,
Having this sql=-10000 on this statement below, which referes to some mismatch between columns and host-vars.
This runs from MicroFocus program against SQLServer'05 table, all hosts are well defined, same picture.
Interesting thing is that if I change ws-volume for literal, eg.
B3M_VOLUME = 21 it will work fine, but doesn't work with B3M_VOLUME = :WS-VOLUME:

--------------------

EXEC SQL
SELECT *
INTO :DCLVB3M-BASE
FROM VB3M_BASE
WHERE B3M_REMSEQ = :WS-REMSEQ
AND B3M_LOCSEQ =
(SELECT B3M_LOCSEQ FROM VB3M_BASE
WHERE B3M_REMSEQ = :WS-REMSEQ
x2 AND B3M_VOLUME = :WS-VOLUME
x1 AND B3M_BUST <> :WS-BUST)
END-EXEC.

------------------
also anybody can point to good place to see list of all sql codes:

Tx all
dai

View 2 Replies


ADVERTISEMENT

Sqlcode/sqlstate In Vb6

Apr 27, 2004

can anyone send me the syntax of how to use sqlcode / sqlstate to handle sql operation success in vb6 code ??, any other error handlers will also do the job ...

thank you in advance

View 1 Replies View Related

Error Sqlcode 8180

May 8, 2008

hi
i have table in sql2005 following error in aplication log

Error sqlcode 8180 (sqlstate: 42000, Return code: -1, diagRecNum: 2) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Flushed at MSQLmsql_error.c : #544.

View 2 Replies View Related

Update 10000 Fields

Nov 15, 2007

I have a list of 10000 websites that need to be updated with certain data.

So my question is would i be able to get SQL to lookup a certain list of websites? And then me update the required fields?

Its prob an easy answer, thanks!

View 9 Replies View Related

390 Tabels In Database And 10000 Transaction A Day Is It A Lot?

Oct 23, 2001

From Sql server point of view 390 tabels in database and 10000 transaction a day is it a lot ?

At what point performance starts slow down ?

View 2 Replies View Related

Package Dies After About 10000 Seconds.

Apr 24, 2006

I have written a package that archives off old orders over night, it appears that this package is failing after about 10000 second every time it is run. I don't think it is memory as I am running it and checking for memory leaks.

Basic run down of package is

EXEcute SQL task to get orders to delete

If a for loop, loop each ordernumber

within the for loop there are 2 dataflow

dataflow 1

find related records in child tables (oldb connection using query)

using a mutli split first

check (with lookup) for records already in archive database

only copy on a fail from the look up

second

delete related records

dataflow 2

do the same but for the parent table



SP1 CTP is installed on server.

Any ideas?



View 4 Replies View Related

Updating More Than 10000 Records SQL Server 2000

Jul 20, 2005

Hi allI just ranUPDATE dbo.tbl_forecastedSET update_ref = 0but it only updated the first 10000 records. I'm wondering if anyone cantell me why this is, and can I get around it.I have looked on google and found a few references, but nothing in too muchdetailsthanks in advanceAndy

View 2 Replies View Related

Format Number With Thousands Separator? 10000 --&&> 10,000

Oct 24, 2007



I would like to select a BIGINT type and get a formatted result with commas. Anyone have ideas?

declare @i bigint
set @i = 123456789

select @i

--Would like to get
123,456,789

View 39 Replies View Related

Can Any One Tell Me How To Delete Data In Batches Of 10000 From A VLDB Table

Nov 14, 2001

Hi,
I would like to delete a data from a 750million row table in chunks of 10000,without blocking the users.As ours is a 24/7 shop I donot want to block the users for a long time.
Answer for this is highly appreciated.
Thanks
Samna

View 3 Replies View Related

SQL 2012 :: Automating Server Patching For More Than 10000 Instances

Nov 4, 2014

Is there any Best Practice, 3rd Party Tool for Automating SQL Server Patching for around 10000+ SQL instances.

It is very difficult to do the same manually because each server will consume atleast 1-2 hours and if this is completely done manually then n number of people might be required for accomplishing this task which doesn't looks feasible at all.

View 5 Replies View Related

Batch Insert 10000 Rows At A Time And Commit

Jul 20, 2005

I want to Insert 10000 rows at a time and commit in sql server , Isthere a way to do it if the source tables have no id fields ?What would be the most efficient method?ThanksAjay

View 1 Replies View Related

SSRS Report Generator Hangs If There Are Around 10000 Pages That Needs To Be Converted To A PDF

Sep 25, 2007



Hi,
I am using SSRS to generate a 4 page statement... So i have a plan whose no. of Participants is 3271 rows... so While we try to export them to a PDF we will have around 13084 pages... but we cannot export so many pages at one time (it craps out). so right now we are breaking it up by start part and stop part and creating a pdf..

Is there a way that SSRS can handle so many pages at one go without any problems... if so how ??

Regards
Karen

View 18 Replies View Related

Insert 9900 Records Out Of 10000 Records Using DTS

Nov 28, 2005

I tried to port 10000 records using DTS. After porting of 9900 records I got an error and comes out without any result. But I want to keep the records which has been ported till the error occured. Plz help me.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved