Search found 969 matches
- Wed Apr 16, 2014 2:48 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Update Count in Outfile file by reading 2 input Files
- Replies: 19
- Views: 20210
- Sun Apr 13, 2014 10:30 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort Card help
- Replies: 3
- Views: 4230
- Sun Apr 13, 2014 10:28 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Reading from 2 input files using SORT
- Replies: 6
- Views: 8232
- Wed Apr 09, 2014 11:19 pm
- Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
- Topic: Need Panvalet Material
- Replies: 3
- Views: 7153
- Wed Apr 09, 2014 11:15 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: NEED HELP IN SORT
- Replies: 8
- Views: 9469
- Wed Apr 09, 2014 11:11 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: XSUM to ICETOOL..??
- Replies: 1
- Views: 3633
- Mon Apr 07, 2014 9:55 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort or DFSORT - find all those fields and replace with 0
- Replies: 6
- Views: 6837
You are going to need to post some fo the values in hex and then explain what to do with the different values in the field(s). Your description does not use "normal" terminology. This is terminology that has come into use in your organization? What you is completely clear to you, but it is not to th...
- Mon Apr 07, 2014 9:47 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: need Header in this format yyyymmddhhmm,im using SYNCSORT
- Replies: 4
- Views: 5833
- Mon Apr 07, 2014 6:32 am
- Forum: TSO, CLIST & REXX
- Topic: Regular expression with rexx
- Replies: 4
- Views: 8092
- Sun Apr 06, 2014 5:39 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: SQL Query in DB2
- Replies: 1
- Views: 4589
Try something like this:
In your case n will be 10.
I did not test this, but copied it from another post.
Code: Select all
SELECT EMPSAL FROM EMPNEW E1 WHERE n =
(SELECT COUNT(*) FROM EMPNEW E2
WHERE E1.EMPSAL<=E2.EMPSAL);
I did not test this, but copied it from another post.
- Sun Apr 06, 2014 5:31 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort or DFSORT - find all those fields and replace with 0
- Replies: 6
- Views: 6837
- Sun Apr 06, 2014 5:29 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Add one month to date.
- Replies: 4
- Views: 5745
but every time I use google it sends me to DFSORT forums as well. Not sure what the difference is. Google doesn't "send" you to dfsort. Your search criteria finds more DFSORT hits than others. The difference is that the sort products are written/supported by different software vendors. The products...
- Sun Apr 06, 2014 5:23 am
- Forum: JCL
- Topic: JCL over 71 character issue
- Replies: 2
- Views: 3477
- Sun Apr 06, 2014 5:19 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to retrieve the right rows ?
- Replies: 4
- Views: 5996
- Sun Apr 06, 2014 5:14 am
- Forum: JCL
- Topic: COND codes, if any of above step fails then execute laststep
- Replies: 3
- Views: 4947
Is it possible to run with step level condition codes only? Definitely. We used cond codes for Many years before IF/THEN was implemented in JCL. One thing I Always have available is a step that will do nothing but generate a condition code that can be used for testing. Make sure the code is taken a...