Search results

I hope there is a Unix guru out there who can help me. I've written a number of awk scripts before OK, but I'm stuck on a simple but aggravating issue. I've cut the code down to just a small test snippet: #!/bin/ksh93 cat /tmp/testfile | awk 'BEGIN { count = 0; } /\(3777\)/ { print...

AIX 7.1, OE10.2B I am trying to get a script to run dbtool to check/amend sqlwidths. It is just in a test form. No problem running the script - but I'm having trouble capturing the output (ie, results). Below is my latest effort - but I have also tried >$log 2>&1 on the "dbtool"...

Thanks a lot! I didn't appreciate that UTF-8 preserved single-byte encoding for ASCII - and 2 or 3 bytes for (for example) Chinese characters. That makes me feel a lot happier - because it means the conversion should not materially change the size of the database at all. It will only be a...

AIX 7.1 -- OE10.2B05 In the next few weeks I have to migrate a DB to be Unicode. I am aware that "-cpinternal UTF-8" is required when re-indexing a Unicode DB. Is there anything else that is different when a Unicode DB is dumped/reloaded? Second question: the Progress docs say: "When an...

Thanks - I see if that helps me. Ron.

Yes - I have checked the documentation. Two problems, however ... 1. As of 10.2B only openedge.jar and pool.jar are now required. 2. I can't use %DLC% - because the PC doesn't have Progress installed. I can install a Progress client on my PC, of course, but for the users who will actually...

AIX server + 10.2B. I have a test (sports) DB on the server and have successfully compiled and run this small test Java program against it: import java.*; import java.sql.*; public class test { public static void main (String args[]) throws SQLException, ClassNotFoundException {...

I've just started working on a moderately large (350 Gb) DB, OE 10.2B on Linux. I notice that the DB block size is 4K, the BI block size is 16K and the AI block size is 8K. My query relates to the different sizes for AI and BI. I know I read somewhere that it's recommended to have them the...

Hi, I'm at a company with many remote sites, each with a Progress DB. They are (slowly) rolling-out a change from SCO Unix + Progress 9.1D - to Linux + Progress 10.2B. However - the storage areas are not being changed. I want to put a case to use Type 2 storage areas. I read the Progress docs...

Thanks very much, Tom. You have confirmed my suspicion that there is a problem lurking there ... Ron.

I'm working on an AIX server. There is a script that imports files from a remote Windows box using Samba - and then loads the data into a Progress DB. (I'm quite familiar with Unix and Progress - but not Windows or Samba.) My concern is that the script has no handshaking logic at all. If (using...

I think you are effectively confirming my own experience about the matter. But I assure you the (university) course I'm doing absolutely requires an intermediate table in-between every pair of entities that have a relationship. This extra table usually contains no data, as such, just the keys...

Maybe I didn't explain sufficiently ... In the common situation of a customer order table (a header - say 'order') - and order line items (say 'lines') - I'm accustomed to there being just two tables. But the course in SQL I'm doing says there must be three tables ... with a 'has' table...

Hi ... After 15 years working with Progress DBs - I'm doing a course about relational databases and SQL. (Yep, I guess I have a masochistic streak in me.) Prior to this my sum total knowledge of SQL was that SELECT COUNT(*) FROM blablabla gave me a count of the records in a table! The course...

Thank you, Tom. I saw the cautionary remarks about scanning the _Lock table in Dan Foreman's VST book - and the program I've written (not the test one) captures the scan time (with ETIME) so I can see how long it takes when I move this to production. I'll change to use the WHILE statement as...

It's working fine, now. Thanks once again for your valuable help. Ron.

That you very much. That makes sense. Clearly I should have examined the Progress example more carefully. Cheers, Ron.

I'm still stuck. I found and read the Progress doc where it said that an external procedure was needed - and changed the test code accordingly - but the behaviour hasn't changed at all. The part of the main test procedure is now: DO i = 1 TO 3: ASSIGN db = LDBNAME(i). IF db = ? THEN...

Aha! Thank you for that. Now that you've pointed it out - I remember that important detail! Cheers, Ron.