diff options
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-copystdout.c')
-rw-r--r-- | src/interfaces/ecpg/test/expected/sql-copystdout.c | 38 |
1 files changed, 14 insertions, 24 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-copystdout.c b/src/interfaces/ecpg/test/expected/sql-copystdout.c index 66c8414ab9e..131c2e8dfe7 100644 --- a/src/interfaces/ecpg/test/expected/sql-copystdout.c +++ b/src/interfaces/ecpg/test/expected/sql-copystdout.c @@ -98,62 +98,52 @@ struct sqlca_t *ECPGget_sqlca(void); int main () { -/* - EXEC SQL BEGIN DECLARE SECTION; - char *fname = "/tmp/foo"; - EXEC SQL END DECLARE SECTION; -*/ - ECPGdebug (1, stderr); { ECPGconnect(__LINE__, 0, "regress1" , NULL, NULL , NULL, 0); -#line 19 "copystdout.pgc" +#line 13 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 19 "copystdout.pgc" +#line 13 "copystdout.pgc" { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "create table foo ( a int , b varchar ) ", ECPGt_EOIT, ECPGt_EORT); -#line 20 "copystdout.pgc" +#line 14 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 20 "copystdout.pgc" +#line 14 "copystdout.pgc" { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into foo values ( 5 , 'abc' ) ", ECPGt_EOIT, ECPGt_EORT); -#line 21 "copystdout.pgc" +#line 15 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 21 "copystdout.pgc" +#line 15 "copystdout.pgc" { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into foo values ( 6 , 'def' ) ", ECPGt_EOIT, ECPGt_EORT); -#line 22 "copystdout.pgc" +#line 16 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 22 "copystdout.pgc" +#line 16 "copystdout.pgc" { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into foo values ( 7 , 'ghi' ) ", ECPGt_EOIT, ECPGt_EORT); -#line 23 "copystdout.pgc" +#line 17 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 23 "copystdout.pgc" +#line 17 "copystdout.pgc" - /* produces expected file "/tmp/foo" */ - /* EXEC SQL COPY foo TO:fname WITH DELIMITER ','; */ - /* printf ("copy to /tmp/foo : sqlca.sqlcode = %ld", sqlca.sqlcode); */ - { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "copy foo to stdout with delimiter ','", ECPGt_EOIT, ECPGt_EORT); -#line 29 "copystdout.pgc" +#line 19 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 29 "copystdout.pgc" +#line 19 "copystdout.pgc" printf ("copy to STDOUT : sqlca.sqlcode = %ld\n", sqlca.sqlcode); { ECPGdisconnect(__LINE__, "CURRENT"); -#line 32 "copystdout.pgc" +#line 22 "copystdout.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 32 "copystdout.pgc" +#line 22 "copystdout.pgc" return 0; |