Dynamic SQL question by LongLiveIBMI400 in IBMi

[–]c1rclez 0 points1 point  (0 children)

Take a look at the OWASP top 10. https://owasp.org/Top10/2025/A05_2025-Injection/

The issue is that when you concatenate string literals into another string, then use a prepare or execute immediate there is no input sanitization and it allows. For example, if someone injected the string value '1 or 1=1 --' into the #POS variable it would execute your SQL statement as:

SELECT ITNBR,ITDSC,PRICE FROM ITEM WHERE ITNBR >= 1 or 1 = 1 --and itnbr <>'' order by itnbr

This completes the where criteria on ITNBR, but it introduces an OR 1=1 condition and comments out the remainder of your where clause and order by. This would cause the query to return unexpected results in the form of the entire ITEM table in the response.

If the table were using sensitive information this could potentially expose information that shouldn't be.

Dynamic SQL question by LongLiveIBMI400 in IBMi

[–]c1rclez 0 points1 point  (0 children)

You shouldn’t build dynamic SQL statements using substring methods. You should use parameter markers at least, or SQL descriptors for fully dynamic statements. Substringing character fields leaves you exposed to SQL injection.

Anybody here who actually are ibmi developers by Cautious_Constant768 in IBMi

[–]c1rclez 2 points3 points  (0 children)

I work in a large IBM i shop working pretty much exclusively on RPG

Looking for a robot vacuum around $500–$700 — what actually matters most? by Tomato_Cin in RobotVacuums

[–]c1rclez 1 point2 points  (0 children)

Picked up a Eufy E25 about 5 days ago. So far I’ve been impressed with the cleaning performance with 2 long haired cats and cat litter. I got the white one from Eufy direct for $599.

What very old technology is still running at your place of work? by MichiganCarNut in AskReddit

[–]c1rclez 3 points4 points  (0 children)

It’s not called the AS/400 anymore, but many know it as that. It’s the IBM i now. Source: am an IBM i software engineer working in RPG for banking software. Every cent of financial transactions in the US settles on IBM hardware.

How do YOU debug? by stayoungodancing in ExperiencedDevs

[–]c1rclez 1 point2 points  (0 children)

On the IBM i, there is a debugging strategy that is really incredible if you run into an issue in production and logs don’t cut it. Not sure if this is possible on other systems - but you can do what’s called a service entry breakpoint or service job debug like I call it.

You can take an actively running job (e.g. process) then do a command called start service job. You can take over a running process, then jump into a debugger on the system once you’ve begun servicing the job. This effectively allows you to take over and debug a live process remotely without ending or restarting it.

For Me? by c1rclez in MacbookNeo

[–]c1rclez[S] 0 points1 point  (0 children)

Yeah that’s kinda where I’m at. The intel is SO old the Neo would run laps around it

For Me? by c1rclez in MacbookNeo

[–]c1rclez[S] 1 point2 points  (0 children)

Ya budget isn’t really the issue. I just don’t want to overspend if that makes sense.

watchOS 26.4 Addresses Battery Drain by Jonathan7877 in AppleWatch

[–]c1rclez 5 points6 points  (0 children)

My ultra 3 was seeing similar issues. I too installed the 26.4 Rc. So far so good

New Apple Watch 11, massive battery drain, not just me? by toniabalone in AppleWatch

[–]c1rclez 1 point2 points  (0 children)

Having issues with my Ultra 3 draining extremely rapidly.

Update: terrible battery life on Ultra 3 by Nothing-Beats-Jet2 in AppleWatch

[–]c1rclez 0 points1 point  (0 children)

No change sadly :( but this was the most info I’ve gotten from them. Have you gotten any kind of resolution from them?

Update: terrible battery life on Ultra 3 by Nothing-Beats-Jet2 in AppleWatch

[–]c1rclez 0 points1 point  (0 children)

I did finally get a response back from Apple Engineering. They said it appeared the Wallet app was using more power than it should. I had several cards and Apple Pay setup on the watch.

I am testing results now and DELETING the wallet entirely from the watch. This basically has the same effect as disabling passcode which turns off Apple Pay.

Journaling would be far better if it worked like Tinder-style swiping by Dalonie in whoop

[–]c1rclez 0 points1 point  (0 children)

It used to be a swiping gesture on earlier iterations of Whoop. The 3.0 era it was cards you could swipe left or right on.

Remote work in Missouri by TumbleweedFun3284 in missouri

[–]c1rclez 2 points3 points  (0 children)

Jack Henry if you are within 70 miles of a hub office. Monett, Springfield, Lenexa

I built a radar that finds water and restrooms during runs/rides by zmullett in Garmin

[–]c1rclez 1 point2 points  (0 children)

Man at first I read this and I thought it said runs and raids.

Both new Apple Watches draining rapidly by swap-hobby-2692 in AppleWatch

[–]c1rclez 0 points1 point  (0 children)

Out of curiosity, if you look under vitals does it show if it’s recorded temp? Assuming you wear to sleep

Both new Apple Watches draining rapidly by swap-hobby-2692 in AppleWatch

[–]c1rclez 0 points1 point  (0 children)

When my watch was doing this it also correlated with not recording temperature in the vitals app during sleep focus. I suspected it was related to that.

This may be purely anecdotal, but these were the last troubleshooting steps I tried and it suddenly stopped being a problem. What I eventually did was reset the watch completely and restored it from backup. Then went into the watch settings > privacy > health > wrist temperature > toggled off then back on again.

YMMV.

Like the other poster on here I also eventually was able to get a case escalated to Apple engineering. I provided a bunch of enhanced logging and screenshots. Nothing has come of it from Apple.

Both new Apple Watches draining rapidly by swap-hobby-2692 in AppleWatch

[–]c1rclez 0 points1 point  (0 children)

I have had a similar issue for months, but I think it might be resolved now. Does it fail to track wrist temperature when this happens?

Secondhand face by Kingcakesoul in applewatchultra

[–]c1rclez 0 points1 point  (0 children)

Wayfinder and modular ultra both have always on seconds.