View previous topic :: View next topic
|
Author |
Message |
selvaaug
New User
Joined: 21 Oct 2010 Posts: 3 Location: Chennai
|
|
|
|
Hi!! My task is, to pull sql data into mainframe as flat file by using JCL.
Help me to solve this...?? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
selvaaug
New User
Joined: 21 Oct 2010 Posts: 3 Location: Chennai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
@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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
@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 |
|
Back to top |
|
|
selvaaug
New User
Joined: 21 Oct 2010 Posts: 3 Location: Chennai
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1041 Location: Richmond, Virginia
|
|
|
|
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 |
|
|
|