• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Help!!!

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Bob
Basic Member Send Private Message
Posts: 7
Basic Member
10/26/2011 1:23 PM
Is there any easier to perform the following without using multiple branches and assign to accomplish this?

SQL statement executed via PFI
   SELECT WHLO, RGDT, substring(String(RGTM),0,2) AS HOUR, COUNT(RIDN) AS RIDN05
   FROM *LIBL.MITADI
   WHERE RIDI > 1 AND RGDT = 20100208
   GROUP BY WHLO, RGDT, HOUR;

Thanks
  
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
10/28/2011 1:45 PM
Is there some reason you can't just use a SQL node and use exactly what you wrote? That's what we do here...
Kelly Meade
J. R. Simplot Company
Boise, ID
Bob
Basic Member Send Private Message
Posts: 7
Basic Member
10/28/2011 4:18 PM
I use the SQL node to run this statement, however, I have encountered multiple instance of error that I have not encounter before. Anyhow, I have finally resolve this issue. Right now, I am facing a certain formatting issue within PFI. A query result return 2 numbers. I need one of them in the format of Z,ZZZ,ZZZ and the other one in the format of $9,999,990.99. How can this be accomplish?
SP
Veteran Member Send Private Message
Posts: 122
Veteran Member
10/28/2011 5:53 PM
your int = math.floor(your double)

On Fri, Oct 28, 2011 at 12:32 PM, wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> Lawson
> ProcessFlow Forum Notification A message was posted to a thread you are
> tracking. *RE: Help!!!* Posted by: *Bob*
> 10/28/2011 11:18 AM I use the SQL node to run this statement, however, I
> have encountered multiple instance of error that I have not encounter
> before. Anyhow, I have finally resolve this issue. Right now, I am facing a
> certain formatting issue within PFI. A query result return 2 numbers. I need
> one of them in the format of Z,ZZZ,ZZZ and the other one in the format of
> $9,999,990.99. How can this be accomplish?
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
> https://www.lawsonguru.co...n/lawson-pflow/help/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>