Search found 969 matches

by DikDude
Sun Apr 06, 2014 5:09 am
Forum: JCL
Topic: Zeke job to pull Zena triggered jobs during a specific time
Replies: 1
Views: 1509

Not the answer you want, but I'd suggest opening an issue with Zeke support.

I'm not familiar with Zeke and none of my clients use this . . .

Good luck.
by DikDude
Sun Apr 06, 2014 5:07 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Update Count in Outfile file by reading 2 input Files
Replies: 19
Views: 12983

Why the push for a single step?
by DikDude
Sun Apr 06, 2014 5:00 am
Forum: DFSORT , ICETOOL & Utilities
Topic: need Header in this format yyyymmddhhmm,im using SYNCSORT
Replies: 4
Views: 3059

To do what you want get the timestamp you want from db2 and use this in the header. Let sort generate the count in the trailer. There are multiple examples of creating headers and trailers in the forum. When you have a problem, post what you tried and what happened. Also, if is Not a good idea to co...
by DikDude
Sun Apr 06, 2014 4:53 am
Forum: DFSORT , ICETOOL & Utilities
Topic: need Header in this format yyyymmddhhmm,im using SYNCSORT
Replies: 4
Views: 3059

This is Sandeep I've raised an issue in the forum yesterday regarding the timestamp format in the header for a syncsort program. Could you pls help me out in that I've been given the task to complete it by today. Thanks Technical questions are Not supported via PM. As has happened with you (for one...
by DikDude
Tue Apr 01, 2014 11:23 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Strange result in SORT Arithmatic Division
Replies: 15
Views: 18015

If you are still having problems, please start a new topic (using th4e Code tag to preserve alignment.

Show a bit of sample input data and the output you want when this particular sample data is run thru your process.

Post the sort control statements and the JCL you use to test.
by DikDude
Sat Mar 29, 2014 12:14 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: During Plan to Package conversion process, -805 error
Replies: 3
Views: 3281

Suggest you work with the dba to ensure this is done correctly. Then record the steps you follow to get the correct link/bind. Follow these steps for the next n programs that are to be incorporated. You have read here: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsn...
by DikDude
Fri Mar 28, 2014 12:10 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Does anybody knows how to reslove -927 sql error ?
Replies: 3
Views: 3202

How are you trying to execute the problem program?

Do you have another program that works correctly?

Suggest you work with a project senior of your dba and see what has been done differently in your problem run compared to a similar run that works.
by DikDude
Thu Mar 27, 2014 11:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Special Char ~ is not displayed in SYSOUT
Replies: 1
Views: 1849

Possibly because of a code page difference?

This may have to do with your 3270 emulator software.

Is it possible that the tilde is not printable on that system?
by DikDude
Thu Mar 27, 2014 11:20 pm
Forum: COBOL
Topic: Hi Team Please tell me about the PF KEYS VALIDATION
Replies: 2
Views: 2496

Yes, you should use the same "style" as other programs that run on your system.

You should not pick up some odds and ends from a forum.
by DikDude
Mon Mar 24, 2014 9:26 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Search string then submit JOB
Replies: 6
Views: 4750

Hi Nic,

The "signature" link has been removed from the post. sagarhaele needs to change change the content of the signature in the profile.

Yup, what was posted tells me nothing i can use to help.

Possibly sagarhaele will clarify . . [/b]
by DikDude
Mon Mar 24, 2014 4:34 am
Forum: IDMS
Topic: Need to recompile?
Replies: 2
Views: 2777

This should not have been posted as a reply to a topic that has been dormant for 3+ years. When you have a question, start a new topic for your question.

Why does someone believe you need to recompile every program?

You have not provided much info for those would help.
by DikDude
Mon Mar 24, 2014 4:29 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQLcode -206 and -501
Replies: 6
Views: 6060

Good to hear it is working - thank you for letting us know :)

We were all new at one time - not to worry :wink:

It appears that when you post you have disabled bbCodes in your posts. If you uncheck this, your tags will work.
by DikDude
Sun Mar 23, 2014 11:16 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQLcode -206 and -501
Replies: 6
Views: 6060

Which column is shown to be a problem in the message?
by DikDude
Sun Mar 23, 2014 7:39 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQLcode -206 and -501
Replies: 6
Views: 6060

You need to download and have the DB2 documentation handy. -206 column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE, OR IS NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER -501 THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN Whic...