IIF function

Tags:
CL Program
IIF
iSeries
OS/400
I have 2 tables:
First table:
1- name
2- position
3- nationality
4- visa No.

Second table:
1- Position
2- No of visas.
3- No of used visas.
4- No of remaining visas.
But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically. Please help me.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Please provide sample data, a sample transaction and expected results. Without those, it's not clear what your question is asking. "IIF" is not a standard SQL function. You should also provide your OS version.

    You might show an example of how you would do it in Access (or other database that uses IIF) and we might be able to show a more standard way of doing it.


    36,115 pointsBadges:
    report
  • ToddN2000
    In addition to what Raven requested, post a sample of your code and any error messages you may be getting.
    134,930 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: