Seeking a JDBC to progress toutorial

> Here's what it will end up looking like:
>
> What I get out of SQUirrel
> 10|1002|1|0|40|10|MILL|250|300|250|300
>
> What I kick out of visual basic
> UPDATE MFGSYS.PUB.QuoteOpDtl SET SetupBurRate = 250, SetupLabRate =300,
> ProdBurRate = 250, ProdLabRate = 300, OverrideRates = 0 WHERE Company
> = '10' and QuoteNum = 1002 AND QuoteLine = 1 AND AssemblySeq = 0 AND
> OprSeq = 40 AND OpDtlSeq = 10;
>
> Simple stuff but will save a lot of time, now to do testing to make
> sure it doesn't blow up the database.

Indeed. Updating the database directly may miss some triggers that would
fire if done through the Business Objects/Web Services.

Mark W.
I'm familiar with SQL and am looking to write procedures and functions
to better views and automate some tasks. I'm able to use Razor SQL to
connect to Progress 10.1B via that software's ODBC to JDBC feature.
However it doesn't allow me to create procedures and functions (I can
make views which have already helped me simplify some crystal reports
and safe time with frequent queries).

I've tried looking at online instructions (JDBC guide from Progress and
other articles) on how to connect to a progress database using JDBC,
however I'm stuck, maybe I'm overcomplicating the situation, but if
anyone has done this and would be wiling to write up a toutorial it
would be a great help for me and I'm sure many others.


As far as more specific questions: Which software have you used to
succesfully do this (I've tried the above Razor SQL without succes and
I've briefly looked into Squirrel SQL)? what do I need to install on
the machine where I'm trying to make the connection from? Just Java?
The Java Development Kit kit (if so which one?). Which file do I use as
the driver (progress.jar?), does this file need to be on the client
machine or can I use unc to connect to it? What else am I missing?

thank you

Paul
I figured it out after many googling and furrowing of the brow.

I added a doc file to the files section under Tutorials with my
notes. Hopefuly this will help someone.

--- In vantage@yahoogroups.com, "Paul" <chaosavy@...> wrote:
>
> I'm familiar with SQL and am looking to write procedures and
functions
> to better views and automate some tasks. I'm able to use Razor SQL
to
> connect to Progress 10.1B via that software's ODBC to JDBC feature.
> However it doesn't allow me to create procedures and functions (I
can
> make views which have already helped me simplify some crystal
reports
> and safe time with frequent queries).
>
> I've tried looking at online instructions (JDBC guide from Progress
and
> other articles) on how to connect to a progress database using
JDBC,
> however I'm stuck, maybe I'm overcomplicating the situation, but if
> anyone has done this and would be wiling to write up a toutorial it
> would be a great help for me and I'm sure many others.
>
>
> As far as more specific questions: Which software have you used to
> succesfully do this (I've tried the above Razor SQL without succes
and
> I've briefly looked into Squirrel SQL)? what do I need to install
on
> the machine where I'm trying to make the connection from? Just
Java?
> The Java Development Kit kit (if so which one?). Which file do I
use as
> the driver (progress.jar?), does this file need to be on the client
> machine or can I use unc to connect to it? What else am I missing?
>
> thank you
>
> Paul
>
>
> I figured it out after many googling and furrowing of the brow.
>
> I added a doc file to the files section under Tutorials with my
> notes. Hopefuly this will help someone.

Did you get the screen shots I sent you offline?

Mark W.
--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> >
> > I figured it out after many googling and furrowing of the brow.
> >
> > I added a doc file to the files section under Tutorials with my
> > notes. Hopefuly this will help someone.
>
> Did you get the screen shots I sent you offline?
>
> Mark W.
>

Got them thanks. If I was still stuck they would have gotten me what I
needed. What got me final bit of the info was a post on psdn.com.

Actually I was able to do nearly the same things with the ODBC to JDBC
connections in SQUirrel and RazorSQL without the progress specific
info. What I was missing with the ODBC to JDBC connections was the
ability to make procedures, but it looks like that is somewhat useless
for me at the current stage, I was hoping to make sql/dml procedures,
and it looks the progress procedures are in java. For my current
project I'm skipping java and do what I need to do in visual basic.

I'm working on a application that will generate sql/dml code to update
the QuoteOpDtl table. After our conversion from 6 to 8.3 all the quotes
have had their "over ride rates" check box checked. I'm going to
generate a bunch of sql/dml (need to alter 100,000 rows) to uncheck
that box and re-set the rates from using the default rates in the
resource group.

Here's what it will end up looking like:

What I get out of SQUirrel
10|1002|1|0|40|10|MILL|250|300|250|300


What I kick out of visual basic
UPDATE MFGSYS.PUB.QuoteOpDtl SET SetupBurRate = 250, SetupLabRate =300,
ProdBurRate = 250, ProdLabRate = 300, OverrideRates = 0 WHERE Company
= '10' and QuoteNum = 1002 AND QuoteLine = 1 AND AssemblySeq = 0 AND
OprSeq = 40 AND OpDtlSeq = 10;


Simple stuff but will save a lot of time, now to do testing to make
sure it doesn't blow up the database.