Join this group to access featured content and participate in discussions related to DMX.

140 Members
Join Us!

Does DMExpress Support bigint and bigserial

Hi,

We are currently using DMExpress 7.13 Linux 2.6 x86_64 64-bit. We are having an issue converting from Informix XPS to Informix IDS. When using XPS we define columns that have large numeric values as int8 and serial8.  This works fine with our version of DMExpress. However, IDS does not support int8 and serial8, it uses bigint and bigserial.  When we try to run the DMExpress job against IDS, we get:

 

<Issuer>DMExpress</Issuer>

<Mnemonic>DBIOCTIV</Mnemonic>

<Text>data type of column &quot;audience_key&quot; in database table &quot;EDW-AudienceKeys&quot;

 is not suppo

rted</Text>

</Message>

<CompletionStatus>

<Text>DMExpress has aborted</Text>

<StatusCode>111</StatusCode>

 

We have tried to define audience_key as bigserial and bigint.  Is there a different version of DMExpress that might support these new data types?

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –

To access Syncsort Knowledge Base, visit:

My Support