Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Question Integration in an AS400 table with CHAR () FOR BIT DATA fields

Start
Prev
1
Next
End

Jackline
Topic Author
Offline

02 Oct 2019 11:10 #1 by Jackline

Integration in an AS400 table with CHAR () FOR BIT DATA fields was created by Jackline

Hello,

We transfer data from one AS400 table to another.
However, there seems to be a problem with CHAR () FOR BIT DATA fields. Indeed, during the creation of the integration table, the generated query is incomplete and generates an error.

Create table I_TABLE
(
FIELDcharForBitData1 ,
Numeric_Field NUMERIC(2,0) ,
FIELDcharForBitData1 ,
...
)

Would you have an idea for us?

Thank you

Thomas BLETON
Offline

16 Oct 2019 13:42 #2 by Thomas BLETON

Replied by Thomas BLETON on topic Integration in an AS400 table with CHAR () FOR BIT DATA fields

Hi, this does not look normal indeed.
If not already done, please send an Export Models and Dependencies of your mapping to the support team. www.stambia.org/support

Start
Prev
1
Next
End