Hi Jayesh, have question again If my file is setting order to "COMPANY_NAME", do i need to set the order to "ORDER_NO" before run SQL ...WHILE ORDER_NO="12345" **************** I want make temp. file name from sys(3) and come with a alias name = "T_ASS2" I have coding as below : III = SYS(3)+".DBF" SELECT * FROM order_items
WHERE order_no == "12345" INTO TABLE &III ***how to addin the alias name = "T_ASS2"