JCL

Need help with FILEAID in BATCH

I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL.My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data.I'm trying (desperately) to create a work-around in order...

View Answer   |  Jun 23 2008   6:31 PM GMT   |  asked by Jonty Walker
DB2, JCL, FILEAID

DSNTEP2 output problem

DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

View Answer   |  Jun 10 2008   4:49 PM GMT   |  asked by Jonty Walker
SQL, DB2, DSNTEP2

Rookie using DSNTEP2 and IBM JCL - Need Help with JCL

I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago.I need to create a JCL that will accept an input file of...

View Answer   |  Jun 10 2008   1:08 PM GMT   |  asked by Jonty Walker
JCL, SQL, DB2

jcl spool command

which spool command is used to release a job with hold option

Answer Question   |  Jun 10 2008   5:43 AM GMT   |  asked by Sravs
JCL, Spool files

Need help executing MULTIPLE SQL extracts from a JCL

GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT.Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

View Answer   |  Jun 3 2008   6:57 PM GMT   |  asked by Jonty Walker
SQL, JCL, DB2

Creating JCL to execute a large merged file of SQL for DB2

I need to create a JCL that will execute - individually - SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?

View Answer   |  Jun 2 2008   4:55 PM GMT   |  asked by Jonty Walker
SQL, DB2, JCL

Problem with highlighting a program or JCL

I am a COBOL developer, and I've got a new terminal (Lenovo) yesterday. I have a problem: I cannot highlight a COBOL program or JCL in the TSO. I type command "HI" in the command line, but instead of getting the next screen with highlight options, I am getting the error message "Invalid terminal"...

Answer Question   |  May 16 2008   8:24 PM GMT   |  asked by Yuefmu
Lenovo terminal, COBOL, JCL

How to change name of file to include date in the name of the file

I want to FTP from mainframe to PC. We run the JCL to do that and this JOB should run every day. Is it possible to change the name of the file that I want to send to the PC everytime? For instance, I'd like to put the month/date/year in the file name. ...

View Answer   |  May 15 2008   4:30 AM GMT   |  asked by Newcoboluser
Job Control Language, JCL, FTP

Unloading specific records in a foreign key, cascade format.

Hi,We have DB2 version 8, os/390. I know how to use QMF and JCL.I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...

View Answer   |  May 13 2008   6:33 PM GMT   |  asked by Donnaw
DB2 Administration, OS/390, DB2

Question about FTP QUOTE SITE - Tandem to Mainframe

I read your answer about the following quote site working for unix and winnt sending to a mainframe. Will this same quote site work for a Tandem to Mainframe transfer?quote site file=jesput my.jclThanks.

Answer Question   |  May 2 2008   1:36 AM GMT   |  asked by FTA
FTP, Mainframes, JCL

How to replace edited dataset in QMF through jcl( i.e Batch)

I have exported one dataset 'IN105.Nord1'through QMF , then I have edited it and now I want to import it in QMF by same name( i.e IN105.Nord1') which I can do it through QMF . But now I would like to achieve same thing by running QMF through jcls( i.e through batch).Can I replace edited dataset...

Answer Question   |  Apr 22 2008   10:59 AM GMT   |  asked by Panky
QMF, JCL