Connecting Database using DS routine

paddu · Post by **paddu** » Mon Feb 04, 2008 7:55 pm

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

Thanks
Paddu

chulett · Post by **chulett** » Mon Feb 04, 2008 8:34 pm

paddu · Post by **paddu** » Mon Feb 04, 2008 8:36 pm

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

chulett · Post by **chulett** » Mon Feb 04, 2008 8:46 pm

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

paddu · Post by **paddu** » Mon Feb 04, 2008 8:59 pm

Thanks Chulett.

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

I will surely search the forum.

Thanks
paddu

chulett · Post by **chulett** » Mon Feb 04, 2008 10:51 pm

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.

paddu · Post by **paddu** » Tue Feb 05, 2008 12:27 pm

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 .

chulett · Post by **chulett** » Tue Feb 05, 2008 12:30 pm

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.

paddu · Post by **paddu** » Tue Feb 05, 2008 1:11 pm

[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

chulett · Post by **chulett** » Tue Feb 05, 2008 1:13 pm

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

Time to mark your post as Resolved.