HP NonStop SQL/MP - Page 250

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-52
Detailed Dynamic SQL Program
487
488 /* ------------------------------------------------- */
489 default: /* unsupported datatype */
490 printf( "**** Error for %-40s: %s Datatype is unsupported.\n",
491 name_array, get_dtname( sqlda->sqlvar[i].data_type ));
492 fflush (stdout);
493
494 break;
495
496 /* ------------------------------------------------- */
497 } /* end: switch stmt */
498 } /* end: for loop */
499
500 printf("\n"); fflush( stdout );
501 return (0);
502
503 } /* end: request_invars */
504
505 /* ********************************************************** */
506 /* FUNCTION get_dtname */
507 /* This function places the name of a given data type into */
508 /* the array datatype_name */
509 /* */
510 /* Return: pointer to array datatype_name */
511 /* (array is null terminated) */
512 /* ********************************************************** */
513 char *get_dtname ( short datatype )
514
515 { /* begin get_dtname */
516
517 switch (datatype) {
518 /* ------------------------------------------------------- */
519 case _SQLDT_ASCII_F : /* CHAR data type */
520
521 strcpy( datatype_name, "CHARACTER" );
522 break;
523
524 /* ------------------------------------------------------- */
525 case _SQLDT_ASCII_V : /* VARCHAR data type */
526
527 strcpy( datatype_name, "VARCHAR" );
528 break;
529
530 /* ------------------------------------------------------- */
531 case _SQLDT_16BIT_S : /* 16 bit signed binary */
532
533 strcpy( datatype_name, "SIGNED 16BIT NUMERIC" );
534 break;
535
536 /* ------------------------------------------------------- */
537 case _SQLDT_16BIT_U : /* 16 bit unsigned binary */
538
539 strcpy( datatype_name, "UNSIGNED 16BIT NUMERIC" );
540 break;
541
542 /* ------------------------------------------------------- */
543 case _SQLDT_32BIT_S : /* 32 bit signed binary */
544
545 strcpy( datatype_name, "SIGNED 32BIT NUMERIC" );
546 break;
547
548 /* ------------------------------------------------------- */
549 case _SQLDT_32BIT_U : /* 32 bit unsigned binary */
Example 10-8. Detailed Dynamic SQL Program (page 9 of 22)