Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-53
Detailed Dynamic SQL Program
550
551 strcpy( datatype_name, "UNSIGNED 32BIT NUMERIC" );
552 break;
553
554 /* ------------------------------------------------------- */
555 case _SQLDT_64BIT_S : /* 64 bit signed binary */
556
557 strcpy( datatype_name, "SIGNED 64BIT NUMERIC" );
558 break;
559
560 /* ------------------------------------------------------- */
561 case _SQLDT_DEC_U : /* DECIMAL datatype: unsi */
562
563 strcpy( datatype_name, "UNSIGNED DECIMAL" );
564 break;
565
566 /* ------------------------------------------------------- */
567 case _SQLDT_DEC_LSS : /* DECIMAL datatype: LSS */
568
569 strcpy( datatype_name, "LEADING SIGN SEPARATE DECIMAL" );
570 break;
571
572 /* ------------------------------------------------------- */
573 case _SQLDT_DEC_LSE : /* DECIMAL datatype: LSE */
574
575 strcpy( datatype_name, "LEADING SIGN EMBEDDED DECIMAL" );
576 break;
577
578 /* ------------------------------------------------------- */
579 case _SQLDT_DEC_TSS : /* DECIMAL datatype: TSS */
580
581 strcpy( datatype_name, "TRAILING SIGN SEPARATE DECIMAL" );
582 break;
583
584 /* ------------------------------------------------------- */
585 case _SQLDT_DEC_TSE : /* DECIMAL datatype: TSE */
586
587 strcpy( datatype_name, "TRAILING SIGN EMBEDDED DECIMAL" );
588 break;
589
590 /* ------------------------------------------------------- */
591 default:
592
593 strcpy( datatype_name, "UNEXPECTED" );
594 break;
595
596 /* ------------------------------------------------------- */
597 } /* end: switch */
598
599 return (datatype_name);
600
601 } /* end get_dtname */
602
Example 10-8. Detailed Dynamic SQL Program (page 10 of 22)