My job has a lookup between input and DataBase. If I get records from the database lookup is done between input and Database,records are sent to the output . If no records come out from the database A message should be sent to the target saying"no records found".
Is there any stage which could be used between look-up and target which could be used to generate message to the target if no records are returned?
need a message to output
Moderators: chulett, rschirm, roy
need a message to output
Thanks,
Surya
Surya
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: need a message to output
A message should be sent to the target saying"no records found"
What do you mean by target here? Target database or application ?
What do you mean by target here? Target database or application ?
You are the creator of your destiny - Swami Vivekananda
Actually I have two conditions specified in the query used in ODBC.
If the situation arises in any of these conditions no records can be pulled out of the database.
So when these situations arise I mean if condition1 happens msg should be condition1 so no records
if condition2 is the situation then msg should be condition2 so no records.
The target is WISD output.
If the situation arises in any of these conditions no records can be pulled out of the database.
So when these situations arise I mean if condition1 happens msg should be condition1 so no records
if condition2 is the situation then msg should be condition2 so no records.
The target is WISD output.
Thanks,
Surya
Surya