MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SAS doubts

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
emadhubabu
Beginner


Joined: 03 Sep 2005
Posts: 13
Topics: 6

PostPosted: Fri Dec 09, 2005 6:50 am    Post subject: SAS doubts Reply with quote

my requirement is:

I had list of variable names in a file.
I have to read a table once for each variable name.
And I have to copy the result of each variable name in to a separate
new member in a PDS. ( member creation should be dynamic)

I have 3500 members to be created..


Please help me!
Back to top
View user's profile Send private message
emadhubabu
Beginner


Joined: 03 Sep 2005
Posts: 13
Topics: 6

PostPosted: Fri Dec 09, 2005 9:37 am    Post subject: Reply with quote

I am making my requirement so more clear...

1. I have a PDS with 3500 members.

MEMBER1, MEMBER2,......MEMBER3500

2. Each member has the data like this
abcedefgh
( ABCD123.*
BCDE234.*
CDEF345.*
-----
---- )
xyz
xyzasasa
xyxx

3. I have a DB2 table for which I will pass a SQL like
SELECT COL1
FROM DB2_TABLE
WHERE COL2 = MEMBERXXXX

4. The result coming the SQL will contain the data

If data is
ABCD123
BCDF234
CDEF345
matching with the data in the braces " () "
copy the member from PDS to another NEW_PDS

if data is not matching means
ABCD123
CDEF345
leave the member

5. Like this I have to copy 3500 members and copy the matching member to another PDS.

Please help me

Thanks
Madhu Babu
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group