64 char * pointer = NULL ;
67 char *
data =
"\\001\\155\\000\\212" ;
76 {
ECPGconnect(__LINE__, 0,
"ecpg1_regression" , NULL, NULL , NULL, 0);
88 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"create table empl ( idnum integer , name char ( 20 ) , accs smallint , byte bytea )",
ECPGt_EOIT,
ECPGt_EORT);
94 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into empl values ( 1 , 'first user' , 320 , $1 )",
100 #line 35 "binary.pgc"
104 #line 36 "binary.pgc"
107 #line 36 "binary.pgc"
109 #line 36 "binary.pgc"
111 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"declare C cursor for select name , accs , byte from empl where idnum = $1 ",
112 ECPGt_long,&(empl.idnum),(
long)1,(
long)1,
sizeof(
long),
114 #line 37 "binary.pgc"
117 #line 37 "binary.pgc"
120 ECPGt_char,(empl.name),(
long)21,(
long)1,(21)*
sizeof(
char),
122 ECPGt_short,&(empl.accs),(
long)1,(
long)1,
sizeof(
short),
124 ECPGt_char,(empl.byte),(
long)20,(
long)1,(20)*
sizeof(
char),
126 #line 38 "binary.pgc"
129 #line 38 "binary.pgc"
131 printf (
"name=%s, accs=%d byte=%s\n", empl.name, empl.accs, empl.byte);
134 #line 41 "binary.pgc"
137 #line 41 "binary.pgc"
140 memset(empl.name, 0, 21L);
143 #line 44 "binary.pgc"
146 #line 44 "binary.pgc"
148 #line 44 "binary.pgc"
150 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"declare B binary cursor for select name , accs , byte from empl where idnum = $1 ",
151 ECPGt_long,&(empl.idnum),(
long)1,(
long)1,
sizeof(
long),
153 #line 45 "binary.pgc"
156 #line 45 "binary.pgc"
159 ECPGt_char,(empl.name),(
long)21,(
long)1,(21)*
sizeof(
char),
161 ECPGt_short,&(empl.accs),(
long)1,(
long)1,
sizeof(
short),
163 ECPGt_char,(empl.byte),(
long)20,(
long)1,(20)*
sizeof(
char),
165 #line 46 "binary.pgc"
168 #line 46 "binary.pgc"
171 #line 47 "binary.pgc"
174 #line 47 "binary.pgc"
178 printf (
"name=%s, byte=", empl.name);
180 printf(
"(%o)", (
unsigned char)empl.byte[
i]);
185 #line 55 "binary.pgc"
188 #line 55 "binary.pgc"
190 #line 55 "binary.pgc"
192 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"declare A binary cursor for select byte from empl where idnum = $1 ",
193 ECPGt_long,&(empl.idnum),(
long)1,(
long)1,
sizeof(
long),
195 #line 56 "binary.pgc"
198 #line 56 "binary.pgc"
201 ECPGt_char,&(pointer),(
long)0,(
long)1,(1)*
sizeof(
char),
203 #line 57 "binary.pgc"
206 #line 57 "binary.pgc"
209 #line 58 "binary.pgc"
212 #line 58 "binary.pgc"
218 printf(
"(%o)", (
unsigned char)pointer[
i]);
224 #line 68 "binary.pgc"
227 #line 68 "binary.pgc"
bool ECPGdisconnect(int lineno, const char *connection_name)
bool ECPGconnect(int lineno, int c, const char *name, const char *user, const char *passwd, const char *connection_name, int autocommit)
bool ECPGdo(const int lineno, const int compat, const int force_indicator, const char *connection_name, const bool questionmarks, const int st, const char *query,...)
void ECPGset_var(int number, void *pointer, int lineno)