Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Need Help with IDX DBMS Queries
358 views
Skip to first unread message
needi...@yahoo.com
Oct 18, 2011, 2:31:44 PM10/18/11
to
Hello,
I need an introduction to IDX DBMS Queries. Just a few words with an
example and the steps required to create and run it.
Please reply here or reply to author.
Thanks,
Needy
I need an introduction to IDX DBMS Queries. Just a few words with an
example and the steps required to create and run it.
Please reply here or reply to author.
Thanks,
Needy
Pete
Oct 27, 2011, 12:21:37 PM10/27/11
to
Guided SQL. In the From Tables, drop in something easy like
REG_B_PAT. In Select Columns, drop in PAT_NAME and MRN. Then in
Where columns meet these conditions:, drop in PAT_NAME='PATIENT,
TEST'. F10 and it will run. You'll get a list with the one patient
and their MRN.
Queries will get more complicated obviously, but thats the basics. A
lot of your success will depend on your knowledge of traditional SQL.
pinkus....@gmail.com
Nov 1, 2012, 3:36:40 PM11/1/12
to
On Thursday, October 27, 2011 12:21:37 PM UTC-4, Pete wrote:
> On Oct 18, 11:31 am, needidxh...@yahoo.com wrote: > Hello, > > I need an introduction to IDX DBMS Queries. Just a few words with an > example and the steps required to create and run it. > > Please reply here or reply to author. > > Thanks, > > Needy Do you have the DBMS user guide from GE? The easiest way is to use Guided SQL. In the From Tables, drop in something easy like REG_B_PAT. In Select Columns, drop in PAT_NAME and MRN. Then in Where columns meet these conditions:, drop in PAT_NAME='PATIENT, TEST'. F10 and it will run. You'll get a list with the one patient and their MRN. Queries will get more complicated obviously, but thats the basics. A lot of your success will depend on your knowledge of traditional SQL.
Hello,
> On Oct 18, 11:31 am, needidxh...@yahoo.com wrote: > Hello, > > I need an introduction to IDX DBMS Queries. Just a few words with an > example and the steps required to create and run it. > > Please reply here or reply to author. > > Thanks, > > Needy Do you have the DBMS user guide from GE? The easiest way is to use Guided SQL. In the From Tables, drop in something easy like REG_B_PAT. In Select Columns, drop in PAT_NAME and MRN. Then in Where columns meet these conditions:, drop in PAT_NAME='PATIENT, TEST'. F10 and it will run. You'll get a list with the one patient and their MRN. Queries will get more complicated obviously, but thats the basics. A lot of your success will depend on your knowledge of traditional SQL.
I too need some help with IDX DBMS. I need to know if it is possible to pull Ethnicity from table REG_B_PAT as I only see race as an option.
Thank You,
cnit...@gmail.com
May 30, 2013, 9:56:18 PM5/30/13
to
I need some help with IDX DBMS also. I was well versed 4 years ago and have forgotten how to enter a date parameter in the "Where" clause. Can someone help?
esha2...@gmail.com
Jan 25, 2018, 12:01:17 PM1/25/18
to
Hello There,
I am new to IDX and I am trying use Dictionary Lookup. If I don't know the exact table name and the exact attribute names, is there any way to look up for the information on DBMS?
I am new to IDX and I am trying use Dictionary Lookup. If I don't know the exact table name and the exact attribute names, is there any way to look up for the information on DBMS?
0 new messages