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
User-Defined SQL Query file in DRS Stage
Moderators: chulett, rschirm, roy
User-Defined SQL Query file in DRS Stage
Simplicity is the ultimate sophistication
Hi !
I have tried it now.. and i get the error (a big error)
Looks like it doesnt like the / character in the file path
Any hints?
-Nagesh
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.
![Question :?:](./images/smilies/icon_question.gif)
-Nagesh
Simplicity is the ultimate sophistication
The Help button just says this:
Maybe someone else has some experience?
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.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.
Maybe someone else has some experience?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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..
-Nagesh
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..
Where do i check for such message?Is there a "following" database message in the log?
-Nagesh
Simplicity is the ultimate sophistication