Search results

Actually got it, its via proenv.

Got the dev license now. I need to add a new AREA called "Data Area" (as my .df refers to this) I need to run the command: prostrct add <db name> <.st file> How do I run the command? Where exactly would I run this? Through Data administrator / Data Dictionary? Thanks Alif

Maybe a better way would be to setup an ODBC. Do you have any idea how to setup an odbc between Progress v9.1 on Unix to MS SQL Server? What would I need to install on the unix end and what would I need to install on the SQL server end? Is it pretty straightforward? I know I can download...

Seeing the menu isn't a problem. It's loading the data at my end. The admin menu is greyed out probably due to the license I have. Just looking for a quick and easy way other than upgrading license just for a single load of data. Alif

Hmm...I'm pretty much stuck then :(

Is the code just a short few lines? Where/how would it be run? Are you able write me the code and compile it? (Pleeeeeeease! :) ) Just need .d file loaded with .df file that's it. Thanks Alif

So what are my options for loading the data? Thanks Alif

I just looked at the help section and it says i need to use 'data administrator' to load the data. It says to use the ADMIN menu but for some reason its greyed out (even though ive connected to my DB). Do you know why this is? Alif

I didn't create the .d files, someone else did. What's the steps? Thanks Alif

I have literally just run setup and completed installation (not done anything else). I've created a DB (empty). I then open data dictionary....what option in menu do I use to load in the .d and .df files (its not obvious). Thanks Alif

I've obtained the .d files and the .df file. What's the easiest way of creating a database and importing the data files into progress db on windows platform. Thanks Alif

Actually just remembered another question in addition to above: How do I obtain the data dictionaries? What's the command? Thanks Alif

Thats great. Silly question, but do I run the mpro dbname -p dict.p command from the Unix session? What's the easiest way to pull the dumped data from the unix box (which i assume to be remote) to my local machine? FTP? Other than that I think all my questions have been answered (for now...

So I take it the result of the dump is not a flat file(s)? Can this data dump be imported into a windows version of Profress DB? Thanks Alif

Really appreciate your advice Tom. If I have a development license (Unix), just to clarify, the steps I would need to take a full extract of the data would be to run the following command: mpro dbname -p dict.p which will bring up the top level menu, then I select "Admin" and then "Dump". Is...

Could I not use a SQL query i.e. a select statement and spool to a flat file? Do you have a document or some resource showing the various progress commands? e.g. - how would I view full list of tables in the DB e.g. like an alltables view? - view records in a specific table? What if...

Many thanks for reply Tom. I didnt realise it was so old. I'm assuming it is the most recent of the version 9 releases / service packs. How is SQL used to interrogate the DB directly (what's the interface or management studio equivalent?) or can this only be done using an ODBC connection? I...

Hello all, Although I am not new to DBs I am to progress. Could you please tell me how I could obtain a DB instance of Progress v9.1 on my machine? Is it opensource? (free?) Also, does anyone have a doc containing SQL syntax? How different is it to standard SQL? What's the best way of...