Loading .d file - Forum - OpenEdge RDBMS - Progress Community
 Forum

Loading .d file

This question is answered

DB version is Openedge 10.2, running in Windows 2003 R2 Enterprise Edition VM,

I created a table (with 3 CHARACTER columns)  using Data Administration tool (Admin -> Load Data and Definitions -> Data Definitions (.df file). 

Now, I want to load data into the table using a .d file, contents below:

"100" "101" "101A"
"100" "101" "101B"
"100" "101" "101C"

And I see multiple options to accomplish this:

Questions:

1. Admin ->  Load Data and Definitions -> Table contents (.d file) option in Data Administration tool seems to be disabled. Why?

I have OE Enterprise RDBMS 1 year EVAL license.

I also tried launching the tool using rx option (prowin32 -p _admin -rx), the option is still disabled.

2. I was trying to use 'input from' command:

INPUT FROM stgrp.d.
REPEAT:
IMPORT stgrp.pgroup stgrp.parent stgrp.subgroup.
END.
INPUT CLOSE.

This command just displays the line number for the next command, and sits there. I ran this command from sqlexplorer prompt. What am I missing?

SQLExplorer>INPUT FROM stgrp.d. 
1> REPEAT:
2> IMPORT stgrp.pgroup stgrp.parent stgrp.subgroup. 
3> END.
4> INPUT CLOSE.
5>

3. I see one more option online - prodict. What is it, how do I execute it, and from where?

This is my first time working on openedge, appreciate any help I can get. Thank you!

rv.

Verified Answer
  • > If so, is there a way to load the data with what I have? - See more at:

    ....

    3) another option since you have ascii file, would be a bulk load (proutil dbname -C bulkload dbname.fd) - you can create the bulk loader description file in data administration.

All Replies
  • 1) it's probably the license (assuming you have the database connected); "showcfg" will tell you (or configinfo icon)

    2) SQLExplorer uses SQL(92) syntax, it does not know what to do with ABL commands; you need to execute this from the procedure editor (prowin32 or mpro) and you would need to create a record in the table first, ie

    input from stgrp.d.

    repeat:

    create stgrp.

    import stgrp.

    end.

    input close.

    3) another option since you have ascii file, would be a bulk load (proutil dbname -C bulkload dbname.fd) - you can create the bulk loader description file in data administration.

  • Option 1: I don't know why Load Table Contents would be disabled - somebody from Progress with access to the source-code should be able to answer that question. Could it be a licensing issue?

    2. Option 2: You are writing an ABL program, but are trying to execute it in the SQL Explorer. ABL you can execute within the Progress Editor (Start -> All Programs -> OpenEdge -> client). Also, you are missing the statement

    CREATE stirrup.

    before the import.

    Option 3: this is basically the same as running the Table Load within the admin-tool. It's just a wrapper program which can be run from a shell-script (for automating dumps and loads of data and definitions). It is actually running the same as the Admin-Tool UI.

    I am suspecting, that it won't do the trick as it most likely runs into the same restriction that caused the option to be disabled in the tool...

    Thomas Hutegger

    tmh@smat-consulting.com

    SMAT-Tools - Web-Apps with RollBase simpleness, ABL flexibility and power

  • 1) showcfg:

    Configuration File:   C:\Progress\OpenEdge\PROGRESS.CFG

    Company Name:  

    Product Name:   OE Enterprise RDBMS

    Installation Date:   Wed Sep 23 09:06:47 2015

    User Limit:   5

    Expiration Date:   10/21/2016

    Serial Number:  

    Control Numbers:  

    Version Number:   10.2B          

    Machine Class:   KB

    Port Number:   31

    2)

    I opened the tool using prowin32 -p _admin -rx.

    I opened a procedure editor to run the command:

    INPUT FROM "C:\data\tfs\stgrp.d".

    REPEAT:

     CREATE stgrp.

     IMPORT stgrp.

    END.

    INPUT CLOSE.

    It gave me a compiler message - 'This version of PROGRESS compiles only encrypted programs. (1086)'. I am not sure if I am in the correct window!

  • For option 2:

    When I go to Start -> All Programs -> OpenEdge -> client, I get a message in the bottom of the window saying - 'openedge client "This version of PROGRESS requires a start up procedure (495):'

    'Press space bar to continue'

    When I press space bar, the window closes.

    I assume there might be help on this problem online, looking.. replying to you as well, Thank you for your help.

    rv

    UPDATE - I am not able to find any useful information online yet, still looking.. But i keep thinking that it is something to do with license! Can someone please point me in the right direction?

  • you are missing the 4gl dev license.  It is what allows you to run uncompiled code and allows the use of the menus in the data dictionary for what you are trying to do.

  • For some reason, I am not able to find some basic information online, guess i need to go home now!

    What I have is a windows VM used for development only purposes, we wouldn't want to pay for license at this point. Is 4GL a paid version? This is the only information I could find in one of the pdfs I see online:

     4GL Development / Provision / OE Studio / OE Architect

    • Licensed as with all standard products

    • Must only be installed at your customer sites if registered to them

    If so, is there a way to load the data with what I have?

  • > If so, is there a way to load the data with what I have? - See more at:

    ....

    3) another option since you have ascii file, would be a bulk load (proutil dbname -C bulkload dbname.fd) - you can create the bulk loader description file in data administration.

  • Ah, overlooked this in your earlier response. Thanks Libor. I will look into this option, try it and post the result.

  • Excellent, Thank You very much!

    I was able to load data in all 3 tables.. (had to fix the .d file for a couple of tables with DATE columns, but that is data issue) and grant some privileges!