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
remote system name - grid property
-
- 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:
-
- 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
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'.
-
- 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
You supply the name of a remote database in that property, and it will use that database instead of the local one.
-
- 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
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
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
-
- 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
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
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
-
- 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
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.
-
- 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
For example, on my IBM i partition, I can run this command:
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: 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.
Code: Select all
WRKRDBDIRE
Then I set my properties like this: 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.
-
- 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
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
Wendy
-
- 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
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
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
Who is online
Users browsing this forum: No registered users and 0 guests