-
Verify whether a dataset is empty.
How do you verify whether a dataset is empty using a JCL?
serken
- May 13th, 2017
In SORT (or SYNCSORT) only RC4 or RC16 are allowed for NULLOFL=
RC12 is not allowedNagaraju
- May 12th, 2017
Using IDCAMS along with PRINT parameter.
It returns 0 data available in file.
It returns 4 data not available in file -
Single Row Function
Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same
yuvaevergreen
- Jun 8th, 2011
In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)
Miao Lin
- May 9th, 2011
SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);
-
How to create a PDS file using JCL
Chan
- May 25th, 2019
IEFBR14 is used to create PS file. IEBCOPY is used to create PDS file. Example: //JOB statement //STEP1 EXEC PGM=IEBCOPY //DD1 DD DSN=,DIS...
serken
- May 28th, 2017
PDS has absolutely nothing to do with folder. Those two are the terms from different worlds: mainframe vs. Windows/Unix/Android
-
Group By
Can you select any column in a Group by query even if that column is not groupable?e.g. Select Dept, Empno, Ave(salary) From T1 Group by DeptCan we select empno in the above query?
-
JCL DD Statement
The step contains more than 3273 DD statements then what will happen the job if I submit..?
serken
- Dec 20th, 2008
The original question was about the number OF DD STATEMENTS, not(!) the number of JOB STEPS!
gskn4u
- May 16th, 2008
Maximum of 255 steps will be executed at once. but if you want to execute more then 255, then divide the jcl in parts. run the first JCL and after checking the return code run the next JCL within...
-
-
What are the advantages of GDG?What is the diffrence between a GDG and a File?
dhs01
- Apr 15th, 2009
Basically a GDG is a catalog that will keep track of files. These files have names that conform to a certain standard. They can be generated and referenced using relative numbers. Existing versio...
serken
- Dec 20th, 2008
Actually the dataset names are created as followsX.Y.Z.G00001V00 X.Y.Z.G00002V00 X.Y.Z.G00003V00 X.Y.Z.G00004V00 X.Y.Z.G00005V00 X.Y.Z.G00006V00. . . . . . . . . etc up to the maximum number of genera...
-
How to update a particular row in a file using JCL?
Any utilities? Don't want to use any programs.
kckinney
- Sep 3rd, 2010
JCL itself is unable to do this, however there is a suite of programs beginning with IEB*.I think the one you're looking for is IEBUPDTE. The syntax of the commands are so arcane that it'...
serken
- Dec 20th, 2008
JCL itself cannot update any file. JCL only can execute other programs. Period.Any file update can be done either by a standard utility program, or by specifically written user program. Period.
