Search found 56 matches

by rangab
Sat Sep 12, 2009 9:34 am
Forum: JCL
Topic: SPACE calculation - Help
Replies: 4
Views: 8068

SPACE calculation - Help

Hi,

We need to add a new file to a JCL with a LRECL of 29990 and RECFM is FB. It will receive a minimum of 2500 records and a maximum of 8700 records. Would somebody help me to calculate the SPACE for this?

Thanks.
by rangab
Sat Sep 12, 2009 9:31 am
Forum: FILE-AID
Topic: Feature to convert PD to ZD
Replies: 0
Views: 3623

Feature to convert PD to ZD

Hello, Does File-Aid (batch) have any feature to convert a PD field to ZD like SORT?

Thanks.
by rangab
Sat Sep 12, 2009 9:29 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Help me to understand how SPLICE works
Replies: 1
Views: 4372

Help me to understand how SPLICE works

I was reading the DFSORT z/OS programming guide to understand how SPLICE exactly works ! I thought it was not helpful and does not explain in a detail way of using SPLICE.

Would anybody please help me to understand how exactly the SPLICE operator works.

Thanks in advance & Have a great weekend.
by rangab
Wed May 13, 2009 11:04 am
Forum: JCL
Topic: Help me to understand this Info - Space.
Replies: 1
Views: 3544

Help me to understand this Info - Space.

Hi, Our dataset shows the below "Data Set Information". Data Set Name . . . . : XXXXX.XXXXX.XXXX.XXXX.BACKUP.G0001V00 General Data Current Allocation Management class . . : XX0001 Allocated bytes . . : 5,487,608 Storage class . . . : XX000001 Allocated extents . : 13 Volume serial . . . : VOL001 Dev...
by rangab
Mon Feb 16, 2009 8:45 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: compare two files:
Replies: 10
Views: 8915

Hi,

Uncommon records from both files into one single file?

What are the LRECL & RECFM of these files?

Thanks.
by rangab
Wed Feb 11, 2009 4:51 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to get sequence number like this?
Replies: 7
Views: 9607

wow....thanks a lot.
by rangab
Tue Feb 10, 2009 2:59 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to get sequence number like this?
Replies: 7
Views: 9607

how to apply this technique?

Hi, Frank. How to apply the sequence number technique on below data? This dataset's LRECL=80 & RECFM=FB. The key field starts in 19th column and of 6 bytes. I want to apply 5 digit sequence number only for key value '161009' and it's next record (01 & 02) at column position 30. Input: ----+----1----...
by rangab
Tue Feb 10, 2009 2:27 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to get sequence number like this?
Replies: 7
Views: 9607

Frank, thank you again. It has worked.
by rangab
Tue Feb 10, 2009 2:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to get sequence number like this?
Replies: 7
Views: 9607

Frank, thanks for the reply. I will try to improve :oops:

The key here starts in 1st column and of 6 bytes length. I want this sequence number technique to be applied on certain key value only (ex. 123456). However, the code you have given here should work for me.

Thanks a lot.
by rangab
Mon Feb 09, 2009 8:35 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to get sequence number like this?
Replies: 7
Views: 9607

how to get sequence number like this?

Hi, My input dataset (LRECL=80, RECFM=FB): 12345600000ZX 12345600000ZY 12345700000ZX 12345700000ZY 12345800000ZX 12345800000ZY 12345600000ZX 12345600000ZY Expected output: LRECL=90, RECFM=FB 12345600000ZX 0001 12345600000ZY 0002 12345600000ZX 0001 12345600000ZY 0002 Input dataset contains duplicates...
by rangab
Mon Feb 09, 2009 7:06 pm
Forum: FILE-AID
Topic: How to know the RRN of a particular record.
Replies: 0
Views: 2752

How to know the RRN of a particular record.

Hi,

I am copying particular records using File-Aid batch process. How to know the RRN of those copied records?

Code: Select all

//SYSIN    DD *              
$$DD01 COPY IF=(1,EQ,C'OBAMA')
With the above code, say, three records got copied to output. How to know their respective RRN numbers?

Thanks.
by rangab
Fri Feb 06, 2009 5:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DB2 SQL Query support with DFSORT?
Replies: 2
Views: 4316

skolusu, we are recently upgraded to DB2 v8.0. Would you please explain in details how exactly we make use of DFSORT with application programming !?

Thanks.
by rangab
Fri Feb 06, 2009 5:14 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: a basic doubt on WHEN=(logexp) and WHEN=ANY
Replies: 5
Views: 5639

Kolusu, thank you for the solution you have provided. Frank, wow......that is a very good piece of info. I thought this detail info is not there in programming guide ! So, how the card should be changed now to meet my criteria after including HIT=NEXT and without build other than the solution sugges...
by rangab
Thu Feb 05, 2009 9:49 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: a basic doubt on WHEN=(logexp) and WHEN=ANY
Replies: 5
Views: 5639

sorry

Frank, sorry.... Here is the data again...... MERMA 01 2009 NEXTR 02 NEXTR 03 VERJO 01 2009 VERJ1 02 BARST 01 2009 VERJ2 02 BARSE 01 2010 VERJ3 02 Sysin used: //SYSIN DD * OPTION COPY INREC IFTHEN=(WHEN=(10,4,CH,EQ,C'2009'),BUILD=(1,80)), IFTHEN=(WHEN=ANY,BUILD=(1,80&...
by rangab
Thu Feb 05, 2009 9:45 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DB2 SQL Query support with DFSORT?
Replies: 2
Views: 4316

DB2 SQL Query support with DFSORT?

Hi,

Does DFSORT support execution of SELECT SQL query? What is the procedure?

Thanks.