Search results for query: *

Thank you so much! The information you provided was enough to find the appropriate Tech Doc on the sas website. I ended up doing the following: LIBNAME ora1 oracle user=username password=password path="db-path" schema=schemaname; LIBNAME ora2 oracle user=username password=password...

I currently use a proc sql; statement to grab data from a table in Oracle to create a data set that I later manipulate in SAS. I have a particular query that utilizes db-links, allowing me to write a select statement accessing tables in various schemas. I would like to use this select statement...

This is great. We use autosys in UNIX and we wanted a way to call the specific programs from autosys. Thank you so much.

Hi, We are running a server copy of SAS (UNIX) and there are a couple programs that we run on a fairly regular basis. We were wondering if there was a way to run SAS programs from the command line, without even having to go in to SAS. Any help or nudge in the direction would be appreciated! fyr

I use Oracle here. so we use the following snipped of code: proc sql stimer; connect to oracle as mydb(user=username orapw=password path="path-to-db" preserve buffsize=1000); create table lib.table as select * from connection to mydb (ORACLE SQL QUERY); disconnect from mydb;

Hi, I am trying to do a nested query in Sybase. I have done the following query: Select * from (Select a,b from table) in the past in Oracle. When I try this in Sybase, it complains of a syntax error. Is it possible in Sybase? And how can it be done? Thanks Fyr

Job compiles properly. When validating, it gives the following error: DataStage Job 104 Phantom 6227 Program "DSD.WriteLog": Line 95, WRITE failure. Attempting to Cleanup after ABORT raised in stage SourceLoad.insert_temp DataStage Phantom Aborting with @ABORT.CODE = 3 Now, I have...

Nothing in the alert log. That is the weird part. The system doesn't seem to recognize there was an error except for this specific error. Oracle seemed not to know what was going on either.

Hi, I am running Oracle 7 on a Unix server and all the tables are loaded by SQL*Loader. I have a table that is a parent of another, and a child of yet another table. I had to alter that table, so I dropped the table and re-ran the script to build it again with the modified fields. Now, when I...

Here is a bit more of a broad question. I currently have DataStage installed on to two servers (the two are distinct unix boxes). One is being used as development and the other as production. I would like to migrate the jobs I developed on Server1 to Server2. Is there an easy and painless way to...

If someone has seen this behavior before and knows how to fix it in Designer I will be forever grateful. (and if this is a simple question, thanks for obliging) While building a job in Designer, I noticed suddenly that when clicking on the Transformer stage to edit, I was no longer seeing the...