2 Replies Latest reply: Sep 27, 2016 6:48 AM by Giacinto Abbruzzese RSS

    %(fieldname) in load script

    Giacinto Abbruzzese

      Dear community,

       

      i have a real quick question:

       

      1. What does the % symbol do if you place it in front of a generated variable?

       

      E.g.:

      LOAD

      PLZ,

      PLZ as %PLZ

      From...

       

      And why does a SQL Load seems to have trouble with using this sort of variable generation?

      When i load PLZ as %PLZ in a excel file i'm getting no errors after data load, but when i implement PLZ as %PLZ in a SQL Load Script, i get an Error for this specific row in the script.

       

      Any suggestions, or do you need any further information?

      Thanks in advance and happy qliking!