PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Devon Austen

Pages: 1 [2] 3 4 ... 19
16
PxPlus has a [DB2] interface similar to the ODBC interface (https://manual.pvxplus.com?command_tags/db2.htm).

Note:
To use the DB2 interface, you must have either the DB2 database or the DB2 client installed on a workstation, and the path to the db2cli.dll file must be locatable by the PATH environment variable.
When using the DB2 client, a db2cli.ini file is created in the user directory to specify such parameters as the Hostname (address), uid (user) and pwd (password).

You can try this to see if it is any faster for you compared to ODBC.

Note the performance may have more to do with the SQL generated then which interface is used. PxPlus will convert reads and writes to SQL for you but in order for it to do that it has to generate SQL that will work for all types of reads and writes. This means it doesn't always generate the most efficient SQL.  You can however issue SQL directly and read the results allowing you to craft the most efficient SQL for the data you need (https://manual.pvxplus.com?PxPlus%20User%20Guide/Data%20Integration/Introduction%20to%20SQL/Using%20SQL%20Directly%20Within%20PxPlus.htm).


17
Wish List / Re: string interpolation
« on: November 15, 2023, 10:16:13 AM »
Here is an example of your code in PxPlus:

Code: [Select]
name$ = "Tom"
print "Hello, "+name$+"! Today is "+dte(0:"%Wl")+", it's "+dte(0:"%Hz:%mz")+" now."

Concatenation can happen on the same line of code.

As for speed I don't think the $"xxxx {var} xxxx" style string building would be any faster from a performance standpoint. Internally the same thing will be happening building the string plus now you have to scan the string for the variables as well.

Does that syntax work for you?

18
Programming / Re: Access IOL variables as properties
« on: November 10, 2023, 08:35:37 AM »
Unfortunately Composite strings cannot be used as object properties (See the note here: https://manual.pvxplus.com?directives/dim.htm#Mark7).

You can probably accomplish what you are going for by dynamically creating properties (https://manual.pvxplus.com?directives/def_class.htm#dynamic).

19
Web Services / Re: REST problems
« on: September 27, 2023, 03:56:56 PM »
From a PxPlus command line can you run:

Code: [Select]
OPEN (1) "[tcp]www.pvxplus.com;443;secure"
That will at least tell you if OpenSSL is working and if not should give you an error pointing to the issue.

20
Web Services / Re: REST problems
« on: September 27, 2023, 02:06:38 PM »
You said:

Quote
Actually, I had to make some adjustments, since it always added ";secure" to the OPEN, and that generated a PxPlus error.

*plus/web/request is adding the ;secure to the open because it is a HTTPS server. If you modified the program not to do that then it then likely the server rejects the request since it is insecure.

What error where you getting when it did add the ;secure? It is possible OpenSSL is not setup correctly for PxPlus to find it and fixing that will resolve your issue.

How to fix missing OpenSSL Libraries on Linux: https://forum1.pvxplus.com/index.php?topic=495.0

If your Linux distribution is older it also could be possible it doesn't support the minimum SSL/TLS version required by the server you are trying to connect to.

The error message when you attempt with a ;secure should tell you what the issue is.  You may need to print msg(-1) for more info.

21
Programming / Re: Create an Excel file in Linux environment
« on: August 14, 2023, 08:44:41 AM »
Another option would be to use the PxPlus Google Sheet object. As long as the Linux machine has access to the internet you can setup a google account with API access and then write a program that uses that google account to generate a google sheet (spreadsheet) and then export/download it as a xlsx file.

https://manual.pvxplus.com/?Google%20Workspace%20Objects/App%20Setup.htm
https://manual.pvxplus.com/?Google%20Workspace%20Objects/Google%20Sheets%20Object.htm

22
the \K is an argument to the cmd.exe program

The COMSPEC environment variable resolves to something like "%SystemRoot%\system32\cmd.exe" the \K is an argument passed to it telling it to remain open after running the command that follows.

https://ss64.com/nt/cmd.html

23
Programming / Re: corrupted journal files
« on: July 11, 2023, 08:50:25 AM »
Journalization is not supported for files with extended length records. See the note at the top of the documentation (https://manual.pvxplus.com/?Data%20Mirroring/Enabling%20Journalization.htm)

We have a wish list item looking at adding support for this. If it does get supported there may be limits on how large of a record length is supported with journalization.

24
Try:

INVOKE HIDE WAIT "[lcl]net use lpt1: \\192.168.xxxx\printershare"

this should run it in a minimized window.

https://manual.pvxplus.com/?directives/invoke.htm

25
Programming / Re: Create/Update Excel Workbook
« on: June 20, 2023, 03:27:04 PM »
If you want to create a Excel spreadsheet without Excel you can use Google Sheets via a Google Sheets object to create the spreadsheet and export it as an .xlsx file.

The constructor requires a Client ID and Client Secret, both of which must be obtained from Google via the Google API Console. See Google API App Setup for detailed steps.

Example:

Code: [Select]
x=NEW("*obj/GoogleSheets",clientID$,clientSecret$)
!
! Wait for user to complete Google sign-in and allow PxPlus access
INPUT "Press any key to continue after logging into Google account and allowing PxPlus access:",*;PRINT ""
!
! Complete the Google Sheets login
x'Login()
!
! Open spreadsheet
path$="Commissions/JuneCommissions"
if x'CreateSpreadsheet(path$)=0 then MSGBOX "Couldn't find "+path$
!
...
! add things to the spreadhseet
...
!
! Export current spreadsheet as a XLSX
if x'ExportSpreadsheet("C:\Users\User\Documents\JuneCommissions.xlsx")=0 then MSGBOX "Couldn't export to xlsx"
!
! Close spreadsheets
if x'CloseSpreadsheets()=0 then MSGBOX "Couldn't close spreadsheets"
!
! Drop object
DROP OBJECT x
END

26
ODBC / Re: ODBC on Redhat
« on: June 09, 2023, 03:11:32 PM »
I think the command you want is

/usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST AR_CUST_MAST

After LIST you just specify the table name not the word table and then the table name.

27
ODBC / Re: ODBC on Redhat
« on: June 09, 2023, 02:44:17 PM »
In your first command you pointed to the data dictionary at /facts93. In the second command you pointed to the data dictionary /facts/facts93.

My guess is if you modify your second command to use -d /facts93 you would get what you want.

28
Performance will vary greatly based on OS, data, how the data is accessed etc. It is impossible to know what your performance difference will be.

I would suggest creating a copy of some data and encrypting it and running some tests if you want to know what the difference will be.

29
“REQUIRED FOR OPEN AND ON DATA”  - This means you always need a password to open the file and the file contents are stored encrypted in the file. So if someone were to open a file in a text editor they could not scrape any useful data out of it.

“REQUIRED FOR WRITE AND ON DATA." - This means you can OPEN INPUT the file in PxPlus without a password, allowing you to read it without a password. To do a standard OPEN on the file in PxPlus you need to specify a password, the standard OPEN allowing you to read and write to the file. Also the file contents are stored encrypted in the file. So if someone were to open a file in a text editor they could not scrape any useful data out of it.

Usually you will just want to use “REQUIRED FOR OPEN AND ON DATA” for the more complete security.

As for legacy native encryption vs industry standard encryption performance. Our testing found they performed very similarly. I would strongly recommend using the industry standard  encryption for the better security and ability to have longer passwords. The limitation of only 8 character long passwords for the legacy encryption limits its strength.

30
ODBC / Re: ODBC Views Issue
« on: May 02, 2023, 08:18:40 AM »
Excellent, I am glad you were able to get it working.

Pages: 1 [2] 3 4 ... 19