Knowledgebase | News | Ask a Question | ...

Browse by category

DB2 AL guide: RWDate should map with DB2 DATE type, instead of RWDBDateTime

Article ID: 918

Last updated: 31 Jan, 2008

Article ID: 918

Last updated: 31 Jan, 2008

Revision: 1

Posted: 26 Jun, 2001
by Dean J.

Updated: 31 Jan, 2008
by Dean J.

Problem

DBTools Access library guide for DB2 CLI, section 2.3, Table 2 has the following mapping:

RWDBDateTime Date SQL_DATE DATE

RWDBDateTime DateTime SQL_TIMESTAMP TIMESTAMP.

Cause

The first mapping is incorrect. It should be as follows

RWDate Date SQL_DATE DATE

RWDBDateTime DateTime SQL_TIMESTAMP TIMESTAMP

Action

This mapping will be corrected in future revisions of our DB2 Access Library guide.

This article was: Helpful | Not helpful

Report an issue

Article ID: 918

Last updated: 31 Jan, 2008

Revision: 1

Posted: 26 Jun, 2001 by Dean J.

Updated: 31 Jan, 2008 by Dean J.

Also listed in

SourcePro -> DB -> DB2 Access

SourcePro -> Releases -> Edition 1 SP

« How can I get the port number from an RWSocket?

Problems Running the Software Parts Manager (Windows) »

Others in this category

Are project files (IDE files) provided for building DBTools.h++ under Windows?

Can DBTools.h++ run under DOS?

Moving Unix applications to Windows when using RPC

Installation order of Math.h++ and Tools.h++ is critical

Library Mismatch with MSVC4.x Compiler

How do I access tables on different databases on the same server?

_ex_keylock undefined symbol problem

Tools.h++ PC Patches

My RWIFtpClient is behaving erratically.

Memory leaks reported on different calls to DBTools.h++ or Tools.h++ methods.

Is Informix transaction logging required?

Will DBTools.h++ operate properly with WIN32s?

How To build RW-Metro examples on WINNT4-MSVC6.0 ?

Stored procedure on Sybase returns empty result set.

Borland C++ 5.02 and SPM 1.3 Edition 5, November 1997

Error installing parts using SPM

Problems Running the Software Parts Manager (Unix)

Link Error when Building DBTools Application

Error ORA-06401 while connecting to ORACLE via DBTools.h++

Establishing connectivity between an RDBMS and DBTools.h++

Error when executing a stored procedure.

Does DBTools.h++ support Dynamic SQL?

Executing multiple SQL statements with RWDBDatabase::executeSql() on ORACLE

Error ORA-12154 while connecting to ORACLE via DBTools.h++.

Integrating JWidgets into Symantec Visual Cafe version 2.0

Informix DB-Access Library fails to build on HP/aCC platforms.

How do I implement a select count (*) in DBTools.h++?

Creating Charts using ChartJ Component Beans

How to use the Rogue Wave Informix Access Library for DBTools.h++ in a multi-threaded application

RWCString::toLower() function call creates runtime error.

DBTools.h++ generates a unique table alias each time a select statement is executed

Memory leaks in Tools.h++ code?

When installing JFactory from InstallShield, why does it start installing other programs?

Beanbox integration for JWidgets

Trouble transferring binary files with FTP examples

How do I stop a thread that is blocked on a system call or performing I/O?

How do I construct an unbounded Producer-Consumer Queue (or Stack)

Visual CASE and Visual C++ 6 Service Pack 3

RWTime Can Only Represent Times Up to the Year 2037

Warning messages in link phase using Math.h++ in OWL project

When using Money.h++ as a DLL in my application, the symbol NaN is undefined during a link.

My Sun compiler reports a Sig 10 error when building with Tools.h++

Compiler trouble on IRIX 5.3

Compiling Math.h++ 6.x with MSVC 4.2 results in errors in the file <tt>rwlpbla.cpp</tt>

How Do Math.h++ Random Number Classes Generate Random Numbers?

Undefined symbols when linking the Math.h++ on SGI

How can I force RWDate to display a four digit year?

Assertion failed, attempting to add intrusive link...

Porting Math 6.1.8 to Redhat Linux 6.0 (Linux 2.2.5-15)

Transaction control with DBTools 3.1

I get the error: [DBNOTFOUND] No access library

RWDBTracer and asString() method behave differently in DBTools 4.0.0

Assigning the Empty String to an RWCString

Installing products with SPM as root accidentally deletes device /dev/null

Does DBTools.h++ support the Oracle Array type?

Assertion failure in rw/tislist.cc, line 0

MDI menus appending items instead of inserting

RWDBCursor write fails at runtime sometimes with a syntax error

Problems compiling .c files in the rogue/mathsrc directory

Compiler errors involving min() and max() macros

JChart 1.0 will not print charts to the printer

How can I have a timestamp inserted with a row into my Oracle table

SPM error - file truncated

Detecting changes in text in an edit line

Accelerator keys in modal dialog

How can I enable and disable radio buttons in a zRadioController?

Table will not accept data

Fix for modeless MDI dialog when modal non-MDI Dialog is opened

Unresolved symbols during linking with DBTools static libraries

Building zApp with the CTL3D option turned on

Unresolved externals when trying to link zApp application with MSVC4.2

zFont does not display the size I specified.

zComboBoxFull on tab stop on zNoteBkDialog prevents tab from reaching any farther

Help and On Apply buttons call the same function from zNoteBookDialog

Compiler error when building zApp as shared library

Putting a static frame around a zStaticText

How do I use an RWDBCursor for Write?

Why am I still connected to my database after my RWDBConnections have gone out of scope?

Which Tools.h++ classes require the Standard C++ Library?

Drag-and-drop columns not working in cellgrid

Assertion Failure Running DBTools Examples

Adding a menu item dynamically when ID of DropDown is not known

What platforms and compilers will View.h++ build on?

zHelp crashes when F1 is pressed twice

Multiple radio buttons are checked and will not disable.

How to store/retrieve large blobs in SybaseCT

Second constructor for zFormDialog

Updating sliders after calling setCurrent()

Sybase warning: Changed database context

RWDBDateTime is Returning an Incorrect Time

Accessing command line arguments in zApp

NullPointerException with JWidgets 3.0 and Netscape 4.04

Placing combo boxes on the tool bar

Memory leak when using zNotebook and zWizard dialogs

Restore button does not work in MDI apps

zApp Error Codes

Building Tools.h++ as a DLL with Borland C++ Builder

How to call Oracle PL/SQL functions from DBTools

Making a vertically scrolling zEditBox

Radio buttons on zNotebookDialog pages

In zHelp, the <A NAME=> tag does not work correctly

How to create and run Stored Procedures in DB2

How do I delete a row in a cell grid?

zApp 3.0.3 Online Documentation for Windows

JChart pie piece value = 0 gives error message

Control Size Problems from Win16 to Win32

Determining what style bit is set from inside your program

How to change the font in a zTable cell and column and row label

JChart 2.1 Java Beans do not work well with certain Java IDEs

The Software Parts Manager(SPM) cannot find CL.EXE

Installing a DBTools error handler

Reading a Sybase user defined type results in an error

Symbol Table Program fails to compile

RWDBInserter.isValid() always returns OK even the SQL generated is incorrect

How to produce an interleaved output in a multithreaded program?

Building Rogue Wave Products on Solaris 2.6 with SunPro 5.2

How can I get the port number from an RWSocket?

Problems Running the Software Parts Manager (Windows)

rwMakeThreadFunctions and Passing Parameters By-reference

Using RWDBBlob with a stored procedure on Sybase

How do I move to the end of my grid

Repository Read Error in Unix for SPM

Using absolute paths with a URL in SerializableImage

All Visual CASE Menus and Toolbars Disabled

Location of Visual CASE Project Files

Location of MFC and ATL UML Libraries

Add UML Model and Integrated UML Modeling Buttons

Removing UML modeling Information from a Workspace

No Visual CASE Tab in the Tools|Options Property Sheet

Base Class Shows Up Empty in UML Diagram

No UML Diagraming Without an Active Project

Why is the UML InfoBrowser no longer updating its contents in response to selection changes?

Refreshing the Contents in the UML View

Visual CASE Errors After Installation of Another Stingray Product

Distributing Visual CASE Diagrams and Projects

Math.h++ Allocates Excessive Memory for Vector, Matrix, and Array Classes

The details of RW_CENTURY_REQD

Objective Grid/J: Which .class files do I deploy with OG/J?

Error compiling on SGI

Having problems with the server when using callbacks.

Using char datatype in C++ Application for char(1) datatype of the database

How to add ESQL function calls to the Informix Access Library

Trapping shift, escape and return keys for a ComboBox

The commit / rollback transaction request has no corresponding BEGIN TRANSACTION

How to avoid a database hit when instantiating a RWDBStoredProc

Informix stored procedure does not execute an INSERT

What relation does the RW Standard C++ Library 1.x have to the ANSI Standard?

Undefined Symbol RWAll when Linking Application

Submitting HTML GET/POST Requests to a CGI Program

I cannot execute the install.sh script for Software Parts Manager

Changing the state of a GXCheckBox with a single click when the control does not have focus?

Throwing exceptions using Sybase or MS SQL Server corrupts connections

Objective Grid/J: Footprint

RWDBTracer and asString() method behave differently in DBTools 4.0.0

LAPACK.h++ with Math.h++ v0613 gives dependancy check failure on Solaris 2.5 and SunOS 4.1.x

Using the schema from an existing table to create a new table

RAISE ERROR statement in my RWDBStoredProc never catches that error.

How can I do Oracle row-level locking with DBTools.h++?

Re-definition of parent table alias inside the sub-query of DML

Control object minimizes or disappears when moving to another window or dialog.

Memory Leak in Threads.h++ with POSIX Threads

Can I use DBTools.h++ 3.1.0 with MSVC 5.0?

Horizontal Scroll Bars on Combo Boxes

Modifying zApp 3.0 Makefiles to use Borland v5.02 compiler

How RWDecimal classes cast ints and doubles

How do I trap the enter key in zComboBox (any type, portable solution)?

Adding a scroll bar to a non-overlay chart in JChart 2.1

Creating image buttons of the correct size

The zApp isShown() function does not work correctly

RWTime/RWDate displays incorrect time and date

Creating custom configurations with SPM 1.4

TreeControl image not updating correctly in JWidgets

RW virtual streams and RWCollectableString ambiguity error

Retrieving Blobs from Oracle using DBToolsJ

How to create a custom overlay

Runtime error in DBTools.h++

The Use of Virtual Destructors in Tools.h++ classes

Using custom build configurations

Standard C++ Library manual examples will not build on Solaris

Software Parts Manager Builds on Unsupported/Non-GUI platforms

Objective Grid/J: Database Connectivity

Can Money.h++ be used in multi-threaded applications?

Catching exceptions from the inet module in Tools.h++ Professional

The StockCursor SizeCursor is not working in zApp

Installation of StudioJ on Unix or Mac

How can I print charts from Chart.J?

Failure building Standard C++ Library with aCC 3.25

Core dumps described in the Tools.h++ Professional readme document

How do I add a subject header to my SMTP application?

The addSubItem() method causes the Tree application or applet to freeze at runtime

RWMutexLock Recursive Acquisition error in Debug - Not True! - Threads 2.0.1 only

Unlock keys do not work

Location of Visual CASE

Passing strings containing quotes causes problems with DBTools.J

Using the clipboard paste function with a JMaskEdit control

How do I use binaryStoreSize and recursiveStoreSize?

When trying to establish a connection to my database using DBTools.h++, I get the error: DB NOT FOUND

Building native Win32 applications with Visual Cafe using Grid.J.

Specifying a frozen column attribute does not lock the selected column

Retrieving return parameters from oracle Storedprocedures

Column titles using center justification disappear when using JFC/Swing

StudioJ product unlock code not accepted during installation

UnsatisfiedLinkError when installing StudioJ

How do I create a list of lists?

JDK 1.1.6 JIT update and later versions cause Labels to disappear in StudioJ

Using DBTools.J with the Oracle Driver: Objects Are Not Getting Released Correctly

Internationalization of Blend.J TextField

Accessing _servInst in zApp 3.x on NT

How Do I Send a Basic Password to a Web Page?

Oracle8 AL: How can I use a RWDBBlob with LONG RAW or BLOB columns that hold 32k or more

How to build an RWDBCriterion with dynamic restrictions

Binary Files downloaded using Tools.h++ Professional are the Wrong Size

Problems Compiling Math.h++ 6.x on HP, DEC and Windows 3.1

Assertion failure with DBTools.h++ examples

getNumberRowCol() method in Grid.J throwing exceptions

Running setup.exe to install StudioJ

Using RWDBConnection in nested RWDBReaders

Using Chart.J with Swing/jfc

Color printouts of Grid.J lose the background colors

SQL Server Access Library 3.x does not support bulk operations

RWMetro Supported Platforms, Metro-Platforms

Linux multithreaded limitation with the Oracle8 805 client

Building Tools.h++ 7.1.1 with Visual Age 5.x

Building .h++ products with +DAportable

Building zApp 3.0 as a DLL under Windows 16-bit crashes with Borland C++ 4.52

Errors installing products with SPM and RedHat Linux

RWZone::os() Returns Unexpected Result

Application crashing in the RWDBBlob destructor in DBTools 3.1.3 version

Creating a Global Database Object

Adding a Timeout to an RWSocket::connect() Call

Viewing a JFactory-made ComboBox with Netscape

Building zApp 3.1 with MSVC 6.0

Compile problems with View.h++ v.1.3.0

Establishing a connection to Personal Oracle 8

Unresolved symbol opinit at runtime

Sybase AL: syntax error when trying to bulk insert a vector object of size 1

Building on Solaris with the g++ compiler

Trying to rollback a transaction and it is not working

Understanding Rogue Wave Build Codes

Having problems using Standard C++ Library 2.x with Orbix 2000

No insertion (<<) or extraction (>>) operator to stream a bool

Changing source code to support link time template instantiation

Resizing a connection pool with the defaultConnections() method does not work

Improving the performance of an application that uses a lot of RWCStrings on the heap.

When bulk reading a database column that allows NULL values, you must check for null in the receiving vector object.

Command line builds for Threads 2.0.1 on Solaris7 with SunPro 4.2

Porting Tools Pro.h++ 1.1.2 to Linux

'Unresolved external symbol opinit' runtime error

'Tried to dereference a null RWENode handle' error running SPM

SPM doesn't install correctly under Windows

When compiling, why can't JDK find LogFontLayout.class?

In Chapter 4 of the tutorial, why can't I find the Menu Edit button?

JFactory won't open; gives error

Why does JFactory flicker between the object manager and the integrated editor when I'm trying to edit the source?

Can't compile Math.h++ source files on SunOS4.1.3 with SunPro 4.0.1 compiler

Can't Enter Information Into Dialog Boxes

can't insert an RWDBDateTime object into the database, formatted as a UTC time.

hasChanged() method never set to TRUE

Software Parts Manager doesn't run

RWCString::operator[] doesn't compile in MSVC

How can I tell if my socket's peer closes the socket?

Blend.J vertically-oriented sliders don't respond correctly

Blend.J's ShortcutBar demo throws exceptions

Why aren't the ATL and MFC libraries just loaded at startup?

I've installed Visual CASE and loaded a project. Now what?

Why won't the InfoBrowser contents update in response to selection changes in ClassView or FileView?

Tools.h++ compile error: C2065: 'localtime_r' : undeclared identifier

I get error C2065: 'localtime_r' : undeclared identifier

Rounding Errors in RWDecimal<T>

Error when Building DBTools Access library for Oracle8 with Microsoft Standard Library

Euro conversion rates as of Jan 1, 1999.

How to deal with lost database connections?

Default and Explicit Connections and the DBTools Connection Pool

How do I kill all the running threads in RWThreadPool?

DB2 AL guide: RWDate should map with DB2 DATE type, instead of RWDBDateTime

BBCode tips