-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Moin List!
It seems to be, that another Bug in the cpc Preprozessor or Library
has been discovered by us. ;-<<

Would you please check this twice ?
Is it possible that'we made an error, reading and using the cpc docments ?
Or is here a real bug discovered ? Can you confirm this ?


This programm crashes without a logical reson on the "fetch" statement
just before the end.
The client crash error occours on lochalhost and remote connections.

I encluded also a tracefile.

Greetings from a frozen german north!
        J�rgen Sauer

- 
----------------x--------------------x---------------------x--------------------x----------
/*
 *  dbtest.cpc --> dbTest
 *
 *  Test for SAPDB
 */

#include <stdlib.h>
#include <string.h>
#include <stdio.h>
#include <ctype.h>

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

  EXEC SQL BEGIN DECLARE SECTION;

  char db[19];
  char node[65];
  char usr[33];
  char pwd[33];
  char target[256];

  EXEC SQL END DECLARE SECTION;
  
  printf( "Start %s\n", argv[0] );

  //
  // Insert here DB Connection
  // 
  strcpy( db  , "AX"    );
  strcpy( node, "server" );
  strcpy( usr , "DBA"       );
  strcpy( pwd , "DBA"       );
  memset( target, 0, 256);

  EXEC SQL SET SERVERDB :db ON :node;

  if( sqlca.sqlcode )
  {
    printf( "db-error: set serverdb\n" );
    return -1;
  }
  else
  {
    printf( "ok: set serverdb\n" );
  }

  EXEC SQL CONNECT :usr IDENTIFIED BY :pwd ISOLATION LEVEL 0;

  if( sqlca.sqlcode )
  {
    printf( "db-error: connect\n" );
    return -1;
  }
  else
  {
    printf( "ok: connect\n" );
  }

  EXEC SQL SELECT TABLENAME FROM TABLES;

  if( sqlca.sqlcode )
  {
    printf( "db-error: select\n" );
    return -1;
  }
  else
  {
    printf( "ok: select\n" );
  }

//
// Here occours the SIGSEV !
// 
  EXEC SQL FETCH INTO :target;

  if( sqlca.sqlcode )
  {
    printf( "db-error: fetch\n" );
    return -1;
  }
  else
  {
    printf( "ok: fetch\n" );
  }

  printf( "target=%s\n", target );

  printf( "End\n" );
  return 0;
}
- 
----------------x--------------------x---------------------x--------------------x----------
<html><head><meta http-equiv="Content-Type" content="text/html; 
charset=utf-8"></head><body ><PRE><PLAINTEXT>
PRODUCT : SAP DB C-PreComp Runtime
VERSION : 7.3.0
BUILD   : 030-000-000-000


SQLMODE   : INTERN
SERVERDB  : AX                
SERVERNODE: server                                                          
CONNECT "DBA               " IDENTIFIED BY :A   ISOLATION LEVEL 0
SET FORMAT INTERNAL
SQL STATEMENT  :  FROM MODULE : dbtest             AT LINE : 48   
Statement Name : :0x010002
START  :  DATE :  2003-01-09    TIME :  0010:28:14
END    :  DATE :  2003-01-09    TIME :  0010:28:14

MASS STATEMENT :  
SELECT TABLENAME FROM TABLES
SQL STATEMENT  :  FROM MODULE : dbtest             AT LINE : 60   
Statement Name : :0x010003
PARSEID: OUTPUT:  0000E1EE 00000301 3C002E00 01000000
mfIndex init      : 1
mfIndex init      : 2
PARSEID: INPUT :  0000E1EE 00000301 3C002E00 01000000
mfIndex init      : 2
SQLERRD(INDEX_3) : 497        
START  :  DATE :  2003-01-09    TIME :  0010:28:14
END    :  DATE :  2003-01-09    TIME :  0010:28:14

MASS STATEMENT :  
FETCH INTO :P_1
SQL STATEMENT  :  FROM MODULE : dbtest             AT LINE : 72   
Statement Name : :0x010004
PARSEID: OUTPUT:  0000E1EE 00000401 2A002B00 01000000
PARSEID: SELECT:  0000E1EE 00000301 3C002E00 01000000
mfIndex found     : 2
PARSEID: INPUT :  0000E1EE 00000401 2A002B00 01000000
- 
----------------x--------------------x---------------------x--------------------x----------
- -- 
J�rgen Sauer - AutomatiX GmbH, +49-4209-4699, [EMAIL PROTECTED] **
** Das Linux Systemhaus - Service - Support - Server - L�sungen **
** http://www.automatix.de http://www.kranautomatisierung.de    **
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+HUPmW7UKI9EqarERAuR5AJ9/juUSkYnBjXS15cxrFu0/UBK2mwCgpU92
he9b9jesu3MIYrmzKMMw4lo=
=1hu8
-----END PGP SIGNATURE-----

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to