"FIND" instead of "SELECT" in sql

Jithesh N · Posted: Tue Aug 22, 2006 2:49 pm

Hi all.

I'm afraid whether this is the correct forum to post this query.
I'm just getting into a project in which i have to use a tool( not sure it is a
tool or a third party language) which uses "FIND" statement instead of
"SELECT" in SQL..

I'll be great, if somebody have an idea on this and post me some study
documents.

shreevamsi · Posted: Tue Aug 22, 2006 4:41 pm

hi,

Yes, That is not an general SQL COMAND. You must be using the FIND command for Select for accessing a database ...probably DATACOM. This command internally triggers an SQL which access the database.

~Vamsi

Archana_MF · Posted: Sat Aug 26, 2006 4:59 am

DATACOM does not use FIND, not that I know.
it uses REDKG, REDKY, GETPS, UPDAT DELET etc etc..

shreevamsi · Posted: Mon Aug 28, 2006 10:14 am

I didn't say DATACOM uses FIND. In our SHOP, we use FIND for:

FIND table-name from col-name = 'value' col-name2 = 'value2'.........
print col-names................'

This inturn returns the rows from the datacome tables for the SQL

Select col-names.............from table-name where col-name = 'value' col-name2 = 'value2'.

~Vamsi

Archana_MF · Posted: Mon Aug 28, 2006 9:42 pm

Oh! Sorry.
correction taken