Archives of the TeradataForum

Message Posted: Mon, 31 Mar 2014 @ 13:25:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, March 31, 2014 05:37 -->

Anomy.Anom wrote:

Dear all,

Thank you for your reply

I defined all parameters and variables as Unicode

I changed the character set from ASCII to Utf8 and I run again the procedure, everything worked fine.

When I change the static values to variables into the SQL that I call using the SYSEXECSQL, I receive the same error again

EX:

I changed the value 8 into the where to a variable --- it works fine here

          CALL DBC.SYSEXECSQL('INSERT INTO '||:V_USER||'.tablename SELECT
                    fieldname

              FROM       tablename
           WHERE source_cd= 8  ');


          CALL Failed. 3706:  REPPROC:Syntax error: expected something between
          the word 'BBR' and a string or a Unicode character literal


          CALL DBC.SYSEXECSQL('INSERT INTO '||:V_USER||'.tablename SELECT
                    fieldname

              FROM       tablename
           WHERE source_cd      in     '||:V_SOURCE_CODE);

	<Prev	Next>		<<First	<Prev	Next>	Last>>