× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Fat fingered the earlier reply - sorry.

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[] )  {  
    char              *tPtr = NULL;
    EXEC SQL INCLUDE SQLCA;          
                                     
    EXEC SQL BEGIN DECLARE SECTION;  
       long     wrkFld1;               
       char     wrkFld2[64];           
    EXEC SQL END DECLARE SECTION;    
                                                
    memset(wrkFld2, 0, 64);                     
    wrkFld1 = 11;                               
    memcpy(wrkFld2, "From C", sizeof(wrkFld2)); 
    tPtr = (char *)&wrkFld2;          
    tPtr = tPtr + 7;                 
    memset( tPtr, 0, 57);             
                                      
    EXEC SQL                          
       insert into QGPL/TESTSQL2      
              ( Fld1, Fld2)           
       values ( :wrkFld1, :wrkFld2);  
 }  /* END  main()   */   


--- 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 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.