I have 100 account numbers in a PS(flat file ). I have to check weather the account numbers are exist in the database or not.
Can we check in the database by executing a single Query in SPUFI flat file as input.
If yes what will be the Query?
Edit the dataset FLAT.FILE.CONTAIN.ACC.NUMBER containing the account number by
1:inserting commas in between two account numbers
2:end the flat file with
I don't think there is anything like this in the manual or I haven't seen yet. They did try an example based on a user defined function but nothing like this. But this thing works! Thanks a027412 for sharing.