scottklement.com

I'm working on a modernization project where the UI is now done in .Net on Wintel and the rest on IBM i. The apps communicate through web services using JSON and YAJL. Is it possible to send images back and forth between .Net and RPG through a web service using JSON? I know binary files aren't allow...

Thank you for taking the time to explain this to me. I was able to get it to work following your example.

I'm concatenating a date and time field together using 'AS' to associate a field name to it which works fine.  I'm looking for a way to use a field name instead of the bulky concatenate each time I want to refer to the date/time.  The below SQL statement works but seems awful clunky. Is there a bett...

Thank you for letting me know about that. I haven't used timestamp_format before. I will try that as well.

Yes sir that worked! Thank you so much for providing the solution. It's much appreciated.

Hi There, I'm not sure how to isolate the hour portion of a 6 digit packed time field. I have a transaction file that has a CustNumber, TranDate (100 year date P5.0), TranTime(HMS P6.0) and TranAmount (P9.2). I need to count the number of transactions and total amount by customer by hour for a given...

Thank you for your help. I really appreciate it. I will be showing the other programmers I work with how this works.

YAJLGEN is awesome! Thank you so much! It generated 3 data structures with the only difference being that body was not nested within header. The code ran fine. Could you show me an example of putting code tags around source code please? I saw in the FAQ's you can't use HTML but you can use BBCode wh...

I have gone through the Working with JSON document and have the YAJL Open Source Tool installed. I coded, compiled and ran the YAJLINTO example successfully. I am very familiar with DATA-INTO using it with XML. I've been learning JSON for the past couple of weeks. In the document, it states that dat...

If a program error occurs within a subprocedure and you have a PSSR routine in the program not in a subprocedure that executes a Dump and/or you respond to the error message with a 'D', the local variable values in the subprocedure do not have any values in the dump unless you have a *PSSR routine i...