Could somebody please let me know how to pass a value to a SQL in a passive stage.
Consider i have a ODBC stage and am connecting to a SQL server database. The scenario here is to use a between clause (or) a < > in a sql statement. This value that i would be passing would be dynamic..
Any suggestions would be appreciated !!
RS
Pass values dynamically to SQL code in passive(database)stg.
Moderators: chulett, rschirm, roy
How about a job parameter? Such as
Code: Select all
table.datecol >= '#YourDateParameter#'
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
For a Server job running on windows OS - How do i pass the #dateparemeter# to the SQL stmt ?? Kindly advise..kcbland wrote:How about a job parameter? Such as...Code: Select all
table.datecol >= '#YourDateParameter#'
You have to pass the value to the job parameter from the sequencer level.
If dynamic value can generated at the sequencer level, like reading from a file, you can use the execute command activity.
If the value has to be generated using some transformation, you can do that in a seperate job and assign the value to user status. This value can be caught at the sequencer level and can again be passed as a parameter to this job.
If dynamic value can generated at the sequencer level, like reading from a file, you can use the execute command activity.
If the value has to be generated using some transformation, you can do that in a seperate job and assign the value to user status. This value can be caught at the sequencer level and can again be passed as a parameter to this job.
Learn about job parameters, use your DS Designer manual for more information. They are the mechanism for feeding dynamic runtime control values to processes from the command line or the controlling processes (Batch, Sequence, custom job control).
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