This is the top 20 accounting firm's third M&A deal since receiving a private equity investment from Reverence Capital Partners, which was announced this past June.

JTaylor is proud to announce the promotion of Connor Wanhanen, CPA, to Partner in the Consulting Services division, effective January 1, 2025. “Admitting

Re: RNQ0103 help --

SQL 22001 identify column *N? -- I've inherited a SQL UDF that uses JSON_TABLE to parse JSON payloads. The JSON is very large and consists of deeply nested key-value pairs. Occasionally, I encounter a 22001 that column *N is truncated. Is there any way (short of trial and error) of identifying the column? Thanks

Re: IBM i Monitoring utility --

Re: VSCode debugging --

Re: VSCode and Bob -- “I don’t need to use VS Code anymore,” Rowe said during the IBM i Guided Tour. “I don’t need to go get VS Code and install it on my PC. It’s a replacement. I’m getting Bob, which includes VS Code. Maybe it’s semantics, but nonetheless we are going to leverage all the code for is support. . . So none of that is going away. It’s just that what I install on my PC is Bob. I don’t need to install VS Code.” https://www.itjungle.com/2026/04/06/bob-1-0-users-bugged-by-lack-of-one-feature/

Re: Decode base64 to job CCSID? --

Re: Using Embedded SQL in RPGLE or Creating SQL Functions --

Resolving *SRVPGM for ext stored proc -- I have an external stored procedure around a RPGLE service program. The stored proc does not specify a library for the service program. For some reason, source control promotes the stored proc to 2 libraries. The service program only exists in 1 of those libraries. The .NET caller uses System naming. The library list contains both of the libraries where the stored proc resides. It finds and executes the stored proc in the highest library in the *LIBL. Then it assumes the service program is in the same libra...

SQL function relay warning -- I have a SQL function that monitors for a warning condition. I need it to relay that warning to the caller. It catches the warning fine, but I can't get it to relay. The caller gets the NULL but not the SQLSTATE and message text. I've tried RESIGNAL and SIGNAL. DECLARE EXIT HANDLER for SQLWARNING BEGIN -- Neither RESIGNAL or SIGNAL seems to work. --RESIGNAL; --GET DIAGNOSTICS CONDITION 1 -- v_state = RETURNED_SQLSTATE, -- v_msg = DB2_ORDINAL_TOKEN_4; --signal sqlstate v_state -- set message_text = v_msg ; R...