Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8657
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: 8657
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: 8657
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: 10457
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: 972
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 Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Defining SSL Port in TCPIP for DB2 Se... Yolanda Harvey TSO/ISPF 1 Wed Mar 28, 2018 7:33 pm
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts COBOL declaration for table Poha Eater DB2 3 Mon Feb 26, 2018 6:58 pm
No new posts load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us