DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Joined: 08 Oct 2007
Posts: 190

Points: 1919

Post Posted: Wed Sep 11, 2019 6:18 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I am trying to run below query in odbc_connector(before sql statement), facing issue. Loading data from netezza to yellowbrick.

and same time create statement table in before sql and insert table is same,
failing job in this scenario also if both names are same, working fine in netezza connector.


issue: YB_Insrt: ODBC function "SQLExecDirect()" reported: SQLSTATE = 42000: Native Error Code = 6819553: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: syntax error at or near "IF"(Position 42; )

YB_Insrt: Execution failed on statement DROP TABLE stage.LEG_CURRENT_MER_TEMP_DM IF EXISTS

Premium Poster

since January 2006

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

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Sat Sep 14, 2019 9:30 am Reply with quote    Back to top    

Don't like to see posts sitting without any replies, but that's the nature of a peer-to-peer site like this. Hopefully in the interim you've either solved this or gotten some official support help. For the latter, please update your post so others with the same question have a solution. Wink

I don't have direct experience but searching tells me that this might help. If it doesn't then I would see if support can help as it could be something PostgreSQL specific with Yellowbrick.


The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
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