I am trying to insert some data to my database and I am getting a right truncation error - so i turned of the error checking for the erros . The data has many international characters in it.
I now get a primary key exists because the data is truncated
This is what i am doing
// then selecting the database to see if it exists
select ...... where "name"=:ls_name
// i get the the result - not found on database
so it insert
// i get an error saying the record already exists
Is there a way of checking what the database will truncate the data to and then truncate it in powerscript ?