ovrdbf on data source

[Bruce.Wilson]

Hello,
On my IBMi I have a green screen program that requires the user to choose a Fiscal Year. After they choose the year, the program issues an OVRDBF to point to the file holding the financial data for that year. In Valence it looks like you have to create a separate data source for each year and re-create the widgits and apps. What is the recommended method to do this with Valence? Are there some postings that explain a way to do this. I'd appreciate some guidance.
Thanks,
Bruce Wilson

[Johnny Major]

You can use a vvIn_Virtual in your SQL statement to dynamically change the table and/or library. For example, here is a statement where, via an app variable, I can change the table dynamically by setting the app variable customerTable to something else.

By default, it’s using VALENCE6.DEMOCMAST; however, I could easily set customerTable to VALENCE52.DEMOCMAST by changing the app variable customerTable.

Blog on vvIn_Virtual

SELECT
  *
FROM
  vvin_virtual(
    'customerTable',
    'valence6.democmast',
    'char',
    25,
    NULL,
    'false'
  )
ORDER BY
  cusno DESC

[robert.swanson]

One more option, if you prefer to continue with the OVRDBF approach, would be to add a pre-execution exit program to your data source. You could then have a custom program apply the appropriate OVRDBF command prior to the data load.

https://valence6.helpdocsonline.com/data-source-work-file-/-exit-program