IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to pull a table from sql server by using JCL??


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
selvaaug

New User


Joined: 21 Oct 2010
Posts: 3
Location: Chennai

PostPosted: Fri Oct 22, 2010 1:04 pm
Reply with quote

Hi!! My task is, to pull sql data into mainframe as flat file by using JCL.
Help me to solve this...??
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Oct 22, 2010 1:24 pm
Reply with quote

Ask your own site support people / DBA's how this is done at your site.

The software and/or standards may vary from site and as we know nothing about your site, nor indeed wish to. These people will give you he best answer available.
Back to top
View user's profile Send private message
selvaaug

New User


Joined: 21 Oct 2010
Posts: 3
Location: Chennai

PostPosted: Fri Oct 22, 2010 2:46 pm
Reply with quote

Hi,thnx for your response.Actually,wat am asking is, any utility available to connect to the sql server in JCL? (In general). If so, can u plz give me one example?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Oct 22, 2010 2:47 pm
Reply with quote

expat wrote:
Ask your own site support people / DBA's how this is done at your site.

The software and/or standards may vary from site and as we know nothing about your site, nor indeed wish to. These people will give you he best answer available.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Oct 22, 2010 2:48 pm
Reply with quote

@expat: Is this even possible without a script on the Windows machine ?
We do this by triggering a script on the SQL server server and ftp-ing the file afterwards.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Oct 22, 2010 2:52 pm
Reply with quote

@GuyC: That is why I suggested he ask HIS OWN (subtle hint there selvaaug) support people.

Should have saved my time and electrons really for all the good it done icon_rolleyes.gif
Back to top
View user's profile Send private message
selvaaug

New User


Joined: 21 Oct 2010
Posts: 3
Location: Chennai

PostPosted: Fri Oct 22, 2010 3:00 pm
Reply with quote

Actually am in situation it is not possible to ask my colleague. thats why i posted here. anyway thnx. I ll see.bye.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Oct 22, 2010 7:19 pm
Reply with quote

Hello,

Quote:
Actually am in situation it is not possible to ask my colleague.
Then you probably won't be using that SQL Server. . .

You will most likely need to ask someone to define "things" on the remote server (unless you happen to be the sysadmin/dba for that system.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Oct 23, 2010 2:31 am
Reply with quote

Quote:
Actually am in situation it is not possible to ask my colleague. thats why i posted here. anyway thnx. I ll see.bye.


a forum is not a foster home for the orphans of poor organization
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1041
Location: Richmond, Virginia

PostPosted: Sun Oct 24, 2010 2:05 am
Reply with quote

Idea

Sign your colleagues up for the forum. Then when you post here, your colleagues can reply.

Use a fake name so they won't know you're the one they're helping (hee hee).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top