Christophe SEPCHAT - Consultant Indépendant : Devops, Modernisation, Organisation, Direction de projets |
SQL - Controler l'existence d'un champ
LAST_UPDATED2
Pour contrôler l'existence d'un champ dans un fichier DB2, il suffit de lancer la requête SQL suivante :
SELECT * FROM QSYS2/SYSCOLUMNS WHERE TABLE_NAME = 'ADRES01PF' AND COLUMN_NAME = 'IDADR'
Cette requête permet de récupérer aussi toute la description d'un champ : Taille, type, libellé, ....
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