About DavidCaliman

DavidCaliman · ‎05-28-2014

Is there some setting in the Web Report Studio not to lock a table while to perform a load on Data Integration Studio on the same table? Is occurring locked table error in insert while a report is running on the Web Report Studio.

DavidCaliman · ‎04-22-2014

What command can I use to physically remove observations marked as deleted and reduce the physical size of the sas base and index file?

DavidCaliman · ‎04-03-2014

Yes. In fact, my job J_MAIN has 100 JOBS and so is bursting the work space before it finished completely.

DavidCaliman · ‎04-03-2014

Good morning! I'm running a job (J_MAIN) within DI Studio that has 3 jobs within it sequentially (J1 -> J2 -> J3). I noticed that when J1 finished and J2 is running, the J1 work files are not erased. Does anyone know if there is some kind of setup for after the successful execution of J1, be cleaned the work files used in the J1 before starting automatically J2?

DavidCaliman · ‎04-01-2014

Good morning! I created a chart report (attached image), however I can not increase the size where this description. I use the commands: GOPTIONS device = png xpixels ypixels = 750 = 350; axis1 order = (1 to 10 by 1) minor = none major = none style = 0 offset = (5.0,5.0) value = none; axis2 label = none order = (2011 to 2014 by 1) minor = none major = none value = (angle = 90) style = 0 offset = (2.0,2.0); axis3 order = (1 to 10 by 1) minor = none major = none label = none value = none style = 0 offset = (5.0,5.0); How do I keep the size of the graph and expand the size of the label??

DavidCaliman · ‎03-19-2014

Hi!! I have three tables: ODS.DATE (SAS TABLE) - Column DATE (numeric 😎 format DATETIME20. ODS.CUSTOMER (SAS TABLE) - Column ID (numeric 😎 ORA.CUSTOMER (ORACLE TABLE) - Column ID (number), Column DAT (date) I need to run this code: PROC SQL NOPRINT; select date into :LOAD_DATE from ODS.DATE QUIT; proc sql; connect to oracle as conn (path='XXXX' user=XXXXX password="XXXXX"); insert into ODS.CUSTOMER select ID from connection to conn ( select ID from ORA.CUSTOMER where dat >= "&LOAD_DATE" ); disconnect from conn; quit; The following error is occurring: - ERROR: ORACLE prepare error: ORA-00904: " 01JAN1900:00:00:00": invalid identifier. SQL statement: select * from ORA.CUSTOMER where dat >= " 01JAN1900:00:00:00". Does anyone know how I Can pass the parameter correctly for Oracle?

DavidCaliman · ‎02-18-2014

Forgiveness. I marked the wrong answer as helpful.

DavidCaliman · ‎02-18-2014

It worked fine. Thanks a lot everybody.

DavidCaliman · ‎02-18-2014

DBailey, I ran your program here and it worked. Ran only 1 sql on database. How would the adaptation of the command below to insert rather than create? create table work.test as select * from connection to cdbmr ( 20 select date_value from mdm.dbdates 21 where date_value= to_date('30Nov2013') 22 );

DavidCaliman · ‎02-18-2014

My Log: 729 /*---- Start of User Written Code ----*/ 730 731 options sastrace=',,,d' sastraceloc=saslog; 732 proc sql; 733 connect to oracle (user=XXXXX password=XXXXXX); 734 INSERT INTO ODS.ODS_CUSTOMER 735 SELECT * 736 FROM ORA.CUSTOMER 737 WHERE ID IN (1,2); 12 1705687392 Main 0 SQL (2) ORACLE_4: Prepared: on connection 2 13 1705687392 Main 0 SQL (2) SELECT * FROM CUSTOMER 14 1705687392 Main 0 SQL (2) 25 The SAS System 13:28 Saturday, January 18, 2014 15 1705687392 Main 0 SQL (2) 16 1705687392 Main 0 SQL (2) ORACLE_5: Prepared: on connection 2 17 1705687392 Main 0 SQL (2) SELECT "ID", "DESC" FROM CUSTOMER WHERE ( ("ID" IN ( 1 , 2) ) ) 18 1705687392 Main 0 SQL (2) 19 1705687392 Main 0 SQL (2) 20 1705687392 Main 0 SQL (2) ORACLE_6: Executed: on connection 2 21 1705687392 Main 0 SQL (2) SELECT statement ORACLE_5 22 1705687392 Main 0 SQL (2) 23 1705687392 Main 0 SQL (2) NOTE: No rows were inserted into ODS.ODS_CUSTOMER.

DavidCaliman · ‎02-18-2014

I'm looking to the Oracle v$sqlarea view. And there are running the two SQLs.

DavidCaliman · ‎02-18-2014

DBailey, This code is also generating 2 SQLs in the database.

DavidCaliman · ‎02-17-2014

With the sastrace option I really identified that SAS is sending two SQL statements to Oracle. I still can not solve the problem.

DavidCaliman · ‎02-17-2014

Using the option DBIDIRECTEXEC the problem persists.

DavidCaliman · ‎02-14-2014

CTorres, I´m using SCD Type 1 Loader. My target is as SAS Table. The value for FLAG is 0 or 1.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Using a prompt value in a Data Item - IMS

Using a prompt value in a Data Item - IMS

Report Scheduling with In-Process Scheduling

Re: CREATE TABLE AS SELECT

CREATE TABLE AS SELECT

DI THREADS and CPUCOUNT

Add SAS Table Column with Default Value

Proc SQL Delete Very Slow

Web Report Studio - Queries

How to pass the job name via email in DI?

Table locked by Web Report Studio

Clean Deleted Observations

Re: Work Files - Sequential JOB

Work Files - Sequential JOB

Chart Report - Expand label size

DateTime Parameter in Oracle PROC SQL

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Warning in DI Studio