MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 7 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Help on DFSORT
Veera333

Replies: 3
Views: 2352

PostForum: Utilities   Posted: Tue Mar 22, 2011 12:53 am   Subject: Help on DFSORT
Hi,

There is no matching key. Both the files are sequential and LREC = 1300 for file 1 and LRECL= 500 for file2.

Small correction in my question, i should not create a new output file.I should r ...
  Topic: Help on DFSORT
Veera333

Replies: 3
Views: 2352

PostForum: Utilities   Posted: Mon Mar 21, 2011 8:11 am   Subject: Help on DFSORT
Hi,
I have a requirement where i have two input files of different LRECL.

The output file must have the content of input files as follows
1: 43 content of file1 for first 43 bytes
44:10 conten ...
  Topic: Help regarding sort card
Veera333

Replies: 2
Views: 2637

PostForum: Job Control Language(JCL)   Posted: Sun Dec 05, 2010 12:57 am   Subject: Help regarding sort card
Hi,

I have a requirement as follows

I have a file with Columns: Name,Designation, Band

I have to extract all the records with designation as 'Engineer'

Then If band is 'E' i have populate ...
  Topic: Help on Reorg
Veera333

Replies: 1
Views: 2052

PostForum: Database   Posted: Thu Oct 07, 2010 3:48 am   Subject: Help on Reorg
Hi,
I am coding Reorg for a DB2 table. Please help me how to find the mapping table that is to be coded in REORG.


Thanks in advance,
Veera
  Topic: Help on Discard
Veera333

Replies: 1
Views: 1414

PostForum: Database   Posted: Wed Aug 11, 2010 1:53 am   Subject: Help on Discard
Hi,

Can i use joins in DISCARD statement.

For example DISCARD FROM TABLE A
WHEN (SELECT 1 FROM TABLE B
WHERE A.COLUMN1 = B.COLUMN1) ...
  Topic: JCL to bind the program
Veera333

Replies: 5
Views: 2667

PostForum: Database   Posted: Wed Jul 21, 2010 7:43 am   Subject: JCL to bind the program
Hi,
In development region i have to bind the program whenever i do a reorg on a table.

I was assuming the same case in production as well. Dont i need to bind or rebind the program every time reor ...
  Topic: JCL to bind the program
Veera333

Replies: 5
Views: 2667

PostForum: Database   Posted: Tue Jul 20, 2010 8:31 am   Subject: JCL to bind the program
Hi,
Is there any JCL that binds the program and can be scheduled as daily or weekly job for rebinding.


Thanks in advance,
Veera
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group