Help Center/ DataArts Studio/ FAQs/ DataArts Factory/ What Should I Do If a Message Is Displayed Indicating that the ID Does Not Exist During the Execution of a DWS SQL Script?
Updated on 2025-08-05 GMT+08:00
View PDF

What Should I Do If a Message Is Displayed Indicating that the ID Does Not Exist During the Execution of a DWS SQL Script?

Possible Causes

This issue is caused by the case of the ID.

Solution

During the execution of a DWS SQL script, the system uses lowercase letters by default. If a field is in upper case, add "".

Example: select * from table1 order by "ID";

select * from table order by "ID";
Parent topic: DataArts Factory