Sp_Gb2Big_ChineseToBig (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

No parameters.

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpGb2Big_ChineseToBig'._

Narrative

Business context: Localisation backfill. Sweeps all UI-label columns across gdsmodule, gdsconfigformmaster, gdsconfigcharmaster, gdsconfigformslave, gdsformconst, gdsjurisdiction and converts each sChinese* (Simplified GB) value into its Traditional-Chinese (Big5) counterpart in the parallel sBig5* column via F_Gb2Big(sChinese, 1). Drives the Traditional-Chinese UI swap for HK/TW deployments without any per-row trigger.

What it does: Bulk UPDATE: gdsmodule.sBig5/sBig5Depart/sBig5UnMemo/sBig5WorkFruit, gdsconfigformmaster.sBig5, gdsconfigcharmaster.sBig5, gdsformconst.sBig5, gdsjurisdiction.sBig5. The slave-column table gdsconfigformslave is the big one — it pages through iIncrement DESC 1,000 rows at a time using a cursor; for each sId it sets sBig5 = F_Gb2Big(sChinese, 1) and sBig5DropDown = F_Gb2Big(sChineseDropDown, 1). No parameters; affects the whole tenant.

Invocation: Status: appears orphaned. No caller found in any channel — no gdsmodule hook, no gdsconfigformmaster reference, no other proc CALLs it, no xly-src Java grep hit (only the install scripts script/标版/30100101/Sp_Gb2Big_ChineseToBig.sql and the underlying F_Gb2Big / Fun_Gb2Big_ChineseToBig definitions appear). Intended as a manual DBA tool run after Simplified-Chinese metadata edits, before deploying a Big5 tenant. F_Gb2Big itself is referenced once in GdsconfigformMapper.xml for column-comment formatting — that's a column-level reference, not a call into this proc.