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 Specialist
- Posts: 65
- Joined: Thu Mar 05, 2009 3:49 pm
Who is online
Users browsing this forum: Majestic-12 [Bot] and 0 guests