DSXchange

Can we connect to Database ( example: oracle) and query to get any specific value in DS routine???

Thanks
Paddu

Yes.

Can you please tell how the syntax for DS routine could be to connect to Database??

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

Thanks Chulett.

I checked the recent post after asking for the syntax here .

I will surely search the forum.

Thanks
paddu

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.

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 .

So... you 'resolved your issue', meaning you actually wrote a routine to connect to Oracle? Or did something else?

I would do something like this in a simple little Server job, if you felt it really needed to come from Oracle.

[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

Well, there you go... much smarter solution.

Time to mark your post as Resolved.