cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SAS_1001
Obsidian | Level 7 SAS_1001
Obsidian | Level 7
Go to Solution

SAS VA 7.4 Db2

Posted 02-03-2018 01:19 PM (939 views)

I'm wondering as to how to automate db2 queries in SAS VA.  I'm directly connecting to DB2 from SAS VA and joining the tables, aggregations, derivations, etc.  I need to automate this process.  How can I automate this process to run on a daily basis to bring DB2 data into LASR directly ?

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star SASKiwi
PROC Star

Re: SAS VA 7.4 Db2

Posted 02-03-2018 09:02 PM (1010 views)  |   In reply to SAS_1001

Check out the scheduling capabilities in SAS VA:

http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkex...

 

Personally I prefer to schedule jobs in VA from SAS Management Console as that is where you can also schedule non-VA batch jobs.

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star SASKiwi
PROC Star

Re: SAS VA 7.4 Db2

Posted 02-03-2018 09:02 PM (1011 views)  |   In reply to SAS_1001

Check out the scheduling capabilities in SAS VA:

http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkex...

 

Personally I prefer to schedule jobs in VA from SAS Management Console as that is where you can also schedule non-VA batch jobs.

SAS_1001
Obsidian | Level 7 SAS_1001
Obsidian | Level 7

Re: SAS VA 7.4 Db2

Posted 02-05-2018 11:05 AM (865 views)  |   In reply to SASKiwi
Thank you. That helps !
0 Likes

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • ‎02-03-2018 01:19 PM
  • 940 views
  • 2 likes
  • 2 in conversation