DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
jackson.eyton



Group memberships:
Premium Members

Joined: 26 Oct 2017
Posts: 133

Points: 2153

Post Posted: Thu May 17, 2018 7:28 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi,
I seem to be having an issue with a source query and its column definitions. Using the netezza connector, the columns defined were all done by hand, not imported from a table definition. I had assumed that certain data types that are NULL from the source, such as SELECT NULL as Column1 FROM TABLE, would need to be cast as the datatype the column is defined to be, however I found that this is not the case. As you can see in the source query I tried this and it made no difference and there are other columns of the same data types that are NULL and are not cast that do not present issues.

Here is the source query:
https://github.com/jacksoneyton/DataStage/blob/master/SourceQry.sql

Here is an export of the table definitions:
https://github.com/jacksoneyton/DataStage/blob/master/AccountMasterColumnDefs.dsx

And here is the first error in the job log:
https://github.com/jacksoneyton/DataStage/blob/master/ErrorLog

I'm quite confused as to what is going on here Sad

_________________
-Me
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42836
Location: Denver, CO
Points: 220819

Post Posted: Thu May 17, 2018 9:40 am Reply with quote    Back to top    

Not really sure what's going on but I'm curious if you get any kind of similar error running that set of UNIONs outside of DataStage? You can have issues if each column in the combined set doesn't have the same data type. Trying to see if this is specific to DataStage and the data types in the job or if the issue is the SQL itself.

_________________
-craig

Your brain is full of spiders, you've got garlic in your soul, Mr. Grinch!
I wouldn't touch you With a thirty-nine-and-a-half foot pole!
Rate this response:  
Not yet rated
jackson.eyton



Group memberships:
Premium Members

Joined: 26 Oct 2017
Posts: 133

Points: 2153

Post Posted: Fri May 18, 2018 7:50 am Reply with quote    Back to top    

alright figured this out, seems odd that we've not run into this before as this is not a new thing for us but we had to cast every NULL field of non VarChar type to its intended type.

_________________
-Me
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours