FWD » Core Development » Database

I searched the project for CONNECT statements and I could not find any. I could find instead a call to DISCONNECT statement (in amodufn1.p) and many CONNECTED function applied on different modules of the application.
I know that there is only one database active (<db_name>) so I guess the search is valid, the database is connected at startup and the above options are to be configured in directory.xml. According to the book, CONNECT support the same options like the command-line client parameters related to database connection.

• The -1 option. According to p4gl reference, if a user connects this way (a locking mechanism) the other are users are forbidden to connect to same database. This is the simple one.
• The -n option (I could not find a N (in capital) option). This is a server-side one and doesn't make sense in a client-side statement. This somehow extends the -1 configuration by allowing a certain number of concurrent users on the server, regardless of database used. When the number is reached, the new users cannot connect to server any more.
• The -cache option. This is used for specifying a database schema cache file for faster access. I think this is only a performance options strictly related to P4GL database server. On P2J the schema is directly and instant accessible at runtime.

Please let me know if I am not off-topic here.

LE: GES removed the database name in this entry.

You are right. We created this task based on an older set of reports. It is not needed in the current code.

This work will be deferred.