QSELECT

Inorder to select ids from a concat file QSELECT can be used. It can also be used to retrieve any field value from a file.

EG:

>QSELECT FBNK.CATEG.ENT.LWORK.DAY *

This will return all the CATEG.ENTRY ids from CATEG.ENT.LWORK.DAY
_________________
Tks
Kandha

Usage of EVAL in SELECT statment.

In SELECT statment expressions can be evaluated by using EVAL function.

Here is a small example, that selects only the decimal part of WORKING.BALANCE in the file FBNK.ACCOUNT.

-->SELECT FBNK.ACCOUNT EVAL 'FIELD(WORKING.BALANCE,'.',1)'
>SAVE.LIST MYLIST

-->CT &SAVEDLISTS& MYLIST
_________________
M A L A I

I personally feel these EVAL are going to cause a lot of performance issues... Also I heard there is something called NSELECT. I will find out more on this NSELECT and let u guys know the same.

Best Regards,
Karthik Sekar
_________________
NJOY LIFE TO THE FULLEST

Hey Hey...

No need to do any R&D on NSELECT.

Its already discovered under the topic 'use of NSELECT'

I agree, for huge select EVAL will cause performance issue.
_________________
M A L A I