Page 1 of 1
SQL ERROR : Really Wierd
Posted: Wed Jan 27, 2010 1:44 pm
by dganeshm
SQL statement:UPDATE AMPSBX.dm.DATALOADHEADER SET RUNTIME = ?, ERRORCOUNT = ? WHERE (JOBNAME = ?)
SQLSTATE=IM974, DBMS.CODE=0
[DataStage][SQL Client]Parameter marker text size exceeds allocated space
JOBNAME = "CopyOfCOMPANIES_SX"
RUNTIME = 0
ERRORCOUNT = 31
Can any one tell what is the reason for the above error..
Posted: Wed Jan 27, 2010 3:17 pm
by ray.wurlod
Yes, but you've already marked the thread as Resolved, so why don't you tell us?
This will assist anyone who encounters the same problem in future.
Yes, it's a silly error, but we all make those, especially while we're learning. Don't be embarrassed about posting something that will help others.
Posted: Wed Jan 27, 2010 3:27 pm
by dganeshm
ray.wurlod wrote:Yes, but you've already marked the thread as Resolved, so why don't you tell us?
This will assist anyone who encounters the same problem in future.
Yes, it's a silly error, but we all make those, especially while we're learning. Don't be embarrassed about posting something that will help others.
I had imported the wrong table definitions and it was not matching with the ones which I was actually trying to insert....
Posted: Wed Jan 27, 2010 3:36 pm
by ray.wurlod
That'll do it nearly every time!