summaryrefslogtreecommitdiffstats
path: root/debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc
diff options
context:
space:
mode:
Diffstat (limited to 'debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc')
-rw-r--r--debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc76
1 files changed, 0 insertions, 76 deletions
diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc
deleted file mode 100644
index 1142c3b9..00000000
--- a/debian/uncrustify-trinity/uncrustify-trinity-0.73.0/tests/expected/sql/21001-sta-select.sqc
+++ /dev/null
@@ -1,76 +0,0 @@
-/*******************************************************
-**
-** A sample program that demonstrates the use of Static embedded SQL.
-** Before compiling this program, be sure you have created a table
-** called video and inserted some tuples in it.
-**
-********************************************************/
-#include <stdio.h>
-
-/* sqlca: is the sql communications area. All error codes
- * are returned from db2 in that structure which is filled
- * each time an interaction with db2 takes place.
- */
-
-EXEC SQL INCLUDE SQLCA; /* SQL communication area structure */
-
-EXEC SQL BEGIN DECLARE SECTION; /* declare host variables */
- char db_name[8]; /* database name */
- char video_title[30]; /* title of the video */
- short video_id; /* serial number */
- char director[20]; /* director name */
-EXEC SQL END DECLARE SECTION;
-
-/* These lines are redundant here because the default
- * action is to continue. They just show the kind of
- * errors that could arise and one way to control them.
- */
-
-EXEC SQL WHENEVER SQLWARNING CONTINUE; /* sqlca.sqlcode > 0 */
-EXEC SQL WHENEVER SQLERROR CONTINUE; /* sqlca.sqlcode < 0 */
-EXEC SQL WHENEVER NOT FOUND CONTINUE; /* sqlca.sqlcode = 100 */
- /* sqlca.sqlcode = 0 (no error) */
-
-void main()
-{
- strcpy(db_name, "csc343h");
-
-/* C variables are preceded by a colon when they are passed to DB2 */
-
- EXEC SQL CONNECT TO :db_name;
-
- if (sqlca.sqlcode != 0)
- {
- printf("Connect failed!: reason %ld\n", sqlca.sqlcode);
- exit(1);
- }
-
-/* cursor delcaration. Have to declare a cursor each time you
- * want tuples back from db2
- */
-
- EXEC SQL DECLARE c1 CURSOR FOR
- SELECT video_title
- FROM video;
-
-/* you have to open the cursor in order to get tuples back */
-
- EXEC SQL OPEN c1;
-
- do
- {
- /* fetch tuples from the cursor. This will execute the statement
- * the cursor implements and will return the results */
-
- EXEC SQL FETCH c1 into :video_title;
- if (SQLCODE != 0)
- {
- break; /* SQLCODE refers to sqlca.sqlcode */
- }
- /* host variables should have ':' prefix when they are used in DB2 commands */
-
- printf("%s\n", video_title);
- } while (1);
- EXEC SQL CLOSE c1;
- EXEC SQL CONNECT RESET;
-}