Search results

So you are saying you can not use a text editor and replace "||" with "|" until you have the desired format?

The extra pipes are necessary if it's a CIM file, the extra |'s are tabs to place the data in the correct field's in the frame. Take your output from the script into your favorite text editor and replace "||" with "|" twice.

-n 300 –Mp 150 –Mn 150 –Ma 2 –S 2510 –Mm 16384 –lkrela -pinshm -T C:\Temp -B 50000 remove -Mp change -Ma 5 (default) add -Mi 1 -T is a client parameter

I defer to Tom (as always :blush:), a binary dump is record by record. Wasn't there another way of performing a binary dump prior to V8?

A binary load will place the records in the new database just as they were in the source database with the same data fragmentation (space from deleted records), there is not too much difference in a binary dump/load and restoring from backup. An ascii dump and load into a new empty database...

You should post this to the QAD forum. Also state the environment (Windows or *nix). Your configuration is sending output to $WRKDIR instead of $HOME, I don't have access to a Desktop2 environment, but you should be able to make the change to the ubroker.properties file.

Wasn't the question "How do I find out the lenght of a decimal field"?

The _user file is not a part of the application schema, don't know how your script is creating the dumpfile list for use by proutil, normally something like for each _file where not _file-name begins "_": File names begining with "_" are normally Progress meta-schema files and will have to...

You should be able to read the file with Widows notepad and save with ansi encodeing instead of Unicode Big Endian. On Linux use iconv.

Hi Andre, You didn't mention where the source data file came from, may not matter. Have you tried using a copy of the OE10 convmap.cp file as a temporary replacement for V9?

Hi Steve and Andre, Andre's example will work better as it will raise an error if the input string is longer than 12 characters. My example would pass it with extra characters. I was trying to highlight that length function needed to be used on a character string.

/* length is for string, raw and blob data types */ DEFINE VAR ckamount AS DECIMAL FORMAT ">>>>>>>>>9.99":U. DEFINE VARIABLE CheckAmount AS CHARACTER NO-UNDO. ckamount = 10452.09. ASSIGN CheckAmount = STRING(ckamount) CheckAmount = REPLACE(CheckAmount,"." , "") CheckAmount = FILL("0",12 -...

Start using prokb (Progress Knowledgebase) and lookup the error codes, it will tell you what to do. The error message you highlighted in red tells you that the test database set was created wrong with a 8k blocksize. The target database must be the same blocksize as the source. Delete the test...

Run this set DLC=c:\DLC set PATH = %PATH;%DLC%\bin set ddir = "C:\EUREKA\Eureka 2007\db" set bdir = E:\ProgressBackups echo DLC = %DLC% echo PATH = %PATH% echo ddir = %ddir% echo bdir = %bdir% only DLC and ddir are set correctly. bdir isn't set due to space after = without quotes and %PATH...

This is the content of probkup.bat #probkup.bat @echo off if "%DLC%"=="" set DLC=C:\Progress\OpenEdge type "%DLC%"\version if ""%1"" == ""online"" goto Online if ""%1"" == ""ONLINE"" goto Online :Offline "%DLC%\bin\_dbutil" probkup %1 %2 %3 %4 %5 %6 %7 %8 %9 GOTO End :Online...

It would not be a very good idea to switch from Unix chui environment to a Windows chui environment for a service pack update. You would have to install the Georgia Software telnet server on the windows server and update the terminal emulation software for all users, or install Progress client...

Was the database started with the Progress Explorer Tool or a script. Was it stated by someone with admin rights (same as Admin Server). View the conmgr.properties file for possible errors. run Promon -> R&D -> Status Displays -> Servers confirms the broker is using a TCP/IP port

You need to make sure the server is configured properly not the client. Now that you have the Progress client installed , select Progress Help from the menu and follow the online resource links to the JDBC/SQL 92 sections. Once you have the server cofigured properly, you should be able to...

Look at proutil -C busy, you can add to you script to test for db status and react accordingly

.netUI is a hybrid of .net browses and and the Desktop2 html interface and as of QAD 2008 SE (eB2.1 SP7), you must use .netUI. Although you still install Desktop2 as well as .netUI, your users will connect via the .netUI client. From the administrative side you will be adding appservers to...