Search results

Something is horribly wrong with the backup file. CRC errors mean it couldn't decode the block properly. Make sure the file was copied correctly and not while it was still being written. Depending on how you are copying the file there are methods to make sure it happens correctly.

As far as I know you can't do SSL socket connections.. especially not in an easy way through the 4GL. cURL has two different options to control how long it waits... a connection timeout and a total time limit before it will return control. It also supports unbuffered output, every flavor of...

The only way I got my previous company upgraded from 9.1E was making sure the audit department knew it was unsupported. Things moved pretty quickly after that.

Greg. Download cURL and use that to interact with the web service. It will handle all of your ssl needs. I think there is a perl module for cURL as well. In new versions you have the json object which makes working with real world json much easier.

Mbpro is a batch file or shell script depending on your os. You will need to extract the line for the actual executable from the script.

On windows there are thousands of ways to find the code (editors that allow you to search files, findstr, etc). ABL2DB will tell you where the references are for all of your non dynamic code (and some for the dynamic ones). You could try searching and compiling with XREF, but that work has...

I meant from a 4GL perspective where the code is trying to lock a record with NO-WAIT and should be able to tell how has it locked without digging through _Lock (which can be very very bad sometimes). Enhancement request added (again)...

Interesting.... glad to see they backed that out. Now if we could just get the easy feature of telling who has a record locked in the 4GL.....

Glad to hear it :-) For interactive testing I don't know if the debugging info will add much value. But when you are using the conditional config options it can be really useful to get the query prepare and any relevant information from background jobs or appservers. It would be interesting to...

I think that is pretty much it for now. The recent additions were the batch config file options and the custom debugging info.

Run the code from this KB on each environment (Windows, Linux, HPUX) and compare the II8N sections to see if there are any differences. Progress KB - Sample code to get startup parameters and environment

Let me know which ones are missing or you have questions about. I will try and carve out the time to correct it. Thanks

You cannot. OpenEdge provides SQL 92 support but is not a native SQL database.

8k is the page size used by SQL Server. Every Microsoft SQL database in the world running like that. Physical IO never happens in 4k blocks with modern drives. Also you can set ntfs up with 8k blocks anyways. Understanding Pages and Extents

What are the other codepage related parameters? How did you verify the XML? If you are simply looking at it on the Unix side the display code page may not be correct. Download the untouched XML file to Windows to verify.

Many times they are one and the same...

How about a nice cost based optimizer with server side partition scans and joins? :-)

Even when developers see the table and index activity... quite a few of them are missing the perspective of what is good or bad. Usually a lack of understanding of the data and the application. Sometimes even not understanding how fast a application function should run. Reading 100,000 records...

QAD loves to connect/disconnect to different databases depending on the user and site..... Go to 36.6.2 to review the database connections for each user (the one that works and the one that doesn't). Verify that the users are using the same startup script. You can look at 36.6.1 to see which...

There are some very old school ways to do this that would require a lot of code.... use a browse and save yourself hours of grief and eventual rewrite when those features get dropped from the language.