Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: How to pull a table from sql server by using JCL??
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: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 22, 2010 1:24 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 22, 2010 2:47 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 22, 2010 2:52 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Oct 22, 2010 7:19 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Sat Oct 23, 2010 2:31 am    Post subject: Reply to: How to pull a table from sql server by using JCL??
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

Active Member


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

PostPosted: Sun Oct 24, 2010 2:05 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Liberty Angel Server using RACF Keyring martin9 CICS 0 Tue May 02, 2017 5:49 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us