Page 1 of 1
User-Defined SQL Query file in DRS Stage
Posted: Tue Oct 10, 2006 8:58 am
by srinagesh
Hi !
I am trying to read the data from DRS stage based on the query in a file.
I am trying to use the Query Type as "User-Defined SQL Query file"
But It doesnt prompt me anywhere for the name of the query file.
Can you please guide me as to where I should give the name of the query file?
Regards
Nagesh
Posted: Tue Oct 10, 2006 9:17 am
by kcbland
Put the fully qualified path to the file in the USER-DEFINED SQL text box.
Posted: Tue Oct 10, 2006 9:46 am
by srinagesh
Hi !
I have tried it now.. and i get the error (a big error)
Code: Select all
F0911_GSKE_DB2_FILTER_nagesh..F0911: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]ILLEGAL SYMBOL /; VALID SYMBOLS ARE ( END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN
F0911_GSKE_DB2_FILTER_nagesh..F0911: SQLExecDirect: Error executing statement '/users/d09/pcg99709/selectqry.sql'. See following database message for details.
F0911_GSKE_DB2_FILTER_nagesh..F0911.DSLink1: DSP.Open GCI $DSP.Open error -100.
Looks like it doesnt like the / character in the file path
Any hints?
-Nagesh
Posted: Tue Oct 10, 2006 10:14 am
by kcbland
The Help button just says this:
User-defined SQL query file. Specifies that the data is extracted using the SQL query in the pathname of the designated file that exists on the server. Enter the pathname for this file instead of the text for the query. With this choice, you can edit the SQL statements.
For both DB2/UDB and ODBC it is a choice, and I know with Oracle this works but never tried with the other two options, one of which I assume you're using.
Maybe someone else has some experience?
Posted: Tue Oct 10, 2006 1:53 pm
by ray.wurlod
Is there a "following" database message in the log?
Have you made sure that the executing user has at least r-x permission to every directory in the path?
Posted: Wed Oct 11, 2006 5:22 am
by srinagesh
Hi !
I have checked the permissions and I have tried executing the file in OCI stage (had similar table in oracle). It worked like a charm.
It doesnt work with DRS stage.
I did not understand..
Is there a "following" database message in the log?
Where do i check for such message?
-Nagesh
Posted: Wed Oct 11, 2006 7:10 am
by chulett
Then perhaps it be broke. Check with Support.
Posted: Wed Oct 11, 2006 8:00 am
by srinagesh
I had raised couple of tickets with support previously and I dont think I will be raising many more to them