remote system name - grid property

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

remote system name - grid property

Post 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
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: remote system name - grid property

Post 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'.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: remote system name - grid property

Post 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.
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: remote system name - grid property

Post 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
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: remote system name - grid property

Post 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
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: remote system name - grid property

Post 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.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: remote system name - grid property

Post 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 3385 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
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: remote system name - grid property

Post 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
sophiaabigail123
New User
Posts: 1
Joined: Wed Aug 03, 2022 6:32 am
First Name: sophia
Last Name: Abigail
Company Name: 192.168.1.254
Phone: 4523167899
Address 1: mexico
Address 2: mexico
City: mexico
State / Province: West Virginia
Zip / Postal Code: 37500
Country: Virgin Islands, US
Location: mexico
Contact:

Re: remote system name - grid property

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests