topic NO-GROUPING in Application Development and Automation Discussions

NO-GROUPING

Former Member — Wed, 12 Dec 2007 05:59:03 GMT

Hi to all Guru's,

Can anybody explain me about this syntax?

... NO-GROUPING

This addition cannot be used together with the addition TIME ZONE.

Effect

This addition suppresses the thousands separator in the output of data objects of data types i or p. In all other data types, the addition is ignored.

Thanks

Priyalataha

Re: NO-GROUPING

amit_khare — Wed, 12 Dec 2007 06:03:15 GMT

This addition suppresses the thousands separator in the output of data objects of data types i or p. In all other data types, the addition is ignored.

For Example :

11,00,000 it will displays like 1100000.

~ As found in forum.

Regards,

Amit

Re: NO-GROUPING

Former Member — Wed, 12 Dec 2007 06:09:49 GMT

Hi Priya,

This addition suppresses the thousands separator in the output of data objects of data types i or p. In all other data types, the addition is ignored.

<b>

No-Grouping Clause</b>

If your variable you are writing to is of type I or P, the separators are omitted while writing the value.

For Example :

11,00,000 it will displays like 1100000.

So because of that this addtion is cannot be used in addtion with TIME ZONE.

hope this will help you...

<b>please reward if useful</b>

Regards,

sunil kairam.

Re: NO-GROUPING

Former Member — Wed, 12 Dec 2007 06:16:51 GMT

DATA pack TYPE p VALUE '123450000.678'.

WRITE pack NO-GROUPING ROUND 0 DECIMALS 2.

check this code by adding and removing no-grouping you can find the difference it won't support for the addition of time zones.