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


