Re: Copying data from IFS to DB2

[CRPence <crpbottle@xxxxxxxxx>]

On 07-Nov-2015 15:58 -0600, CRPence wrote:
> <<SNIP>>
>
>     runsql
>       'create table qtemp/imported
>        ( Store            char      (    3) not null with default
>        , Register         char      (    2) not null with default
>        , "TRANSACTION" for TRANSACTN
>                           char      (    2) not null with default
>        , "TIMESTAMP"      char      (   14) not null with default
> <<SNIP>>

  Oh.  And because the char(14) [as 'YYYYMMDDHHMMSS'] is a supported 
character string representation for [the implicit casting into] a 
TIMESTAMP value, the above "TIMESTAMP" column could be defined instead as:

         , "TIMESTAMP"      timestamp         not null with default