Programming

  SELECT nvl(rtrim(value), ' ')
--                              INTO :OrgFilepath
                              FROM ccsp_sysparm_tbl
                             WHERE parmkey = 'ORG_PATH'
                               AND country = 'HK'
VALUE
====
/prd/ccsp/hk/upload


please help on this.

      SELECT nvl(rtrim(value), ' ')
                              INTO :OrgFilepath
                              FROM ccsp_sysparm_tbl
                              WHERE parmkey = ltrim(rtrim(:ParmKeyValue))
                              AND country = ltrim(rtrim(:CountryCode));[/B][/B][/B]



#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include "ccspGlobals.h"
#include <sqlca.h>

EXEC SQL BEGIN DECLARE SECTION;
varchar OrgFilepath[132];
varchar filepath[150];
varchar CountryCode[2+1];
varchar SerInfo[9];
varchar ParmKeyValue[999999999];
EXEC SQL END DECLARE SECTION;



int main(int argc, char *argv[])
{

 if (argc < 4)
 {
  fprintf(stdout,"Incorrect argument");
  fflush(stdout);
        fflush(stdout);
        EXEC SQL        SELECT nvl(rtrim(value), ' ')
                              INTO :OrgFilepath
                              FROM ccsp_sysparm_tbl
                              WHERE parmkey = ltrim(rtrim(:ParmKeyValue))
                              AND country = ltrim(rtrim(:CountryCode));
        fprintf(stdout,"%d ret: %d\n",sqlca.sqlerrd[2],sqlca.sqlcode);
        fprintf(stdout,"\n OrgFilepath [%s]",OrgFilepath.arr);
               OrgFilepath.len=strlen(OrgFilepath.arr);
               OrgFilepath.arr[OrgFilepath.len] ='\0';



        fprintf(stdout,"\n OrgFilepath [%s]",OrgFilepath.arr);

       strcpy(filepath.arr,OrgFilepath.arr);
       strcat(filepath.arr,"/");
       strcat(filepath.arr,CountryCode.arr);
       fprintf(stdout,"filepath[%s] orgfilepath[%s]",filepath.arr,OrgFilepath.ar
r);

    if (InfoBusOutput (CountryCode.arr,SerInfo.arr,OrgFilepath.arr,filepath.arr)
 < 0 )
        {
    printf("\n error in writteing in MQ");
  fflush(stdout);
        return (-1);
        }

    printf("\n writtern in MQ");
  fflush(stdout);
}

strcpy(ParmKeyValue.arr,"ORG_PATH"); /*Or strncpy */
ParmKeyValue.len=strlen((char *) ParmKeyValue.arr);