SQL ERROR : Really Wierd

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dganeshm
Premium Member
Premium Member
Posts: 91
Joined: Tue Aug 11, 2009 3:26 pm

SQL ERROR : Really Wierd

Post 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..
Regards,
Ganesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dganeshm
Premium Member
Premium Member
Posts: 91
Joined: Tue Aug 11, 2009 3:26 pm

Post 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....
Regards,
Ganesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That'll do it nearly every time!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply