Can we connect to Database ( example: oracle) and query to get any specific value in DS routine???
Thanks
Paddu
Connecting Database using DS routine
Moderators: chulett, rschirm, roy
Now, that's an entirely different question - and not one to be answered in a simple post. Search the forums for "BCI" and perhaps even "SQLExecDirect" to get some idea of what road you are looking to travel down.
For example, a recent series on the subject:
viewtopic.php?t=115619
For example, a recent series on the subject:
viewtopic.php?t=115619
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Out of curiousity, why do you ask? What are you thinking about doing that you would need something like this? I have been working with the tool for quite some time and never once felt the need to do any such thing, hence the question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Yes sir !!! i have something in my mind ..
At one point i needed to get a date from oracle table to use in job sequences .Basically identify the month of date from oracle table and process rest of the sequence.
According to our process , the date i am trying is always previous month date from the current month date .
I mean , if the process is running February then the month i am trying to get from oracle is January.
So i resolved my issue by creating a small routine to get previous month from the current date .
At one point i needed to get a date from oracle table to use in job sequences .Basically identify the month of date from oracle table and process rest of the sequence.
According to our process , the date i am trying is always previous month date from the current month date .
I mean , if the process is running February then the month i am trying to get from oracle is January.
So i resolved my issue by creating a small routine to get previous month from the current date .
[quote="chulett"]So... you 'resolved your issue', meaning you actually wrote a routine to connect to Oracle? Or did something else?
quote]
No i did not write a routine to connect to Oracle .
I wrote a routine to get previous month value from the current date (@DATE).
I did not use oracle date at all. Basically made by job easy
quote]
No i did not write a routine to connect to Oracle .
I wrote a routine to get previous month value from the current date (@DATE).
I did not use oracle date at all. Basically made by job easy
Last edited by paddu on Tue Feb 05, 2008 1:14 pm, edited 1 time in total.