Search found 143 matches

by arrbee
Tue Sep 23, 2008 5:35 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Searching a PDS using SORT
Replies: 1
Views: 4048

Searching a PDS using SORT

Hi, I know that we can use "SS" feature of SORT to search a PS file. How to use this function to search a PDS? I tried to apply it on a PDS but could succeed only if member names are mentioned.........not useful.....huh.... :( Is it possible to mention Not Equal To condition along with SS on a PDS? ...
by arrbee
Mon Sep 15, 2008 2:30 pm
Forum: FILE-AID
Topic: continuation character in File-Aid batch.
Replies: 2
Views: 7828

continuation character in File-Aid batch.

Hi,

I want to code several entries to search a PS using File-Aid batch.

How to code the $$DD01 card beyond column 72 in File-Aid batch mode?

Please help.

Thanks.
by arrbee
Mon Sep 15, 2008 2:29 pm
Forum: FILE-AID
Topic: File-aid compare
Replies: 1
Views: 4256

use 3.10

Hi,

You will have to use option 3.10 within File-Aid menu.

HTH.
by arrbee
Wed Jun 25, 2008 8:39 pm
Forum: JCL
Topic: empty check and abend the JCL
Replies: 4
Views: 11446

Thank you guys
by arrbee
Wed Jun 25, 2008 8:36 pm
Forum: COBOL
Topic: urgent - dynamic array.
Replies: 4
Views: 8658

Thanks

Yeah.........nice idea.....

thx.
by arrbee
Thu Mar 06, 2008 5:49 pm
Forum: JCL
Topic: empty check and abend the JCL
Replies: 4
Views: 11446

Thx.

Krishna,

Thank you.

But, in case, the input file to be checked has got millions of records then would the job take long time to complete?

Thx.
by arrbee
Thu Mar 06, 2008 5:46 pm
Forum: COBOL
Topic: urgent - dynamic array.
Replies: 4
Views: 8658

would you please elaborate.

Krishna, Thank you very much for the solution. would you please explain me the following lines in detail: In your case, i suggest, use SELECT count(*)... before fetching records from cursor.... to know number of records you are going to fetch from cursor. so that... before fetch records from cursor....
by arrbee
Wed Mar 05, 2008 7:58 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: sort two files with same sort condition
Replies: 5
Views: 12253

WOW......this is really nice trick.....

Would anybody please suggest a syncsort version of this?

Thx.
by arrbee
Wed Mar 05, 2008 7:47 pm
Forum: COBOL
Topic: question
Replies: 2
Views: 5714

KSDS is key based read....... :)

Hi,

The KSDS means a KEY SEQUENCED DATASET. There is no point whether you read it from top or bottom because the read happens based on the key you supply. :idea:

HTH.

Thx.
by arrbee
Wed Mar 05, 2008 7:44 pm
Forum: COBOL
Topic: urgent - dynamic array.
Replies: 4
Views: 8658

urgent - dynamic array.

Hi, Our customer has got a peculiar problem and describes as told below: There is a DB2-COBOL program that uses a cursor to fetch data from a table based upon some condition. If the internal table reaches a said limit that program abends. We can't predict the number of entries coming into the intern...
by arrbee
Wed Mar 05, 2008 7:39 pm
Forum: JCL
Topic: empty check and abend the JCL
Replies: 4
Views: 11446

empty check and abend the JCL

Hi, Our production job cycle has got 200 jobs. The new requirement from the customer is as given below: "There are 10 important files among these 200 jobs and these files should be checked for emptiness and if any of the file is empty then the JCL should abend or issue some meaningful return code". ...
by arrbee
Fri Jun 15, 2007 12:59 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to display in SYSOUT?
Replies: 4
Views: 10785

thanks for the details.
by arrbee
Tue Jun 12, 2007 12:45 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to display in SYSOUT?
Replies: 4
Views: 10785

How to display in SYSOUT?

Hi, I need to display the columns and their corresponding host-variables in SYSOUT for a COBOL-DB2 program. How to do it? Please find the code below: P0001-UNLOCK-BORSED SECTION. EXEC SQL UPDATE XYZ_IRTER SET LOCKED_INDCTR = 'N' VU_LAST_CHG_TIMSTM = CURRENT TIMESTAMP WHERE VU_PRIXNK_KEY = :DCLVUK-BO...
by arrbee
Sun Feb 25, 2007 1:05 pm
Forum: COBOL
Topic: Comparing a X(12) field against 9(9)v99 field.
Replies: 2
Views: 5183

Comparing a X(12) field against 9(9)v99 field.

Hi,

I receive a X(12) field from a MAP and need to compare it with a 9(9)V99 field in a batch job.

I was able to compare when the v99 was not there for the numeric field.

Please help me ASAP.

Thanks. :D
by arrbee
Mon Oct 16, 2006 9:32 am
Forum: Admin Announcements
Topic: STAR MEMBER AWARD - FOR SEPTEMBER 2006
Replies: 3
Views: 11033

Frank the great.

Frank is always helpful....

You are awesome.