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 Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

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

Postby 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.
Support_Duane
Support Specialist
 
Posts: 66
Joined: Thu Mar 05, 2009 3:49 pm

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 1 guest