Expert DB2 for i SQL. Procedures stockees, fonctions UDF/UDTF/pipelined, triggers, indexation avancee (EVI, MTI, index parfait, IOA), Visual Explain, plan cache, QAQQINI, services QSYS2, MQT, RCAC, CTE, OLAP, generation JSON/XML, IFS via SQL, REST API. Use when user asks to write SQL for IBM i, optimize queries, create procedures/functions/triggers, manage indexes, analyze Visual Explain, generate JSON/XML, read/write IFS, use QSYS2 services, troubleshoot SQL errors. Triggers - requete SQL, DB2 for i, QSYS2, MQT, RCAC, procedure stockee, CALL, FUNCTION, RETURNS TABLE, IFS SQL, Visual Explain, EVI, MTI, CTE, OLAP, ROW_NUMBER, SYSTABLES, trigger, PIPE, JSON_TABLE, JSON_OBJECT, LISTAGG, XMLTABLE, QAQQINI, OPTIMIZE FOR, SYSIXADV. Do NOT use for RPG (use rpg-ile-expert), RPG III (use rpg3-expert), or CL-only admin (use ibmi-admin-expert).
Expert administration IBM i (AS/400). Couvre sous-systemes, JOBQ, JOBD, OUTQ, profils utilisateurs, bibliotheques, Library List, messages, spools, objets, surveillance, sauvegarde/restauration, TCP/IP, journalisation, PTF, securite, IFS. Reference de 2399 commandes QSYS. Use when user asks about IBM i administration, subsystem management, job queues, user profiles, spool management, message queues, library list, object security, backup/restore, TCP/IP, journaling, PTF, IFS, or any CL command. Triggers - sous-systeme, SBSD, JOBQ, JOBD, OUTQ, CRTUSRPRF, CRTSBSD, bibliotheque, LIBL, spool, WRKSPLF, WRKACTJOB, WRKSBS, DSPMSG, MSGQ, WRKOBJ, securite, IPL, SAVLIB, RSTLIB, TCP/IP, JRN, PTF, IFS, WRKLNK, commande CL, commande IBM i, QSYS, DSPSYSVAL, CHGSYSVAL. Do NOT use for RPG programming, SQL development, or webservices coding.
Expert RPG ILE et developpement IBM i AS400. Genere du code RPG full free moderne, SQLRPGLE, consommation de webservices REST, SQL embarque, ecrans 5250 et sous-fichiers. Use when user asks to write RPG code, create DSPF PF LF files, call REST APIs from IBM i, build subfile screens, manipulate JSON, write SQL embedded in RPG, design 5250 interfaces, or troubleshoot RPG compilation errors. Trigger phrases - programme RPG, code RPG, ecran 5250, sous-fichier, SFL, webservice IBM i, SQLRPGLE, appel API REST, fichier PF, fichier LF, DSPF, pagination SFL, full free RPG. Do NOT use for general SQL queries without RPG context, PHP or Java development on IBM i, or IBM i system administration.
Expert RPG II et cycle logique GAP (programme a cycle implicite). Explique les 16 etapes du cycle logique RPG, les indicateurs (1P, LR, L1-L9, OF, OA-OV, MR, M1-M9, 01-99), les specifications positionnelles (H/F/E/L/I/C/O), fichiers primaires/secondaires, ruptures de controle, concordances, depassement de capacite. Lit et explique du code RPG II cycle a un debutant avec analogies pedagogiques. Use when user asks about cycle logique RPG, programme GAP, cycle GAP, RPG II cycle, programme a cycle implicite, comprendre le cycle RPG, lire un programme cycle, fichier primaire IP, indicateur 1P LR, rupture L1 L2, sortie total T, sortie detail D, sortie en-tete H, depassement capacite OF, concordance MR, 16 etapes cycle. Do NOT use for RPG III procedural (use rpg3-expert), RPG ILE (use rpg-ile-expert), or SQL.
Expert RPG III (RPG/400) sur IBM i en format colonnes. Genere du code RPG III avec specifications positionnelles (H/F/E/I/C/O), indicateurs, conditions IFxx, boucles DOWxx/DOUxx/DO, acces fichiers (READ, CHAIN, SETLL, WRITE, UPDAT, DELET), sous-programmes (EXSR/BEGSR/ENDSR), appels externes (CALL/PARM), ecrans 5250 (EXFMT/DSPF), sous-fichiers, KLIST/KFLD, tableaux, CAT, GOTO/TAG, REDPE, COMP, verrouillage N. Base sur la documentation officielle IBM RPG/400 Help. Use when user asks to write RPG III code, understand legacy RPG/400 programs, convert RPG III to RPG ILE, create DSPF screens for RPG III, explain column-based RPG syntax, or troubleshoot RPG III compilation errors. Trigger phrases - RPG III, RPG/400, RPG 3, GAP, programme RPG colonnes, format fixe RPG, indicateurs RPG, SETON LR, CRTRPGPGM, code RPG ancien, legacy RPG, programme GAP, migrer RPG III, convertir RPG III. Do NOT use for RPG ILE full free (use rpg-ile-expert instead), SQLRPGLE, or modern RPG with ctl-opt and dcl-s.
Expert administration systeme multi-plateforme Linux (Debian/Ubuntu) et IBM i. Specialise BRMS (Backup Recovery and Media Services), strategies sauvegarde/restauration, monitoring et PRA sur les deux plateformes. Couvre BRMS complet (politiques, groupes de controle, medias, planification, recuperation), sauvegarde Linux (borgbackup, restic, rsync, LVM snapshots), comparatif Linux/IBM i. Use when user asks about BRMS, backup strategies, disaster recovery, media management, or comparing Linux and IBM i concepts. Triggers - BRMS, STRMNTBRM, STRBKUBRM, STRRCYBRM, sauvegarde multi-plateforme, PRA, disaster recovery, media rotation, groupe de controle, politique sauvegarde, monitoring mixte, comparatif Linux IBM i. Do NOT use for pure RPG/SQL dev or single-platform questions covered by debian-linux-expert or ibmi-admin-expert.