MVSFORUMS.com

Hi Kolusu,

Thanks for the reply.
But T1 T2 T3 are just example values. It may change to T1 T3 T4 and a new T value t5 can get added. There is a user interface to do so.

So it can not be hard c ...

Hi,

We have a database in which data appears in this format:

M1 T1
M1 T2
M1 T3
M2 T1
M2 T2
M2 T3
M2 T4
Etc... T row will be unique for ...

Hi,

We have a requirement to schedule a job based on the retun code of previous job, is this possible in JOBTRAC?

For eg:

Job1 --> Job2 ---> Job3 ---> Job4

Now Job1 has a last s ...

This operation gets terminated using ATTN key, for me it's shift + esc. May be there is something wrong with ur ATTN key mapping.

Otherwise why don't you terminate ur session by using command
TS ...

Hi Kolusu,

SYSOUT msgs:=>

SYSIN :
SORT FIELDS=COPY
OUTREC FIELDS=(01,76, ...

YEs i have written exactly similar to what you have given.

//STEP0010 EXEC PGM=SORT
//*
//SORT ...

Hi Kolusu,

Thanks a lot for this solution it's working out and taking only .10 sec Smile

also got to learn some new features of syncsort that i had not used till now.

But there is one probl ...

Hi Kolusu,

01 RS01.
10 RS01-FIELD1 PICTURE X(24).
10 RS01-FIELD2 PICTURE S9(3) COMPUTATIONAL-3.
10 RS01- ...

Hi Bauer,

Thanks for the reply.
Actually i am somewhat new to mainframe and DB2, so not familiar to all those terms.
Could you please let me know some more details. Where to find those info and h ...

Hi Kolusu,

Program is in Cobol. The processing that program does is somewhat like this.

for each record.
if field-1 not = 'HH'
increment counter count-1
if field-1 = 'CC'
...

Hi Kolusu,

Thanks for response.

In your case you need to check if your Cursor is using an index or not.

Cursor is using indexes in Where and order by clause, only two extra fields are prese ...

Hi,

I have a program that selects daily data from a DB2 table using Cursor and formats some fields of data and writes them to an O/P file. In other words it extracts the data from DB to file. Daily ...

Phantom,

Thanks.

But i could not get the funda clear.
When i tried passing 0.000 from sysin to variable of PIC 9V9(3), it displayed the accepted value as 0.00
When i tried passing 0.000 to va ...

Hi,

Through JCL we can pass values that can be accepted in program using an ACCEPT statement.

like
//SYSIN DD *
0.003
/*

If i want to pass a value like 0.003 can i accept it in a varia ...

ok, thanks