Hello @japsas100,
interesting the messages on an error on Line1, and with the chinesse characters.
It seems to me that something is passing the code/instruction on doble-byte format to the redshift database, when it might be expecting something simple-byte, or similar. On what char set are you running the sas session?
Anyway, i would expect a lack of harmony between the client driver and the database. Did you checked and tested your diver and its connection?
If you get stuck, my best suggestion is to go to the logs of the database and the client driver on your SAS server, and if you still cannot find anything, just increase the level of the logs.