About Halaku

bentleyj1 · ‎07-09-2012

Glad to hear that you figured it out. Firewall issue, eh? More research is probably needed because you might not want to disable your firewall client. I know almost nothing about firewalls, but maybe figure out how to tell it that your SAS server is trusted. But then again, if you're on an intranet maybe you don't need a desktop firewall. I googled 'ISA Client' and got lots of hits. Good luck. You might want to mark this question as 'answered'.

Halaku · ‎03-05-2012

I have put a reply, please read and if you have any suggestions...

Halaku · ‎02-10-2012

I have looked already but is not helpful for what I require. I am intrested in details of how to actually implement the concept, may be a sample job or something.

forumsguy · ‎02-10-2012

Thank you very much.. it worked... now can somebody help me in integrating this in one job itself... because this is for loading csv files in table and we will have around 50 fact tables so this will create about 100 jobs which are difficult to maintain...... Please find attached snapshot of my outer and inner job... can we do both these things in same job is my question...

twocanbazza · ‎11-03-2011

hmmmm, I was hoping for the Correct answer points

Tom · ‎10-12-2011

I do not know anything about SAS Enterprise Data Management & Integration, but if you want a data step to generate a macro variable use CALL SYMPUTX in place of your PUT statement. call symputx('vcid',case_id); call symputx('vtstamp',timestamp); Note that this will only work correctly when there is only one observation. If there are mulitple observations then only the last value will remain in the macro variable as the previous values will have been overwritten.

Liangck · ‎10-11-2011

Halaku: ya, i do it all the way with %put ....and i get no result in the log. totally no idea what happen last time... now no problem alreadly, it work well, just want to made sure its not happen again. Anyway,thanks for reply. LiangCk

nar_sas · ‎07-13-2011

One way to try is to use the LOG option that will provide the name of the log file, which wont work if you are running interactively. You can also specify the ALTLOG option if that helps.

Patrick · ‎06-22-2011

Hi If you have already a perfectly working Oracle PL/SQL job then why trying to rebuild everything in SAS DI and not only implement some code in DIS which controls execution of the PL/SQL component. If this would be a way to go then the following paper will be interesting for you: http://www2.sas.com/proceedings/sugi30/063-30.pdf HTH Patrick

CameronLawson · ‎05-14-2011

try the getattr() metadata function. Feed in the &transformID variable to return the name of the object. http://support.sas.com/documentation/cdl/en/lrmeta/60739/HTML/default/viewer.htm#getattr.htm

Halaku · ‎05-13-2011

Thanks folks for the reply.

LinusH · ‎04-19-2011

No, you can't do it (exactly that way). But if you have a job you want to have as template, you can copy the whole job, and then make the appropriate customizations in that job. This will probably work if you try to keep your jobs quite small, so you don't have to copy parts of jobs into each other. /Linus

DaveR_SAS · ‎04-08-2011

The SAS Intelligence Platform: System Administration Guide has some general instructions for promoting jobs that might be helpful: http://support.sas.com/documentation/cdl/en/bisag/64088/HTML/default/viewer.htm#a003139354.htm

Michael_SAS · ‎04-25-2011

Have you tried CURRVAL? it returns the current value of a sequence. here is an example. create sequence seq_customers; select seq_customers.nextval from dual; NEXTVAL ---------------------- 2 select seq_customers.currval from dual; CURRVAL ---------------------- 2

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

Re: DI Studio 4.21 install on Windows 7 x62

Re: DI Studio 4.21 install on Windows 7 x62

Re: DI Studio 4.21 install on Windows 7 x62

Re: DI Studio 4.21 install on Windows 7 x62

Re: DI Studio 4.21 install on Windows 7 x62

DI Studio 4.21 install on Windows 7 x62

How to extract data for last 1/2 hour?

Re: How to extract data for last 1/2 hour?

How to extract data for last 1/2 hour?

How to extract data for last 1/2 hour?

propagating lengths from source to target

propagating lengths from source to target

In DIS Table Loader , how to sort target

Re: DI Studio 4.21 install on Windows 7 x62

How to extract data for last 1/2 hour?

Create XML file using XSL style sheet

Help needed with Loop transformation

How do I reference the INPUT tables joined in a Generated Transformati...

How do I: Loop through the data to build a timestamp string.

Re: User written code had been ignore

Capture log file name in monitoring process:

Re: How do I read and load a .JPG file to Oracle table:

Re: How d I retrieve the Transformation name in a job?

Re: How do I truncate a table using transformation

Re: How do I copy objects from a job to another?

Re: What to look for when moving the development jobs to Production.

Re: HOW TO: Assign a column value to a global variable