MVSFORUMS.com

Kolusu
Sorry about that. Please find the SYSOUT of the job.

The input is in two files. One has the total request count and the other the completed count. I would like the percentage to be displaye ...

Kolusu

Though we are specifiying the EDIT pattern I am still getting the output percentage rounded. I am not getting the percentage with decimal values. Am I missing something?

Kolusu
Thank you for helping me. The solution works perfectly fine if both the counts are of the same number of digits and not for the ones if they are different. For example if the Request no is 200 ...

Kolusu

Thanks a ton. It works. But I would prefer to have the status report even when the percentage is less than 50%. Only that I need that return code to be set but report to be produced at any ...

Kolusu

Thank you for your Quick response.

The Request and complete file have only counters of the number of records. Both the files will not be empty at any time as the counter is retrieved fro ...

We are having two files with one file having the count of total number of requests and the other with the counter of only the completed requests. I would like to calculate the percentage and produce a ...

Ranga,
You have to pass the value like 123456789.99 to both ws-num-1 and ws-num-2value.The WS-NUM-1 is an assumed decimal format and WS-NUM-2 is a numeric edited field.
WS-NUM-2 is used for displayi ...

Anta,
I tried executing the same Query that you have used it but it works well for me. May I know the Error that you are facing while executing this Query??

Thanks
Karthik

Vivek

If you want to try these SQL statements using batch then you can try using the DB2 program DSNTIAD.

//JOBLIB DD DSN=LINKLIST.DB2.DSN710.SDSNLOAD,DISP=SHR
// DD DSN= ...

Kolusu

Is there a possibility to do it with a Row ID ?

Karthik

The requirement is to fetch a row in a table only if the table contains more than 100 rows.
Note : The Query should not be tried with the Count operator

Thanks Kolusu and German for ur reply.
Am still not able to figure out.Kolusu am pasting the Error message i got

Out-of-synch messages (hint - search for "!" marks)
DUPLIC! (Staging duplicat ...

Hi all
Regarding to Changeman tool.
Am facing an audit Error when am promoting my Package in the Changeman.I have given a full promotion of my package from the Level 0 to another Level 15.There was ...

Hi
You can drop a column in the Oracle 9i but not in the earlier versions
But in DB2 we dont have that provision.So u have use that move what u said earlier

hi 614
you can use both the tables and temporary storage queue for this.but its best to use the temporary storage queue and the easy way is you count the no of records present in the tsq whil writ ...