HP NonStop SQL/MP User Manual

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-48
Detailed Dynamic SQL Program
241 /* display first 38 characters of data */
242 printf( "%-40s %.38s\n", name_array, data_ptr );
243 fflush (stdout);
244 }
245
246 break;
247
248 /* ------------------------------------------------- */
249 case _SQLDT_16BIT_S : /* 16bit numeric */
250
251 in_out_ptrs.smallint_ptr = (short *) sqlda->sqlvar[i].var_ptr;
252 printf( "%-40s %hd\n", name_array, *in_out_ptrs.smallint_ptr);
253 fflush (stdout);
254 break;
255
256 /* ------------------------------------------------- */
257 case _SQLDT_16BIT_U : /* 16 bit unsigned numeric */
258
259 in_out_ptrs.usmallint_ptr =
260 (unsigned short *) sqlda->sqlvar[i].var_ptr;
261 printf( "%-40s %hu\n", name_array, *in_out_ptrs.usmallint_ptr);
262 fflush (stdout);
263 break;
264
265 /* ------------------------------------------------- */
266 case _SQLDT_32BIT_S : /* 32 bit signed numeric */
267
268 in_out_ptrs.integer_ptr = (long *) sqlda->sqlvar[i].var_ptr;
269 printf( "%-40s %ld\n", name_array, *in_out_ptrs.integer_ptr);
270 fflush (stdout);
271 break;
272
273 /* ------------------------------------------------- */
274 case _SQLDT_32BIT_U : /* 32 bit unsigned numeric */
275
276 in_out_ptrs.uinteger_ptr =
277 (unsigned long *) sqlda->sqlvar[i].var_ptr;
278 printf( "%-40s %lu\n", name_array, *in_out_ptrs.uinteger_ptr);
279 fflush (stdout);
280 break;
281
282 /* ------------------------------------------------- */
283 default: /* unsupported datatype */
284 printf( "**** Error for %-40s: %s Datatype is unsupported.\n",
285 name_array, get_dtname( sqlda->sqlvar[i].data_type ));
286 fflush (stdout);
287 break;
288
289 /* ------------------------------------------------- */
290 } /* end: switch stmt */
291 } /* end: for loop */
292
293 /* place a space line */
294 printf("\n"); fflush( stdout );
295
296 return (0);
297
298 } /* end: display_result */
299
Example 10-8. Detailed Dynamic SQL Program (page 5 of 22)

HP NonStop SQL/MP Specifications

General

Brand	HP
Model	NonStop SQL/MP
Category	Software
Language	English