Search results for query: *

Hi I am a beginner in SAS and Data warehouse. I was said that I could NOT create intermediate table in Data warehouse DUE to no certain privileges and therefore I have to created multiple joins in one query (in only step within PROC sql). For example: proc SQL; create table home.ALL as...

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...

Hi, I need to create a query which extracts just 1. those members who were enrolled for at least 90 days anytime starting from Sep1,2003 till the Apr30/2004. (However they may be enrolled before Sep1 and enrollment end date migh happen before Apr 30. 2. The part of their enrollment should...

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!

Hi, I have a table and I need a query with records where (stopdate-startdtSept1)>=90 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...

Hi everybody Could you please help me with my problem? I am trying to distinguish eligible members from non-eligible and I need all eligible in to a table Eligible and non-eligible into a table nonEligible. I need all fields from the original table. I have a source file in Access XP format...

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

Hi Everybody, Being the Oracle DBA (9i) on the machine MI I have just logged into the ORACLE account and issue the UNIX command to find the following processes: ora-ckpt_MI01 ORA-SMON_MI01 ORA-PMON_MI01 ORA-DBW0_MI01 ORA-LGWR_MI01 ORA-RECO_MI01 While I am logged into the database and...

Hi, I work at SunOS 5.9 with Oracle 9i I have the following questions: 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...