Date/Time Format Stored Procedure Calls in ADVANCE MODE in JDBC ADAPTER

[Former Member]

Hi Experts,

What is significance of Date/Time Format Stored Procedure Calls in ADVANCE MODE in JDBC ADAPTER.

Thanks,

ABDUR

[MichalKrawczyk · Accepted solution]

hi,

from design point of view there are two things:

1. adapter will set the data format more precisely then the datetrans function in the mapping

2. all dates will be changed so you don't need to do that inside your mapping

Regards,

Michal Krawczyk

[prateek]

Its just to convert the field format to one supported by your stored procedure. See the last section

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards,

Prateek

[Former Member]

Hi,

Thanks for ur answer.

I have one doubt.

It will consider fields of stored procedure having type DATE, TIME only for format conversion.

Is is correct?

Thanks,

ABDUR

[prateek]

I guess this would be applicable for the folowing formats - DATE, TIME, TIMESTAMP.

This is the correct link

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Regards,

Prateek