Thursday, March 31, 2005

Submit JCL through FTP

This is something that I did back in my MCI days of integrating Windows NT servers with mainframes in the land of no budget.

1. Establish a connection with the MVS/S390/Z-OS host
2. quote site filetype=jes
3. put preexist.jcl
Where preexist.jcl is the JCL that will be submitted. It needs to be located on the submitting box, not the mainframe.

Also, I found article that says you can retrieve the output thusly:

To submit a pre-existing JCL job stream via FTP and retrieve the results can be as simple as:
ftp mvs.host
quote site filetype=jes
get preexist.jcl jes.output

http://expertanswercenter.techtarget.com/eac/
knowledgebaseAnswer/0,295199,sid63_gci984797,00.html

To further automate the process, you can store the ftp commands in a file and use ftp -s:

Wednesday, March 30, 2005

Problem getting JAVA GUI to show itself

When i would run the debugger on a SWING based JAVA utility that I had written using WSAD in order to read data from an iseries DTAQ object, and the java icon would appear when doing an alt-tab, but I couldn't find the GUI. Turns out that WSAD didn't auto-generate the following code ...


TEST1 T1 = new TEST1();
T1.show();

... in the main method.

I don't know if this was my mistake, or if WSAD is really this challenged to anticipate the need for this terribly, terribly boiler-plate code.

By the by, why aren't there any freely downloadable iseries utilities to work with dataqueues? I'll post the one that I have when it's "finished". That could be a while. It currenlty will only read from a dataqueue and clear the contents.

Yep, I'm an idiot: WSAD import

Again, to my knowledge, all you need to do is the steps I depicted below.

-----Original Message-----From: Hayes, Joe Sent: Tuesday, March 29, 2005 10:11 AMTo: Indraganti, Sastry; Zheng, JasonSubject: RE: WSAD Question

You’re the man, Sastry. Much obliged.
So, to clarify, in the future, do I need to do all three of these things, or do I just need to do the thing that you said?
Thanks again.
Joe

_____________________________________________From: Indraganti, Sastry Sent: Tuesday, March 29, 2005 10:03 AMTo: Hayes, Joe; Zheng, JasonSubject: RE: WSAD Question

To the best of my knowledge, Go to your project, click on properties, Go to Java build path, then to libraries and then click on add external jars and browse to wherever you have jt400.jar. This should solve the problem.
Jason- You could correct me if I am wrong. Thanks!
Sastry

-----Original Message-----From: Hayes, Joe Sent: Tuesday, March 29, 2005 9:58 AMTo: Zheng, Jason; Indraganti, SastrySubject: WSAD Question
I’m trying to get WSAD to import com.ibm.as400.* from JT400, but keep getting a message stating that com.ibm.as400 cannot be resolved.
I’ve added the jt400.jar file to my classpath variable via Window->Preferences->Java->CLASSPATH.
I’ve also right-clicked the project and done import->File System-> and browsed to the jar file to select it.
Is there something else that I have to do to get WSAD to find the jar file?
Joe

DBA Categories from Brent Ozar

Brent Ozar shared a post on the categories for a SQL Server DBA. NOTE that these overlook things like BI or data scientist professionals, w...