remote system name - grid property

[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

[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'.

[Scott Klement]

You supply the name of a remote database in that property, and it will use that database instead of the local one.

[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

[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

[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.

[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 (6.02 KiB) Viewed 3572 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.

[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

[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