Why & When 'Garbage after statement' comes?

[dmohanty]

I want to use like this above. Here I am getting a 'Garbage after statement' error. However if I am doing a Set errormode = 0, this is avoided and table loads fine.But I dont want to keep the rrormode = 0.

Coul you please suggest how to use this variables? Please test and let me know.

[sushil353]

try to make it in single quote.

'$(tableString)' & '$(concatenateSting)':

[#3]

If that is exactly what you have in your load script, you are missing a semi-colon after the $(ConcatenateString) part.

[jagan]

Hi,

Try this script

TempOrders:

LOAD

    'test' AS Category

AutoGenerate(0);

SET vConcatenate = 'Concatenate(TempOrders)';

SET vTableName = 'vTempOrders';

$(vConcatenate)

LOAD * INLINE [   

    Category

    Category1

    Category2

    Category3

    Category4

    Category5

    Category6

    Category7

    Category8

    Category9

    Category10

    Category11

];

I think there is no need to mention table name separately, it is mention in Concatenate().  So the variable tableString is not useful.

Regards,

Jagan.

[dmohanty]

Unfortunately, putting a semicolon (;) or a colon (:) ,not working.

If Errormode = 0, then this is avoided and working. But I don't need to use that.

Any other solutions please?

[dmohanty]

I have one more scenario like this. So I need a common solution for these 2 syntax error images.

Here also I am unable to fix the syntax issue. Any suggestions please????

[kaushiknsolanki]

Hi,

     First of all you dont require to give table alice name before concatenate statement so remove $(tableString):

     Secondly you need dont need to use the single quote when defining the variable with set statment.

     So your variable defination will be

     set _SupplierSelectionSql String = And SUPP_ID in (1);

Regards,

Kaushik Solanki