CREATE TABLE QGPL/TESTSQL2 
   (FLD1 INT NOT NULL WITH DEFAULT, 
    FLD2 CHAR ( 64) NOT NULL WITH DEFAULT)            
                 




#include <stdlib.h>                 
#include <string.h>                 
 main(int args, char *argv[] )  {   
    int                rc = 0;      
    char              *tPtr = NULL; 
    EXEC SQL INCLUDE SQLCA;        
    EXEC SQL BEGIN DECLARE SECTION; 
       long     wrkFld1;              
       char     wrkFld2[64];          
    EXEC SQL END DECLARE SECTION;   
    EXEC SQL                                    
       Set Transaction Isolation Level NONE;    
                                                
                                                   
memset(wrkFld2, 0, 64);                     
    wrkFld1 = 11;                               
    memcpy(wrkFld2, "From C", sizeof(wrkFld2)); 







--- Elvis Budimlic
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Show some code please.  
> And your CREATE TABLE statement so we can see your
> field definitions.
> 
> Elvis
> 
> -----Original Message-----
>  Subject: [C400-L] SQLC and null-terminated strings
> 
>    Newbie C question:  What is the expected behavior
> (using SQL embedded in a C program) of an insert
> when
> the host variable is a null-terminated string? 
> Regardless of the size of the host variable, the
> value
> of the CNULRQD option (or the selection of
> *CNULRQD/*NOCNULRQD on the compile), the type of the
> table field (char or graphic), or the phase of the
> moon -- or several other things I tried -- my result
> is always blank-padded.  I am on a V5R1 machine (not
> current on ptf's), but replicated this on a V5R3
> machine.
>    What I find odd is that I prototyped this in
> RPGLE
> (with embedded SQL) and this does write nulls.
> 
> Thanks,
> Don Whittaker



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].