How do I use files names with special characters in SQL?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Duane

Support Specialist
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm

Post by Support_Duane » Mon Mar 09, 2009 11:11 am
In the SQL task, in order to use file names or field names that include special characters or periods , the names must be enclosed in double quotes when writing the SQL statements.

For example, given a library/schema called MYLIB which has a file named MY.FILE, the select statement would look similar to:
SELECT * FROM MYLIB.”MY.FILE”.
Of course all names may be enclosed in double quotes if so desired.

In the SQL Wizard, there is an option to generate the SQL Statements with Double Quotes (or database specific enclosing character) in the preview.
1 post Page 1 of 1