gte Posted January 13, 2010 Share Posted January 13, 2010 I'm trying to query a db2 database and it's designed to use JCL to retrieve information. Can AIT interact with a JCL file? Does anyone have any examples of this? HP OpenView ServiceCenter keep alive scriptRemote Desktop Login Script Link to comment Share on other sites More sharing options...
Developers Jos Posted January 13, 2010 Developers Share Posted January 13, 2010 JCL? The only relation I have with JCL is Job Control Language but that's IBM mainframe stuff. SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
gte Posted January 13, 2010 Author Share Posted January 13, 2010 That is correct.I'm wondering if I can call a jcl file and query a db2 IBM mainframe?JCL? The only relation I have with JCL is Job Control Language but that's IBM mainframe stuff. HP OpenView ServiceCenter keep alive scriptRemote Desktop Login Script Link to comment Share on other sites More sharing options...
Developers Jos Posted January 13, 2010 Developers Share Posted January 13, 2010 So that JCL stuff still exists. I worked with it around 1980 but that were punchcards. Anyway, I have no idea what you mean by "call a jcl file". to me its a fat fat that consists of records with a lenght of 80 characters. Making a call to a db2 database requires at least a ODBC driver that you can work through. Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
gte Posted January 13, 2010 Author Share Posted January 13, 2010 Hi Jos I was a twinkle in my Mom's eye in 1980, hahaThey way our db developers describe this JCL thing in the documentation, is that they make it seem like you can call it almost like an object, and then have it act as a mediary for the high level app and the mainframe.Any ideas? So that JCL stuff still exists. I worked with it around 1980 but that were punchcards. Anyway, I have no idea what you mean by "call a jcl file". to me its a fat fat that consists of records with a lenght of 80 characters.Making a call to a db2 database requires at least a ODBC driver that you can work through.Jos HP OpenView ServiceCenter keep alive scriptRemote Desktop Login Script Link to comment Share on other sites More sharing options...
Developers Jos Posted January 13, 2010 Developers Share Posted January 13, 2010 The JCL I knew was to describe the batch jobs ran daily/weekly/monthly and was just a way to define which programs to run and what files to use. Haven't worked with JCL since 1985-ish and have no idea what you are describing here. Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
PsaltyDS Posted January 13, 2010 Share Posted January 13, 2010 And you're doing this in Windows? A quick google on JCL with DB2 turned up z/OS applications?! Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Developers Jos Posted January 13, 2010 Developers Share Posted January 13, 2010 And you're doing this in Windows? A quick google on JCL with DB2 turned up z/OS applications?! Correct, It use to be a 370 Mainframe running MVS/CICS/TSO/IMS and you connected via a 3270 green tube. SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
gte Posted January 13, 2010 Author Share Posted January 13, 2010 Psalty, I have no idea why this page is setup this way.I have a feeling we have an old cobol programmer that refuses to modernize? I'm going to see if there is some way to export to an access db or an xml or something, so I can parse through thatJos, Psalty, thanks for helping with brainstorming.And you're doing this in Windows? A quick google on JCL with DB2 turned up z/OS applications?! HP OpenView ServiceCenter keep alive scriptRemote Desktop Login Script Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now