inserting string value in to table

Teradata Applications
Enthusiast

inserting string value in to table

Hi All,

i am just  trying to insert the million records if values into table but having the issues with this

i had the data in this formate 'PYE:879'-"sd4696' and i am not able to insert the records

Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879'-"sd4696');

Can you please help on this issue

Thanks

3 REPLIES
Junior Supporter

Re: inserting string value in to table

Seenu:

You'll have to escape the single quote between the '9' an the '-' : '...9'-"...'

Cheers.

Carlos.

Teradata Employee

Re: inserting string value in to table

The Single quote after digit 9 is causing the issue becuse string terminates there due to that. Either remove it or add one more if one single quote is needed.

Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879''-"sd4696');

Enthusiast

Re: inserting string value in to table

Thanks guys for replying back.

The issue is single quote after 9 and this thorwing the error and the data has been fixed from the soruce after identifying the issue.