🚀 go-pugleaf

Ricko,

    I am assuming that your using Microsoft Sequal DB when you say "Sequel
Database". If I'm correct and you are using the built in DTS data pump then
you can replace the generic "copy field" functionality with your own
VBScript or JScript routine.
    Go to the transformation tab of the connector between the ODBC and the
Sequal DB's, find the field in question in the Left and Right panes. After
you click on the matching fields, delete the entry and click "New". That
should popup a window with a script outline that you can add your own
conversion code to.

Hope this helps

Gary Tummond


"ricko" <ricko@softlad.co.uk> wrote in message
news:3a87c97a$1@d2o313.teliauk.com...
> Hi
>
> I am trying to populate a Sequel Database with Data from an AS400 File
> (ODBC). The AS400 file
> contains several DATE Fields that have the field date property assigned.
> (L).
>
> I do not always need the dates to contain a date i.e. I need them to be
> Null. However, When I run
> my RPG Program to populate the AS400 file, the Date fields default to
> 1940/01/01 (*ISO Default).
>
> This is causing a problem because the Application that uses the Sequel
> database displays these dates
> to the users and I need them to be Blank.
>
> The ALWNULL and DFT Keywords do nothing to help. I have changed the DDS to
> be a 6 char numeric
> field but then Sequel detects that its not a date field and rejects my
file
> transfer.
>
> I am trying to automate the entire process without and 'manual'
> intervention.
>
> Is there a solution??
>
> Thanks in Advance!
>
> Paul Cullen
>
>
>
>