Ask a Question
Tech Areas
4GL (0)
Contact Management (1)
Data Manipulation (0)
MS Access (0)
MS SQL Server (1)
Oracle (2)
Reporting (0)
Software (0)
Latest Database Jobs
Teradata DBA - new
Qss - Germantown, MD - Tech jobs in Germantown, MD - Tech jobs in Maryland - Database Administrator 11 hours ago
Corporate Consulting Services - Trumbull, CT Coordinates the implementation of databases, support of applications, database... 1 day ago
Global Techforce - Boston, MA This role is for a Database Engineer who will be responsible for designing, 1 day ago
Database

Welcome! to the Database area! Please post your questions or search now!

Subscribe to the Database forum
2009
1 Response
0
0
When I try to initiate a new Slony cluster in the PgAdmin interface, the status-bar says "Slony-I creation scripts not available; only joining possible" .. OS : windows PostgreSQL version : 8.4 I fallowed some solutions like ? Xxid.sql, slony1_funcs.sql, slony1_base.sql file copy and rename as a Xxid.v84.sql, slony1_funcs.v84.sql, slony1_base.v84.sql ? All this script copy in to C:\WINDOWS\system32 folder ? In pgadmin option’s specified correct patch like “C:\Program Files\PostgreSQL\8.4\share” But the problem persists. Could you help me? Are there any solution? Thanks in advance for your support Best regards
Subscribe:
2009
1 Response
0
0
How do I disable the window that pops up telling me that I haven't synced for 90 days and if I don't sync the database will expire.
Subscribe:
2008
0 Responses
0
0
If you have a nested transactions one inside the the other and if you commit inside the inner trasction, will it effect the outer one ?
Subscribe:
2008
0 Responses
0
0
My Oracle is 10.2.0.3.0. TOAD DEVL environment: 1) CREATE TABLE trg_farinvc AS SELECT fabinvh_vend_pidm pidm, fabinvh_code inv#, fabinvh_pohd_code PO#, fabinvh_vend_inv_code vend_inv#, fabinvh_invoice_date inv_date, fabinvh_pmt_due_date due_date, fabinvh_invoice_type_ind inv_type, farinvc_comm_desc comm_desc, sum( NVL(farinvc_appr_unit_price, 0) * NVL(farinvc_appr_qty, 0) + NVL(farinvc_addl_chrg_amt, 0) + NVL(farinvc_tax_amt, 0) - NVL(farinvc_disc_amt, 0) ) as tot_amt FROM farinvc, fabinvh WHERE farinvc_invh_code = fabinvh_code AND fabinvh_complete_ind = 'Y' AND fabinvh_cancel_ind = 'N' AND fabinvh_pmt_due_date >= to_date('07/01/2008', 'mm/dd/yyyy') AND fabinvh_pmt_due_date < to_date('08/15/2008', 'mm/dd/yyyy') --AND farinvc_invh_code like 'I8%' GROUP BY fabinvh_vend_pidm, fabinvh_code, fabinvh_pohd_code, fabinvh_vend_inv_code , substr(fabinvh_vend_inv_code, 1, 5), fabinvh_invoice_date, fabinvh_pmt_due_date , fabinvh_invoice_type...
Subscribe:
2008
0 Responses
0
0
create table jctdp ( site number, subject number, fieldname varChar2 ( 20), fieldval varchar2(10) ); /******insert values *****/ /** VIS1N **/ insert into jctdp values (10085,1, 'VSN1N','1'); insert into jctdp values (10085,1, 'VSN1N','2'); insert into jctdp values (10085,1, 'VSN1N','3'); insert into jctdp values (10085,1, 'VSN1N','4'); insert into jctdp values (10085,1, 'VSN1N','5'); /** STNSBP1N **/ insert into jctdp values (10085,1, 'STNSBP1N','140'); insert into jctdp values (10085,1, 'STNSBP1N','150'); insert into jctdp values (10085,1, 'STNSBP1N','160'); insert into jctdp values (10085,1, 'STNSBP1N','170'); insert into jctdp values (10085,1, 'STNSBP1N','175'); /**STNSBP2N **/ insert into jctdp values (10085,1, 'STNSBP2N','145'); insert into jctdp values (10085,1, 'STNSBP2N','155'); insert into jctdp values (10085,1, 'STNSBP2N','165'); insert into jctdp values (10085,1, 'STNSBP2N','175'); insert into jctdp values (10085,1, 'STNSBP2N','170'); ...
Subscribe:
2008
0 Responses
0
0
Hi, I'm trying to create a macro that returns the number of months elapsed between two dates. The macro would be called in a datastep pulling in the dates from two variables and returning the months difference into a new variable. Here is what I have so far: ************************* %macro months_elapsed(date1, date2); %let year1 = year(&date1); %let year2 = year(&date2); %let month1 = month(&date1); %let month2 = month(&date2); %let day1 = day(&date1); %let day2 = day(&date2); %let month_diff = &year2*12 + &month2 - &year1*12 - &month1; %if &day1<&day2 %then %let month_diff = &month_diff - 1; &month_diff.; %mend; data test2; set test; month_diff = %months_elapsed(firstdate,seconddate); run; ************************* Everything works splendidly up until the if statement, where SAS cannot resolve my macro variable to be the value of the variables firstdate and seconddate, but instead thinks that &day1 = "firstdate" and %day2 = "seconddate". How do I make sure that the valu...
Subscribe:
2008
0 Responses
0
0
Hi, I'm trying to create a macro that returns the number of months elapsed between two dates. The macro would be called in a datastep pulling in the dates from two variables and returning the months difference into a new variable. Here is what I have so far: ************************* %macro months_elapsed(date1, date2); %let year1 = year(&date1); %let year2 = year(&date2); %let month1 = month(&date1); %let month2 = month(&date2); %let day1 = day(&date1); %let day2 = day(&date2); %let month_diff = &year2*12 + &month2 - &year1*12 - &month1; %if &day1<&day2 %then %let month_diff = &month_diff - 1; &month_diff.; %mend; data test2; set test; month_diff = %months_elapsed(firstdate,seconddate); run; ************************* Everything works splendidly up until the if statement, where SAS cannot resolve my macro variable to be the value of the variables firstdate and seconddate, but instead thinks that &day1 = "firstdate" and %day2 = "seconddate". How do I make sure that the valu...
Subscribe:
2008
0 Responses
2
0
Looking for a MS-SQL DBA – for 15-20 hours per week on a steady basis. To do consulting, troubleshooting and training. This person needs to be a hard-core MS-SQL person and will be on site (not remote) – this person will have a regular schedule and also be available for emergencies. We are located in Dallas, TX. If interested please email your resume to mverver@neospire.net and include MS-SQL DBA in the subject line.
Subscribe: