More efficient way to get an answer like this is to just write the code rather
than taking on the overhead and spawning a thread to ask the query language
processor to do your work
OPEN ‘FBNK.FUNDS.TRANSFER$NAU’ TO THE FILE ELSE STOP
NBR.RECS = 0
SELECT THE.FILE TO THE.LIST
LOOP
READNEXT ID FROM THE.LIST ELSE
BREAK
END
READ RCD FROM THE.FILE,ID ELSE
CONTINUE
END
CO.CODE = RCD<someattribute>
IF CO.CODE EQ ‘XX0010001’ THEN
NBR.RECS += 1
END
REPEAT
From: Durai raj
Sent: Wednesday, July 11, 2012 6:20 AM
To: [email protected]
Subject: Re: how to store the result from Jbase command in a variable ?
Hi,
You can capture the output and error by using SETTING and CAPTURING with
EXECUTE.
EX.COMMAND = "COUNT FBNK.FUNDS.TRANSFER$NAU WITH CO.CODE EQ XX0010001"
EXECUTE EX.COMMAND SETTING SETTING.MSG CAPTURING OUTPUTSYSTEM.RETURN.CODE =
@SYSTEM.RETURN.CODE
SELECTED = @SELECTED
CRT SYSTEM.RETURN.CODE
CRT SELECTED
CRT SETTING.MSG
CRT OUTPUTInstead of COUNT use SELECT and check the output.
Regards,
Durairaj. N
On Wed, Jul 11, 2012 at 9:18 AM, Noh <[email protected]> wrote:
Hi....
How can I store the result from Jbase command in a variable
I do like this, but it doesn't work
PROGRAM TEST
NUM.FT = EXECUTE "COUNT FBNK.FUNDS.TRANSFER$NAU WITH CO.CODE EQ XX0010001
IF NUM.FT GT 0 THEN
DISPLAY "FT ": NUM.FT
END
END
pls guide me how to do it
Big thanks in advance
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at
http://groups.google.com/group/jBASE?hl=en
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
