Patrick Reynolds

Patrick Reynolds

Users
Tweets

Mar 23

The Postgres error SQLCODE 53000 "insufficient resources" along with error messages like "Traffic Control: <something> limit exceeded" and a hint telling you specifically which budget applied. We make it really clear, so clients know not to retry the same query immediately.

大手企業社員の資産設計室

大手企業社員の資産設計室 @InvGogo05

Jan 24

SQLCODE = 0

きょうさん @kyo_114514

Jan 24

SELECT 巨乳 FROM ﾌｫﾛﾜ

Rofiah | E-Commerce & Growth Analyst

Rofiah | E-Commerce & Growth Analyst @techiehub_28

24 May 2025

Ever revisited your SQL code and found yourself asking, “What was I trying to do here?” 😅 That’s where SQL comments become a powerful tool, not just for you, but for anyone reading your code. #mysql #dataanalysis #Sqlcode #comment

Jack Grodeska

Jack Grodeska

@JackGrodeska

19 Feb 2025

@elonmusk, I have no doubt that your agents have found individuals in the Social Security system who are 150 years old. There is an explanation. Many U.S. government systems, like those used by Social Security and the IRS, still rely on an old programming language called COBOL because it is stable and processes large amounts of data reliably. However, these systems are outdated and difficult to update, partly because there are fewer COBOL programmers today. (I may be one of the last) In some cases, when a person’s birth date is missing from the system, a default date—such as January 1, 1899, or January 1, 1900—may be used as a placeholder. This helps the system function properly but doesn’t mean the person was actually born on that date. Write a query to find all of the accounts without birthdates, or anomalous birthdates. Have your people research those accounts and reenter the date of birth accurately. Then run the original op again. To do this in COBOL: COBOL Embedded SQL Query- IDENTIFICATION DIVISION. PROGRAM-ID. FIND-MISSING-BIRTHDATES. ENVIRONMENT DIVISION. DATA DIVISION. WORKING-STORAGE SECTION. EXEC SQL INCLUDE SQLCA END-EXEC. 01 WS-SSN PIC X(9). 01 WS-NAME PIC X(30). 01 WS-BIRTHDATE PIC X(10). EXEC SQL DECLARE SSN-CURSOR CURSOR FOR SELECT SSN, NAME, BIRTHDATE FROM SOCIAL_SECURITY_DB WHERE BIRTHDATE IS NULL END-EXEC. PROCEDURE DIVISION. EXEC SQL OPEN SSN-CURSOR END-EXEC. PERFORM UNTIL SQLCODE NOT = 0 EXEC SQL FETCH SSN-CURSOR INTO :WS-SSN, :WS-NAME, :WS-BIRTHDATE END-EXEC DISPLAY 'SSN: ' WS-SSN ' NAME: ' WS-NAME ' BIRTHDATE: ' WS-BIRTHDATE END-PERFORM. EXEC SQL CLOSE SSN-CURSOR END-EXEC. STOP RUN. Please do not delete records until you do this. It would be catastrophic. Good Luck. CC: @realDonaldTrump

173

3丁目エンジニア.net🦀@ITエンジニアgr | 🇯🇵software developer

3丁目エンジニア.net🦀@ITエンジニアgr | 🇯🇵software developer

@3chome_net

27 Jan 2025

Db2 ALTER TABLEした後に起きたエラー　SQLCODE=-668, SQLSTATE=57007, SQLERRMC=7　 #プログラミング学習 #エンジニアブログ紹介 qiita.com/choco227/items/ba9…

Db2 ALTER TABLEした後に起きたエラー　SQLCODE=-668, SQLSTATE=57007, SQLERRMC=7　 - Qiita

エラー内容 ALTER TABLE コマンドでテーブルの構造を変更した。そのあと、そのテーブルを参照しているSQLを実行すると以下のエラーが発生。 SQLCODE=-668, SQLSTATE=57007, SQLERRMC=7 原因このエラーは操作対象のテーブルがR...

qiita.com

Joe Portman

Joe Portman

@RealJoePortman

9 Dec 2024

Replying to @RealJoePortman @elonmusk

17 seconds with Claude. IDENTIFICATION DIVISION. PROGRAM-ID. CUSTDATA. ENVIRONMENT DIVISION. INPUT-OUTPUT SECTION. FILE-CONTROL. DATA DIVISION. WORKING-STORAGE SECTION. 01 WS-VARIABLES. 05 WS-SQLCODE PIC S9(9) COMP. 05 WS-ERROR-MESSAGE PIC X(50). 01 WS-CUSTOMER-RECORD. 05 WS-CUSTOMER-ID PIC 9(5). 05 WS-CUSTOMER-NAME PIC X(30). 05 WS-CUSTOMER-ADDRESS PIC X(50). 05 WS-CUSTOMER-PHONE PIC X(15). EXEC SQL INCLUDE SQLCA END-EXEC. PROCEDURE DIVISION. 000-MAIN-PARA. PERFORM 100-CONNECT-DB PERFORM 200-CREATE-TABLE PERFORM 300-INSERT-RECORD PERFORM 400-READ-RECORDS PERFORM 500-DISCONNECT-DB STOP RUN. 100-CONNECT-DB. EXEC SQL CONNECT TO CUSTDB END-EXEC PERFORM 900-CHECK-SQL-STATUS. 200-CREATE-TABLE. EXEC SQL CREATE TABLE CUSTOMERS (CUST_ID INTEGER NOT NULL PRIMARY KEY, CUST_NAME VARCHAR(30), CUST_ADDR VARCHAR(50), CUST_PHONE VARCHAR(15)) END-EXEC PERFORM 900-CHECK-SQL-STATUS. 300-INSERT-RECORD. MOVE 10001 TO WS-CUSTOMER-ID MOVE 'JOHN DOE' TO WS-CUSTOMER-NAME MOVE '123 MAIN ST' TO WS-CUSTOMER-ADDRESS MOVE '555-0123' TO WS-CUSTOMER-PHONE EXEC SQL INSERT INTO CUSTOMERS VALUES (:WS-CUSTOMER-ID, :WS-CUSTOMER-NAME, :WS-CUSTOMER-ADDRESS, :WS-CUSTOMER-PHONE) END-EXEC PERFORM 900-CHECK-SQL-STATUS. 400-READ-RECORDS. EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM CUSTOMERS END-EXEC EXEC SQL OPEN C1 END-EXEC PERFORM UNTIL SQLCODE = 100 EXEC SQL FETCH C1 INTO :WS-CUSTOMER-ID, :WS-CUSTOMER-NAME, :WS-CUSTOMER-ADDRESS, :WS-CUSTOMER-PHONE END-EXEC IF SQLCODE = 0 DISPLAY 'Customer ID: ' WS-CUSTOMER-ID DISPLAY 'Name: ' WS-CUSTOMER-NAME DISPLAY 'Address: ' WS-CUSTOMER-ADDRESS DISPLAY 'Phone: ' WS-CUSTOMER-PHONE END-IF END-PERFORM EXEC SQL CLOSE C1 END-EXEC. 500-DISCONNECT-DB. EXEC SQL DISCONNECT CUSTDB END-EXEC. 900-CHECK-SQL-STATUS. IF SQLCODE NOT = 0 MOVE 'Database error occurred' TO WS-ERROR-MESSAGE DISPLAY WS-ERROR-MESSAGE DISPLAY 'SQLCODE: ' SQLCODE PERFORM 500-DISCONNECT-DB STOP RUN END-IF.

271

Simon Hutchinson

Simon Hutchinson @RPGPGM

22 Oct 2024

Using a #SQL table function to lookup SQLCODE and then show it in a display file. 💙#IBMi #rpgpgm #IBMChampion rpgpgm.com/2024/06/using-sql…

Using SQL table function to lookup SQL codes

Retrieve the message text for any valid SQL code using this Db2 for i table function

rpgpgm.com

107

Ercan Ermiş

Ercan Ermiş

@flightlesstux

21 Feb 2024

e-Devlet az once sunu dedi: "THE NUMBER OF ASSIGNED VALUES IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS. SQLCODE=-117, SQLSTATE=42802, DRIVER=4.32.28"

5,707

ABC

ABC

@Ubunta

2 Feb 2024

Running 70 billion parameter language models on a Mac is not practical. I attempted to execute the sqlcode-70b on my Mac, but it consistently produces nonsensical characters after each run. However, it operates without issues on a GPU setup.

764