in reply to Code flow not going to while loop

Hi I tried using back quotes and it did not work. I got this : DBD::DB2::db prepare failed: IBMCLI DriverDB2/AIX64 SQL0007N The statement was not processed because a character that is not supported in SQL statements was included in the SQL statement. Invalid character: "`". Text preceding the invalid character: "select distinct ". SQLSTATE=42601

Replies are listed 'Best First'.
Re^2: Code flow not going to while loop
by thanos1983 (Parson) on Aug 02, 2017 at 15:43 UTC

    Hello again dipit,

    You are right bakcticks are not working on SQL. Remove them from the SELECT statement and execute again. See the update2 with the eval.

    Hope this helps, BR.

    Seeking for Perl wisdom...on the process of learning...not there...yet!
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom