Recent content by bugg_tb

You can set that directly in the odbc driver settings. Although I am after the same answer to that question, so if anyone knows..... :)

I've tried this in SQL using Progress 9.1D and I get fed a syntax error, is it possible to set the isolation level in pure sql or do I _have_ to set it in jdbc driver settings? Cheers Tom

Thats the best piece of advice I've had in a long time! just dropped my query down from 300 seconds to 25. Great Stuff

Turns out that if I remove all aliases and define full table paths in the grouping, it seems to work... Eh?

SELECT PUB.D2_SORD_DEL_HEAD.sdh_deliver_num , PUB.D2_SORD_DEL_HEAD.sdh_deliver_name , PUB.D2_SORD_DEL_HEAD.sdh_deliver_addr1 , PUB.D2_SORD_DEL_LINE.sdl_deliver_wght , PUB.D2_SORD_DEL_LINE.sdl_deliver_vol , PUB.D2_SORD_DEL_HEAD.sdh_deliver_date , PUB.D2_SORD_DEL_LINE.soh_num ...

Never mind, I found out it likes CASE statements

May be a dumb question.. If(PUB.D2_SORD_DEL_HEAD.sdh_del_method='001','D','C') AS ORDERTYPE if that sorta thing right for an IF statement or have I got it wrong? Cause no matter what I try I get a syntax error. Cheers Tom

Yeah, but if you're not using ODBC thats out the window :)

Hi Guys, Im not using SQL Explorer(JDBC) but Kettle when setting up a connection or running a query I can't for the life of me work out how to set the transaction read uncommitted. I've tried SET TRANSACTION ISOLATION LEVEL UNCOMMITTED READ and the @TRANSACTIONISOLATION 0 but neither have...

Sorry by forget it I mean it not going to update the new record if the old one is edited? This parent table is deleted at the end of the day and obviously I don't want all the old new records disappearing, I'm just trying to keep a log of every product code entered into this table. Anyway I've...

Thanks for the reply, I've actually managed to come up with a quick bit of code but I'm still struggling. I want my trigger to copy the data then forget about the new one so when the old records are deleted (the following night)it will leave the new copies(I'm not sure if I understand you...

Hi Guys, I have very little knowledge of 4GL(Progress 9.1D) and usually use SQL to rip the data I need from the tables, but I need to implement a trigger on a table that copies a few fields from one table to another whenever a record is inserted and I was hoping someone could help. Ive created...

Cheers Casper Its one of my small SQL bug bears, not aimed at Progress but they all have to be just slightly different syntactically dont they :) Tom

Whoever designed this database thought it'd be a great idea to put a minus sign in the doc-id column header, so in a sql query how do I ask it to look at pub.blah.doc-id without it giving me a syntax error? Cheers Tom

Right I've been playing around with my various 9.1C and 9.1D database's with the ODBC drivers on my XP box, they work fine, but as I've read in lots of places the jdbc drivers performance is better so I thought I'd give them a shot as my ETL program is java based anyway. So I followed a guide...