This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
In a COBOL program in VISUAL COBOL for Eclipse I create a temporary table as follow
EXEC SQL AT DBCT
SELECT TOP(1)
*
INTO ##table_name
FROM table_name
END-EXEC.
When the table is created I expected to have an SQLCODE equal to 0.
But when the table is created I received an SQLCODE +100.
Could you explain.
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi @Riccardo Bizzi (RVA-ONEM)
Please check if SELECT TOP(1) * FROM table_name gives you a row of data.
Best regards,
LiHong
The query qives me a row of a data and the temporary table is created with as input the selected row of data with their properties.
My question is why does the result of this action gives an sqlcode=+100 when data was found and the temporary table was created.
An SQL action withou errors will gives me normally an SQLCODE = 0.
The only time I wil get an SQLCODE +100, is when I loop a table and the loop is ended (No more data found).
VISUAL COBOL
That's not a Microsoft product; you should better post to a more related forum.
SQLCODE = 100, "no data" was found
And that's correct, your query don't return a result set.