Re: JDBD: time format

If I followed this thread correctly than these JDBC driver settings did not change. You just recompiled the stored procedure with time format=hms & sep=:?

Mark wrote: 
url="jdbc:db2://" + system + ";prompt=false;date format=iso;time
format=hms;time separator=:;";


--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@xxxxxxxxxxxxxxxx (spam trick)   GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)
.

Relevant Pages

  • Re: Adjusting to DB2
    ... Mark A wrote: ... >>but Marks remarks about the instrumentation is not incorrect it is also ... > to support at least one DB2 application. ... been done by the vendor prior to release, ...
    (comp.databases.oracle.server)
  • RE: Calling DB2 Stored Procedures through DBD::ODBC
    ... > connecting to DB2 ... The short answer is you need the ODBC syntax wrapped around it. ... > The second thing is if I can run the stored procedure through ...
    (perl.dbi.users)
  • Re: errors calling linked oleDB server stored procedures
    ... The remote database is not DB2, ... So I am not sure whether the provider you used could support ... would you please try to call a stored procedure without dynamic ...
    (microsoft.public.sqlserver.programming)
  • Re: Selecting multiple checkboxes inside a GridView control
    ... Walk through all of the rows in the GridView and construct a comma-delimited string of the IDs of those which are checked. ... Create a stored procedure like below and pass the above string to it: ... Rem in the PRINT line and rem out the last two lines if you want to see what the dynamic SQL looks like first for testing purposes. ... Mark Rae ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... What I want to do is open a form, enter some data and update the DB2. ... With STRSQL (iSeries/Navigator SQL ... I am unable to run a stored procedure with question mark. ...
    (comp.sys.ibm.as400.misc)