Page 1 of 1

remote system name - grid property

Posted: Tue Jan 11, 2022 11:53 am
by Wendy
Good morning,
I want to populate a grid from a different partition on our system using the 'remote system name' property on the grid widget. There is nothing in documentation for database-driven grids on how to use this property even though it shows up in the picture explaining the use of a database file.

I cannot get this to work for me when using the system name of the partition I want to access. When I put that name in the field for 'remote system name' property, the 'database file' property continues to pull the schemas on the local partition.

I'd appreciate anyone's advice on how to use this property.

Wendy

Re: remote system name - grid property

Posted: Tue Jan 11, 2022 12:00 pm
by Wendy
I don't know why the post put '***' in place of 'doc...' I can't find anything in the ProfoundUI doc for 'remote system property'.

Re: remote system name - grid property

Posted: Tue Jan 11, 2022 2:43 pm
by Scott Klement
You supply the name of a remote database in that property, and it will use that database instead of the local one.

Re: remote system name - grid property

Posted: Wed Jan 12, 2022 9:47 am
by Wendy
Scott,
I guess I don't understand what the syntax should be, or perhaps I don't understand what the database name actually is, because I can't get the correct combination to work.

Thank you!
Wendy

Re: remote system name - grid property

Posted: Wed Jan 12, 2022 10:49 am
by Wendy
Scott,
I now know what the remote database name is of the partition I want to access. I had it correct initially, according to our system administrator.
Even when I enter the correct name of the Remote System Name, it continues to give me the schema on the local partition (not sure of terminology here) and doesn't return what is on the remote partition.

Wendy

Re: remote system name - grid property

Posted: Wed Jan 12, 2022 12:42 pm
by Scott Klement
Unfortunately, the "remote database name" won't allow you to browse for files or fields in the Visual Designer. However, if you fill in the correct values by hand, it should work correctly at runtime.

Re: remote system name - grid property

Posted: Wed Jan 12, 2022 12:58 pm
by Scott Klement
For example, on my IBM i partition, I can run this command:

Code: Select all

WRKRDBDIRE
This lists the databases that I've configured for remote access. On mine, I have one that's named "WATSONJR" -- which happens to be another LPAR. (Though, it could also be another IBM i computer that's available on the network, either one would work the same way.)

Then I set my properties like this:
remoteSystem.png
remoteSystem.png (6.02 KiB) Viewed 3421 times
I have to manually fill-in the properties (I cannot use the "..." buttons to browse for files in the schema or fields in the file) But, I can just log onto a green-screen and use WRKF and DSPFFD to find the file/field names and key them into the blanks -- so, it's easy enough.

Re: remote system name - grid property

Posted: Wed Jan 12, 2022 2:20 pm
by Wendy
Thank you Scott, this is perfect. I was in the process of doing just that to test, however I've been interrupted so I haven't yet gotten to see results yet.

Wendy

Re: remote system name - grid property

Posted: Wed Aug 03, 2022 6:35 am
by sophiaabigail123
This property is most useful when creating multiple entities in a single call to the server in a Ext. data. operation. Create .Assign dimensions to the row, column, and page axes. Database name the grid 192.168.l.254 is accessing. Member Name shows member names as the heading.Grid Infrastructure Installation and Upgrade Guide for Linux ... each physical host name in the cluster and for IPs for the Oracle Clusterware managed VIPs.
To bind remote data to grid component, assign service data as an instance of DataManager to the dataSource property. To interact with remote data source, ...The grid manager runs on a host, and manages all the run-time components. When you select a grid manager in the navigator, the components of the user interface