DSXchange

blue3zer0

The code that you pasted above will create or alter the stored procedure and needs to be run in Enterprise Manager so that the procedure is ready to be called from DS. When you call the procedure from DS you would the use the format.

Code: Select all

exec spForeignKeyconstraintNOCHECK

This will run the procedure.

blue3zer0

Thanks that worked.

It's funny because it only happens to me when I connect to Oracle and when I connect to MS SQL it works fine. Unless MS SQL is just reading the string without the quotes.

blue3zer0

It is from a Job Parameter. After I click run I fill in the string either as an equal to or and IN statements

For Example

Code: Select all

= '374425' or IN ('374425','274426')

In the user defined SQL statement I have a select statement that says

example

Code: Select all

Select a, b, c from abc where #WHERE#

blue3zer0

I tried that, it leaves the double quotes and strips the single quotes.

blue3zer0

I've created a simple job to query an Oracle DB and load the result to a sequential file. I've included a parameter for a where clause that I want to add directly to the sql statement. When I am in the Oracle stage I can query the data by changing the where clause to something like = '374425' which ...

DSXchange

Search found 5 matches

DataStage stripping quotes from parameters