 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 34 matches |
| Author | Message |
|---|---|
 Topic: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
|
| Bharath.AK Replies: 10 Views: 5413 |
 Forum: Application Programming Posted: Wed May 25, 2011 9:43 am Subject: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
| Thank you kolusu & papadi...
I'm not at all into sql or mainframe or db2 programming, but had to work on this. Yes, I have to 'learn' db2 (but not 'brush up')  And yes, I definitely will avoi ... |
|
| Topic: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
|
| Bharath.AK Replies: 10 Views: 5413 |
Forum: Application Programming Posted: Fri May 20, 2011 1:19 pm Subject: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
| Kolusu, thatk you for your time to help me out in this regard. Actually I am not coding this PROC SQL stmt on mainframe, but in a SAS application. SYSIBM.SYSDUMMY1 is a utility used in JCL, correct? ... | |
| Topic: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
|
| Bharath.AK Replies: 10 Views: 5413 |
Forum: Application Programming Posted: Fri May 20, 2011 11:53 am Subject: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
| Kolusu, if this helps,
1. If the LIBUSER.AdUser NOT = 'ALL', then I should create the TEMP table as create table temp as select distinct a.adgroup, d.aduser from group a, libuser d where a.li ... |
|
| Topic: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
|
| Bharath.AK Replies: 10 Views: 5413 |
Forum: Application Programming Posted: Fri May 20, 2011 11:42 am Subject: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
| Hello Kolusu,
The thing is we are working on restricting our SAS users to have access to only few libraries instead of all available libraries. When the value of AdUser in LIBUSER table is 'ALL' ... |
|
| Topic: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
|
| Bharath.AK Replies: 10 Views: 5413 |
Forum: Application Programming Posted: Fri May 20, 2011 11:05 am Subject: WHERE statements based on IF-THEN-ELSE conditions - PROC SQL |
| Hello,
Please help me out with this scenario: I have 2 tables - One is GROUP and another is LIBUSER. GROUP contains AdGroup and Library variables; LIBUSER contains Library and AdUser variable ... |
|
| Topic: SAS MERGE Issue - Please Recommend! |
|
| Bharath.AK Replies: 1 Views: 1868 |
Forum: Application Programming Posted: Thu Feb 18, 2010 3:20 am Subject: SAS MERGE Issue - Please Recommend! |
| Hi,
I have two datasets: Dataset A: Key: Misc: AMC WIRE AMC WIRE AMC WIRE ABD XXXX Datase ... |
|
| Topic: NDM Through JCL - Passing Parameters to NDM PROC? |
|
| Bharath.AK Replies: 6 Views: 17798 |
Forum: Job Control Language(JCL) Posted: Sat May 02, 2009 10:40 am Subject: NDM Through JCL - Passing Parameters to NDM PROC? |
| Hi,
My bad. I wasn't clear on my question. Actually In JCL, it is SET REG='NC' SET ID='T' SET NUID='F7777' In NDM Step (but no Proc), DS1 = '&NUID..®..TEST&ID..SASDA ... |
|
| Topic: NDM Through JCL - Passing Parameters to NDM PROC? |
|
| Bharath.AK Replies: 6 Views: 17798 |
Forum: Job Control Language(JCL) Posted: Fri May 01, 2009 7:53 pm Subject: NDM Through JCL - Passing Parameters to NDM PROC? |
| Hi,
I need to NDM files (some hundreds) from a batch job (not from the Panel). To reduce the effort, I decided to pass parameters from JCL to NDM Proc each time I run the batch job. But I found ... |
|
| Topic: Writing/ Modifying JCLs |
|
| Bharath.AK Replies: 2 Views: 2199 |
Forum: Job Control Language(JCL) Posted: Tue Feb 24, 2009 8:25 pm Subject: Writing/ Modifying JCLs |
| Hi Kolusu.. You wouldn't know how much it's helpful for me Thank you so much for your time to share with me...
You have a great day ahead! ~BK |
|
| Topic: Writing/ Modifying JCLs |
|
| Bharath.AK Replies: 2 Views: 2199 |
Forum: Job Control Language(JCL) Posted: Tue Feb 24, 2009 6:17 pm Subject: Writing/ Modifying JCLs |
| Hi,
This sounds too funny but it's the fact. I have been asked by USCIS the question - Why atleast a bachelor's degree is required to write/ modify JCLs at your job position? Firstly I found it so ... |
|
| Topic: difference between NDM and BFTS |
|
| Bharath.AK Replies: 2 Views: 2512 |
Forum: Utilities Posted: Fri Apr 04, 2008 5:36 am Subject: difference between NDM and BFTS |
| Let me put my idea on this!
BayScribe File Transfer Service is kind of utility that can be used on 'Windows' environment which communicates with the BayScribe's web server, to recieve or send files ... |
|
| Topic: Blog on one of the Forums! |
|
| Bharath.AK Replies: 6 Views: 17756 |
Forum: Related Non-Technical Topics Posted: Mon Mar 31, 2008 9:42 pm Subject: Blog on one of the Forums! |
| Chill... no hard feelings/statements please... | |
| Topic: Blog on one of the Forums! |
|
| Bharath.AK Replies: 6 Views: 17756 |
Forum: Related Non-Technical Topics Posted: Mon Mar 31, 2008 10:58 am Subject: Blog on one of the Forums! |
| you are absolutely correct... but at the same time, people are not so foolish to post the blogs with no reason... right?
anyways, I'm glad mvsforums understands the situation of the members.. atleast ... |
|
| Topic: Blog on one of the Forums! |
|
| Bharath.AK Replies: 6 Views: 17756 |
Forum: Related Non-Technical Topics Posted: Mon Mar 31, 2008 6:10 am Subject: Blog on one of the Forums! |
| Moderators showing their personal frustration on the members:
I wish we (mvsforums.com) won't have a bad reputation! |
|
| Topic: DASD File Owner? - Not a Production file |
|
| Bharath.AK Replies: 10 Views: 8828 |
Forum: Data Management Posted: Fri Mar 28, 2008 1:34 am Subject: DASD File Owner? - Not a Production file |
| Hi,
I was trying to find out who is the owner of a flat file on DISK, which is not a production file to track the catalog details through file touch method. It is very hard to find out the crea ... |
|
All times are GMT - 5 Hours |