Search results for query: *

good day We wish to subtract the CURR_TIME(Jobname_01) from CURR_TIME(Jobname_02) and update the column DURATION((Jobname_02) with the result. Excerpt from the DATALOAD_EXEC_LOG Table: CURR_DATE DATE FORMAT 'YY/MM/DD', CURR_TIME CHAR(8), DURATION CHAR(8), JOBNAME VARCHAR(64) CURR_DATE...

good day, I have separate sql-scripts to drop mytable create mytable with description of variables insert data from other tables into mytable grant select privileges to USER2 how do I combine these into one single sql-script? if somecriteria (mytable exists) then drop table mytable create...

hi and good day, need to develop an updateroutine for our report data. Script 1 gathers the data from a definite starting point eg. start of financial year to date. After successful completion ORA-table MaxDate is created. Script 2 is the update part for Script 1. According to the value...

good day, need to develop a SAS script to import data from a textfile into PALO olap DB. An example provided (using PHP) reads as follows: <?php define('HOST', '127.0.0.1'); define('PORT', '7777'); define('USER', 'admin'); define('PASS', 'admin'); $connection = palo_init(HOST, PORT, USER...

good day, I need to run my Main SAS script, in which I have INCLUDEed the tasks that need to accomplished after a certain condition has been met. Basically it should operate as follows: My SAS script would test, say from 05h00 onward, whether a specific datevariable meets the condition or not...

good day, the number of hours and minutes between two dates have to be calculated. eg sdate = 18APR2007:10:34:51 edate = 19APR2007:09:22:58 Any assistance is most welcome. Kind regards Karlo

good day, where could I find a sample application typically an Invoicing or reporting application written with SAS The app should contain a login module display reports using IE. Kindest regards Karlo

Hello and good day, I need to join the following two tables in Access: The SQL script looks like this: FROM VBWADM.VBW_FACT a, ADBADM.SALES_ORG b WHERE (a.SALES_NUMBER=b.SALES_NUMBER_ AND a.REPORT_DATE BETWEEN b.VALID_FROM AND b.VALID_THRU) The SQL-Statement generated by Access (using the...

hello and good day in my SAS script I have the following proc sql statement: rsubmit; proc sql; create table myTable as ( select ProductTarif, sum(number_of_items) from Orders where Sales_Channel in ('A', 'B', 'C') and ProductTarif in ('X', 'Y', 'Z') and...

Hello and good day, to my script I would like to add a MsgBox that informs the user what is currently happening: for example: ' switch WarnMsgs OFF DoCmd.SetWarnings False ' copy File1 to File1_old DoCmd.OpenQuery "Backup_File1", acViewNormal, acEdit MsgBox "File1 copied to...

good day, how do I export the result of a Query to an existing Excel file (containing further information) and place the Data on a specified Tab ? Thank you for you're valued assistance. Kind regards Karlo meistertools@gmx.net

hello and good day, how do I ... export the result of an Access query to an existing Excel file and place it on a specified tab ? Thanks for valued response. Kind regards Karlo meistertools@gmx.net

good day, is it possible to compact and repair an Access DB using a Macro inside the DB ? Any useful tips would be highly appreciated. Kind regards Karlo meistertools@gmx.net

good Day, I wish you and your relatives a happy and prosperous 2005. In my script I create 3 different SAS datasets DATA=WORKUNIX.MonthlySum DATA=WORKUNIX.SalesChannelMonth DATA=WORKUNIX.SalesRegionsMonth which I export separately to excel using the following PROC EXPORT: PROC EXPORT DATA=...

Hi all, I have created a SAStable(origtable) from an excel table using PROC IMPORT. Now I would like to replace the data in an ORAtable(desttable) with the data from the SAStable. I can't use DBLOAD, because the varnames are longer than 8 chars. Any help is much appreciated. Kind regards...

hi everyone, with the following script we create a SAS-table from an Oracle DB: rsubmit; proc sql; connect to oracle(user=&quot;&uname&quot; password=&quot;&pw&quot; path=&quot;db_path&quot; buffsize=200); create table TABLENAME as select * from connection to oracle ( select tbl1.column1 as...

hi all, after comparing two identical tables (source, destination) with select s.col1, s.col2, s.col3 from source s where whereclause and and 1 = some condition and and 2 = another condition and (s.col1, s.col2) not in (select col1, col2 from...

good day, need to INSERT INTO tablename (col1, col2, col3) ca 1500 rows of textdata from .dat file (semi-colon separated). Any help is much appreciated. Kind regards. Karlo meistertools@gmx.net

Hi everyone, how do I create an Access db using a script - like SQL create table. Any help most welcome. Kind regards. Karlo meistertools@gmx.net

Hi all, I wish to display the current system date in a text field of status bar. Similarly, I wish to display the current system time. It should not be static, but be updated similar to the windows time display normally in the right bottom corner (of Windows) Any help much appreciated. Kind...