控制台命令实用程序用于进度?

huangapple go评论116阅读模式
英文:

Console Command Utility for progress?

问题

有一个客户拥有一个Progress数据库,我需要能够使用命令行客户端连接。是否有这样的工具?我在服务器上看到可以启动proenv并运行sqlexp,我想能够从开发机器连接到远程数据库类似的操作。

英文:

A customer has a progress database and I need to be able to connect using a command line client. Does such a thing exist? Ive seen on the server you can launch proenv and run sqlexp, and I'd like to be able to do similar from a dev machine to the remote DB.

答案1

得分: 4

任何安装了Progress的开发机都会有PROENV可用。

对于SQL访问,“sqlexp”将像您已经使用过的那样工作。如果您需要4GL访问,可以使用“pro”(单用户)或“mpro”(多用户)。远程访问始终是多用户的。

您可能使用了类似于以下命令的SQLEXP:

proenv> sqlexp -db dbName -H hostName -S servicePort -user userName -password passWord -infile something.sql

MPRO的等效命令将是:

proenv> mpro -db dbName -H hostName -S servicePort -U userName -P passWord -p something.p

在这两种情况下,如果省略要运行的程序(something.*)参数,您将看到一个提示。SQLEXP更多是一个命令行,MPRO是一个带有顶部菜单系统的“编辑器”,但您也可以直接键入4GL语句并使用“GO”键(在Windows上为F2,在Unix上为F1,或者对于任何平台都可以使用^X)来执行它们。

在旧的应用程序中,允许4GL客户端使用“空白”用户名访问是常见的(尽管不是一个好主意),所以您可以尝试省略-U和-P来连接。如果出现要求输入用户名和密码的对话框,请尝试什么都不输入,或者使用F4(或^E)退出对话框。如果您没有凭据并且允许这种访问,这可能会起作用。

您连接的机器的许可证可能会影响您可以使用该连接做什么。还有一个名为“showcfg”的实用程序,它将显示您配置的许可证列表。

这只是基本的连接。一旦连接成功,如果知道您要做什么,我们可能还会有更多要说的。

英文:

Any dev machine with Progress installed will have PROENV available.

For SQL access "sqlexp" will work just as you have already used it. If you need 4GL access you can use "pro" (single user) or "mpro" (multi-user). Remote access is always going to be multi-user.

You probably used a SQLEXP command similar to this:

proenv> sqlexp -db dbName -H hostName -S servicePort -user userName -password passWord -infile something.sql

The equivalent for MPRO would be:

proenv> mpro  -db dbName -H hostName -S servicePort -U userName -P passWord -p something.p

In both cases if you omit the program to run (something.*) parameter you will be greeted by a prompt. SQLEXP is more of a command line, MPRO is an "editor" with a menu system at the top but you can also just type 4GL statements and execute them directly with the "GO" key (F2 for Windows, F1 for Unix, alternatively ^X for either platform).

It is common (although a bad idea) in older applications to permit "blank" userid access for 4GL clients so you may be able to succeed in connecting by omitting the -U and -P. If you get a dialog asking for username and password try entering nothing or exiting the dialog with F4 (or ^E). That might work if you have no credentials and such access is allowed.

The licensing of the machine that you are connecting from may impact what you can do with that connection. There is also always a utility called "showcfg" which will show you a list of the configured licenses.

That's all just basic connectivity. We might have more to say if we know what it is that you want to do once you are connected.

huangapple
  • 本文由 发表于 2023年3月9日 19:58:50
  • 转载请务必保留本文链接:https://go.coder-hub.com/75684305.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定