Page 1 of 1
SELECT not in your VOC
Posted: Tue Feb 09, 2010 2:52 pm
by suryapkakani
Hi,
I am trying to execute a query from the dssh folder, but it gives me the error below.
dsadm@XXXXX01:/opt/IBM/InformationServer/Server/DSEngine/bin> ./dssh
DataStage Command Language 8.0 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2006 All Rights Reserved.
bin logged on: Tue Feb 9 15:45:47 2010
>"select * from ds_jobs;"
Verb ""SELECT" is not in your VOC.
What might be the resoultion to this problem....
Posted: Tue Feb 09, 2010 3:41 pm
by ray.wurlod
Type the command in upper case.
The parser has actually reported it incorrectly; the problem is with the table name, which is case sensitive. Reserved words from SQL are not actually case sensitive. So the following would have worked.
Posted: Tue Feb 09, 2010 3:48 pm
by suryapkakani
Hi Ray,
I tried the following as mentioned
dsadm@dldatas01:/opt/IBM/InformationServer/Server/DSEngine/bin> ./dssh
DataStage Command Language 8.0 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2006 All Rights Reserved.
bin logged on: Tue Feb 9 16:43:44 2010
>SELECT * FROM DS_JOBS;
DataStage/SQL: Table "DS_JOBS" does not exist.
>"SELECT * FROM DS_JOBS;"
Verb ""SELECT" is not in your VOC.
>
I still get the same error. Is anything wrong in the format in which I am writing the query.
One other thing is, I am able to execute the same from the Administrator.
Posted: Tue Feb 09, 2010 3:55 pm
by ray.wurlod
That's because you are in an account that is not a project, therefore there is no DS_JOBS table.
LOGTO any project account and you will find that the query succeeds.
It works in Administrator because there you have already chosen (and invisibly connected to) a project.
Quoting the entire SQL makes no difference.
Major problem: at some point someone has created an account in your $DSHOME/bin directory. This should be unwound at an early opportunity. Delete the following items from bin:
- &SAVEDLISTS& (directory) and contents
VOC
VOCLIB
D_&SAVEDLISTS&
D_VOC
D_VOCLIB
Posted: Wed Feb 10, 2010 7:07 am
by chulett
When you launched your 'dssh' command, did it tell you something along the lines of it not being 'properly set up' and asking you if you want to set it up? If so, the answer is always no.
This means you are not launching the command from the proper location, which would be either the DSEngine directory or from one of your Projects. The latter will automatically LOGTO the project you start in.