NSELECT from SUBROUTINE

  • Jorge
  • Topic Author
  • Visitor
  • Visitor
17 years 1 month ago #2084 by Jorge
NSELECT from SUBROUTINE was created by Jorge
Hello, I am trying to make a subroutine to use a list from two files LMM.CUSTOMER and MG.CUSTOMER using the NSELECT. Can anybody help me on this? Thanks in advance.

Please Log in or Create an account to join the conversation.

More
17 years 1 month ago #2085 by malai
Replied by malai on topic NSELECT
Hi,

I dont understand your question. Do you want to select both the files or do you want to select only the records which are existing in one file and are not present in another file?

NSELECT is only to select the records which are present in one file and are not present in another file.

You cannot use NSELECT using EB.READLIST api. You have to don this only using EXECUTE command.

SEL.CMD1 = 'SELECT FXXX.LMM.CUSTOMER'
SEL.CMD2 = 'NSELECT FXXX.MG.CUSTOMER'
EXECUTE SEL.CMD1 CAPTURING YOUT1
EXECUTE SEL.CMD2 CAPTURING YOUT2
LOOP
.....
WHILE
.....
REPEAT

______
Thanks

Please Log in or Create an account to join the conversation.

  • Jorge
  • Topic Author
  • Visitor
  • Visitor
17 years 1 month ago #2086 by Jorge
Replied by Jorge on topic NSELECT
Thanks for your answer, It is that I wanted, select only the records wich are existing in one file and are not present in another file from a subroutine.


Thanks

Please Log in or Create an account to join the conversation.

Time to create page: 0.026 seconds