Database Driven Components Are Not Working
Posted: Fri Dec 04, 2009 5:13 pm
Genie’s database driven components (such as the drop down box) make use of separate SQL processes to retrieve the record set. Since these processes are separate from the main 5250 application job, some synchronization must be done so that the processes will run using the same library list, and with the same user authority as the main application.
To make all of this happen, Genie tries to capture the workstation device id from the sign on screen when you start a session. On successful sign on, Genie stores the information on this particular job in your session. When the SQL processes run, they use this information to locate and synchronize to the main application job so that the same library list and user authorities are in play.
If the database driven components are not working for you, or if you are getting a “session error” when attempting to use the field listing button in the designer, the most likely cause is that you are using a customized sign on screen and Genie does not know where to look for the workstation device id when you sign in. Genie looks in the default location for an IBM-shipped sign on screen.
If your sign on screen is different, you can tell Genie where to look for the workstation device id. To do this:
1. Start a new session in Genie.
2. On the sign on screen, go into Design mode.
3. Find the workstation device id field and click on it. It’s field id will display in the title bar of the Properties window.
4. Go into the Admin interface, and then into the Global Settings section.
5. On the “General Settings” tab, there is a field labeled “Workstation Id Field”. Enter the id that Genie assigns to your sign on screen’s workstation id field here, without any quotes, for example:
D_4_69
This should allow Genie to successfully capture the application job information, and will allow the database driven components to work properly on your system.
To make all of this happen, Genie tries to capture the workstation device id from the sign on screen when you start a session. On successful sign on, Genie stores the information on this particular job in your session. When the SQL processes run, they use this information to locate and synchronize to the main application job so that the same library list and user authorities are in play.
If the database driven components are not working for you, or if you are getting a “session error” when attempting to use the field listing button in the designer, the most likely cause is that you are using a customized sign on screen and Genie does not know where to look for the workstation device id when you sign in. Genie looks in the default location for an IBM-shipped sign on screen.
If your sign on screen is different, you can tell Genie where to look for the workstation device id. To do this:
1. Start a new session in Genie.
2. On the sign on screen, go into Design mode.
3. Find the workstation device id field and click on it. It’s field id will display in the title bar of the Properties window.
4. Go into the Admin interface, and then into the Global Settings section.
5. On the “General Settings” tab, there is a field labeled “Workstation Id Field”. Enter the id that Genie assigns to your sign on screen’s workstation id field here, without any quotes, for example:
D_4_69
This should allow Genie to successfully capture the application job information, and will allow the database driven components to work properly on your system.