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: 20210

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: 4230

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: 8232

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: 7153

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: 9469

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: 3633

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

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: 8092

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: 4589

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: 6837

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

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: 5996

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