> -----Original Message----- > From: ajit_cus [mailto:ajit_cus@;infosys.com] > Sent: Donnerstag, 31. Oktober 2002 06:32 > To: [EMAIL PROTECTED] > Subject: ODBC trace > > > Hi, > Can somebody tell me what the following SAP DB ODBC trace > means and what the warnings are for? The program that I ran > does not work as expected.
Hello Ajit, The warnings are described in the http://sapdb.org/pdf/usmanprecompiler_eng.pdf The meaning of the warnings are: W0 It is set to "W" if at least one of the warnings "W1" to "W15" has the value "W". Otherwise, "W0" has the value " ". The characters "W" for warning set and " " for warning not set apply to all warnings. W1 It indicates whether character strings (SAP DB data type "char") have been truncated during the assignment to host variables. When this character has the value "W", an indicator variable may exist which indicates the length of the original character strings. W2 It is set if null values occurred and were ignored during the execution of the SQL functions count (not countc(*)), min, max, avg, sum, stddev or variance. W3 It is set if the number of result columns of a "select" or "fetch" is not equal to the number of host variables in the into clause. W4 It is set if an "update" or "delete" has been executed without a where clause, i.e., on the entire table. W6 It is set if, for an operation on date or timestamp in the database, an adaptation to a correct date was made. W8 It is set if, for the generation of a result table, it was necessary to search through the entire table(s). W11 It is set if a time value is > 99 (or > 23 in USA format). The value will be corrected to modulo 100 (or 24). W12 It is set if, in the case of a select statement, more rows have been found than are allowed by rowno in the where clause. W13 It is set if, in the case of a select statement, the search was performed via a simply-indexed column which may contain null values. Null values are not written to the index list; i.e., the select statement must be formulated differently if you want to obtain the null values. W14 It is set if the value of the secondary key has changed (transition to the next index list) during the execution of one of the SQL statements "select next", "select prev", "select first" or "select last" by means of a secondary key. Regards, Burkhard _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
