Search results

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 ...

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

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...

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...

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...

Hi Guys, I have been playing around with SQL on our Progress 9.1C installation at work and I was wondering if anyone can enlighten me as to what a 'Function Sequence Error' is its an intermittent fault that happens every now and again but causes our connection to bomb so I need to resolve it...

I've recently been given access to our databases with ODBC and a playing around. Our sales figures are held in a table called D2_Move, when I run a query to select all the sales figures in a database and add them up it returns a smaller figure than when run against 4GL, I can't work out what...

Hi Guys, this is my first foray into the SQL side of progress, we're running 9.1c on an AIX box, I connect it using the merrant ODBC drivers and I'm trying to write a nested query that shows our sales figures for the month. I've crafted this.... Select * FROM[ Select PUB.D2_MOVE.trad_code...

Hi Guys, I'm currently working in a company who uses progress for it Stock control and I have been asked to come up with a nice front end for some figure we need to get out of it. I've never used progress before and I've searched and searched but can't come up with an answer. On our server...