MVSFORUMS.com

Thanks a Lot Kolusu and Christian!!!. That Really helps...

Hi,

I have got a db2 query where we are using CONCAT " in the query,

SELECT * FROM Table1 A, Table2 B
WHERE A.ABC= B.ABC CONCAT ''

The column ABC is of same datatype.

When we ran t ...

Hi all,

I'm reframing my question again like this.

Lets take an example like SPACE=(CYL,(500,100),RLSE) for a file.

here the total space available for the file is Space = 500 + (100 * 15) = 2 ...

Hi all,

I have gone thru the links given by kolusu...

I'm still confused with the numbers 'Allocated bytes: 5487608 and Used extents: 13.

Can somebody please help me understand. Thanks a lot ...

Can somebody pls help with COBOL code.

It will be very helpful to me.

Thanks in advance.

Hi Kolusu,

I dont need to sort the extracted strings.

first i will sort the input file and then i will extract the 7 strings based on the poistions from input file and put it in the output file. ...

Hi,

I have a input file A. I need to extract 7 strings from the input file based on the position say @position 5,30,40,55,60,75,90 etc.

after extracting the seven strings, i need to put all the ...

Hi all,

I have a situation here...

I have two input files A and B.

I need to pick up the search string from the input file A for the first record, let us say at pos(30-40) and do a search for ...

I am currently facing a SOC 7 error in PL/I Program. The issue here is same as that arises in COBOL. I am comparing a Fixed Decimal Variable (Equivalent to Comp-3) with Zeros but it contains Spaces in ...

TSO ISRDDN B JFGCOPY

when i executed this command, it shows that the load module was not loaded.

i asked all my coworkers also. they were not aware of this utility.

please help me if anyone i ...

please help me how the utility JFGCOPY works??

thanks in advance

Hi vivek,

ya it worked!!! thanks a ton!!...

now i got my required output.

thanks,

waves

Hi vivek,

thanks for ur valuable reply.

i have tested the job using the suggestion given by you.

but the job got abended saying that there is a syntax error in the OUTFIL Statement.

this w ...

hi Vkphani,

thanks a lot for ur quick reply.

the solution which u gave for the first one worked fine for me..

but i have a question regarding the second one.

if i need to extract the elimi ...

Hi all,
i have two questions.

first one is as follows:

i'm using two sort conditions to eliminate the following:

a) zeroes in the Timestamp field

//SYSIN DD * ...