CODEWITHSUNDEEP
db2ibm-midrange
wkm
wkm

Reputation: 1762

Run a SQL query on a DB2 file with a dot "." in the name?

I have a DB2 file with a name like "my.test". The DB2 filename contains a dot '.'

If I try and run the following query via strsql:

select * from my.test

I receive the following error:

Token . was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH ORDER UNION EXCEPT OPTIMIZE.

Is there a way around this? I tried surrounding it in quotes but that doesn't help.

Upvotes: 5

Views: 11931

Answers (1)

James Allman
James Allman

Reputation: 41188

Double quotes are the correct way to escape the file name. The file name becomes case sensitive within quotes and must be specified in upper case.

SELECT * FROM "MY.TEST"

Note that in the IFS naming convention the "." operator is used to reference members within a file but it doesn't work with SQL.

If you need to access a file named "MY" with a member named "TEST" you would need to create an alias to query against. 

CREATE ALIAS QTEMP/MYTEST FOR MY (TEST)
SELECT * FROM QTEMP/MYTEST

Upvotes: 5

Related Questions