Home » Developer & Programmer » Data Integration » Create JDBC task in integration template OWB
Create JDBC task in integration template OWB [message #563971] Sun, 19 August 2012 07:46 Go to next message
lola_bas
Messages: 3
Registered: July 2012
Junior Member
I'm trying to modify the flag_useless_lines task and create a different condition for one single column in my table (the column is called TS). Something like
(<?if ([COL_NAME]equals(\u0022TS\u0022))
I'm sure this line is not good. Can you suggest me something?

{?>"snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME])!=T.[COL_NAME])<?} else {?>("snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME]=T.[COL_NAME]) Or ("snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME] IS NULL and T.[COL_NAME] IS NULL)<?}?
)", " \tand\t", "", "(UPD AND (NOT TRG)) AND (NOT UK)")%>

Thanks!

[Updated on: Sun, 19 August 2012 07:51]

Report message to a moderator

Re: Create JDBC task in integration template OWB [message #564007 is a reply to message #563971] Sun, 19 August 2012 17:45 Go to previous messageGo to next message
lola_bas
Messages: 3
Registered: July 2012
Junior Member
The solution is something like this: (where TS is the colum name)
if (\u0022[COL_NAME]\u0022.equals(\u0022TS\u0022))
Re: Create JDBC task in integration template OWB [message #564965 is a reply to message #564007] Wed, 29 August 2012 14:24 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for letting us know.

I suppose you saw that many Warehouse Builder questions remain unanswered as nobody of the regulars uses it. If you have any experience with OWB and have some time to spare, browse previous topics and try to assist - I'm sure these people will appreciate it.
Previous Topic: Update package in Design Center
Next Topic: OWB Vs Solaris Compatibility Matrix
Goto Forum:
  


Current Time: Tue Mar 19 06:09:57 CDT 2024