bnfusa
Member
First of all let me say I am new to Enterprise One, I have been developing/using World from 87 for quite a time and we are now upgrading.
That said I have normally been able to perform a SQL insert statement to populate tables in the old AS400. But when I am performing a insert into a z file on the new iSeries so that I can upload al our old customers I get a error.
[SQL0420] Character in CAST argument not valid
I have looked over my statement and it all seems to be right, but I always get the error. I know I can use SQL to insert data into the new system because I created a table and then tested my commands.
Can anyone help a newbie to Enterprise One?
That said I have normally been able to perform a SQL insert statement to populate tables in the old AS400. But when I am performing a insert into a z file on the new iSeries so that I can upload al our old customers I get a error.
[SQL0420] Character in CAST argument not valid
I have looked over my statement and it all seems to be right, but I always get the error. I know I can use SQL to insert data into the new system because I created a table and then tested my commands.
Can anyone help a newbie to Enterprise One?