Christophe SEPCHAT - Consultant Indépendant : Devops, Modernisation, Organisation, Direction de projets |
IBM i - Comment lancer une requête SQL par commande
LAST_UPDATED2
L'API IBM "QZDFMDB2" permet d’exécuter une requêtes SQL dans un programme ou une ligne de commande.
Exemple :
Ecriture dans un fichier
CALL QZDFMDB2 ('INSERT INTO qgpl.qauoopt (OPTION, COMMAND) VALUES(''ob'', ''WRKOBJPDM *ALL'')')
Puis pour consulter le résultat :
CALL QZDFMDB2 ('SELECT * FROM qgpl.qauoopt ')
Top Articles
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Derniers Ajouts
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109