Focal Point
[SOLVED] reg sql trace.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/913105925

September 17, 2010, 10:56 AM
swati
[SOLVED] reg sql trace.
Hi all ,i have a simple WF code.when i try to get the Sql trace out of it,i am missing the SQL stmt for one WF line,the line is "WHERE TABLENAME NOT LIKE '%_WRK' OR '%_BKP' OR '%_DMY' OR '%_TBX' OR '%_ARC' OR '%_PER' ".(where TABLENAME is field)

can some one tell me please on why i am not getting the sql generated for only the above where statement of WebFocus,is something wrong with that where stmt?

please reply...

This message has been edited. Last edited by: Kerry,


7.6.7
windows
PDF,EXCEL.
September 17, 2010, 11:23 AM
BlueZone
Swati - It would be easier to review if you could post the actual FOCUS code and the SQL being generated. Can you please?

Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
September 17, 2010, 11:29 AM
Francis Mariani
Unfortunately, the SQL translator does not like LIKE.

In a case like this I would use SQL passthru and code my own SQL.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 17, 2010, 11:42 AM
swati
but there are other where stmts in code with like operator but why only the above stmt cannot get sql.


7.6.7
windows
PDF,EXCEL.
September 17, 2010, 11:49 AM
Francis Mariani
Because the mask is at the beginning of the string and not at the end.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 17, 2010, 11:51 AM
swati
got it ,Thx francis.


7.6.7
windows
PDF,EXCEL.
September 19, 2010, 05:52 PM
Waz
I think that this would have been highlighted in the SQL trace with a (FOC2598) FOCUS IF/WHERE TEST CANNOT BE PASSED TO SQL


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

September 20, 2010, 11:01 AM
Francis Mariani
Definitely Waz, except that the "why" is not documented anywhere:
quote:
Because the mask is at the beginning of the string and not at the end



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 20, 2010, 05:59 PM
Waz
Well a case needs to be put in with IBI to make sure the documentation is updated.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code