SQLCODE in Cobol

[Claudio Ricardo]

Hi,
cQuery := "select name from customer" return an array with only "name" field
cQuery := "select * from customer" return an array with all fields
See here:
https://www.w3schools.com/mysql/default.asp

[dragancesu]

With SQL database you must know use command SELECT

https://www.mysqltutorial.org/mysql-sel ... -data.aspx

SQL is beautifuly language, only four command SELECT, INSERT, UPDATE, DELETE (data manipulation language)
other is DDL (data definition language) like CREATE, INDEX, RENAME,...