Search results for query: *

...I have to created multiple joins in one query (in only step within PROC sql). For example: proc SQL; create table home.ALL as (select s.*, d.*, m.* from tst s, prd_srv d, prd_cmp m where m.id=s.id AND (m.id=d.id AND m.cntrl_key=d.cntrl_key) AND s.rsn <> 'NO' AND s.tag='G'...

I tried it but I got a message: "operation must use an updateble query" Does it mean that I should do table through make-table query first (as I used the result of select query)? Or it is due to other error?

Hi, I am trying to use update query in order to do Stopdt equal null when startdt=stopdt (both are date/time ) 1. use update query option 2. put criteria into design view grid under startdt =stopdt 3.put is null ito update under stopdt However I failed to do it ... What I am doing wrong...

Hi Everybody, I am wondering how I can add an additional table into the existing query Design View Grid in Access XP. I remember I could easily do it in older version of Access and I am unable to find this option now. Could you please help me with that? Thank you in advance

1.Most of records under PROGRAM END DATE have values 4/30/2004 while some of them have earlier dates such as 10/31/2003, 11/31/2003 (in other words they can end in 2003) 2. PROGRAM START DATE may be whatever date . They can start 2001 ( as it is a beginning of enrollment). For the purpose...

...enrollment end date migh happen before Apr 30. 2. The part of their enrollment should take place after Sept 30 I did the following query: SELECT * FROM mytable WHERE DateDiff("d",[mytable].[startdtSept1],([mytable].[program end date])>=90 and...

To continue my previous question... "DateDiff(xx,d1,d2) function expects the earlier date first, i.e. d1 < d2 " Now I need to set a condition where value for DATE OF TREATMENT should be witween 9/1/2003 and 3/31/2004 Considering statement above...Would it be correct to do the following...

Thank you! When I swapped d1 (earlier date) and d2 it started to work properly!

...or stopdate empty. All records under StartdtSept1 field have the same value 9/1/2003 . I did the following query: SELECT * FROM MYtable WHERE Datediff("d",[mytable].[stopdate],[mytable].[startdtSept1])>=90 or mytable].[stopdate] is NULL; However I received unexpected output because some...

...original table. I have a source file in Access XP format. Startdt and stopdt are formatted like 6/1/2002 1st level (criteria) is the following: ******************************** members are considered to be enrolled when stopdt-startdt=enrl_range >=90 days and part of this range should be...

Hi Everybody, Could you please tell me what Compress function does? For ex Yearmonthend=compress(YearE) ||'/'||compress(monthasked); Thank you in advance, Liliya

Mufasa, The only thing I can see is : total 0 bardeen% setenv ORACLE_SID bardeen bardeen% setenv ORACLE_HOME /ORACLE9i/HOME bardeen% setenv ORACLE_BASE /ORACLE9i/BASE bardeen% setenv PATH $ORACLE_HOME/bin:$PATH bardeen% which sqlplus /ORACLE9i/HOME/bin/sqlplus bardeen% cd $ORACLE_HOME/dbs...

Mufasa, I tried but I got a message as below mv:cannot access redo_G1_MI Does it mean that the system cannot access a file without extension .log? Is there anything else I can attemp in this situation? Thank You for your help, Liliya /ORACLE9i/HOME/bin/sqlplus bardeen% cd $ORACLE_HOME/dbs...

Hi , I work under SunOS5.9 Oracle9i I have a problem... Having created a database instance I copied redo01.log file: cd~ mkdir DISK1 cd DISK1 cp -pr /ORACLE9i/BASE/oradata/mySID/redo01.log redo_G_M1 Unfortunately I did mistake and copied it to redo_G_M1 ...rather than to copy it to...

Mufasa, Thank you so much! And I wonder what MAXLOGMEMBERS is used for and what ITS value means? Thank you once again! Liliya

Hi everybody, Being new in SAS, I would like to know what textbook is the best for me? Could you please recommend me good resources for this purpose? Any idea would be greatly appreciated Thank You ! Liliya

Hi everybody, Can anybody tell me WHAT maxlogfile used for? What does its value mean regarding to Control File Trace? Thank you very much in advance Liliya

Mufasa, Thank you very much for your explanation! I am actually not a DBA: I am just trying to start doing it.I really appreciated as it was very helpful Liliya

...1.what process is responsible for making sure that the changes are written to the disk BEFORE the COMMIT process finishes and I get the SQL*PLUS prompt back again? 2. What process is responsible for writing data buffer cache info into the datafiles of the database system? I am on Sub OS...

...1.What parameters need to be set in order to place the system into shared server configuration? 2.What parameters need to be set to turn on advanced queuing? As far as I know MTS_* parameters have been replaced for 9i So...what parameters work for this version? Thank you in advance, Liliya