sort jcl

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Locked
ht5008253
Member
Posts: 1
Joined: Sat Sep 14, 2013 12:34 pm

sort jcl

Post by ht5008253 » Sat Sep 14, 2013 12:47 pm

Hi Friends,my task is to unload a table i am having one ps which contains 8 lakhs Records,which contains primary key of length s9(18) usage comp in cobol and in table it is defined as binary not null.so,i want to unload the table based on these values.As i cannot hard code these 8 lakh values in SYSIN DD *.Is there any other possible way where i can use these values in my query without hard coding it.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sun Sep 15, 2013 6:35 am

In another post on another forum you have been given the answer to this question.

Read and follow that advice.

This topic is locked.
Have a good one

Locked

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others