User-Defined SQL Query file in DRS Stage

srinagesh · Post by **srinagesh** » Tue Oct 10, 2006 8:58 am

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

kcbland · Post by **kcbland** » Tue Oct 10, 2006 9:17 am

Put the fully qualified path to the file in the USER-DEFINED SQL text box.

srinagesh · Post by **srinagesh** » Tue Oct 10, 2006 9:46 am

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

kcbland · Post by **kcbland** » Tue Oct 10, 2006 10:14 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 10, 2006 1:53 pm

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?

srinagesh · Post by **srinagesh** » Wed Oct 11, 2006 5:22 am

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

chulett · Post by **chulett** » Wed Oct 11, 2006 7:10 am

Then perhaps it be broke. Check with Support.

srinagesh · Post by **srinagesh** » Wed Oct 11, 2006 8:00 am

I had raised couple of tickets with support previously and I dont think I will be raising many more to them