sql code 1480 error while trying to do insert

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vishal_rastogi
Participant
Posts: 47
Joined: Thu Dec 09, 2010 4:37 am

sql code 1480 error while trying to do insert

Post by vishal_rastogi »

Hi

when i am trying to insert records in oracle enterprise i am getting the sql code as 1480
the column in which i am trying to insert is a varchar and length is 4000
i also tried the APT_STRING_PADCHAR = 0x20,0x10 but its still giving the same
please suggest!!
Vish
myukassign
Premium Member
Premium Member
Posts: 238
Joined: Fri Jul 25, 2008 8:55 am

Re: sql code 1480 error while trying to do insert

Post by myukassign »

Please post the warnings from the director.
vishal_rastogi
Participant
Posts: 47
Joined: Thu Dec 09, 2010 4:37 am

Post by vishal_rastogi »

Hi

I have added a reject file while doing this insert and in that reject file i am taking the sqlcode as one column
Vish
Post Reply