topic Re: Data to MS SQL in Application Development and Automation Discussions

Data to MS SQL

dmi — Sun, 28 Jan 2007 07:07:41 GMT

Hello

I send data from SAP (rel. 4.6C) to a SQL data base.

It works properly with Native SQL. But my problem is:

I send a dataset, some fields are empty. In SAP I use CLEAR to initialize this fields (type CHAR)

In the SQL data base this fields arrives with one space.

Its possible to send a CHAR-Field without any space - realy empty?

Many thanks for your help!

abdul_hakim — Sun, 28 Jan 2007 07:57:29 GMT

no you cannot since the default value of char type field is space.

Cheers,

Hakim

Former Member — Sun, 28 Jan 2007 12:19:47 GMT

Hi Daniel,

1. Instead of EXEC SQL, use the ADBC library. It offers proper error handling (it gives you the ORA-XXX error code). See sample program ADBC_DEMO.

2. Generate your NATIVE SQL dynamically and use <b>null</b> where applicable.

For example (not proper code- just the general idea):

 Insert into TABNAME values(Field1,Field2,null,null,null,null)...

Best Regards,

Ofer

dmi — Tue, 03 Mar 2009 06:16:19 GMT

solved by my self