mainframegurukul.com

It worked fine. Thanks for the reply.

Thamodharan

Hi, Please let me know how I should proceed for the below scenario. There are 2 FB files say File A of length 200 and File B of length 80. File A has only 1 record while File B has 5 records. File A: 123456789 YYYYYYYY 123456789 File B: ABCDEF12345678 XXXXXXXX ABCDEF12345678 ABCDEF12345678SSSSSSSSAB...

Hi Dick, (select max(shop_last_pur_ts) from shop_pur_det where pur_type = 'POS'), could be null. The above field has never been a NULL. It was 27 bytes instead of 26 bytes. First 26 bytes were having the Timestamp and the 27th byte was having no value. Please suggest me how to get only timestamp(26 ...

Hi All, I am using DSNTIAUL utility to unload data and the query used to unload data is somewhat similar to the following query, Select shop_id, shop_name, (select max(shop_last_pur_ts) from shop_pur_det where pur_type = 'POS'), shop_addr1, shop_addr2 from Shop_det where shop_city_cd = 'NC' Problem ...

Hi Frank,

I wanted only SUM in the output and it works fine.

Thanks for the help as well as the online tutorial.

Regards,
Thamo

Hi, I have a requirement to sum a field irrespective of any fields in the PS file. Input file, 100 ttt aaa 200 xxx yyy 300 aaa xxx 100 yyy tttt output must be, 700 .... When i use the following, I am not getting the desired output. Because it summing with respect to a specific field. Sort fields=(5,...

Hi,

I need to find the sum of a field(Ex 1,5,ZD) irrespective of any fields.
for example,

My input file

100 XXXXXX
200 XYYYYXX
300 XXXYYYY

required output

600 XXXXXX

or

600 ...........

Please suggest me a sort card for this.

Thanks in advance.

Regards,
Thamu.

Hi, The following JCL is the one I used to compare two files(INFILE1, INFILE2). //U573403A EXEC PGM=ISRSUPC, // PARM=(DELTAL,LINECMP, // '', // '') //NEWDD DD DSN=INFILE1, // DISP=SHR //OLDDD DD DSN=INFILE2, // DISP=SHR //*OUTDD DD SYSOUT=* //OUTDD DD DSN=REPORT.FILE, // DISP=(NEW,CATLG,DELETE), // ...

Hi, I am using ISRSUPC utility(ISPF Utility) for comparing two files. When comparing I am getting unsuccessful comparision but both the files are matching when I manually look at the files. For example, In the error message its showing '0071001' as inserted, and the same data has been shown as Delet...

Hi All, I have a program which is fetching 2000 rows from a table. I encountered an abend after fetching 1000 rows and written into the output file. So, I need to start fetching the rows from 1000, instead of starting from Row1. Can anyone suggest me how to start fetching the records like I mentione...

The Select Job is working fine for me.

Thanks for your assistance!!!

The example files as follows, File1 File2 10001 10001 10003 10002 10004 10004 10006 10005 after comparing above two files I should get 10002 and 10005 as output. Or we can get the count (i.e. 2) of file2 record that could not be found in file1. The requirement is to check whether all the records in ...

Hi, I have two input files. Both having same LRECL and having only one field. I need to know whether all the records in file2 is there in the file1. If some records in file2 are missing in file1 then I need those records in Output file Or to get the number of output records in output file. Please gi...

Hi All,

Can I open a Tape file in I-O mode? when I tried to open a Tape file in I-O mode I was getting 37 file status.
Anyone plz let me know whether we can open a Tape file in I-O mode?


Thanks!

Hi Natarajan,

I already tried this sub-query. The disadvantage with this query is that, its taking more CPU time compared to cursor.

I think, I should stick with the cursor itself. Please tell me if you have any other idea.

Thanks!