Search found 969 matches

by DikDude
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: 12997

One way to get what you want is to have3 2 steps that each read a file and write the count to the same output file. Use disp MOD for the second file.
by DikDude
Sun Apr 13, 2014 10:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort Card help
Replies: 3
Views: 2262

Did you look in the documentation?

The L(xxx, yyy) says this is a list of values to test.
by DikDude
Sun Apr 13, 2014 10:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Reading from 2 input files using SORT
Replies: 6
Views: 4670

One way would be to use JOINKEYS.

There are examples in the forum or the documentation.
by DikDude
Wed Apr 09, 2014 11:19 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: Need Panvalet Material
Replies: 3
Views: 3034

All of this material is available from CA Support - for free - if your organization is licensed to use the product.
by DikDude
Wed Apr 09, 2014 11:15 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: NEED HELP IN SORT
Replies: 8
Views: 5952

Suggest you repost your examples or clarify how the output came to be . . .

It would help if you defined the fields and used beter values than alphabet soup . . .
by DikDude
Wed Apr 09, 2014 11:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: XSUM to ICETOOL..??
Replies: 1
Views: 1868

You need to post the diagnostic messages including the message ids that were generated . . .

Why post "is not working" - which tells us NOTHING and just wastes everyone's time.

Why was the code changed?
by DikDude
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: 3684

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...
by DikDude
Mon Apr 07, 2014 9:47 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: need Header in this format yyyymmddhhmm,im using SYNCSORT
Replies: 4
Views: 3064

Thanks Nic.
hope the rest of you is, too
Workin' on it . . . :)
by DikDude
Mon Apr 07, 2014 6:32 am
Forum: TSO, CLIST & REXX
Topic: Regular expression with rexx
Replies: 4
Views: 3666

Which rules are you using to determine a valid e-addr?
by DikDude
Sun Apr 06, 2014 5:39 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: SQL Query in DB2
Replies: 1
Views: 2011

Try something like this:

Code: Select all

SELECT EMPSAL FROM EMPNEW E1 WHERE n = 
 (SELECT COUNT(*) FROM EMPNEW E2 
 WHERE E1.EMPSAL<=E2.EMPSAL&#41;; 
In your case n will be 10.

I did not test this, but copied it from another post.
by DikDude
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: 3684

What is invalid to you? I suspect that different kinds of fields have different valid/invalid values. . . .
by DikDude
Sun Apr 06, 2014 5:29 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Add one month to date.
Replies: 4
Views: 3168

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...
by DikDude
Sun Apr 06, 2014 5:23 am
Forum: JCL
Topic: JCL over 71 character issue
Replies: 2
Views: 1836

Which file transfer product is being used?
by DikDude
Sun Apr 06, 2014 5:19 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to retrieve the right rows ?
Replies: 4
Views: 3396

Your data has been "Code'd". It appears there is an alignment issue.

Please repost your data properly Code'd.

Then a suggestion will be easier to make.

So far, I do not understand what the process will do whan it is working properly :?
by DikDude
Sun Apr 06, 2014 5:14 am
Forum: JCL
Topic: COND codes, if any of above step fails then execute laststep
Replies: 3
Views: 2722

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...