Data problems on test machine

[rmcclure]

Hi,

We Datastage server set up on a Windows Server 2003 Enterprise edition machine. We want to do a simple test so we decided to use a Windows 2000 SP4 desktop and installed Datastage server on it.

Our source data is coming from an AS/400 or SQL server 2005 using ODBC.

We then did a straight copy of a server job from our 2003 Development server to this test desktop, but when we do a view data on the test desktop, the data is truncated, strange characters, zeros or blank.

While debugging this problem we did a query using MS Query with the same ODBC datasources that Datastage uses. The Data looked fine. therefore we don't think it is the ODBC driver set up.

The Driver version is the same on both machines.
The Drivers are set up the same.
The MDAC level is the same.
The server job is the same.

The only difference is that one machine is Windows Server 2003 and the other is Windows 2000 SP4.

Any ideas?

thanks
Rich

[ArndW]

Hello Rich,

when I see

...the data is truncated, strange characters, zeros or blank...

in this scenario I think of two main possibilities:

1. EBCDIC to ASCII conversion isn't being done anymore
2. NLS Settings might be different.

Both might apply in your case, since the new server is on a Win2k box instead of the Win2003 of the original.

Can you write a record from the new box to the database and read that same record from the original DS system to see if the data is also transmogrified? Do you have NLS installed on either, both or neither machine?

[rmcclure]

NLS was installed and both machines are set the same.

Convert Binary is set.

[kduke]

The AS400 ODBC driver does have the NLS character set defined as well. This could be the issue.

By the way welcome to DSX.